Python for Office Automation: The Complete Starter Guide
Use Python to automate everyday office work: set up Python, handle files and folders, read and write Excel, create Word reports, send emails safely,…
Read article →Category Archives: Python
Python for analysts and office automation.
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 →Python Lists, Dictionaries and Loops for Excel Users
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 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 →