Real World Data Cleaning in Python Pandas (Step By Step)

In this video, I show you how to clean up data within Python Pandas within Jupyter notebook. This Python tutorial is great for those trying to get into Data Analytics or Data Science.

Everything is coded within MSSQL and inside SQL Server Management Studio.

Interested in discussing a Data or AI project? Feel free to reach out via email or simply complete the contact form on my website.

🍿 WATCH NEXT

MY OTHER SOCIALS:

WHO AM I?
As a full-time data analyst/scientist at a fintech company specializing in combating fraud within underwriting and risk, I've transitioned from my background in Electrical Engineering to pursue my true passion: data. In this dynamic field, I've discovered a profound interest in leveraging data analytics to address complex challenges in the financial sector.

This YouTube channel serves as both a platform for sharing knowledge and a personal journey of continuous learning. With a commitment to growth, I aim to expand my skill set by publishing 2 to 3 new videos each week, delving into various aspects of data analytics/science and Artificial Intelligence. Join me on this exciting journey as we explore the endless possibilities of data together.

*This is an affiliate program. I may receive a small portion of the final sale at no extra cost to you.

[ArmanKHAN-bjiv]

Fantastic tutorial! Your step-by-step guide on data cleaning in Python Pandas was excellent. Clear explanations and practical examples made it easy to follow along. Looking forward to more of your uploads. Keep up the great work!

[nickdaboss]

you work super hard and put out really good content. Keep it up man, I'm looking forward to watching you grow!

[AJAY]

this video really helped me man, i was trying to leard about panda now it poped up on my notification, thanks for the video.

[koo]

Now that’s some cool content. This is exact what I wanted. Thanks bro🙏🏼keep helping the poor students like us! 😌

[Al-Ahdal]

@Ryan Nolan: Excellent Video. Very clearly explained. I'm looking forward to watching you grow!

[Tewhi]

Mistakes always help me learn because it forces me to recall new/old knowledge. Depending on how common the mistake was (>3) I end up retaining it and auto check, rarely do I see that mistake again.

[RoleJohn]

i guess watching your videos while preparing my own portofolio, i am halfway there. Thanks a lot

[suvanshgaurav]

Great Learning we gettin here ! Everything explained precisely 👍 jus having 1 doubt : why using (axis=1), (axis=0)????

[pradeeppadeliya]

This is a best tutorial .... 👍👍👍👍👍👍👍👍👍👍👍👍👍👍

[tianbowen]

Pretty Amazing :) and I'd say it's some dense content to fit in 40 mins ~~I learned a lot

[prathmesh_jadhav]

Brother you doing awesome…. Upload more videos related to data analysis

[far]

I am trying to move away from R, and this is a great video. Thanks Ryan!

[indiecasmlive]

The star on highest score means that player was NOT OUT till the end of the match. Non star players were OUT right after the score achieved.

[iunzgyl]

Thanks . Appreciate for this tutorial. Just have a question on Q5. Why is it already in a data frame? while we have to use to_frame for Q4 ? Thanks

[satishharijan]

nice lecture bro thanks for this it is use full video for me

[lewismurigi]

This was so much helpfull, Thanks Man

[Al-Ahdal]

@Ryan Nolan: Your videos are great indeed. It is requested to have a comprehensive series on "Data Analytics & Visualization". Thanks

[ArhamZaiem]

In the highest inns score, why didn't you used rstrip to remove * instead of split??

[khan]

Sir when we import data from site to table I'm not getting the option of table 0 what's the solution for that at 1:54.

[mindacid]

star at the end of the score means that was the runs scored -NOT OUT and currently batting