Python Pandas Tutorial 5: Handle Missing Data: fillna, dropna, interpolate

Published: 17 February 2017
on channel: codebasics
479,072
8.4k

In this tutorial we'll learn how to handle missing data in pandas using fillna, interpolate and dropna methods. You can fill missing values using a value or list of values or use one of the interpolation methods.

Topics that are covered in this Python Pandas Video:
0:00 Introduction
2:30 Convert string column into the date type
3:15 Use date as an index of dataframe usine set_index() method
4:10 Use fillna() method in dataframe
7:35 Use fillna(method="ffill") method in dataframe
8:57 Use fillna(method="bfill") method in dataframe
9:56 "axis" parameter in fillna() method in dataframe
11:18 "limit" parameter in fillna() method in dataframe
13:46 interpolate() to do interpolation in dataframe
15:34 interpolate() method "time"
16:50 dropna() method Drop all the rows which has "na" in dataframe
17:50 "how" parameter in dropna() method
18:33 "thresh" parameter in dropna() method

Code link: https://github.com/codebasics/py/tree...

Do you want to learn technology from me? Check https://codebasics.io/?utm_source=des... for my affordable video courses.

Popular Playlist:
Complete python course:    • Python 3 Programming Tutorials for Beginners  

Data science course:    • Data Science Full Course For Beginners | P...  

Machine learning tutorials:    • Machine Learning Tutorial Python | Machine...  

Pandas tutorials:    • Pandas Tutorial (Data Analysis In Python)  

Git github tutorials:    • Git/Github Tutorial  

Matplotlib course:    • Matplotlib tutorial  

Data structures course:    • Data Structures And Algorithms In Python  

Data Science Project - Real Estate Price Prediction:    • Machine Learning & Data Science Project - ...  


To download csv and code for all tutorials: go to https://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: https://codebasics.io/?utm_source=des...

Need help building software or data analytics and AI solutions? My company https://www.atliq.com/ can help. Click on the Contact button on that website.

#️⃣ Social Media #️⃣
🔗 Discord:   / discord  
📸 Dhaval's Personal Instagram:   / dhavalsays  
📸 Instagram:   / codebasicshub  
🔊 Facebook:   / codebasicshub  
📝 Linkedin (Personal):   / dhavalsays  
📝 Linkedin (Codebasics):   / codebasics  
📱 Twitter:   / codebasicshub  
🔗 Patreon: https://www.patreon.com/codebasics?fa...


On this page of the site you can watch the video online Python Pandas Tutorial 5: Handle Missing Data: fillna, dropna, interpolate with a duration of hours minute second in good quality, which was uploaded by the user codebasics 17 February 2017, share the link with friends and acquaintances, this video has already been watched 479,072 times on youtube and it was liked by 8.4 thousand viewers. Enjoy your viewing!