Hi, can someone please let me know how to read an excel file using Python notebooks in Alteryx? I tried:
import pandas as pd
fileName = pd.read_excel('Name of the file.xlsx')
It didn't work.
Thanks!
Solved! Go to Solution.
1)Use the input tool to connect with your excel file normally
2)Connect the input tool with the python tool
3)Import the data from Alteryx to Python with Alteryx.read("#1")
@Felipe_Ribeir0 amazing, thank you!!!! :-)