Import Excel data file into python pandas : Read Excel File
HTML-код
- Опубликовано: 21 авг 2024
- This video explain how to read excel file into python with pandas read_excel function with various different argument.
To Learn more about data science, python, machine learning
one complete example on python excel read write example
www.udemy.com/...
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
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.
How do you set openpyxl to be the reading engine?🤔
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.
Your clutch
dude thank you
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'
thank you!
The best of online tutory 👍👍👍👍👍👍...
Nice explanation
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!
what accent is that?
@@ChPetru From what I csn tell its a UP/Bihar accent which are both states in the nort/northeast of India.
Thank you very much
This was great! Thanks for the clear and helpful examples
Thanks, I was stuck with bloody unnamed column from xl. Publish more videos with simple approach like this.
Very well explained. Thank you! Can we also sort data based on filtering data in rows.
Good job. Keep going on 👍
Thanks very much sir. This was very helpful and easir to understand
Very good explanation. Thank you very much.
Great work, thank you for sharing this!
Amazing explanation. Thanks a lot
Sir, how to read an excel file of complex numbers into python..
If you can provide a solution, it would be of great help
This video is so helpful. Thank you so much
thank you so much
Thank you❤️❤️❤️❤️❤️❤️❤️❤️very helpful
Excellent!
very helpful .Thank you so much gentleman.
Thankyou sir ❤
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 ?
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!
Thank you very much for this video! It really helps me a lot!
Amazing! Very helpful👍🏼
NameError Traceback
(most recent call last)
Input In [1], in ()
----> 1 pd._version_
NameError: name 'pd' is not defined
Thank you so much for this detailed tutorial!
great sir thank u
Thank you so much
Great
What the other ways to read excel and csv files? Can you make video for that, lease?
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?
Python is general purpose programming, excel is not
@@MyStudyIsFun so what can we do with this data using Python that we can't using Excel?
@@RussianVideoPodcast 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 ….
@@kmahim82 Thank you!!! This makes sense.
I am trying to import data and then pick random cells in a GUI format
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.
how to do the same in GUI interface
Which python ide you use ?
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.
What is the code if we want to get all the column details just giving the row number
cant get it done it always throws the error handle=(open) tell me whats wrong
Sir how to display data to be draw as curve for example temperature with depth?
thankyou sir
If I have only path of the file, how I can read it ?
How to load excel file which contains filters in jupyter
thank you
hi, how does python know where toi find the excel file please?
First at same location where you kept python source code file.
@@MyStudyIsFun How can I know where is my python source code located ?
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')
@@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.
@@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
pls, how do you display a short content from file read script as you do in you video? thank you
Head function
Var.head() it will bring you the first five columns
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
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 :/
ruclips.net/video/oH96MB8vQRo/видео.html
dont need to give the path of the excel?
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
xlsb files?
Errno 2 issue is plauging me
Sir in my system is saying FileNotFoundError
same here
because the version is updated
ruclips.net/video/oH96MB8vQRo/видео.html
Thanks :)
error filr not found
ruclips.net/video/oH96MB8vQRo/видео.html
B.A. Physics😅😅
giving a dislike as basic is not described and your way is very difficult
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')