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
Trending now


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.