A walkthrough of managing earthquake data and doing basic visualizations with spreadsheets (Part 2 of 3)
Create a Google spreadsheet in your PADJO2015 folder named: PADJO2015-MORECRIME-PIVOTS
It should include 2 different histograms and/or pivot tables:
Category
column is too broad, so find me something more interesting.You don’t have to make a visualization if you don’t want to. If you can filter/reduce the data to a few rows and columns that make your point, then great.
Download the CSV data and import into Google spreadsheets
For the second chart/table, pick a city: Chicago, Los Angeles, or Dallas. Use their respective web site tools to filter by date and export.
As you’ll see very quickly, every other city does not categorize crimes the same way that San Francisco does.
Obviously, the tutorial on pivot tables and earthquakes will be very handy.
Download the SF 2014-2015 August data for this exercise here.
The data originally came from the SF data portal
The other city datasets:
Look for the Filter and Export buttons:
A walkthrough of managing earthquake data and doing basic visualizations with spreadsheets (Part 2 of 3)
A walkthrough of using Pivot Tables to summarize earthquake data across two dimensions, allowing for even more insightful histograms (Part 3 of 3)
Pivot tables are an effective tool for quickly summarizing the facts from a mass of records