ไม่สามารถเล่นวิดีโอนี้
ขออภัยในความไม่สะดวก
Import Excel data file into python pandas : Read Excel File
ฝัง
- เผยแพร่เมื่อ 5 ธ.ค. 2019
- 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?🤔
The best of online tutory 👍👍👍👍👍👍...
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!
This was great! Thanks for the clear and helpful examples
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
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!
Good job. Keep going on 👍
Very well explained. Thank you! Can we also sort data based on filtering data in rows.
Amazing explanation. Thanks a lot
Thanks, I was stuck with bloody unnamed column from xl. Publish more videos with simple approach like this.
Which python ide you use ?
This video is so helpful. Thank you so much
very helpful .Thank you so much gentleman.
Thank you❤️❤️❤️❤️❤️❤️❤️❤️very helpful
thank you so much
Sir, how to read an excel file of complex numbers into python..
If you can provide a solution, it would be of great help
Thankyou sir ❤
Amazing! Very helpful👍🏼
Thank you very much for this video! It really helps me a lot!
Excellent!
NameError Traceback
(most recent call last)
Input In [1], in ()
----> 1 pd._version_
NameError: name 'pd' is not defined
What the other ways to read excel and csv files? Can you make video for that, lease?
how to do the same in GUI interface
Thank you so much for this detailed tutorial!
Thank you so much
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.
great sir thank u
cant get it done it always throws the error handle=(open) tell me whats wrong
What is the code if we want to get all the column details just giving the row number
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!
Sir how to display data to be draw as curve for example temperature with depth?
If I have only path of the file, how I can read it ?
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.
Great
How to load excel file which contains filters in jupyter
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
thankyou sir
dont need to give the path of the excel?
thank you
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 :/
th-cam.com/video/oH96MB8vQRo/w-d-xo.html
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
xlsb files?
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
Errno 2 issue is plauging me
Sir in my system is saying FileNotFoundError
same here
because the version is updated
th-cam.com/video/oH96MB8vQRo/w-d-xo.html
B.A. Physics😅😅
Thanks :)
error filr not found
th-cam.com/video/oH96MB8vQRo/w-d-xo.html
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')