Python Pandas Tutorial 4: Read Write Excel CSV File

Поделиться
HTML-код
  • Опубликовано: 4 окт 2024

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

  • @codebasics
    @codebasics  2 года назад +5

    Check out our premium machine learning course with 2 Industry projects: codebasics.io/courses/machine-learning-for-data-science-beginners-to-advanced

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

      Ur vids are great but in pandas I cud not bring my csv excel file into pandas. Syntax error or kernel not connected or other big red lines

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

    can't believe that these videos was made in 2017. still so much helpful and easy to understand

    • @codebasics
      @codebasics  2 года назад +9

      I am happy this was helpful to you.

  • @Mushsayer
    @Mushsayer 4 года назад +40

    First of all, this the best tutorial I have seen on python and secondly you mention something else where people might have question in that topic. You answered all my questions when you are teaching. YOU ARE THE BEST!

    • @mymoviemania1
      @mymoviemania1 5 месяцев назад

      What are you doing currently?

  • @anshuraj5734
    @anshuraj5734 Год назад +6

    This is by far the best series on Pandas which I've came across till date. Thanks sir for making things look this easy.

  • @khansaluqman8665
    @khansaluqman8665 3 года назад +10

    I was happy when you got the error with skip_rows and you showed us how to search for methods and debug your code. Amazing videos. Thanks a ton for teaching us :D

  • @jananibalaji2782
    @jananibalaji2782 Год назад +5

    I want to take a moment and Thank you for all your efforts. I am in the beginning stages of learning Python and it has been very confusing. Your detailed tutorials are super helpful and I am learning a lot, taking notes! Bless You!

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

      Best of luck!

    • @dopamine8840
      @dopamine8840 7 месяцев назад +1

      Hi jananibalaji, how are you? I'm in the stage where u were mentioned. Have u got ur job in Python or Data Science? If so I want big tips of real-time environment from u which will help me lot in understanding python much better and knowing the real world of python. could u help me in this? I believe that u know well about the huge difference between studying things and real world of things. Thank u

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

    Can't believe that these videos was made in 2017. Still so much helpful and easy to understand.Best Pandas playlist ever

  • @kevinzhang8974
    @kevinzhang8974 7 лет назад +18

    I can't stop myself to keep learning Pandas by watching this series ... this is the best ...

    • @loveSG999
      @loveSG999 4 года назад

      Totally agree mate

    • @CyberPin2001
      @CyberPin2001 4 года назад

      Agree -better than any others I have watched and I have watched a lot.

  • @andrewdouglas9559
    @andrewdouglas9559 Год назад +2

    This is the best tutorial on Pandas I've seen so far. Thanks for putting this together.

  • @NMAAJIDKHANMIS
    @NMAAJIDKHANMIS 5 лет назад +5

    By far the best series of videos you would ever find. Thanks.

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

    Maybe 6 or 7 mins in and you have helped me out already, thanks. Not sure if I have posted a comment before but your pace and diction are greatly appreciated, content is clear and to the point, again thank you. Stay healthy and safe.

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

    after visiting many platform and youtube videos, I am learning actual thing in a practical way.

  • @loveSG999
    @loveSG999 4 года назад +12

    Dear Sir, I truly appreciate your teaching style: always clear, straight to the point, and thorough enough to cover the logics behind each task! I also like how you break things down to simple terms using plain English so that IT challenged people like me can easily understand! I will stay tuned to your RUclips channel while continuing to learn python! Best Regards👍

    • @codebasics
      @codebasics  4 года назад +1

      Scottie thanks for the detailed feedback buddy. It was certainly useful 😊👍

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

    Five years old video and it's still so relevant, thanks, I'm learning how to read and write excel files.

  • @debashissahoo5031
    @debashissahoo5031 6 лет назад +6

    got clear idea about data_frame and read_csv() - thank you
    one thing: your voice and english all matches to M. S. Dhoni.

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

    Seriously , you teach so many things in a way that one other does ... just amazing

  • @rightwingtrollslayer
    @rightwingtrollslayer 7 лет назад +23

    Love your videos on Python and Pandas. Keep up the good work

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

    This is the best pandas tutorial so far!

    • @codebasics
      @codebasics  4 года назад

      I am glad it was helpful

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

    Showing how you resolve errors is the most important for us like you did as skip_rows.

  • @codebasics
    @codebasics  4 года назад +10

    Step by step roadmap to learn data science in 6 months: ruclips.net/video/H4YcqULY1-Q/видео.html

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

    Your Teaching is Always super , moreover you are helping the Data Science Community, sincere Thanks to you

  • @sep69
    @sep69 6 лет назад +8

    Thank you for this great tutorial. Just getting started with pandas and your video's are a fantastic help :)

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

    Thank you, instructor, to make the videos. Love your voice.

  • @fanchihk
    @fanchihk 5 лет назад +1

    Thank you. I love you work. You make the process simple, clear, direct.

    • @codebasics
      @codebasics  5 лет назад +1

      Fanchihk, thanks for sharing a valuable feedback 👍

  • @thatguyadarsh
    @thatguyadarsh 5 лет назад

    your video tutorials are packed with soo much stuff....its like small packet but big explosion!! ..thank you so much for sharing ur valuable knowledge and experiences with us !!

    • @codebasics
      @codebasics  5 лет назад +1

      "Small package but big explosion" love that analogy adarsh ❤️ Thanks 😊

  • @getosuguru-i6c
    @getosuguru-i6c Год назад +1

    This class is a gem ♥♥♥

  • @terryhenyo9216
    @terryhenyo9216 5 лет назад +1

    Thanks for the very detailed tutorial of read_csv!

    • @codebasics
      @codebasics  5 лет назад +1

      Terry I am really glad you liked it

  • @mohanlpuri1
    @mohanlpuri1 4 года назад

    Very clear explanation with examples. Quick tutorial to learn Panda use in Python. Excellent job.

    • @codebasics
      @codebasics  4 года назад +1

      Mohan I am happy to help buddy :)

  • @zennologyofeverything7265
    @zennologyofeverything7265 6 лет назад

    thank you bro. you are the first one to teach so clearly

  • @CyberPin2001
    @CyberPin2001 4 года назад

    Another first class video. Great detail without the complexity. Thanks!

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

    small tip :
    You can use Windows + left/right arrow key to adjust multiple windows ,
    makes it so much easier than dragging it manually with a cursor

  • @codebasics
    @codebasics  5 лет назад +4

    Machine learning tutorials with exercises:
    ruclips.net/video/gmvvaobm7eQ/видео.html
    Step by step roadmap to learn data science in 6 months: ruclips.net/video/H4YcqULY1-Q/видео.html

  • @theadrix92
    @theadrix92 5 лет назад +1

    great tutorial, clear and straight to the point

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

    You teach really well.I got all my doubts clear

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

    Greatly explained the commands to filter and visualize the data...very nice

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

    you are giving a knowledge in different way sir

  • @ChiTamNguyen-d9d
    @ChiTamNguyen-d9d Год назад

    You're the GOAT. The tutorial is extremely helpful.

  • @itsvenkis1
    @itsvenkis1 6 лет назад

    you made learning of Pandas easy and interesting . Thanks

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

    Thanks a lot. I was unable to import data in jupyter. Your video really helped me.

  • @bhaskarsubbaiah6002
    @bhaskarsubbaiah6002 4 года назад

    loving the way you are teaching

  • @himanshukarki
    @himanshukarki 5 лет назад +1

    I understood everything you tough by now... Thanks for useful content

  • @RAGHURAM-jb6qc
    @RAGHURAM-jb6qc 4 года назад +1

    Thanks for the videos, everything is so clear. Really love them

  • @abdulbasithos8805
    @abdulbasithos8805 4 года назад

    Ultimate for spreadsheet automations users.
    Thanks for this tutorial and requesting to make some videos related to styling of cells.

    • @codebasics
      @codebasics  4 года назад +1

      Abdul I am glad you found this to be useful 👍

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

    Definitely one of the best Pandas tutorial that I've found on internet. However, I got a bit confused when you called the converter function inside a dictionary and didn't use any arguments whereas the function had converters(cell) as argument. How did that work? Thanks!

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

    Videos are just perfect. I just wanna know are you a data scientist or analyst.

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

      I am a data engineer. Now you will ask me what is the difference between the three :) Well I have a video on explaining the difference between these 3 roles.

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

      @@codebasics data engineer sounds like king of data oriented IT jobs. Keep it up.

  • @bizeet24
    @bizeet24 4 года назад

    Thanks for the video. An observation, at 6:08 min of this video, you have taught us how to put a label on the column in case we don't have. So I was trying to another data set which has higher number of columns and if I don't name them all, the columns were named from right to left, in place of left to right.

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

      I think in dictionary the order is a bit different. I am not able to say that exactly. But you can look up any basic tutorial on dictionaries. The qn is 1 year old. Sorry about that. You must have learned so much more.

  • @kostasnikoloutsos5172
    @kostasnikoloutsos5172 7 лет назад +1

    Great video, I really enjoyed it till the end.
    19:12 you better use a lambda function!

  • @HappyTrails238
    @HappyTrails238 7 лет назад

    Great video and easy to follow and learn the essentials of reading and writing to/from a dataframe.

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

    Great vedios for non cs backgroung nice and simple explaination.

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

    just completed this video and also I am taking notes. Moving to next video :)

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

    Thank you dear ,simple and condensed information.

  • @CodingMazaa
    @CodingMazaa 5 лет назад

    Awesome intro to data science!

  • @jitu1856
    @jitu1856 6 лет назад +1

    best tutorials on pandas :) thanks

  • @elpintor2091
    @elpintor2091 6 лет назад

    I love your videos sir you have a way of making me feel calm while learning

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

    At 11:40 you could have added that row 4 in price column did not change as it was not included in the dictionary. At 12:30 the demo of to csv the NaN was not found in the csv file. Those cells were blank. However the 4th row of column price had the NA intact.

  • @priyadarsinipaital5755
    @priyadarsinipaital5755 5 лет назад +1

    Thank you for this great tutorial. it's Awesome......which I found very helpful.

    • @codebasics
      @codebasics  5 лет назад

      Priyadarsini, I am glad you liked it

  • @gaddamshanthsri125
    @gaddamshanthsri125 5 лет назад +1

    superb teaching sir

    • @codebasics
      @codebasics  4 года назад

      Thanks a lot for your kind works Sri Shanth. Stay in touch for more videos and share our channel if you really find it worth.

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

    This video is very useful.Awesome explanaition

  • @VishalSharma-rn7mt
    @VishalSharma-rn7mt 4 года назад +1

    Your are rocking, great video, thank you so much. It saved my life.....!!

    • @codebasics
      @codebasics  4 года назад +1

      Glad you like it Vishal 👍😊

  • @duna7381
    @duna7381 7 лет назад

    Great videos! There are many details I didn't know about pandas. Thx for the effort. Waiting for further videos :)

  • @akshay4081
    @akshay4081 5 лет назад +1

    Phenomenal Videos Sir!!!
    One doubt how to create new data sheet in the same excel file

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

    Thank you for this very useful video!

  • @sriharshavardhan299
    @sriharshavardhan299 5 лет назад

    ur my teacher sir ... thank you sooo much

    • @codebasics
      @codebasics  5 лет назад +1

      Glad to be your teacher sri 😊🙏

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

    Excellent tutorial.

  • @rohank2825
    @rohank2825 4 года назад

    ‘Those who know, do. Those that understand, teach.’ -Aristotle
    thank you very much sir for your effort .

    • @codebasics
      @codebasics  4 года назад +1

      Another great quote Rohan 👏👏👏

  • @guningogoi3733
    @guningogoi3733 5 лет назад

    Nice tutorials to learn Python - Pandas

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

    Wonderful class! I've just found your channel.
    Thank you!

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

    simply super content explained

  • @amandaschettini3416
    @amandaschettini3416 7 лет назад

    Excellent video. It actually helped me out a lot for a recent project.

  • @dnkalita
    @dnkalita 4 года назад

    Extremely helpful.Thanks.

    • @codebasics
      @codebasics  4 года назад

      I am happy this was helpful to you.

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

    Thank you for your fantastic tutorial! You have helped me tremendously!

  • @mohitgupta1958
    @mohitgupta1958 6 лет назад

    Fantastic Videos. Covered all necessary functionalities with maximum ease. Thanks a lot :-)

  • @saadmanahmed860
    @saadmanahmed860 4 года назад

    very good illustration

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

    excellent. clear, to the point. love it.

  • @melanieunida2976
    @melanieunida2976 4 года назад

    you helped me in my assignment. thank you

  • @swetabhattacharjee1203
    @swetabhattacharjee1203 4 года назад

    Your tutorials are best....thank u...learnt a lot from ur videos ....have subscribed your channel.. waiting for tutorials on other python modules like sklearn nltk keras

    • @codebasics
      @codebasics  4 года назад +1

      For sklearn I already have a full series. Check it out on my channel it's called machine learning tutorials

  • @ninonazghaidze7687
    @ninonazghaidze7687 5 лет назад +1

    Great thanks for the excellent tutorial!

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

    Very clear video - thank you!

  • @sameerparnami4995
    @sameerparnami4995 5 лет назад

    if you are getting "UnicodeDecodeError"
    try reading with below:
    data = pd.read_csv('file_name.csv', encoding='utf-8')
    and the other different encoding types are:
    encoding = "cp1252"
    encoding = "ISO-8859-1"
    Hope this helps !!

  • @hariharamoorthythennetipan2190
    @hariharamoorthythennetipan2190 7 лет назад

    Very nice detail explanation.

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

    Converters functions is changing sam walton on every n.a. value in PEOPLE it doesn't checks for TICKERS . I put -1 on 1st row having tickers as google also changed to sam walton(changes larry page)

  • @srikantpadhy7102
    @srikantpadhy7102 5 лет назад

    I Love your video so much.I am very happy with out any cost you gave like this lactrue. thanks a lot......

    • @codebasics
      @codebasics  5 лет назад

      Yes srikant social media platforms makes it easy to share the content and make it availt for the ones who need it. RUclips is indeed an awesome platform.

  • @deekshithanand3094
    @deekshithanand3094 4 года назад

    Sir the series is a great one to learn. But it would be great if you could have hosted the required dataset elsewhere or in a different repe. I had to clone to entire repo which had other things. So now I am doing copy and pasting csv in raw format from github!

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

    Great job, sir!

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

    Ok,Thank you! I will upgrade.

  • @amanrastogi1232
    @amanrastogi1232 5 лет назад

    if instead of -1 it is possible that there must be other negative number like -100 or -987 how to change these to Nan...
    your videos are awesome . Thanks for teaching us :)

  • @aduck24
    @aduck24 5 лет назад

    This is life saver. Thank you very much.

  • @zulfikaraziz
    @zulfikaraziz 4 года назад

    Great Explanation,Thanks sir !

  • @kannanv8831
    @kannanv8831 4 года назад

    Every tutorial getting me excited. A best tutorial of pandas.

  • @MostafaMASLOUHI
    @MostafaMASLOUHI 6 лет назад

    Very nice works. Thank you for your efforts.

  • @codebasics
    @codebasics  4 года назад

    How to learn coding for beginners | Learn coding for free: ruclips.net/video/CptrlyD0LJ8/видео.html

  • @n.s.karthik5628
    @n.s.karthik5628 4 года назад

    Excellent video thank you

  • @Ankurkumar14680
    @Ankurkumar14680 5 лет назад

    Very good video, please add videos on Deep Learning and Text Analytics also

    • @codebasics
      @codebasics  5 лет назад

      Yes ankur. I have big plans but I am facing some health issues and that's why not able to find time. But as soon as I recover I will resume the work! Thanks for your interest in my content.

  • @MahmoudBacha.r.s_personal
    @MahmoudBacha.r.s_personal Год назад

    Thank you so much sir , OSU !

  • @matheussazevedo9588
    @matheussazevedo9588 5 лет назад

    Very useful tips, thanks!

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

    Fantastic video

  • @PinhoDeng
    @PinhoDeng 5 лет назад

    Excellent explanation. Thank you!!

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

    For the Excel reading/writing I had to pip install openpyxl. That threw me a little but otherwise the video was very helpful, thanks lots! :-)

  • @jatinfalwaria7087
    @jatinfalwaria7087 7 лет назад +11

    where is your csv file stored in pc???
    coz m getting an error of file not found.
    Much appreciated video content .Thanx :)

    • @jatinfalwaria7087
      @jatinfalwaria7087 7 лет назад

      codebasics thanx buddy😁

    • @alokpratap2094
      @alokpratap2094 6 лет назад

      codebasics sir how we can give the absolute path, sir please help me

    • @inclinedscorpio
      @inclinedscorpio 5 лет назад +2

      whereever the csv be located , just after opening your notebook go to upload and then from browse go to location your file is located and upload it !!

    • @herlinanapitupulu5593
      @herlinanapitupulu5593 4 года назад +1

      @Nirav.Raval Mtech2018 Thanks so much..

    • @shan5612
      @shan5612 4 года назад

      If you have got the Answer plz write it here.

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

    Instead of puttin -1 in the na_values to remove from revenue column, is there a way to give an argument which says if less than 0 then NaN ?