Stata

excelclean (ssc install excelclean)

A Stata module that extends the default import excel command and adds support on batch processing of excel files.

  • load all excel files in the specified directory
  • organize variable names and labels
  • reshape the dataset if necessary
  • integrate all files into a cleaned dataset.

Python

Hermes and Google Mail Reminder

  • Connect to your Cambridge Hermes email and/or Gmail account.
  • Check incoming mails every x minutes.
  • Call/message you if you received an email from your boss.
  • If you do not read your boss’ email, the program will keep calling you every x minutes.

Web and Text Scraping at hansearch.com