Python

Pandas GroupBy and Merge: The Two Skills That Cover Most Analysis Work

by

If you sat down and logged what you do in pandas over a month, two operations would dominate almost everything else: splitting data into groups and summarising it, and sticking two tables together. Everything else is decoration. Get these two right and you can do most analysis work. The problem is that both of them … Read more

Data Cleaning With Pandas: A Step by Step Walkthrough on a Messy File

by

Every pandas tutorial starts with a clean dataset. Real work never does. Real work starts with a file called sales_final_v3_USE_THIS.xlsx where the header is on row four, prices are stored as text with currency symbols, half the dates are in the wrong format, and the region column contains “North”, “north”, “N” and an empty cell. … Read more