The client was a researcher responsible for organizing the data for a larger research project. Among their data sources was a public dataset that's only available segmented into many small topic pieces, and is also segmented into biannual periods. My task was to take a specific set of the segments, across the 1999-2000 and 2001-2002 biannual periods, and combine them into a single large spreadsheet for ease of use. I also had to divide the data into control and experiment groups across a specific population, and take a random sample.
Built with
- pandas
- MySQL
- Python