Now that we have our crime and mapping data, lets work on gathering the other data I wrote down during the previous Planning post. Part 2 of Data Search will focus on our Other Data Sources branch in the project plan. Moon Phases On previous work projects, I have come across a couple of R…
Category: data project
Criminal Analysis: Data Search (part 1)
Now that we have our crime data, lets work on gathering the other data I wrote down during the previous Planning post. Part 1 of Data Search will focus on our Map Data branch in the project plan. Map Data Boundary Data Using the same Open Data website, I just queried for DC boundary and…
Criminal Analysis: Data Search (part 0)
Searching for Criminal Activity Data My initial search begins with querying for “Washington DC” and “Crime Data”. This is very broad but it lets me see what is available. I can always get more specific. https://duckduckgo.com/?q=Washington+DC+crime+data&t=lm&ia=web My results yielded a couple pages of interest. Check out the sites that seem interesting or could provide the…
Criminal Analysis: Planning
UPDATE (12/6/20): I have removed the original content in this post concerning the Data Search work for the crime data. You can now find that portion of the original post here. In this series, I will be exploring the criminal activity in Washington DC over the past decade. I have explored the data in previous…
Project Workflow
Overview Over the years of being involved with numerous data analysis projects, I have established a structure that I use to design and plan for each new project. Through repetition, I have found that having a structure helps factor in considerations unique to each project. It ensures that . During each phase of my workflow,…
Project Workflow: Data Analysis
***This was created and valid in 2016. Data for this specific data project may no longer be current*** Data analysis is our investigation of the questions we set out to answer for our project during the planning stage. At this point we should have a good understanding of what are data contains, and various value…
Project Workflow: Data Exploration
***This was created and valid in 2016. Data for this specific data project may no longer be current*** In this section, we will take a look at pivot tables in R. This can help us quickly summarize the data and get a rough distribution of the values. We will also explore some initial visualizations to…
Project Workflow: Data Transformation
***This was created and valid in 2016. Data for this specific data project may no longer be current*** Data Transformation The transformation stage is where you develop, add or enhance the data you have to suit your follow-on analysis and visualization requirements. You may revisit the transformation stage many times throughout a project because you…
Project Workflow: Data Preparation
***This was created and valid in 2016. Data for this specific data project may no longer be current*** Surveying the Data Data Preparation is a valuable stage that steps up the rest of the stages in our project. It allows you to survey the data and figure out what needs to be done. Its your…
Project Workflow: Data Storage
***This was created and valid in 2016. Links for this specific data project may no longer be current*** Where do you store all the data? It is quite possible that you have to download a series of files in order to have a full set or may you have a lot a data sources that…
