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

Поделиться
HTML-код
  • Опубликовано: 24 сен 2024
  • 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.

Комментарии • 155

  • @nq1342
    @nq1342 2 года назад +19

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

  • @LuyandaDuma-s7s
    @LuyandaDuma-s7s 11 месяцев назад +3

    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
      @manjitsharma889 6 месяцев назад

      it worked brother, thanks for your comment

  • @m.night_shyamamalama_sama_kun
    @m.night_shyamamalama_sama_kun Год назад +5

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

  • @daisylovesparis
    @daisylovesparis Год назад +1

    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.

  • @TowfeeqRameezShaik
    @TowfeeqRameezShaik 3 месяца назад +1

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

  • @rajgsrinivas
    @rajgsrinivas 2 месяца назад +1

    Thank you somuch for the simple explanation.

  • @venkysworld
    @venkysworld 2 года назад +4

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

  • @santiagoarsuaga369
    @santiagoarsuaga369 2 года назад +17

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

    • @max8232-q2g
      @max8232-q2g Год назад +1

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

  • @ashutoshannamwar
    @ashutoshannamwar Год назад +1

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

  • @micheleobama2809
    @micheleobama2809 Год назад +1

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

  • @jainjoy2221
    @jainjoy2221 2 года назад +4

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

  • @manojkule195
    @manojkule195 11 месяцев назад +1

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

  • @abdelilahazelhak924
    @abdelilahazelhak924 2 года назад +1

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

  • @honedattraction4110
    @honedattraction4110 Месяц назад

    A gold video in itself. Thank you sir.

  • @danielleshelton6706
    @danielleshelton6706 Год назад +3

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

  • @surajmeshram6656
    @surajmeshram6656 2 года назад +2

    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.

  • @dpurposedrivenwoman-kosy
    @dpurposedrivenwoman-kosy Год назад +1

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

  • @brosjay2131
    @brosjay2131 Год назад +1

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

  • @taahirahbenzinat3660
    @taahirahbenzinat3660 Месяц назад +1

    So helpful! Thanks

  • @TowfeeqRameezShaik
    @TowfeeqRameezShaik 3 месяца назад

    guys who want to thank him just hit a like button

  • @oshadhadammearachchi7772
    @oshadhadammearachchi7772 Год назад +1

    This guy made my day !

  • @pasangpasang7803
    @pasangpasang7803 2 года назад +2

    simple and effective explanation

  • @statisticseducator
    @statisticseducator 7 месяцев назад

    Honestly very good explanation

  • @comealive182
    @comealive182 2 года назад

    Excellent delivery

  • @cruzmonte4614
    @cruzmonte4614 Год назад

    amazing work bro, am liking and following

  • @ahmadndaliman8051
    @ahmadndaliman8051 11 месяцев назад

    thank you man, it worked.

  • @prathmeshkulkarni2079
    @prathmeshkulkarni2079 Год назад +1

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

  • @soufianetaoufik7830
    @soufianetaoufik7830 2 года назад +1

    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

  • @nyiransangwascolastique7640
    @nyiransangwascolastique7640 5 месяцев назад +1

    thank you
    🙏🙏

  • @shailajamunukala5430
    @shailajamunukala5430 4 месяца назад

    Thank you very much sir

  • @chakranezakariae6227
    @chakranezakariae6227 Год назад

    my friend omar saaidi and I are thanking you

  • @jongdave2691
    @jongdave2691 2 года назад +25

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

    • @adityamehra7238
      @adityamehra7238 2 года назад +1

      How did you solve it?

    • @anilchauhan573
      @anilchauhan573 2 года назад

      same problem

    • @kikibryceofficial6223
      @kikibryceofficial6223 2 года назад +15

      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
      @akshitha986 2 года назад

      @@kikibryceofficial6223 great thanx

    • @piyushsahu2652
      @piyushsahu2652 2 года назад

      @@kikibryceofficial6223 thanks man 👍

  • @apalachatterjee3730
    @apalachatterjee3730 2 года назад +2

    Helpful. Thank You So Much.

  • @Shiksharathore-w8v
    @Shiksharathore-w8v 6 месяцев назад

    Thankyou so much sir ☺️

  • @rkb89
    @rkb89 2 года назад +3

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

    • @veerendrasathwik2715
      @veerendrasathwik2715 2 года назад

      Fckn legend you're

    • @welcome.to.1percent.community
      @welcome.to.1percent.community 2 года назад

      @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

  • @gamespotlive3673
    @gamespotlive3673 4 месяца назад

    Thank you sir.

  • @NeneSmith23
    @NeneSmith23 2 года назад +1

    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
      @kikibryceofficial6223 2 года назад

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

  • @phaedra7285
    @phaedra7285 2 года назад +1

    This helped! Thank you so much

  • @jobdedo
    @jobdedo Год назад +1

    thanks man

  • @milavyousef3577
    @milavyousef3577 4 месяца назад

    Thank you 🙏🏼

  • @BradHua
    @BradHua 2 года назад +1

    Thanks for sharing!

  • @jatinjoshi1830
    @jatinjoshi1830 Год назад

    Thank you so much for your effort.

  • @babarhans7485
    @babarhans7485 Год назад

    Very easy explaination ❤

  • @stephanromero4979
    @stephanromero4979 2 года назад

    Thank you for the explanation!

  • @sufianabdul7458
    @sufianabdul7458 Год назад

    thank you so much

  • @paxywan6583
    @paxywan6583 Год назад

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

  • @vallerijoshna5858
    @vallerijoshna5858 2 года назад

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

  • @bhaviavs9903
    @bhaviavs9903 3 года назад +2

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

    • @learnurself1234
      @learnurself1234  3 года назад

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

  • @haritimamishra333
    @haritimamishra333 2 года назад

    Thank you sir very helpful video

  • @sandhyayadav2189
    @sandhyayadav2189 Год назад

    Thanks a lot

  • @kalabid9617
    @kalabid9617 Год назад

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

  • @Islamic_videos627
    @Islamic_videos627 Год назад

    Thank you very helpful

  • @waqarbinjamil3577
    @waqarbinjamil3577 13 дней назад

    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

  • @prashantprabhu6970
    @prashantprabhu6970 2 года назад

    Helpful video... Thanks!

  • @RememberRox
    @RememberRox Год назад

    Thank you!!

  • @divinetv4570
    @divinetv4570 3 года назад +1

    ❤❤❤❤❤

  • @mikiaseshetu3786
    @mikiaseshetu3786 2 года назад

    Thank you, Very helpfull

  • @partabparmar5537
    @partabparmar5537 2 года назад

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

  • @basharabuqaaud4676
    @basharabuqaaud4676 2 года назад

    Thanks for the demo :)

  • @businessdevelopmentstrategies
    @businessdevelopmentstrategies 3 года назад

    very good explaination brother

  • @sonic-fan-play4817
    @sonic-fan-play4817 2 года назад

    Great job, thanks

  • @khushilshah2858
    @khushilshah2858 Год назад

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

  • @susikavin9412
    @susikavin9412 2 года назад +1

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

  • @nishantarora518
    @nishantarora518 2 года назад

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

  • @ANILKUMAR-mn7pk
    @ANILKUMAR-mn7pk Год назад

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

  • @jamiurrahmanjamir5144
    @jamiurrahmanjamir5144 9 месяцев назад

    best

  • @DataPulse
    @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 ?

  • @SarojAgnihotri_Vlog
    @SarojAgnihotri_Vlog 2 года назад

    Thank you

  • @mainabashir3014
    @mainabashir3014 Год назад

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

  • @andrews13
    @andrews13 2 года назад

    Very good

  • @luisdotto7944
    @luisdotto7944 2 года назад

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

  • @yaminivaka9748
    @yaminivaka9748 3 года назад

    Very useful 👍

  • @jayshreepatra1834
    @jayshreepatra1834 2 года назад

    Thank you so muchh!!!!

  • @parthasinha1656
    @parthasinha1656 2 года назад

    very good,thanks a lot

  • @thirumalareddy5537
    @thirumalareddy5537 Год назад

    thanks

  • @tech_parivaar
    @tech_parivaar 3 года назад +1

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

    • @Vikas03kumar
      @Vikas03kumar 3 года назад +1

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

  • @creatornonu
    @creatornonu 3 года назад +1

    thank u

  • @abdelilahazelhak924
    @abdelilahazelhak924 Год назад

    this is great

  • @ঘরেরস্বাদ
    @ঘরেরস্বাদ 2 года назад

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

  • @edthomas100
    @edthomas100 Год назад

    You havent included the path or setup for the path

  • @jerryvladimire7474
    @jerryvladimire7474 2 года назад

    Thanks for the help bro

  • @VidyavantuEdu
    @VidyavantuEdu 7 месяцев назад

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

  • @ferideymkli
    @ferideymkli 2 года назад

    thank you!

  • @brijeshdeb5133
    @brijeshdeb5133 3 года назад

    thank you
    it was helpful

  • @nyashagracenhandara7757
    @nyashagracenhandara7757 2 года назад

    well explained thank you

  • @jayshreepatra1834
    @jayshreepatra1834 2 года назад

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

  • @techkid358
    @techkid358 Год назад

    how to import all the data from csv file

  • @muhammadzikriismailnasarud9233
    @muhammadzikriismailnasarud9233 3 года назад +1

    not working.. is say my file is not defined

    • @learnurself1234
      @learnurself1234  3 года назад

      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!

  • @scottnguyen4521
    @scottnguyen4521 2 года назад

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

  • @ovichowdhury2398
    @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.......

  • @thecaramel-1
    @thecaramel-1 2 года назад

    thank u ♥️

  • @oumaimajanouj6309
    @oumaimajanouj6309 3 года назад +1

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

    • @Vikas03kumar
      @Vikas03kumar 3 года назад

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

  • @froilanemeliano6551
    @froilanemeliano6551 2 года назад

    doesn't work. still FileNotFoundError

  • @kumarrishabh7042
    @kumarrishabh7042 Год назад

    everything is fine
    but
    pd is not defined

  • @AbidAli-bv2gl
    @AbidAli-bv2gl 3 года назад

    excellent

  • @niranjanreddy3620
    @niranjanreddy3620 2 месяца назад

    data not coming sir

  • @nikhilrathi8500
    @nikhilrathi8500 Год назад +1

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

  • @prasanthk8048
    @prasanthk8048 2 года назад

    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
      @learnurself1234  2 года назад +1

      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

  • @abdeljalilsekal6366
    @abdeljalilsekal6366 2 года назад

    i flow you step by step but thy did not work

  • @durgammahesh8379
    @durgammahesh8379 3 года назад

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