Python Pandas Tutorial 4: Read Write Excel CSV File

แชร์
ฝัง
  • เผยแพร่เมื่อ 19 ม.ค. 2025

ความคิดเห็น • 527

  • @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 3 ปีที่แล้ว +24

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

    • @codebasics
      @codebasics  3 ปีที่แล้ว +10

      I am happy this was helpful to you.

  • @Mushsayer
    @Mushsayer 4 ปีที่แล้ว +44

    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 9 หลายเดือนก่อน

      What are you doing currently?

  • @anshuraj5734
    @anshuraj5734 ปีที่แล้ว +7

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

  • @itzzawad3162
    @itzzawad3162 5 หลายเดือนก่อน +2

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

  • @khansaluqman8665
    @khansaluqman8665 4 ปีที่แล้ว +11

    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 ปีที่แล้ว +6

    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  ปีที่แล้ว +2

      Best of luck!

    • @dopamine8840
      @dopamine8840 11 หลายเดือนก่อน +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

  • @andrewdouglas9559
    @andrewdouglas9559 2 ปีที่แล้ว +2

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

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

  • @christopherjspiteri
    @christopherjspiteri 4 ปีที่แล้ว +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.

  • @NMAAJIDKHANMIS
    @NMAAJIDKHANMIS 5 ปีที่แล้ว +5

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

  • @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 TH-cam 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 2 ปีที่แล้ว

    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.

  • @aryosetowicaksono
    @aryosetowicaksono 5 ปีที่แล้ว +2

    This is the best pandas tutorial so far!

    • @codebasics
      @codebasics  4 ปีที่แล้ว

      I am glad it was helpful

  • @rightwingtrollslayer
    @rightwingtrollslayer 8 ปีที่แล้ว +23

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

  • @suyash7450
    @suyash7450 ปีที่แล้ว

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

  • @bhaskarg8438
    @bhaskarg8438 3 ปีที่แล้ว

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

  • @brij1728
    @brij1728 5 ปีที่แล้ว +2

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

  • @mohanlpuri1
    @mohanlpuri1 5 ปีที่แล้ว

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

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Mohan I am happy to help buddy :)

  • @ChiTamNguyen-d9d
    @ChiTamNguyen-d9d ปีที่แล้ว

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

  • @codebasics
    @codebasics  4 ปีที่แล้ว +10

    Step by step roadmap to learn data science in 6 months: th-cam.com/video/H4YcqULY1-Q/w-d-xo.html

  • @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 😊

  • @eliashossain9849
    @eliashossain9849 4 ปีที่แล้ว +2

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

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Glad, you liked it

  • @getosuguru-i6c
    @getosuguru-i6c ปีที่แล้ว +1

    This class is a gem ♥♥♥

  • @sep69
    @sep69 6 ปีที่แล้ว +8

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

  • @sagarmehla2102
    @sagarmehla2102 3 ปีที่แล้ว +1

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

  • @zennologyofeverything7265
    @zennologyofeverything7265 6 ปีที่แล้ว

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

  • @mershadmajeed2246
    @mershadmajeed2246 7 หลายเดือนก่อน +1

    This video contains content:
    1) How to change anything from the start (df.read(.....)) and also using functions in python.
    2) When saving an excel file, how to change the column and row according to ours.
    3) When saving to excel file we can save it in sheet.

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

  • @rajeshsrirangam339
    @rajeshsrirangam339 2 ปีที่แล้ว

    you are giving a knowledge in different way sir

  • @CyberPin2001
    @CyberPin2001 4 ปีที่แล้ว

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

  • @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 👍

  • @muhammadasif7761
    @muhammadasif7761 ปีที่แล้ว

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

  • @mamatasingh7069
    @mamatasingh7069 2 ปีที่แล้ว

    You teach really well.I got all my doubts clear

  • @bhaskarsubbaiah6002
    @bhaskarsubbaiah6002 4 ปีที่แล้ว

    loving the way you are teaching

  • @MohammadMonirHossain-uo2mm
    @MohammadMonirHossain-uo2mm ชั่วโมงที่ผ่านมา

    Good video from a good teacher.

  • @ankitaxalxo409
    @ankitaxalxo409 2 ปีที่แล้ว

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

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

  • @kamilliyev9802
    @kamilliyev9802 5 วันที่ผ่านมา

    You did great job man, I hope you doing TH-cam now

  • @codebasics
    @codebasics  5 ปีที่แล้ว +4

    Machine learning tutorials with exercises:
    th-cam.com/video/gmvvaobm7eQ/w-d-xo.html
    Step by step roadmap to learn data science in 6 months: th-cam.com/video/H4YcqULY1-Q/w-d-xo.html

  • @duna7381
    @duna7381 7 ปีที่แล้ว

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

  • @kostasnikoloutsos5172
    @kostasnikoloutsos5172 7 ปีที่แล้ว +1

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

  • @sagarmehla2102
    @sagarmehla2102 3 ปีที่แล้ว

    This video is very useful.Awesome explanaition

  • @himanshukarki
    @himanshukarki 5 ปีที่แล้ว +1

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

  • @kannanv8831
    @kannanv8831 5 ปีที่แล้ว

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

    • @codebasics
      @codebasics  4 ปีที่แล้ว

      Happy to hear that!

  • @abdulbasithos8805
    @abdulbasithos8805 5 ปีที่แล้ว

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

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Abdul I am glad you found this to be useful 👍

  • @itsvenkis1
    @itsvenkis1 6 ปีที่แล้ว

    you made learning of Pandas easy and interesting . Thanks

  • @raom2127
    @raom2127 3 ปีที่แล้ว

    Great vedios for non cs backgroung nice and simple explaination.

    • @codebasics
      @codebasics  3 ปีที่แล้ว

      Glad you liked it

  • @danhill5357
    @danhill5357 3 ปีที่แล้ว

    Thank you dear ,simple and condensed information.

    • @codebasics
      @codebasics  3 ปีที่แล้ว

      Glad it was helpful!

  • @RAGHURAM-jb6qc
    @RAGHURAM-jb6qc 4 ปีที่แล้ว +1

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

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Happy to hear that!

  • @mohitgupta1958
    @mohitgupta1958 7 ปีที่แล้ว

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

  • @theadrix92
    @theadrix92 5 ปีที่แล้ว +1

    great tutorial, clear and straight to the point

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Great thanks adrix92.

  • @HappyTrails238
    @HappyTrails238 7 ปีที่แล้ว

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

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

  • @matosleni
    @matosleni 3 ปีที่แล้ว

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

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

  • @guningogoi3733
    @guningogoi3733 5 ปีที่แล้ว

    Nice tutorials to learn Python - Pandas

    • @codebasics
      @codebasics  5 ปีที่แล้ว

      Glad you liked it 😊

  • @swetabhattacharjee1203
    @swetabhattacharjee1203 5 ปีที่แล้ว

    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

  • @elpintor2091
    @elpintor2091 6 ปีที่แล้ว

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

  • @theengineervlogger1470
    @theengineervlogger1470 4 ปีที่แล้ว

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

  • @VishalSharma-rn7mt
    @VishalSharma-rn7mt 5 ปีที่แล้ว +1

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

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Glad you like it Vishal 👍😊

  • @gaddamshanthsri125
    @gaddamshanthsri125 5 ปีที่แล้ว +1

    superb teaching sir

    • @codebasics
      @codebasics  5 ปีที่แล้ว

      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.

  • @amandaschettini3416
    @amandaschettini3416 8 ปีที่แล้ว

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

  • @codebasics
    @codebasics  4 ปีที่แล้ว

    How to learn coding for beginners | Learn coding for free: th-cam.com/video/CptrlyD0LJ8/w-d-xo.html

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

  • @sriharshavardhan299
    @sriharshavardhan299 5 ปีที่แล้ว

    ur my teacher sir ... thank you sooo much

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Glad to be your teacher sri 😊🙏

  • @justinahern9729
    @justinahern9729 4 ปีที่แล้ว

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

    • @codebasics
      @codebasics  4 ปีที่แล้ว +1

      Great to hear justin!

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

  • @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. TH-cam is indeed an awesome platform.

  • @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!

  • @abhishekdubey9920
    @abhishekdubey9920 7 หลายเดือนก่อน +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)

  • @CodingMazaa
    @CodingMazaa 5 ปีที่แล้ว

    Awesome intro to data science!

  • @datasome-clarity
    @datasome-clarity 6 ปีที่แล้ว +1

    best tutorials on pandas :) thanks

  • @bhaskarg8438
    @bhaskarg8438 3 ปีที่แล้ว

    simply super content explained

  • @kennethgomes4727
    @kennethgomes4727 2 ปีที่แล้ว +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 ?

  • @piyushraj1331
    @piyushraj1331 5 ปีที่แล้ว +1

    Thank you for providing these great tutorials. Keep doing the good work :)

    • @codebasics
      @codebasics  5 ปีที่แล้ว +1

      Piyush, thanks for your kind words of appreciation

  • @higiniofuentes2551
    @higiniofuentes2551 ปีที่แล้ว

    Thank you for this very useful video!

  • @contactdiwa
    @contactdiwa 3 ปีที่แล้ว

    Very clear video - thank you!

    • @codebasics
      @codebasics  3 ปีที่แล้ว +1

      Glad you enjoyed it!

  • @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 👏👏👏

  • @saadmanahmed860
    @saadmanahmed860 4 ปีที่แล้ว

    very good illustration

  • @robertomorales5245
    @robertomorales5245 3 ปีที่แล้ว

    excellent. clear, to the point. love it.

    • @codebasics
      @codebasics  3 ปีที่แล้ว +1

      Great to hear!

  • @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 !!

  • @dnkalita
    @dnkalita 4 ปีที่แล้ว

    Extremely helpful.Thanks.

    • @codebasics
      @codebasics  4 ปีที่แล้ว

      I am happy this was helpful to 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.

  • @akshaynitin5589
    @akshaynitin5589 5 หลายเดือนก่อน

    Excellent tutorial.

  • @akshay4081
    @akshay4081 6 ปีที่แล้ว +1

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

  • @alexandercrump2298
    @alexandercrump2298 7 ปีที่แล้ว

    This is really fantastic and informative content :)

  • @hariharamoorthythennetipan2190
    @hariharamoorthythennetipan2190 7 ปีที่แล้ว

    Very nice detail explanation.

  • @melanieunida2976
    @melanieunida2976 4 ปีที่แล้ว

    you helped me in my assignment. thank you

  • @paratalsrinivas3193
    @paratalsrinivas3193 5 ปีที่แล้ว

    Nice Video and explained very nicely. it helped me to resolve one of my problem.

    • @codebasics
      @codebasics  3 ปีที่แล้ว

      I am happy this was helpful to you.

  • @MostafaMASLOUHI
    @MostafaMASLOUHI 6 ปีที่แล้ว

    Very nice works. Thank you for your efforts.

  • @zulfikaraziz
    @zulfikaraziz 4 ปีที่แล้ว

    Great Explanation,Thanks sir !

  • @MichaelGerrard
    @MichaelGerrard 4 ปีที่แล้ว

    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! :-)

  • @aduck24
    @aduck24 5 ปีที่แล้ว

    This is life saver. Thank you very much.

  • @amanrastogi1232
    @amanrastogi1232 6 ปีที่แล้ว

    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 :)

  • @techwithdavid
    @techwithdavid 2 ปีที่แล้ว

    Great job, sir!

  • @ninonazghaidze7687
    @ninonazghaidze7687 5 ปีที่แล้ว +1

    Great thanks for the excellent tutorial!

  • @潘潘华
    @潘潘华 5 ปีที่แล้ว

    Perfect videos! thank you so much for sharing.

  • @mrmabb123
    @mrmabb123 6 ปีที่แล้ว

    good tutorial! exactly what I needed. Thanks.