R Studio Coding -- 2
Budget: $10 – $30 USD
This project uses data handling and the fundamentals of graphic buildings with ggplot. This includes, but is not limited to, mutate, group_by, summarize, ggplot aesthetics, layering within ggplot, and proper labeling. Detailed directions are below.
Read in COVID case data from Ohio. Use col_types in your code to read these data with the appropriate variable types. Data source:
https://coronavirus.ohio.gov/static/dashboards/COVIDDeathData_CountyOfResidence.csv (Links to an external site.)
Create a data frame *age_cases* for all cases since June 01, 2022 (including 2022-06-01) summarized by age group. Create *age_hosp_death*, a similar data frame for all hospitalizations and deaths by age group since June 01, 2022.
Convert Counts to rates by dividing each total by population size within the age group. County level population (from the 2020 census) by age groups are available here:
https://tjfisher19.github.io/data/OhioCountyPopulation_byAge2020.csv (Links to an external site.)
Produce a 'pyramid' plot with hospitalization & death rates in each age group on the left and case rates in each age group on the right side. (See example for model to match.) Color deaths & hospitalizations 'red' and cases 'blue'.
Notes:
Readability of code will be evaluated.
You are NOT EXPECTED to match the provided pyramid plot (it is provided for reference).
Your plot will be evaluated on overall correctness, proper labeling, aesthetically pleasing, etc..
Your numbers will be different than the provided plot (this plot was constructed on September 6th, 2022)
Your code needs to save your final plot as a png file -- this is what will be graded for aesthetic purposes.
Example plot and example code are available too. I am looking to work with someone year long this project is a way to test if you would be a good fit for my work in the future. This project should take about 20 minutes.
Read in COVID case data from Ohio. Use col_types in your code to read these data with the appropriate variable types. Data source:
https://coronavirus.ohio.gov/static/dashboards/COVIDDeathData_CountyOfResidence.csv (Links to an external site.)
Create a data frame *age_cases* for all cases since June 01, 2022 (including 2022-06-01) summarized by age group. Create *age_hosp_death*, a similar data frame for all hospitalizations and deaths by age group since June 01, 2022.
Convert Counts to rates by dividing each total by population size within the age group. County level population (from the 2020 census) by age groups are available here:
https://tjfisher19.github.io/data/OhioCountyPopulation_byAge2020.csv (Links to an external site.)
Produce a 'pyramid' plot with hospitalization & death rates in each age group on the left and case rates in each age group on the right side. (See example for model to match.) Color deaths & hospitalizations 'red' and cases 'blue'.
Notes:
Readability of code will be evaluated.
You are NOT EXPECTED to match the provided pyramid plot (it is provided for reference).
Your plot will be evaluated on overall correctness, proper labeling, aesthetically pleasing, etc..
Your numbers will be different than the provided plot (this plot was constructed on September 6th, 2022)
Your code needs to save your final plot as a png file -- this is what will be graded for aesthetic purposes.
Example plot and example code are available too. I am looking to work with someone year long this project is a way to test if you would be a good fit for my work in the future. This project should take about 20 minutes.