[Tutor] Creating a DataFrame from excel file

Mark Lawrence breamoreboy at gmail.com
Fri Feb 9 11:35:15 EST 2018


On 08/02/18 21:23, Charlotte Hoff Sonne wrote:
> I wish to create a very large data frame with pandas. So far, I have learned how to create data frames by manually entering the values I want in my data frame. However, now I have a large dataset from excel that I want to get imported as a data frame in jupyter notebook. Initially i wrote the following code:
> 
> pd.read_excel(“…”)
> 
> But this is not a data frame, is it? Can I convert my excel file to a data frame?

https://pandas.pydata.org/pandas-docs/stable/generated/pandas.read_excel.html 
states quite clearly "Read an Excel table into a pandas DataFrame" so 
you just have to assign the return value from the call to a variable.

-- 
My fellow Pythonistas, ask not what our language can do for you, ask
what you can do for our language.

Mark Lawrence



More information about the Tutor mailing list