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.
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
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.
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!
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'
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!
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?
@@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 ….
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
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 :/
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
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 👍👍👍👍👍👍...
Very nice video. Finally I understood this basic operation with excel in python.
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
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
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
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
Very well explained. Thank you! Can we also sort data based on filtering data in rows.
Good job. Keep going on 👍
Nice explanation
What the other ways to read excel and csv files? Can you make video for that, lease?
Very good explanation. Thank you very much.
Thanks, I was stuck with bloody unnamed column from xl. Publish more videos with simple approach like this.
Sir, how to read an excel file of complex numbers into python..
If you can provide a solution, it would be of great help
Thanks very much sir. This was very helpful and easir to understand
NameError Traceback
(most recent call last)
Input In [1], in ()
----> 1 pd._version_
NameError: name 'pd' is not defined
Which python ide you use ?
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!
Amazing explanation. Thanks a lot
Great work, thank you for sharing this!
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.
Sir how to display data to be draw as curve for example temperature with depth?
What is the code if we want to get all the column details just giving the row number
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.
how to do the same in GUI interface
This video is so helpful. Thank you so much
cant get it done it always throws the error handle=(open) tell me whats wrong
If I have only path of the file, how I can read it ?
Amazing! Very helpful👍🏼
How to load excel file which contains filters in jupyter
Excellent!
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?
@@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 ….
@@kmahim82 Thank you!!! This makes sense.
I am trying to import data and then pick random cells in a GUI format
very helpful .Thank you so much gentleman.
dont need to give the path of the excel?
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
Thank you❤️❤️❤️❤️❤️❤️❤️❤️very helpful
Thank you very much for this video! It really helps me a lot!
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
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
Great
Thank you so much for this detailed tutorial!
xlsb files?
great sir thank u
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
Thankyou sir ❤
Thank you so much
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
thankyou sir
thank you
error filr not found
ruclips.net/video/oH96MB8vQRo/видео.html
B.A. Physics😅😅
Thanks :)
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')
thank you so much