Notice The New York Times map has broken the data at 4, 8, 12, 16 and 20. Next, we need to clean up the Estimated Age-adjusted Death Rate column. We need to decide how we will distribute this data. This is a habit of mine and it helps me track any changes I’ve made between steps. Then, select all rows and paste into a new sheet. By clicking the filter drop-down menu in the Year column, filter your data by the year 2015. Find the Filter option in the data tab in Excel. Place a filter on your data so you can sort and filter columns. What we will use later is the “Fips” column, which is recognized as a string. Click Spatial file under “Connect- To a file” to connect the shapefile. What we will use in Tableau Public is Uscounties.shp.įirst, open up Tableau Public. In order to add it to Tableau Public, we need to extract the files. county shapefiles, which are in essence polygons that define the borders of a county. county shapefilesĮSRI, a mapping service, provides U.S. We’ll need that FIPS number to merge this data with shapefiles of each county. That’s a federal code that uniquely identifies each county. Open the CSV file using Excel or similar spreadsheet software. (The filename should end in by_County_United_States.csv. Download the CSV Format county estimates file here. The New York Times based its map off of 1999 to 2014 drug poisoning deaths data from the National Center for Health Statistics. The following tutorial shows you how to create the same map using Tableau Public. Storybench published a tutorial for creating the map in. Last year, to explore the impact the opioids crisis is having on the United States, The New York Times visualized overdose deaths by county.
0 kommentar(er)
