Data Cleaning Project in Python

💎Join my membership💎
herdataproject...
Do this project next - (PowerBI file included)
• Video
The dataset can be downloaded from
* Ko-Fi - ko-fi.com/s/61...
* Telegram - t.me/+7ms4DzzA...
* GitHub - github.com/Ire...
💎Support my channel 💎
www.paypal.com...
Buy me a coffee
ko-fi.com/herd...
This is a data cleaning project of the FIFA21 dataset that was provided by the Data Challenge Space on twitter.
You will learn how to use pandas and numpy libraries.
LET'S CONNECT
Twitter : / herdataproject
Instagram: / herdataproject
Website: / irenenafula
Some of the links on this channel are affiliate links, meaning that, at no additional cost to you, I will earn a commission if you click through and make a purchase. This helps support my channel and allows me to continue creating valuable content for you. I only recommend products or services that I personally use and believe will add value to you. Thank you for being so supportive!

[@abolarinwayusuf151]

This is so far the best data-cleaning tutorial I've seen on the internet. Keep up the good work!

[@herdataproject]

Thank you so much!!

[@ronykeya3530]

Thank you for this. Can't wait to get to this level of proficiency in Python.

[@deborahchepkoech8120]

Thanks Irene I was able to go through the tutorial and actually practice on it and I can say it is absolutely helpful to me as a beginner in the data industry .Thumbs up and keep up inspiring!!

[@herdataproject]

You're most welcome Deborah. Keep learning and practising. You'll become great

[@Prathmesh_jadhav96]

Really thankful to you. You uploaded different content from others… Your methods are very helpful… ❤

[@herdataproject]

Thank you so much!! I’m glad you find it helpful

[@osoriomatucurane9511]

Awesome tutorial, thank you for sharing. As a beginner with no confidence in looping/iteration, I have succeeded cleaning the contract column just the naive way, borrowing some pieces from your snippet:
# udf that extract the contract period
def contract_period(period):
if period =='Free' or 'On Loan' in period:
return np.nan
else:
return x.split(' ~ ')
# get contract start and end years as pd.Series
start_year=fifa.Contract.apply(lambda row: contract_period(row)).str[0]
end_year = fifa.Contract.apply(lambda row:contract_period(row)).str[1]
# Add the new columns in the dataframe
fifa.insert(loc=fifa.columns.get_loc('contract_status')+1, column='Start_Contract', value= start_year)
fifa.insert(loc=fifa.columns.get_loc('contract_status')+2, column='End_Contract', value=end_year)

[@herdataproject]

I'm glad you found it helpful😊

[@user-dn1my6kh4b]

Right on point for me as an aspiring data analyst. Thank you.

[@nauncastillo]

hello it is very interesting the project, I would be happy to see more tutorials of this type, I enjoyed the explanation.

[@herdataproject]

Thank you Castillo. I'm working on more of them. Stay tuned!

[@russel2506]

Awesome Explanation, hope u doing well and please do it more project with python

[@herdataproject]

Thank you.
More coming soon

[@emilynjeri5062]

Bravo, good job, very insightful & inspiring

[@herdataproject]

Glad it was helpful!

[@user-zo9rq5hb8m]

Thank you for this it was really helpful. Upload more like this and I will soon get a job

[@herdataproject]

Thank you so much and you're welcome.
More will come soon. Keep practising and you'll soon be there.

[@rohanbansiyar8984]

hie.. This is really helpful.. I would be grateful, if you upload more of such data cleaning videos

[@sraoarjun]

Awesome project !!

[@whohow8429]

Thanks for your guidance

[@user-on4gy1oo4u]

Thank you for your effort of love in creating this tutorial/

[@herdataproject]

You're most welcome!!

[@user-on4gy1oo4u]

@@herdataproject 💙

[@admonitoring-pi9os]

nice effort. thankyou for it. will there be more videos on this topic

[@codewithpraisejames]

Your video was so helpful. Thank you so much

[@herdataproject]

You're most welcome!

[@kevinmugo2662]

Great content , but if there anyone who encountered an issue when running the convert height function alone rather than the entire notebook?

[@jameskalenga7546]

thanks for sharing

[@herdataproject]

Thanks for watching!

[@tboykelvin1865]

Thank u for this educative content

[@herdataproject]

You're most welcome.
Thanks for watching!

[@Satishkumar-gv5ss]

Thank you 🎉

[@herdataproject]

You're welcome!

[@sonusiwan6938]

I want to learn more please upload more videos 🙏

[@herdataproject]

More videos will be added soon.
Which tool are you most interested in?

[@dataotechingriding8271]

@@herdataprojectpython and mssql for data cleaning. Great video and it would be helpful to have more on the cleaning and transformation process with datasets! Thanks for what you do btw!

[@rumonseoexparts9697]

Thanks for contributing its really helped me to polish myself. love from bangladesh

[@samuel_muly]

Girl, are you ok? this is some dope work. I have checked your twitter account and it's been a while since you tweeted

[@herdataproject]

Thank you. Will get back to it soon

[@nam9555]

How to upload that file(template) into the jupyter notebook. can anyone explain?

[@herdataproject]

Hi, you don't need to upload. Just make sure you have Jupyter Notebook or Anaconda installed and then open the template once you've downloaded it

[@ramneeksharma4226]

Hi... Could you pls upload more videos like this one

[@herdataproject]

Hello, yes I can. I will upload more soon

[@QueenOpex]

Thank you so much for this video. I’m unable to download the dataset tho.

[@herdataproject]

Hi, apologies for that. Kindly join the telegram group here
t.me/+7ms4DzzAYVlhYmZk
Or download from GitHub here
github.com/Irene-arch/Python-Data-Cleaning-FIFA21-Dataset

[@QueenOpex]

@@herdataproject Thank you so much.

[@piyushpathak7311]

Please upload more projects like this

[@herdataproject]

For sure. I'm working on more projects.
Stay tuned. Thanks for watching!

[@rajareddyraju6773]

23:54

[@aidanthompson5053]

28:06

[@vishnuv1519]

good project,but a bit hard to understand ur explanation

[@Paperscissor183]

The best way is to know basics of python and pandas