Pergunta de entrevista da empresa RTI International

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.)