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

ID: 3702460 • Letter: 1

Question

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 patient’s initial diagnosis date and a

patient’s 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.

Solution:

The first question is done as per Chegg guidelines, please repost others.

When presented with the dataset or a new database the steps one should take are:

2)
After evaluating the dataset or database and its structure
The questions which should be asked are:

Based on the analytical method required one should start writing code or queries which will project the analysis of the data.

I hope this helps if you find any problem. Please comment below. Don't forget to give a thumbs up if you liked it. :)

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.