Mace questions

• Subsetting a unbalanced panel dataset to have at least 2 consecutive observations in R
• Separating an address string in SQL
• Producing a rolling average of ALL the previous observations per ID in an unbalanced panel data set
• Speed up web scraper
• Following hyperlink and "Filtered offsite request"

Mace answers