All scripts

Filter by tag, or search titles and descriptions.

• 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.

  • Python
  • Data cleaning
  • Analytics
  • Beginner

• 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.

  • VBA
  • Excel
  • Automation
  • Beginner

• Log serial port data to CSV with Python

  Read lines from an Arduino, sensor or lab instrument over a serial port and save each one with a timestamp, ready for Excel or pandas.

  • Python
  • Serial / hardware
  • Automation
  • Intermediate

No scripts match those filters yet.