1. When presented with a new dataset or database, what steps do you generally take

to evaluate it prior to working with it?

2. Based on the information provided above and the attached dataset, what 3

questions would you like to understand prior to conducting any analysis of the

data?

3. How would you prep the dataset provided for analysis? Please list steps taken and

provide code used to prep the tables for analysis.

Using the datasets you have prepped, please answer the following questions and provide

all code/output used.

Be sure to include and explain any assumptions made when answering each question.

Data Specific Questions

1. What is the average time elapsed between a patients initial diagnosis date and a

patients first treatment? Does this time vary by gender?

2. How many patients are on nivolumab from 20122016?

3. Using the following risk stratification rules, please summarize the number of high,

medium, and low risk patients.

HighRisk = Female? anyage?

NON_WHITE OR Male? >= 70? NON_WHITE

MediumRisk = Female? >=75, WHITE OR Male? <70? NON_WHITE

LowRisk = Female? < 75, WHITE OR Male? anyage?

WHITE

4. Please create a visualization that could be used to help a medical researcher

understand how drug prevalence has changed over time.