Below are the required components of your code sample. Note that we would like to see a single, full program or script that incorporates all of the below components as part of a broad programming task. We will need to see successful demonstration of these data manipulation tasks in Python and/or SQL.
1. Reading in data or sets of data in a format other than the programming language’s default file format (e.g., read-in data from Excel or flat text file into Stata)
2. Validating data by performing summaries, frequencies, and/or tabulations
3. Changing the format of data (e.g., converting character date value to the programming language’s date, convert characters/strings to numeric, etc.)
4. Creating and/or calculating new variables from existing variables (e.g., time between two dates)
5. Using conditional logic
6. Merging and appending data
7. Addressing repetitive processes (e.g., loops)
8. Exporting data to a format other than the programming language’s default file format (e.g., data in Stata exported to Excel, CSV, delimited, etc.)
