Data Cleaning in Pandas in 20 minutes

Learn essential data cleaning techniques in Python. In this video tutorial we will use salary data scraped from job websites that requires some cleaning. We will remove characters, convert hourly salary to yearly, split columns and then create visuals. This tutorial covers: String manipulation with str.replace(), Splitting columns using comma separators, One-hot encoding for categorical data, Creating word clouds for text analysis, Generating horizontal and vertical bar charts, Plotting histograms for data distribution. ---------------------- Dataset available here - https://www.kaggle.com/datasets/emreksz/data-scientist-job-roles-in-uk ---------------------- 💌 Join my newsletter and get access to various freebies (Books and checklists, CV template, Portfolio Projects) - https://stan.store/KarinaDataScientist 🧠 AI to help you analyse your data - https://powerdrill.ai/?via=karina-samsonova ---------------------- Timestamps: ---------------------- 00:00 Intro 00:46 Installing libraries 01:45 Data Statistics 02:01 Summary report 04:00 String replace 05:24 Convert hourly rate to yearly 07:28 Split column 08:38 Remove whitespace 09:07 Convert to numeric 09:34 Split location 10:26 Split skills. One-hot encoding 11:20 Concat datasets 12:05 Wordcloud 14:15 Horizontal bar chart 17:43 Histogram 19:05 Bar chart 19:45 String Replace 🎥 Other videos you might be interested in ---------------------- https://youtu.be/xLW796-J5fI ---------------------- About me ---------------------- Hi, my name is Karina and I'm a finance person turned data person. My mission is to transform intimidating tech into accessible tools. I aim to empower 1 million people to harness the power of AI, Python, SQL, and Excel to work smarter, not harder. #pythonprogramming #pythontutorial #dataanalysis Contact ---------------------- Youtube: youtube comments are by far the best way to get a response from me! email for business inquiries only: [email protected] ---------------------- Social Media: ---------------------- TikTok: https://www.tiktok.com/@karinadatascientist Instagram: https://www.instagram.com/karinadatascientist/ Linkedin: https://www.linkedin.com/in/karina-samsonova/