Python & SQLTutorialClean a messy CSV with pandas: text, numbers, dates and duplicates
Work through the five problems almost every export has: stray spaces and case, numbers stored as text, bad dates, missing values and repeated rows.
Working with data using Python and SQL.
2 pieces · Tutorials, Beginner · Clear filters
Step by step from nothing to a working result, explaining each step.
Python & SQLTutorialWork through the five problems almost every export has: stray spaces and case, numbers stored as text, bad dates, missing values and repeated rows.
Python & SQLTutorialLoad a CSV export into SQLite, reject the rows that do not fit, and answer a business question with SQL. Nothing but Python's standard library.