such an awesome video - really helped me with my task when i was freaking out!!! for any beginners - make sure to open the correct folder on Jupyter notebook so that it can locate the correct file ;)
People commenting that they get a file not found error need to upload the excel file first to your jupyter notebook. This video here explains how to do it with a CSV, but the same applies to an excel file (ruclips.net/video/JwteBpgMYuE/видео.html). Once you upload the data frame if you are looking for some nice visualizations I was told to use Seaborn (ruclips.net/video/6GUZXDef2U0/видео.html). Hope it helps
Thank for the video. A small note Pandas read_excel method removed support for xlsx files. Kindly please update the information otherwise someone might find hard to follow the video.
Can I upload an account statement directly to Jupiter without opening it up in excel n arranging data..? I get an error message : expected 1 field on row 1, saw 4 .
I have query...this is only file to read jupyter as pandas CSV file as it is ...but how to calculate input read file output calculation or date after successfull read for file any code editor
How can you import and excel with extension .xlsb? I get different opinions that pandas does not support xlsb and some that say there is a way to import it.
Hi, Thanks for your video. I have just started learning. How do we go from here to create different types of visualization charts from the imported excel data?
You can create charts using Matplotlib packages. You can refer this link: matplotlib.org/tutorials/introductory/sample_plots.html#sphx-glr-tutorials-introductory-sample-plots-py
can someone help me? When I read csv file as """"" pd.read_csv("filename.csv")""""" the data frame appear below but when I assign a variable like """"""df = pd.read_csv(""filename.csv")"""""" Then jupyter notebook do not show anything no data no error.. What could be the solution? I am working on IMAC
Hi, i am finding error in importing excel file, "SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 0-1: truncated \UXXXXXXXX escape" .Can you please let me know how to resolve it.
you need to first set the current working directory and in that directory, you need to keep the file. The name could be anything. I kept my folder name as "panda". Please watch this video it would help you to set the current working directory and clear your doubt. ruclips.net/video/swl7pFoZ4vc/видео.html
@@Vikas03kumar this comment just made my day. Finally got the excel data imported after watching multiple videos which didn't indicate clearly that I needed to do this.
First you need to set the path. If your path is not configured then how system finds the file. Check this video: ruclips.net/video/swl7pFoZ4vc/видео.html
You must install and call the xlrd package before importing the excle(.xls,.xlsx) file into jupyter Notebook. Use (!pip install xlrd) or also check this link:- stackoverflow.com/questions/48066517/python-pandas-pd-read-excel-giving-importerror-install-xlrd-0-9-0-for-excel
Extremely happily with the tutorial, i struggledto load with thousands of way. Finally its working. God bless
Man your voice is so calmy in good way
I am transitioning from R and this video is extremely helpful! Thank you
Well explained Sir, Kindly provide your sheet to ease our practice on your description.
THANK YOU SO MUCH!!!!!! finally working after watching many tutorials
Thanks for your video. It's helpfull for me as a beginner
Thank you bro really helpful till now I was unable to load data set
such an awesome video - really helped me with my task when i was freaking out!!! for any beginners - make sure to open the correct folder on Jupyter notebook so that it can locate the correct file ;)
Thank you very much. it was really nice with a clear descriptions .
valuable for beginner good vedio
More Informative and more accurate ✨👍 Thankyou Sir
Very good explanation .Keep it up
man youre greate, simple and easy. thanks for this
People commenting that they get a file not found error need to upload the excel file first to your jupyter notebook. This video here explains how to do it with a CSV, but the same applies to an excel file (ruclips.net/video/JwteBpgMYuE/видео.html). Once you upload the data frame if you are looking for some nice visualizations I was told to use Seaborn (ruclips.net/video/6GUZXDef2U0/видео.html). Hope it helps
Thanks a lot!
Thanks
I am happy it was able to load. Thank you
Really appreciable. 👏 Can you pls show an example of extracting a particular value from this data set?
Thanks sir its very useful for me🙏🙏
Thank you so much ❤, it's very helpful video indeed🙂🙂
Thanks for your vedio.this is really helpful for us.
Very well explained. Thank you!
you should create more videos.
thank you soOoO much , oh my god you helped me very well , THANKS
so clear tutorial. How can we express only one row or column?
it was helpful
Good really helpful
Thank you for the info !!!
Great job 🙏🏽
Thank for the video. A small note Pandas read_excel method removed support for xlsx files. Kindly please update the information otherwise someone might find hard to follow the video.
Thanks for that video Sir 😊😊
Thankyou bro , really helpful for me ,
Please make video on python project step by step:)
Thank you sir it was very helpful ☺️
Thank you for the clear explanation. How can I add the slider to show the loaded data?
Thanks for your video
nice
Can I upload an account statement directly to Jupiter without opening it up in excel n arranging data..? I get an error message : expected 1 field on row 1, saw 4 .
great explanation and easy to follow. so helpful, thank you bro. keep it up :)
Thank you sir.
Thanks bhai😊
Plz make more videos we need you
How to set directory if I have excel in local drive of system and I am using jupyter notebook as a cloud based UI
I have query...this is only file to read jupyter as pandas CSV file as it is ...but how to calculate input read file output calculation or date after successfull read for file any code editor
How can you import and excel with extension .xlsb? I get different opinions that pandas does not support xlsb and some that say there is a way to import it.
thank you very much
Ive one question
Don't we need to show the file path? I mean what is the location should mention or not.
What if there are multiple tabs in Excel and we have to import only one
Thanks bro...
Hi, Thanks for your video. I have just started learning. How do we go from here to create different types of visualization charts from the imported excel data?
You can create charts using Matplotlib packages. You can refer this link: matplotlib.org/tutorials/introductory/sample_plots.html#sphx-glr-tutorials-introductory-sample-plots-py
@@Vikas03kumar Great!!! Thanks for the guidance
Who to download dataset and fix pc and in excel file and jupyter notebook
What are the index we are to press for it to be executed.. I didn’t get that
I imported in same way as you shown in this video. But I'm getting error as "There is no File". Plz resolve my issue.
Hi how do i change dtypes before import data. When import value 0001234 why the result is 1234 not 0001234
It reads all preceeding zero as null that is mathematically true.
Sir can you please how to use the jupyter notebook online
Please make some more videos...
Thanks mate
Hi
In location patch in my laptop it showing patch .ods kindly help me how can we import dat excel to python
I copyed everything but I have error. I dont know why. (i put it my file name only)
Thank you
Hello there! I got a "File not found error" in my jupyter IDE for a csv file...please how can i address this issue...regards! blessings
can someone help me? When I read csv file as """"" pd.read_csv("filename.csv")""""" the data frame appear below but when I assign a variable like """"""df = pd.read_csv(""filename.csv")"""""" Then jupyter notebook do not show anything no data no error.. What could be the solution? I am working on IMAC
DF ko nichy print bi krwai
thank you!!
Hi, i am finding error in importing excel file, "SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 0-1: truncated \UXXXXXXXX escape" .Can you please let me know how to resolve it.
Try this link to explore:
pretagteam.com/question/python-pandas-readexcel-returns-unicodedecodeerror-on-describe
Plz upload full step EDA
It still give me error that the file is not there ???????strange !!!!!
no where the file path is given?
I get an error when I try to import .csv. It says “ no such file or directory : for my file name thag I put
Bro hope you’ve come across a solution ....I’m having the same problem
It is saying file not found. it has to be saved under pander folder?
you need to first set the current working directory and in that directory, you need to keep the file. The name could be anything. I kept my folder name as "panda". Please watch this video it would help you to set the current working directory and clear your doubt. ruclips.net/video/swl7pFoZ4vc/видео.html
@@Vikas03kumar this comment just made my day. Finally got the excel data imported after watching multiple videos which didn't indicate clearly that I needed to do this.
My running is telling
No such file or directory: 'housing_excel'
Thank you
First you need to set the path. If your path is not configured then how system finds the file.
Check this video:
ruclips.net/video/swl7pFoZ4vc/видео.html
Pls sorry what are d skills needed to become a Data scientist and do u really needed Deep learning for Datascience
Plz Need Help To Load The Data Set
Anyone facing issue to access this video? i m not able to see video jus audio
It is working fine.
Please zoom we can’t see it is toooooi tiny also I have copy everything nothing worked 4 hours for nothing
Sir xlsm file ko kase read kare
I have copied every thing and I could not download the excel file !!!!!!!
this is not working...even it's showing no such file or directory
You need to put file in specific location first and then set the directory and then try to load the files.
while loading excel file i got xlrd error. what to do?
You must install and call the xlrd package before importing the excle(.xls,.xlsx) file into jupyter Notebook. Use (!pip install xlrd) or also check this link:- stackoverflow.com/questions/48066517/python-pandas-pd-read-excel-giving-importerror-install-xlrd-0-9-0-for-excel
Showing error
No such file or directory error
Errno 2
waste of time just taking time for explaining nothing
Thanks for your vedio.this is really helpful for us.