Python Pandas Tutorial 2: Dataframe Basics

This pandas tutorial covers basics on dataframe. DataFrame is a main object of pandas. It is used to represent tabular data (with rows and columns). This tutorial will go over,
1) What is dataframe?
2) Create dataframe from csv file and python dictionary
3) Dealing with rows and columns
4) Operations: mean, max, std, describe
5) Conditional selection
6) set_index function and usefulness of it
Topics that are covered in this Python Pandas Video:
0:00 Introduction
0:15 What is Dataframe?
2:02 Import pandas in jupyternotebook
3:34 Create dataframeusing python dictionary
5:15 Use head() method
5:52 Use tail() method
6:10 Use Indexing and slicing in dataframe
8:12 Insert new cell in current cell
8:39 What is the type of your dataframe?
10:01 Operations with your dataframe
10:34 Use max() method
11:02 Use mean() method
11:11 Use min() method
11:23 Use describe() method
12:12 Conditional select the data in your dataframe
14:55 Pandas operations list
15:41 Use set_index() method
18:12 Use reset_index() method
Code: github.com/codebasics/py/tree...
Do you want to learn technology from me? Check codebasics.io/?... for my affordable video courses.
Next Video:
Python Pandas Tutorial 3: Different Ways Of Creating DataFrame
• Python Pandas Tutorial...
Very Simple Explanation Of Neural Network: • Neural Network Simply ...
Popular Playlist:
Complete python course: • Python 3 Programming T...
Data science course: • Data Science Full Cour...
Machine learning tutorials: • Machine Learning Tutor...
Pandas tutorials: • Pandas Tutorial (Data ...
Git github tutorials: • Git/Github Tutorial
Matplotlib course: • Matplotlib tutorial
Data structures course: • Data Structures And Al...
Data Science Project - Real Estate Price Prediction: • Machine Learning & Dat...
To download csv and code for all tutorials: go to github.com/codebasics/py, click on a green button to clone or download the entire repository and then go to relevant folder to get access to that specific file.
🌎 My Website For Video Courses: codebasics.io/?...
Need help building software or data analytics and AI solutions? My company www.atliq.com/ can help. Click on the Contact button on that website.
#️⃣ Social Media #️⃣
🔗 Discord: / discord
📸 Dhaval's Personal Instagram: / dhavalsays
📸 Codebasics Instagram: / codebasicshub
🔊 Facebook: / codebasicshub
📱 Twitter: / codebasicshub
📝 Linkedin (Personal): / dhavalsays
📝 Linkedin (Codebasics): / codebasics
🔗 Patreon: www.patreon.com/codebasics?fa...

Пікірлер: 460

  • @codebasics
    @codebasics2 жыл бұрын

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

  • @reeshatkhan9353
    @reeshatkhan93533 жыл бұрын

    Highly recommended to those who are searching for the perfect tutorial on Pandas! He literally reads a learners mind!

  • @coinsec
    @coinsec7 жыл бұрын

    What a legend, explains it so well. Exactly what I needed. Thanks

  • @zerostudy7508

    @zerostudy7508

    5 жыл бұрын

    Comment==True

  • @m.arsalanbabar3303

    @m.arsalanbabar3303

    3 жыл бұрын

    kzread.info/dash/bejne/loyKtrSrqMa1h7w.html Who should file Return of Income according to law Please like, comment, share and subscribe. Thank you

  • @yashkushwaha6940

    @yashkushwaha6940

    Жыл бұрын

    @@zerostudy7508 in

  • @Vertek11235

    @Vertek11235

    Ай бұрын

    Actually a great beginners tutorial

  • @nishushroff9656
    @nishushroff96562 жыл бұрын

    Literally, your pandas playlist is better than any other paid courses. Thank you so much ❤

  • @wasimbader5706

    @wasimbader5706

    10 ай бұрын

    really, u must have a very fast eyes movement. he is ok. great learning is good too. try both to learn more

  • @thecaveofthedead
    @thecaveofthedead6 жыл бұрын

    These are so great. I've been looking all over for the best introduction as a person converting from Excel, and yours is way better than others I've come across.

  • @classik305
    @classik3056 жыл бұрын

    only half way through and I'm already excited about what I've gained from this! can't wait to try this when I get to the computer. thank you for such clear explanation!!

  • @zappist751

    @zappist751

    2 жыл бұрын

    ME TOO I AM SO EXCITED

  • @gobucbabu1583
    @gobucbabu1583 Жыл бұрын

    Been going through your Python playlist and it's perfect. Absolutely great work on these videos.

  • @alexlaverty8564
    @alexlaverty85645 жыл бұрын

    Awesome tutorial, thank you for putting this together, i've been learning Pandas in my spare time but I had quite a few light bulb moments watching your videos.

  • @parthkatlana1252
    @parthkatlana12522 жыл бұрын

    Thank you so much, I've literally searched for an hour now how to draw charts with conditions. I finally found it here.

  • @juliocesarbenavente9590
    @juliocesarbenavente95906 жыл бұрын

    El video muy bien explicado. Paso a paso a fin de entender el proceso completamente bien. Por ahora no hay dudas. Espero que surgan pronto! Muchas gracias! Me encantó!

  • @Richard-pm8sd
    @Richard-pm8sd6 жыл бұрын

    Your tutorial is so good that I had to sign in to give you a thumbs up

  • @bishnudas8638
    @bishnudas86382 ай бұрын

    Treat this comment as appreciation. It's awesome to follow your videos and I am slowly getting a lot of hands-on in Python coding. I highly appreciate your efforts that people are getting educated with your videos.

  • @sep69
    @sep695 жыл бұрын

    Great tutorial ! Thank you so much for this explanation. Exactly what I was looking for. I am going to watch the next one right away :)

  • @questforprogramming
    @questforprogramming5 жыл бұрын

    I am watching your videos in 2x...and I am still comfortable in understanding also saving my time..

  • @rickandelon9374

    @rickandelon9374

    4 жыл бұрын

    bharath bhimshetty take your time to learn from great teachers, try to fully understand what they are saying. Its not wasting time while learning cause you will inevitably waste your time on some other stupid things.

  • @EdiiXHD

    @EdiiXHD

    4 жыл бұрын

    Alt Cunningham jup, you prob won’t learn much from trying to speedrun the video. Taking your time and actually trying these functions is way more usefull.

  • @sameer9045

    @sameer9045

    Жыл бұрын

    I'm also watching it in 2x. and later practicing 4x .... And believe it's worth it.

  • @khubaibraza8446
    @khubaibraza84465 жыл бұрын

    One of the Best tutorial i have seen about dataframes .. Bundle of thanks

  • @ushaakkina3355
    @ushaakkina33555 ай бұрын

    I just started learning Python for data analytics and this is a very good explanation on how we can use pandas. Thank you😀

  • @arunkaruppaiah971
    @arunkaruppaiah9715 жыл бұрын

    No words to say! Awesome explanation.

  • @Oz_blackprime
    @Oz_blackprime8 ай бұрын

    In the starting I learned Java script and I also used Notepad++ but now learning python from you bro you are super cool your videos are very interesting hands off 🙏🙏

  • @ragavsathis
    @ragavsathis6 жыл бұрын

    Thanks for explaining it with clarify, this is what I have been looking for

  • @nepalimusician6445
    @nepalimusician64452 жыл бұрын

    This is such a good tutorial. Simple and smooth without giving any complex explanation. Explaining by examples rather than the theory behind it. Thank you so much. Subscribed!!!

  • @codebasics

    @codebasics

    2 жыл бұрын

    🤗🙏🙏🤔

  • @wasimbader5706

    @wasimbader5706

    10 ай бұрын

    try others like great learning, Mosh, and few other plonkers.

  • @sanjaykrish8719
    @sanjaykrish87196 жыл бұрын

    You made me very comfortable to use pandas. Kudos to you

  • @JoseAlvarez-dl3hm
    @JoseAlvarez-dl3hm6 жыл бұрын

    Really great work mate, keep doing what you are doing, cheers!

  • @skkkks2321
    @skkkks23215 жыл бұрын

    What a nice introduction to use Jupitor using DF,Excellent Sir.Learn something valuable...looking more and more.Thanks

  • @cartoon-wc4hm
    @cartoon-wc4hm2 жыл бұрын

    You are a great teacher. Thank you for helping me to start my data science journey.

  • @debashissahoo5031
    @debashissahoo50316 жыл бұрын

    thank you sir, you way of explanation is really amazing and it makes the concept simpler.

  • @ArtArchitectureAndAI
    @ArtArchitectureAndAI4 жыл бұрын

    Awesome job. This is great tutorial for Pandas dataframe introduction. Thank you!

  • @codebasics

    @codebasics

    4 жыл бұрын

    I am glad it was helpful

  • @samrathchadha5062
    @samrathchadha50623 жыл бұрын

    First video that got straight to the point

  • @codebasics

    @codebasics

    3 жыл бұрын

    👍👍

  • @asadtanvir4065
    @asadtanvir40656 жыл бұрын

    Thanks a lot for the video. Exactly what I was looking for. Keep making tutorials on data structure like this

  • @ahmedhelal920

    @ahmedhelal920

    3 жыл бұрын

    can you please help me on this code I want to make filter on the data frame about what it's temperature is > 13 , and I am coding on Pycharm , so I write it like this print(data_frame['tempreature']>13)

  • @eswarveeranki4191

    @eswarveeranki4191

    11 ай бұрын

    @@ahmedhelal920 df["temprature"][df["temprature"]>13]

  • @MrCEO-jw1vm
    @MrCEO-jw1vmАй бұрын

    Very effective teaching of pandas here. Thank you for such a great resource

  • @saichaithrik7134
    @saichaithrik71344 жыл бұрын

    Sir you are great and you explained better than most of my faculty and online tutors thank you so much sir really helped a lot

  • @user-ed4mb9rg5g
    @user-ed4mb9rg5g6 ай бұрын

    i found your videos so fascinating ,i had wached several videos before i got yours and there i understood nothing therefore thanks for an amazing tutorial

  • @flamboyantperson5936
    @flamboyantperson59366 жыл бұрын

    Amazing tutorial just love it. Thank you so much.

  • @Jonathan-od5xc
    @Jonathan-od5xc6 жыл бұрын

    Man, this was fantastic. Thank you, sir.

  • @learnerlearner4090
    @learnerlearner40903 жыл бұрын

    Learnt about using short cuts along with simple pandas code examples for dataframe. Thanks.

  • @hasankhalid
    @hasankhalid6 жыл бұрын

    dude you are awesome. I dont leave comments but I learned soooo much. Saved my a** on my homework

  • @user-iv9mx7md8q
    @user-iv9mx7md8q7 ай бұрын

    I am enjoying this playlist very much. Also completed numpy, python as well. Your explanation style with real life data and examples is preety much fascinating and interesting and it motivates me to play with data which makes a good player in case of performing EDA. Thanks for your efforts for us sir

  • @alexandrelucas5621
    @alexandrelucas56216 жыл бұрын

    Very good! Congrats and keep up the good work!

  • @shreedharchavan7033
    @shreedharchavan70332 жыл бұрын

    Its great that you don't cut video for errors

  • @abhinavmishra6648
    @abhinavmishra66485 жыл бұрын

    This was very helpful! Thank you so much!

  • @nnennaumelloh8834
    @nnennaumelloh88343 жыл бұрын

    This is amazing! Thank you!

  • @drewphillips3241
    @drewphillips32416 жыл бұрын

    Thanks for the clear and simple explanation.

  • @rsdntevl
    @rsdntevl6 жыл бұрын

    A natural teacher!

  • @renyildiz5155
    @renyildiz5155 Жыл бұрын

    I have taken classes and I have the basics but still confused your made it sattle in my head. Thank youl

  • @annamorgiel
    @annamorgiel7 жыл бұрын

    really useful tutorial, I got all I needed. Thank you

  • @samuisuman
    @samuisuman5 жыл бұрын

    Clean and clear...Thumps up!

  • @asifnizamani7513
    @asifnizamani75136 жыл бұрын

    what a lovely explanation and knowledge sharing

  • @cameronemmanuel2426
    @cameronemmanuel24266 жыл бұрын

    THANK YOU SOOOOOOO MUCH. UNREAL. I'VE BEEN STRUGGLING FOR DAYS AND DUDE YOU'VE EXPLAINED IT ALL SO EASY. A MILLION THUMBS UP! THANKS!!! :D

  • @cameronemmanuel2426

    @cameronemmanuel2426

    6 жыл бұрын

    Is there a command to show every variable in a column? For example if you had a large database with lots of different variables under 'Weather' would there be a command to show a list of them all and how many in each?

  • @cameronemmanuel2426

    @cameronemmanuel2426

    6 жыл бұрын

    Wow thanks so much! do you do online tutoring or anything at all?

  • @cameronemmanuel2426

    @cameronemmanuel2426

    6 жыл бұрын

    Ah okay. Thanks for your replies. Your videos are the best!!! :D

  • @shanepython
    @shanepython7 жыл бұрын

    Very informative and understandable. Thank you for sharing your knowledge.

  • @mvcutube
    @mvcutube3 жыл бұрын

    The best video on data frame basics. Thank you

  • @codebasics

    @codebasics

    3 жыл бұрын

    Glad it was helpful!

  • @movinsq07
    @movinsq075 жыл бұрын

    Awesome and easy to follow. Thank you.

  • @hagarali5009
    @hagarali50095 жыл бұрын

    it's so much better than coursera python course in data analysis thank you

  • @techworm3533
    @techworm35336 жыл бұрын

    Sir your teaching methodology is awesome 👌

  • @anishamalblanco7386
    @anishamalblanco73862 жыл бұрын

    Thank you Sir for this awesome tutorial. I could not grasp any idea about pandas from other videos. I luckily found this video and I am gonna complete the series and try different datasets.

  • @codebasics

    @codebasics

    2 жыл бұрын

    Glad it helped!

  • @deepthisudhakaran6417
    @deepthisudhakaran64173 жыл бұрын

    Thank you! Outstanding tutorial

  • @rumaizarizkin3728
    @rumaizarizkin37286 жыл бұрын

    i have never seen such an excellent tutorial. explain in very simpler way with good ascent hats of to you

  • @TechBalu
    @TechBalu4 ай бұрын

    A great explanation and covered almost important things in one video almost is superb, thanks a lot sir

  • @mchandresh
    @mchandresh7 жыл бұрын

    thank you for awesome presentation. thumbs up!

  • @phoenixvisual7410
    @phoenixvisual74106 жыл бұрын

    I was searching for over a week the whole internet, how to print rows, where the country was "Germany" ("Snow"). You explained this in a few seconds. If I could give you 100 Likes, I would do this. Thank you very MUCH

  • @lalitdevda7616
    @lalitdevda76162 жыл бұрын

    Great session of pandas, I learnt lot of about pandas DataFrame, Thank you sir for have a great session

  • @oneramen
    @oneramen5 жыл бұрын

    Thanks for the tutorial. It helps a lot.

  • @aaronanderson1068
    @aaronanderson10686 жыл бұрын

    Great job! Thanks for the time.

  • @suyashpurwar8310
    @suyashpurwar83105 жыл бұрын

    Loving these series

  • @codebasics

    @codebasics

    5 жыл бұрын

    😊 glad u liked it

  • @MohdJaved-zd1ly
    @MohdJaved-zd1ly7 жыл бұрын

    Thanks man.....you have made the learning very easy.

  • @musaddikhossain5862
    @musaddikhossain58624 жыл бұрын

    Just Amazing!!! Appreciate you efforts sir. Thank you very much.

  • @codebasics

    @codebasics

    4 жыл бұрын

    I am glad it was helpful

  • @bhuvaneswarimanoharan8077
    @bhuvaneswarimanoharan80775 ай бұрын

    clear cut explanation for beginners like me compared to paid courses. thanks sir

  • @shantanubedajna6240
    @shantanubedajna62406 жыл бұрын

    you are doing better job explaining than sentdex . Awesome brother !!

  • @adityasinghaswal4923

    @adityasinghaswal4923

    6 жыл бұрын

    the speed at which he speaks is perfect for us Indians :)

  • @FLVCTVAT_NEC_MERGITVR
    @FLVCTVAT_NEC_MERGITVR7 жыл бұрын

    Excellent tutorial!

  • @itsvenkis1
    @itsvenkis16 жыл бұрын

    Explained well, Good job and thanks

  • @michelesantos5716
    @michelesantos57163 жыл бұрын

    Thank you so much for this video. It has helped me a lot in understanding dataframes.

  • @codebasics

    @codebasics

    3 жыл бұрын

    I am happy this was helpful to you.

  • @Soumirai
    @Soumirai7 жыл бұрын

    Good tutorial, thank you!

  • @MuhammadKashif-pd9em
    @MuhammadKashif-pd9em3 жыл бұрын

    Really explained in a great way...love it❤️❤️

  • @codebasics

    @codebasics

    3 жыл бұрын

    Thank you so much 😀

  • @victorcostaricci3515
    @victorcostaricci35152 жыл бұрын

    I really enjoyed you the way you explain. All success to you.

  • @fahadreda3060
    @fahadreda30606 жыл бұрын

    Really Nice Tutorial, Thank You sir

  • @nateenglishlab783
    @nateenglishlab7832 жыл бұрын

    Awesome tutorial thanks!

  • @akhileshagarwal5913
    @akhileshagarwal59134 ай бұрын

    Great Tutorial...I mean really Great Explaination

  • @CyberPin2001
    @CyberPin20013 жыл бұрын

    Excellent - so well presented with great ecplanations. I have looked at a lot of Pandas tutorials and these are the best I have come across. Very clear explanations and you can tell the presenter has a very good understanding of the subject. Something many others don't have. Will be checking out some of his other videos. 👍

  • @crazypigs100
    @crazypigs1007 жыл бұрын

    ur the best!! inspiring

  • @motiongraphic5145
    @motiongraphic51452 жыл бұрын

    You are the best tutor ever, that helped me alot. Thank you

  • @codebasics

    @codebasics

    2 жыл бұрын

    Glad it helped!

  • @badassopenpolling
    @badassopenpolling14 күн бұрын

    Naught-Book, nicely explained

  • @KevinGalbraith
    @KevinGalbraith5 жыл бұрын

    Very well done. Easy to follow and explained simply. Thanks.

  • @codebasics

    @codebasics

    5 жыл бұрын

    glad you liked it kevin

  • @SophiaandHaakenPedersen
    @SophiaandHaakenPedersen5 жыл бұрын

    Excellent, thank you for your video, that is very helpful

  • @rgh1986aka199
    @rgh1986aka1997 жыл бұрын

    awesome tutorial, thank you

  • @rgh1986aka199

    @rgh1986aka199

    7 жыл бұрын

    codebasics may I know where you are located?

  • @rgh1986aka199

    @rgh1986aka199

    7 жыл бұрын

    codebasics if you are from Delhi, I would have tried to meet you in person

  • @soumilshah3890

    @soumilshah3890

    5 жыл бұрын

    @@codebasics hey i live in Bridgeport would love to connect +1646 204 5957

  • @dilipbhardwaj1699
    @dilipbhardwaj16996 жыл бұрын

    Nice tutorial, thanks.

  • @ayushgupta80
    @ayushgupta803 ай бұрын

    Data frame is a main object in Pandas . It is used to represent data with rows and columns ( tabular or excel spreadsheet like data) Code : import pandas as pd df = pd.read_csv("C:\\Users\\ayush\\Downloads\\weather_data.csv") df.shape # gives number of rows and columns df.head(2) # print starting 2 rows df.tail(2) # print last 2 rows df[2:5] # print row 2 to 4. df[:] or df # to print all the rows df.columns # gives all columns df.col_name # to print specific column df[['event','day']] # to print specific columns df['temperature'].max() # gives the max value present in temperature column # we can print -- mean() --- std() # standard deviation df[df.temperature >= 32] # condition pandas had many operations we can set / reset index.

  • @satishk1464
    @satishk1464 Жыл бұрын

    Very simple explanation and easy to understand.. Thank you !!

  • @easydatascience2508

    @easydatascience2508

    Жыл бұрын

    See mine pls.

  • @vwindie
    @vwindie3 жыл бұрын

    Well explained Highly recommended for basics

  • @codebasics

    @codebasics

    3 жыл бұрын

    I am happy this was helpful to you.

  • @Gauravkr0071
    @Gauravkr00714 жыл бұрын

    keep posting such high quality content man.....love u

  • @codebasics

    @codebasics

    4 жыл бұрын

    Sure gaurav. thanks for the comment.

  • @rajeshk7908
    @rajeshk79085 жыл бұрын

    Awesome tutorial :)

  • @fantacyuser
    @fantacyuser6 жыл бұрын

    excellent video sir..simple explanation....

  • @vishalzope1978
    @vishalzope19784 жыл бұрын

    Thanks a lot sir, u explained with very ease....

  • @MohamedArafat
    @MohamedArafat6 жыл бұрын

    Well done !

  • @shashirajusiddaraju4979
    @shashirajusiddaraju49795 жыл бұрын

    You are simply awesome..

  • @shivashukla7894
    @shivashukla78945 жыл бұрын

    very helpful. Thankyou

  • @gregs138
    @gregs1385 жыл бұрын

    Nice video, thank you for going through all this!

  • @codebasics

    @codebasics

    5 жыл бұрын

    Greg, thanks for leaving out a comment

  • @panduenglishacademy7856

    @panduenglishacademy7856

    4 жыл бұрын

    Great video

  • @arpanghosh680
    @arpanghosh6803 жыл бұрын

    Thanks bro for teaching me dataframe

  • @guhanathanprathish9704
    @guhanathanprathish97044 жыл бұрын

    your way of teaching was amazing and very easy to understand the concepts.. Thank you so much sir.. ❤️❤️😊

  • @codebasics

    @codebasics

    4 жыл бұрын

    Prathish, I am glad 👍

  • @hariharamoorthythennetipan2190
    @hariharamoorthythennetipan21906 жыл бұрын

    Very nice explanation

  • @geev3s
    @geev3s6 жыл бұрын

    great video, thanks

  • @dr.satyapatel7520
    @dr.satyapatel75206 жыл бұрын

    Thanks codebasica, you are awesome. really helped me a lot

  • @praiseemma-iwuozo6938
    @praiseemma-iwuozo6938 Жыл бұрын

    Thank you Soo much for this course. I can't express enough how much this course has helped me. This free course is far better than any other paid courses I've seen so far. Thank you so much. I'm in a little fix on the path for the data frame. I mean where you fixed the path. I think my path is correct but each time I run, I keep seeing syntax error. please I need your help.