Python Lists, Dictionaries and Loops for Excel Users
The three Python building blocks you use in every script — lists, dictionaries and loops — explained with Excel comparisons and small, runnable examples.
Read article →Python
Python for analysts and office automation.
Data Cleaning With Python pandas: The 15 Fixes You Need for Real Excel Files
Data Cleaning With Python pandas: The 15 Fixes You Need for Real Excel Files
A practical pandas data-cleaning guide for messy Excel exports: header rows, types, dates, duplicates, missing values, text cleanup, splitting columns, mapping, outliers and a…
Read article →Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
Python for Excel Users: Read, Clean and Summarise a Spreadsheet with pandas
A gentle first step from Excel to Python: load a spreadsheet with pandas, clean it, build a pivot table and save the result —…
Read article →Merge 100 Excel Files into One with Python (in 10 Lines)
Merge 100 Excel Files into One with Python (in 10 Lines)
Combine every Excel file in a folder into one sheet with Python and pandas — with a source column, header checks and a summary.
Read article →