I recently had a project where I scraped salary data from Glassdoor. Some data cleaning was needed on the scraped data to prepare it for use in further analysis. One of the tasks involved having to parse the data in a column indicating location of company. This write-up is a walk-through of what I did.