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

  • Python
  • Data cleaning
  • Analytics
  • 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