Import Excel data file into python pandas : Read Excel File

[@MyStudyIsFun]

Checkout my Best Seller Course on Pandas, Scikit-learn and Data Science Python : www.udemy.com/course/data-analysis-with-pandas-python/?referralCode=AD67F6846C5F17E55EC2 www.udemy.com/course/data-science-with-python-and-pandas/?referralCode=51F15876D7C4B4B92876

[@rayoh2011]

First, thank you for posting this tutorial. It's great. But I have a problem, I couldn't load the Excel file: It's October, 2023. For people using the newer versions of Pandas, we need to upgrade Pandas' Excel reading module. this is what I Googled: Short story: XLRD is the default engine for Pandas to read Excel files, and as it happens XLRD stopped supporting XLSX files. If you want to read one anyway, you need to pip install openpyxl, and set it to be the reading engine instead of the default.

[@nick-oi1xf]

How do you set openpyxl to be the reading engine?🤔

[@aditibahadur8081]

Great tutorial. I just wanted to add some extra information from my experience with using the jupiter notebook on anaconda navigator. Ensure that you upload the excel sheet in the anaconda navigator folder as well and then use these codes.

[@glepht]

Your clutch

[@Rob-kx5yx]

dude thank you

[@surya691]

The best of online tutory 👍👍👍👍👍👍...

[@stcopik]

Very nice video. Finally I understood this basic operation with excel in python.

[@a-woke5283]

I'm feeling guilty by thinking that If I was still in India I would've judged you because of your accent and not knowledge. But now I really appreciate you for your knowledge and willingness to share it! Thank you!

[@ChPetru]

what accent is that?

[@a-woke5283]

@@ChPetru From what I csn tell its a UP/Bihar accent which are both states in the nort/northeast of India.

[@mekidesbekele1787]

Thank you very much

[@julianbogado9378]

if sb is getting an error with the location, copy the route to the file and add the file name at the end, replacing bars with double bars: 'C:\\xxx\\Example.xlsx'

[@Jechisha]

thank you!

[@mhommadhassan2482]

Which python ide you use ?

[@abhijitnayak3673]

How can I fetch the excel or CSV file in pydroid3? I am using this in my TAB. Can't use excel and CSV in pandas.

[@yousif_alyousifi]

What the other ways to read excel and csv files? Can you make video for that, lease?

[@kavanakundapur]

Very well explained. Thank you! Can we also sort data based on filtering data in rows.

[@vardhinirudra3052]

Sir, how to read an excel file of complex numbers into python.. If you can provide a solution, it would be of great help

[@SuperDaxos]

This was great! Thanks for the clear and helpful examples

[@anupamaroy8893]

NameError Traceback (most recent call last) Input In [1], in () ----> 1 pd._version_ NameError: name 'pd' is not defined

[@秦建团]

Sir when you export to excel, how to make the data format be Text or Currency or Percentage by Python. I wanna know the code of converting format.

[@dmmsai5356]

What is the code if we want to get all the column details just giving the row number

[@jashanbhamra103]

cant get it done it always throws the error handle=(open) tell me whats wrong

[@murungicalvin5235]

Thanks very much sir. This was very helpful and easir to understand

[@abderrazzakaljalil1375]

Good job. Keep going on 👍

[@mazenomar7279]

Sir how to display data to be draw as curve for example temperature with depth?

[@redcabinstudios7248]

Thanks, I was stuck with bloody unnamed column from xl. Publish more videos with simple approach like this.

[@granand]

Please can you show, how to 1. Run specific version of Python in Pandas as I have 3 different version 2. How to read excel files in various locations, one in sharepoint, other in C:/user etc in windows 10 ?

[@tymothylim6550]

Hello! I am quite new to Python, but I hope this helps: 1. I assume you mean running different versions of Python. I think if you run Python in an IDE (like Pycharm), you can toggle the Python version! 2. pandas.pydata.org/pandas-docs/stable/reference/api/pandas.read_excel.html This link shows the wiki for this code. You can refer to "io" parameter in the link. I think that's the correct one!

[@srikrishnanr8155]

Using Pandas how to select data frame and write into existing workbook in a specific sheet with specific cell range ??? Please help with some references

[@ajayjangid5968]

If I have only path of the file, how I can read it ?

[@dp6736]

Very good explanation. Thank you very much.

[@HindiLearnersDiary]

Could someone please explain the practical application of this. In the real world, why do we want to import data from excel and work with it this way instead of working with excel documents directly?

[@MyStudyIsFun]

Python is general purpose programming, excel is not

[@HindiLearnersDiary]

@@MyStudyIsFun so what can we do with this data using Python that we can't using Excel?

[@kmahim82]

@@HindiLearnersDiary the process can be automated and is actually very fast when working with a big data… excel has a limitation for rows and will take ages to just open the file … python takes few micro seconds to do the same ….

[@HindiLearnersDiary]

@@kmahim82 Thank you!!! This makes sense.

[@chrisb3189]

I am trying to import data and then pick random cells in a GUI format

[@ramprakash0]

How to load excel file which contains filters in jupyter

[@dg-hobbymad9898]

Nice explanation

[@prateekyadav7679]

I'm getting filenotfound error. have tried everything - double dash, absolute path, adding r before the path, checked case sensitivity. The damn file exists but it keeps showing the error. I'm doing on colab if that's helpful

[@prateekyadav7679]

This problem was solved on IDE but then I got stuck at plt.plot(wh['height'], wh['weight']) which throws up a keyerror even though my columns are indeed named as such. What to do? Very frustrating :/

[@kirolloseisa]

kzbin.info/www/bejne/pXmcZ4B4bduEiNE

[@shortanimation1533]

how to do the same in GUI interface

[@younesdeffous3493]

pls, how do you display a short content from file read script as you do in you video? thank you

[@MyStudyIsFun]

Head function

[@ajaysinhchudasama2236]

Var.head() it will bring you the first five columns

[@mfmalth]

dont need to give the path of the excel?

[@avenewconsulting1118]

hi, how does python know where toi find the excel file please?

[@MyStudyIsFun]

First at same location where you kept python source code file.

[@b.woldegergis5158]

@@MyStudyIsFun How can I know where is my python source code located ?

[@b.woldegergis5158]

for those who had issues like me, here is the tip I found, I just copied pasted the entire Path data = pd.read_excel ( ' / Users / xx / xx / xx / xx / xx / xx/ xx / Excel_Sample.xlsx')

[@rimshaaiman3098]

@@b.woldegergis5158 Hi! can you please elaborate on how to find the path of the excel sheet ? I wasn't able to implement this because of some issue regarding the path.

[@kmahim82]

@@rimshaaiman3098 drag and drop your excel file in the terminal….. it will gice you the path of the excel file where it has been saved… just copy paste the path to your python … thats it

[@prakeerthjishamadhu1375]

Amazing explanation. Thanks a lot

[@VincentStevenson]

Great work, thank you for sharing this!

[@alinemath5030]

I keep getting the error even after adding the location, my code is -> data= pd.read_excel('C:\Users\asyed1\Documents\Graphics Cards Data.xlsx')

[@kimyonhee7337]

This video is so helpful. Thank you so much

[@impersonality3]

Thank you❤️❤️❤️❤️❤️❤️❤️❤️very helpful

[@BernhardWeber-l5b]

Excellent!

[@rodrsturge663]

xlsb files?

[@tymothylim6550]

Thank you very much for this video! It really helps me a lot!

[@zeendabadzeendabad3366]

Amazing! Very helpful👍🏼

[@hridayborah9750]

very helpful .Thank you so much gentleman.

[@GauravSharmaIN]

Thank you so much for this detailed tutorial!

[@dilshangautam7703]

Sir in my system is saying FileNotFoundError

[@krushnaraut9118]

same here

[@yashmishra3385]

because the version is updated

[@kirolloseisa]

kzbin.info/www/bejne/pXmcZ4B4bduEiNE

[@Versa_Tube.]

Thankyou sir ❤

[@tanwarrahul5300]

great sir thank u

[@positively8461]

thank you so much

[@kizhissery]

Errno 2 issue is plauging me

[@Yazdah]

Great

[@krushnaraut9118]

error filr not found

[@kirolloseisa]

kzbin.info/www/bejne/pXmcZ4B4bduEiNE

[@abrahamarthuryoku7540]

thankyou sir

[@brahimferjani3147]

thank you

[@marcusaureliusregulus2833]

B.A. Physics😅😅

[@maxdesko]

Thanks :)

[@abubakarmeraj8040]

giving a dislike as basic is not described and your way is very difficult

[@rushikamble4457]

Thank you so much