While your data companions rushed off to jobs in finance and government, you remained adamant that science was the way for you. Staying true to your mission, you've joined Pymaceuticals Inc., a burgeoning pharmaceutical company based out of San Diego. Pymaceuticals specializes in anti-cancer pharmaceuticals. In its most recent efforts, it began screening for potential treatments for squamous cell carcinoma (SCC), a commonly occurring form of skin cancer.

As a senior data analyst at the company, you've been given access to the complete data from their most recent animal study. In this study, 249 mice identified with SCC tumor growth were treated through a variety of drug regimens. Over the course of 45 days, tumor development was observed and measured. The purpose of this study was to compare the performance of Pymaceuticals' drug of interest, Capomulin, versus the other treatment regimens. You have been tasked by the executive team to generate all of the tables and figures needed for the technical report of the study. The executive team also has asked for a top-level summary of the study results.

• Clean a data set for any mouse ID with duplicated values.

• Create a summary statistics table that contains mean, median, variance, standard deviation, and SEM of the tumor volume for each drug regimen.

• Create a bar plots for total mice for each treatment regimen throughout the data study.

• Design a pie plot using both Pandas and Matplotlib that shows the distribution of female and male mice in the study.

• Calculate the final tumor volumen of each mouse across four of the most promising treatment regimens: Capomulin, Ramicane, Infubinol, and Ceftamin.

• Calculate the quartiles and IQR and quantitatively determine if there are any potential outliers across all four treatment regimens.

• Using Matplotlib, generate a box and whisker plot of the final tumor volume for all four treatment regimens and highlight any potential outliers in the plot by changing their color and style.

• Select one mouse that was treated with Capomulin and create a line plot of time point versus tumor volume for that mouse.

• Create a scatter plot of mouse weight versus average tumor volume for the Capomulin treament regimen.

• Calculate the correlation coefficient and linear regression model between mouse weight and average tumor volume for the Capomulin treament. Plot the linear regression model on top of the previous scatter plot.

• Write out the three observations or inferences on a separate Jupyter Notebook file.

Erika Yi © 2020. All Rights Reserved.