Developing Data Products

Jose Ramon Pineda
March 18, 2020

Final Project for Coursera Developing Data Products

Quarterly Metropolitan Exports

For this project I decided to create a graphic interface for the US Census Bureau's Quarterly Metropolitan Exports data. It is a fairly new data product and as someone who works with the data I wanted to explore new ways of visualizing it.

Data Source is here:

https://www.census.gov/foreign-trade/statistics/state/metrohistory.xlsx

Data Sample

This program compiles quarterly data from 2016 to 2018 for all major metropolitan areas in the United States as well as their regional aggregations.

head(metro3[,c(1,2,3,5,6)], 10)

                                   metro abv    region Quarter     exports
1                   All Metropolitan (1) MET    Region      Q4 369552.3093
2      Allentown-Bethlehem-Easton, PA-NJ ALL Northeast      Q4    854.5056
3      Atlanta-Sandy Springs-Roswell, GA ATL     South      Q4   6273.7802
4         Boston-Cambridge-Newton, MA-NH BOS Northeast      Q4   6500.9603
5        Bridgeport-Stamford-Norwalk, CT BRD Northeast      Q4   2447.2293
6  Buffalo-Cheektowaga-Niagara Falls, NY BUF Northeast      Q4   1379.4423
7      Charlotte-Concord-Gastonia, NC-SC CHA     South      Q4   3403.4238
8     Chicago-Naperville-Elgin, IL-IN-WI CHI   Midwest      Q4  11534.8619
9               Cincinnati, OH-KY-IN (2) CIN     South      Q4   6528.6283
10                  Cleveland-Elyria, OH CLE   Midwest      Q4   2282.8474

Chart Example

In the Shiny app you will be able to easily pick what Metropolitan areas or Regional areas are displayed for analytical purposes.

Here we can see an example of Allentown,PA, Milwaukee, WI and New Orleans, LA in a single chart.

plot of chunk unnamed-chunk-3

Resources and Shiny App locations

ShinyApp:https://jrpineda.shinyapps.io/myApp/

This contains the actual app that you can interact with. Simply click on the checkboxes to select the metropolitan areas or regions you would like to view. Click on CLEAR ALL to reset your selections.

Github: https://github.com/jrpineda/Developing-Data-Products

My Github contains the server.R and ui.R files if you would like to review the code and how I did the graph.