How to Import Excel and CSV files into Python using Jupyter Notebooks || Python for Scientists

[@Julian-hw6zf]

thank you very much!! I've been dealing with this issue for one or two days and finally someone explained it clearly :).

[@aavere3284]

You are a godsend I have an assignment due tommorow and I didn't even know where to start

[@KierstenMills-p9s]

Thank you! I get so frustrated when I don't know what I don't know and you did a beautiful job explaining everything here!

[@praiseemma-iwuozo6938]

Thanks so much. This was greatly helpful. Was already getting frustrated but your video answered all my questions.

[@SciGradCoach]

Glad it helped!

[@xytay]

Thank you, by far the clearest and best structured simple vid, I was able to open my csv file with your help!

[@SciGradCoach]

Yay! I am so glad it was helpful!

[@rinaldodelucca8073]

This solution only works for CSV files if I have only one cell with data in the file. Otherwise I get all kinds of errors. It worked fine for Excel files. Thank you for this video.

[@kateb5659]

Thank you! I had be struggling with this on a homework assignment and this made it so simple to find my error!

[@SciGradCoach]

Glad it helped!

[@vibespriority201]

Very nice and clear explanation! Thank you!

[@SciGradCoach]

Glad it was helpful! :)

[@FatosZogjani]

great video,very helpful!👍

[@jashanbhamra103]

Im getting the same error thousand times handle open( self.handles=get handle can you tell me whats wrong

[@danielbarnes478]

Thank you for the help, excellent job walking through all the steps! I was getting frustrated with other videos I was finding not explaining things well.

[@SciGradCoach]

I am so glad it helped!!!!!

[@johnnyturner8044]

You provided an easily understandable example. Thank you!

[@SciGradCoach]

Thank you! I am so glad it helped!

[@haroldasraz]

Cheers for a great video.

[@Carolinelias]

Thank you. Can you please help me import 1 column from 4 multiple csv files? let's say the column ['Adjusted Close'] available in 4 csv files: Procter and Gamble, Ford, General Electric and Microsoft. Thank you!

[@SciGradCoach]

You just need to import all 4 columns and then only select the one column from each file.

[@pemayangzom4358]

Thank you so much. It helped me a lot

[@cocostar8914]

Thank you so much, this was really helpful

[@SciGradCoach]

I am so glad it was helpful!

[@qusay6948]

CAN WE USE THE PYTHON TO ANALYSE THE SCOPUS DATASET?

[@SciGradCoach]

You can use Python to analyze any data set!

[@qusay6948]

But why you did not upload the command file?

[@SciGradCoach]

What command file are you looking for?

[@StructuredData-cp2yi]

came here specifically to say a big thank you for solving my errors. I see others agree with me as well😃😃

[@SciGradCoach]

I am so glad it was helpful!

[@rohitagnihotri2074]

thannnkkkk yoouuuu so much

[@meandtheuniverse1449]

thank you for this

[@SciGradCoach]

SO glad it helps!

[@Yasser.Moussa]

tried with xlsx and csv

[@Matt-br6zo]

Nothing stresses me out like trying to import data

[@LeonidasParigoris]

Jesus... it wasn't working for me until I found out it was an xlsx file and had to convert it to csv

[@qusay6948]

Thank you.

[@SciGradCoach]

You're welcome!

[@EG101ify]

i love you

[@moouodsh6504]

🤍

[@agabala82]

nothing clear. did not understand even a word

[@Yasser.Moussa]

hi it's given me this error import pandas as pd pd.read_xlsx("data1.xlsx") AttributeError Traceback (most recent call last) Input In [5], in () ----> 1 pd.read_xlsx("data1.xlsx") File ~\anaconda3\lib\site-packages\pandas\__init__.py:261, in __getattr__(name) 257 from pandas.core.arrays.sparse import SparseArray as _SparseArray 259 return _SparseArray --> 261 raise AttributeError(f"module 'pandas' has no attribute '{name}'") AttributeError: module 'pandas' has no attribute 'read_xlsx'

[@SciGradCoach]

It should be pd.read_excel not pd.read_xlsx. I hope that helps!

[@eng.miroslavmanahilov1944]

Thank you.