Description
In this course, you will :
- Discover why data cleaning is important. You'll solve simple problems like leading and trailing spaces in strings, unifying flight registration formats, combining strings, and more.
- Learn how to deal with missing data, how to avoid duplicate data in your datasets, and how to work with various date formats.
- Learn how to combine and aggregate data from multiple columns into one, how to split data from one column into multiple columns, and how to convert rows into columns and vice versa.
Syllabus :
- Starting with Cleaning Data
- Dealing with missing data, duplicate data, and different date formats
- Dealing with out of range values, different data types, and pattern matching
- Combining, splitting, and transforming data