task-10

Task 10: Clean and Reformat (aka tidy)

Background

With stock return data from the previous task, we need to tidy this data for the creation of a time series plot. We want to look at the returns for each six-month period of the year in which the returns were reported. Your plot should highlight the tighter spread of the DJIA as compared to the other two selection methods (DARTS and PROS). We need to display a table of the DJIA returns with months on the rows and years in the columns (i.e. “spread” the data).

• Back or Course Website

Reading

This reading will help you complete the tasks below.

• o Python for Data Science - Tidy Data

Tasks

• Take notes on your reading of the specified ‘Python for Data Science’ chapter in in a marimo notebook.

• Import the Dart_Expert_Dow_6month_anova data from GitHub (see details in previous task)

• The contestant_period column is not clean/“tidy” we want to create a month_end and year_end column from the information it contains

• Create a plot that shows the six-month returns by the year in which the returns are collected

• Create a table using code of the DJIA returns that matches the table shown below (“spread” the data)

• Create a marimo notebook with short paragraph describing your plots.

• Export your notebook to .html and have both the notebook and HTML into your git repository

Final table

Month	1990	1991	1992	1993	1994	1995	1996	1997	1998
January	-	-0.8	6.5	-0.8	11.2	1.8	15	19.6	-0.3
February	-	11	8.6	2.5	5.5	3.2	15.6	20.1	10.7
March	-	15.8	7.2	9	1.6	7.3	18.4	9.6	7.6
April	-	16.2	10.6	5.8	0.5	12.8	14.8	15.3	22.5
May	-	17.3	17.6	6.7	1.3	19.5	9	13.3	10.6
June	2.5	17.7	3.6	7.7	-6.2	16	10.2	16.2	15
July	11.5	7.6	4.2	3.7	-5.3	19.6	1.3	20.8	7.1
August	-2.3	4.4	-0.3	7.3	1.5	15.3	0.6	8.3	-13.1
September	-9.2	3.4	-0.1	5.2	4.4	14	5.8	20.2	-11.8
October	-8.5	4.4	-5	5.7	6.9	8.2	7.2	3	-
November	-12.8	-3.3	-2.8	4.9	-0.3	13.1	15.1	3.8	-
December	-9.3	6.6	0.2	8	3.6	9.3	15.5	-0.7	-