Use the dataset “Crimes_-_2001_to_Present” AND Requirement to answer the TWO questions in Rmarkdown (IMPORTANT: including code in Rmd script):
1. Clean the dataset properly (remember the tidy data principles when wrangling the data) Provide a snapshot of the dataset in your output (e.g., create a proper table showing the data). Need to show how they are structured, variables, etc
2. Explain the data cleaning process step-by-step.
3. Explicitly identify the unit of analysis when describing the data.
4. Change column names if they are not intuitive
5. Check out the missing data and explain how to address them (if applicable)
6. Do not include steps that are not replicable or done in Excel
1. Use pipe annotations (not the dollar sign framework) as much as possible.
2. Create functions if / when needed.
3. Use loops to Optimize the work.
Data visualization Requirements:
1. Create your own theme for plots.
2. Comment on the results below each graph.
3. Include both explorative and explicative plots as well as tables:
1. Have explicative plots that showcase your main findings along with a few other explorative plots to showcase the distributions and frequencies of your variables. 2. Descriptive statistics in either table or plot form. Talk about the main variable distribution or frequency.
4. Check all elements in plots and tables and make sure they are intuitive for someone who doesn’t know your project – x and y axes labels, titles, notes and captions.
5. use aesthetically pleasant color in table and plots. Use color palettes.
packges may use:
(or more packages)
Question 1: What has changed in Chicago’s crime rates from 2019 to 2022?
Requirement: Summary the stats in a table. Use the dataset to create a line graph that shows the criminal case number by year and month from 2019 to 2021.
Question 2: How does Chicago’s crime rate relate to location, which areas have higher crime rates?
Requirement: Create a table that shows the crime cases in the top 10 high-crime-rate districts in Chicago. Then create a heatmap to show the Crime Type vs. Month Crossover Heat Map from 2019 to 2020. Expect to explore the relationship between different crime types and months.
Here attached the link of the data sources ( Or search Crimes – 2001 to Present – Chicago Data Portal):