Beginner scripts
-
Clean a messy CSV export with pandas
One command that fixes headers, trims whitespace, removes blank and duplicate rows, and converts text to real numbers and dates.
-
Merge every Excel file in a folder into one sheet (VBA)
A single macro that stacks the first sheet of each workbook in a folder into one master sheet, tagging every row with its source file.