Categories
Data analysis and reports

USE RStuido Use the dataset “Crimes_-_2001_to_Present” AND Requirement to answer

USE RStuido
Use the dataset “Crimes_-_2001_to_Present” AND Requirement to answer the TWO questions in Rmarkdown (IMPORTANT: including code in Rmd script):
Requirements:
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
Coding Requirement:
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.
Packages:
tidyverse
tidytuesdayR
paletteer
packges may use:
purrr
tinytex
extrafont
forcats
RColorBrewer
rcartocolor
ggrepel
(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):
https://data.cityofchicago.org/Public-Safety/Crimes-2001-to-Present/ijzp-q8t2/data

Categories
Data analysis and reports

You did the publish 2 and 3 for me, and I have added the commons leave by professo

You did the publish 2 and 3 for me, and I have added the commons leave by professor in the publish 3 files. And there are more reference is needed.

Categories
Data analysis and reports

All the instructions are written in the pdf. Please read carefully and the whole

All the instructions are written in the pdf.
Please read carefully and the whole instruction.
This is very very basic class (not even a coding class, not sure why we have to do this), so please use very basic coding methods.

Categories
Data analysis and reports

1.Create 5 bulleted list of data viz issues of old chart, 2.Designate the top th

1.Create 5 bulleted list of data viz issues of old chart,
2.Designate the top three issues (with brief supporting rationale).
3.Design a new chart to solve identified issues in Tableau.
5 sentence of bullet list, 3 sentence of issues and One simple and clrear new chart and thats all.
upload a WORD or PDF

Categories
Data analysis and reports

Hello. this is my Final MySQL assignment for this course. The professor for this

Hello. this is my Final MySQL assignment for this course. The professor for this class really cares about the instructions and attention to detail in the work, so I would really appreciate it if you could follow all the instructions fully and be very careful with what she asks for. This assignment is really important and could really affect my grade. I will be attaching the files of the assignment including the work I have already done throughout the semester. I have been working on this assignment since the beginning of the semester and the point of it is to build a database. Please let me know if you have any questions or if you need anything else. I will be adding a tip when I get the assignment as I have done with the other writers. Thank you. Please let me know if you can work on an exported file. just import it in and all the data is going to be there from the previous assignments.

Categories
Data analysis and reports

Hello All instructions are in the PDF attached. Plz do not use ZIP file. When up

Hello All instructions are in the PDF attached.
Plz do not use ZIP file. When uploading file plz use Doc.accdb

Categories
Data analysis and reports

it shuld be an ipynb file on google colab with descriptions, there are instructi

it shuld be an ipynb file on google colab with descriptions, there are instructions on the file
Comments from Customer
the work has to be done on google colab and the file has to be ipnyb

Categories
Data analysis and reports

Comments from Customer hi please see the ipynb file it has instructions, there i

Comments from Customer
hi please see the ipynb file it has instructions, there is a csv data set to be used please see I have attached that any doubts please let me know asap.

Categories
Data analysis and reports

https://archive.ics.uci.edu/ml/datasets.php?format=&task=clu&att=num&area=&numAt

https://archive.ics.uci.edu/ml/datasets.php?format=&task=clu&att=num&area=&numAtt=&numIns=&type=mvar&sort=nameUp&view=table
please choose any data set from here
Explain (i) what the data is and (ii) where it comes from
for item (i) include: basic overall description of the data, number of observations, number of features (break down by numeric vs. factor)
for item (ii) if you get the data from a website, then the name of the website and a URL is sufficient
Perform clustering on the data using any 3 methods from among the following: k-means, k-medoids, hierarchical clustering, dbscan, optics
you will not need to include ANY code in this section in the PDF!
for k-means and k-medoids, you need to discuss how you determine the value of k
compare and contrast the resulting clusters — use visualizations, statistics, etc.
you can include things like SSE, number of clusters, size of clusters, visualization of cluster
choose one set of cluster results (from one method) and provide some interpretation as to the meaning of the clustering.

Categories
Data analysis and reports

I need you also send me the dataset and your tableau workbook . Download any cov

I need you also send me the dataset and your tableau workbook .
Download any covid-19 time series data from one of the sources below and create a Tableau dashboard
(including at least two different charts) to demonstrate the trends in the data. Upload your tableau
workbook to the submission link on Blackboard before the due date.