Import csv file in python Jupyter Notebook using pandas. Load csv file python Jupyter notebook

We have started the Data Science Foundation series which actually eases our data operations in Data Science Field.
Please check the complete video tutorials and search video with
DSFP001- Keyword.

[@nq1342]

Honestly one of the best explanations and tutorials - especially for beginners. Real-life saver, thank you my friend!

[@daisylovesparis]

thank you so much. It has been a year I hadn't used Python and kinds forgot how to import the file. This was very easy to follow.

[@m.night_shyamamalama_sama_kun]

love how you put the microphone on your tongue, loved all the mouth sounds you made, really made me learn easier

[@user-oc8rh3gg1z]

Nice explanation... You helped me a lot..."
But I noted one thing... I'm mentioning it just in case another person comes across the same problem as I did
When I put the filename only, it didn't, I honestly don't why...
Then I changed and used the file path, I then replaced the backslashes on the filepath with the forwardslashes, then it worked.

[@manjitsharma889]

it worked brother, thanks for your comment

[@venkysworld]

Very good explanation. Step by Step approach. Easy to learn with your videos. Thank you.

[@ashutoshannamwar]

Thank you man 😌 you solved my major problem of importing the csv. I had a problem with the location and it got resolved.

[@santiagoarsuaga369]

But how do I establish the folder in which read_csv will look for the file?

[@max8232-q2g]

# Find out your current working directory
import os
print(os.getcwd())

[@honedattraction4110]

A gold video in itself. Thank you sir.

[@danielleshelton6706]

Thank you for this. Working on my first project and this really helped!

[@manojkule195]

your learning skill is very nice .. thank you for your video

[@TowfeeqRameezShaik]

You helped me a lot how to upload files. Thank you a lot

[@jainjoy2221]

great great explanatiom! can feel how much you love teaching from the way you explain!

[@surajmeshram6656]

It's nice tutorial of Short part of ML , it's was really helpful for me ..can uplod fulll tutorial of ML?? .it help for me or many other who really need that types of teaching.

[@micheleobama2809]

waiting for ur more vedios... u explaining clearly ,, ur a great teacher... sending u love and tnk u ,,, keep it up ,, we need

[@dpurposedrivenwoman-kosy]

Please more videos. I enjoy your teachings. Thank you so much

[@rajgsrinivas]

Thank you somuch for the simple explanation.

[@abdelilahazelhak924]

very good man , continue , i had a problem using location , i chnaged it to Desktop and it worked well.

[@statisticseducator]

Honestly very good explanation

[@TowfeeqRameezShaik]

guys who want to thank him just hit a like button

[@pasangpasang7803]

simple and effective explanation

[@chakranezakariae6227]

my friend omar saaidi and I are thanking you

[@comealive182]

Excellent delivery

[@cruzmonte4614]

amazing work bro, am liking and following

[@brosjay2131]

Great tutorial. I loved it and I've subscribed.

[@taahirahbenzinat3660]

So helpful! Thanks

[@prathmeshkulkarni2079]

If you get an error for file not found just put r in front of filename:
data = pd.read_csv(r"filename.csv")

[@vallerijoshna5858]

Great explanation nice video it's helped a lot thank you.

[@apalachatterjee3730]

Helpful. Thank You So Much.

[@jongdave2691]

I get error of "FileNotFoundError". Please explain more about the csv file path setup.

[@adityamehra7238]

How did you solve it?

[@anilchauhan573]

same problem

[@kikibryceofficial6223]

Use the format pd.read_csv("location\\file name.csv") eg if the file location is C:\Users\user\Documents make sure you use double backward slash on the location eg C:\\Users\\user\\Documents.Lets say for example your csv file is called "Data".The final part will look like this. pd.read_csv("C:\\Users\\user\\Documents\\Data.csv")
Hope this helps

[@akshitha986]

@@kikibryceofficial6223 great thanx

[@piyushsahu2652]

@@kikibryceofficial6223 thanks man 👍

[@nyiransangwascolastique7640]

thank you
🙏🙏

[@rkb89]

I had to modify a bit, dataset = pd.read_csv(r"filepath")

[@veerendrasathwik2715]

Fckn legend you're

[@welcome.to.1percent.community]

@Rohan Bhardwaj thanks a lot bro, i literally spend almost 2 hour on this but I am not getting solution and you solve this problem within 1 min, really appreciated dude

[@oshadhadammearachchi7772]

This guy made my day !

[@shailajamunukala5430]

Thank you very much sir

[@NeneSmith23]

No matter what I do ... I always get an error. juypter cannot find my files and I don't know why I NEED HELP !! like the explanation you gave was great I followed it to a "t" and still it just says no such file or directory

[@kikibryceofficial6223]

Use the the following format pd.read_csv("location\\filename.csv")
nb. Make sure the location has the double backward slash.
Hope it helps

[@haritimamishra333]

Thank you sir very helpful video

[@soufianetaoufik7830]

i followed the same steps but the data set is not showing. i have the csv file in the desktop, should it be somewhere else? thank you

[@babarhans7485]

Very easy explaination ❤

[@user-cg1dr3pm3n]

Thankyou so much sir ☺️

[@gamespotlive3673]

Thank you sir.

[@BradHua]

Thanks for sharing!

[@jatinjoshi1830]

Thank you so much for your effort.

[@andrews13]

Very good

[@businessdevelopmentstrategies]

very good explaination brother

[@ahmadndaliman8051]

thank you man, it worked.

[@prashantprabhu6970]

Helpful video... Thanks!

[@jamiurrahmanjamir5144]

best

[@stephanromero4979]

Thank you for the explanation!

[@phaedra7285]

This helped! Thank you so much

[@Islamic_videos627]

Thank you very helpful

[@kalabid9617]

I am trying to learn this on the Carnet app. I am unable to load the csv file.

[@paxywan6583]

Why is the "import" green in colour? Mine isn't green and i am worried.

[@bhaviavs9903]

After giving the file name with extension. Csv, it's showing error, what maybe the reason

[@learnurself1234]

It depends on error. May be file path is missing or you have not kept the filename.csv under the doible quote. .

[@jobdedo]

thanks man

[@milavyousef3577]

Thank you 🙏🏼

[@nyashagracenhandara7757]

well explained thank you

[@sufianabdul7458]

thank you so much

[@mikiaseshetu3786]

Thank you, Very helpfull

[@sandhyayadav2189]

Thanks a lot

[@parthasinha1656]

very good,thanks a lot

[@DataPulse]

Thanks a lot for this video. I got encoding of csv file as utf-8. Jupyter throws error "'utf-8' codec can't decode byte 0x93 in position 285: invalid start byte". could you suggest the best encoding for csv files for jupyter ?

[@yaminivaka9748]

Very useful 👍

[@sonic-fan-play4817]

Great job, thanks

[@abdelilahazelhak924]

this is great

[@susikavin9412]

Hi sir i use d same code bt get a error like file not found could yu please help me with that

[@NitishSharma-zi6qr]

Same here

[@jayshreepatra1834]

can you please share the video of how to predict the invoice is going to get paid.?... plzzzzzzz

[@basharabuqaaud4676]

Thanks for the demo :)

[@nishantarora518]

what if the file and notebook are not in the same folder. ( because this will not work then )

[@ANILKUMAR-mn7pk]

I have file in c folder but unable to fetch, how can i solve this problem

[@jerryvladimire7474]

Thanks for the help bro

[@AbidAli-bv2gl]

excellent

[@partabparmar5537]

thank you bhai..................!!

[@brijeshdeb5133]

thank you
it was helpful

[@user-wg1rp7qg3v]

I am getting FileNotFoundError while trying to read the file. can someone explain it why I am getting and how to solve it.

[@tech_parivaar]

I m getting file not found error. please help me. the csv file is not reading from my local system

[@Vikas03kumar]

First you need to keep the file in some location and set that location as directory. Check this video: ruclips.net/video/swl7pFoZ4vc/видео.html

[@khushilshah2858]

Getting an error file not found. Tried a lot to find the solution but unable to find it

[@ovichowdhury2398]

import pandas as pd
dataset = pd.read_csv("NetFlix-1.csv")
dataset.head()
can someone check why it is running an error? i just copied and pasted file path.......

[@creatornonu]

thank u

[@luisdotto7944]

What happens if you want to load a csv from a web?

[@mainabashir3014]

in importing do i have to inclue the fath of the file?

[@thirumalareddy5537]

thanks

[@divinetv4570]

❤❤❤❤❤

[@SarojAgnihotri_Vlog]

Thank you

[@sampathkumar4141]

It was nice. How load CSV in to local my sql

[@ঘরেরস্বাদ]

It's showing file format and extention don't match naw plz tell me the solution asap pls

[@RememberRox]

Thank you!!

[@jayshreepatra1834]

Thank you so muchh!!!!

[@edthomas100]

You havent included the path or setup for the path

[@techkid358]

how to import all the data from csv file

[@ferideymkli]

thank you!

[@oumaimajanouj6309]

thank you but they keep telling me i have a permission error. do you know why

[@Vikas03kumar]

It might be system-specific issues. You can connect with the system administrator. Thanks!

[@prasanthk8048]

import pandas as pd
import os
data1 = pd.read_csv(‪"‪COVID-19.csv")
file is not open in jupyter but opening in cmd prompt
i want to open in jupyter, please help me

[@learnurself1234]

Kindly read the error what error it shows. Like file not found or unable to find the file. Then search in google with your error and read you would get the answer. This is how troubleshooting done. First set the path for your directory where file kept and then load it

[@scottnguyen4521]

How can I check the bottom 100 rows of the data?

[@durgammahesh8379]

Hi ji.. Can i have a session for export csv to oracle database using python jupyter

[@thecaramel-1]

thank u ♥️

[@ashleymarshall6620]

I am going crazy. I can not import a CSV FILE using pandas. I'm getting error after error and i'm using these methods. One error states file can not be found another error states "unicode error" what does this mean!

[@kanchanvinayakbhale8236]

add r just after the first bracket (r"filename.csv") --solves unicode error

[@snegas2849]

@@kanchanvinayakbhale8236 hey when I read local file and give its location in Jupyter it is showing no path found...what I should I do

[@surabhitiwari4328]

@@snegas2849 ruclips.net/video/swl7pFoZ4vc/видео.html

[@muhammadzikriismailnasarud9233]

not working.. is say my file is not defined

[@learnurself1234]

Then it woukd have priblem with your file type. Kindly check your file type first and confirm, is it csv file or other type. Thanks!

[@nikhilrathi8500]

Just zoom it first here you are going to explain to another

[@militarymusic1794]

Please provide the link of the csv file dataset

[@kumarrishabh7042]

everything is fine
but
pd is not defined

[@abdeljalilsekal6366]

i flow you step by step but thy did not work