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

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

Written By codebasics on Friday, Feb 17, 2017 | 08:49 AM

 
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/master/pandas/5_handling_missing_data_fillna_dropna_interpolate Do you want to learn technology from me? Check https://codebasics.io/?utm_source=description&utm_medium=yt&utm_campaign=description&utm_id=description for my affordable video courses. Popular Playlist: Complete python course: https://www.youtube.com/playlist?list=PLeo1K3hjS3uv5U-Lmlnucd7gqF-3ehIh0 Data science course: https://www.youtube.com/playlist?list=PLeo1K3hjS3us_ELKYSj_Fth2tIEkdKXvV Machine learning tutorials: https://www.youtube.com/playlist?list=PLeo1K3hjS3uvCeTYTeyfe0-rN5r8zn9rw Pandas tutorials: https://www.youtube.com/playlist?list=PLeo1K3hjS3uuASpe-1LjfG5f14Bnozjwy Git github tutorials: https://www.youtube.com/playlist?list=PLeo1K3hjS3usJuxZZUBdjAcilgfQHkRzW Matplotlib course: https://www.youtube.com/playlist?list=PLeo1K3hjS3uu4Lr8_kro2AqaO6CFYgKOl Data structures course: https://www.youtube.com/playlist?list=PLeo1K3hjS3uu_n_a__MI_KktGTLYopZ12 Data Science Project - Real Estate Price Prediction: https://www.youtube.com/watch?v=rdfbcdP75KI&list=PLeo1K3hjS3uu7clOTtwsp94PcHbzqpAdg 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=description&utm_medium=yt&utm_campaign=description&utm_id=description 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: https://discord.gg/r42Kbuk 📸 Dhaval's Personal Instagram: https://www.instagram.com/dhavalsays/ 📸 Instagram: https://www.instagram.com/codebasicshub/ 🔊 Facebook: https://www.facebook.com/codebasicshub 📝 Linkedin (Personal): https://www.linkedin.com/in/dhavalsays/ 📝 Linkedin (Codebasics): https://www.linkedin.com/company/codebasics/ 📱 Twitter: https://twitter.com/codebasicshub 🔗 Patreon: https://www.patreon.com/codebasics?fan_landing=true