In this second project of GR5243 Applied Data Science, we develop an Exploratory Data Analysis and Visualization shiny app on US international trade using U.S. government open data released on the data.gov website. See Project 2 Description for more details.
The app is available here: https://prayerest.shinyapps.io/ShinyApp-Proj2/
Data Source: data.gov.
Term: Spring 2017
-
Team # Scent of Spirit
-
Trace of Aroma - World Trade with U.S.: + Team members
- Ruxue Peng
- Raphael Xiv
- Xiaowo Sun
- Bowen Huang
- Terry Li
-
Project summary: In this cool project, we aim to help our user explore the trend of international trade of coffee, tea, chocolate, cocoa and spices(all belong to the same subgroup in Customs)and look into the reason of up-and-downs of trade value. We do that by presenting our data and results interactively: trade relationships are displayed on 3D globe, 2D map with different countries' news link and a series of statistical plots.
-
Contribution statement: (default) All team members contributed equally in all stages of this project. All team members approve our work presented in this GitHub repository including this contributions statement.
-
Project demostration: We have mainly four parts show on the web, "Home", "3D Globe", "2D Map", and "Summary Statistics", which are shown as follows.
"Home" is our homepage, with the names of out project and team members. "3D Globe" is an interactive 3D map for earch, which shows the geographical distribution of the countries whom the U.S. imports from or exports to. "3D Globe" is shown below.
"2D Map" shows the position of counties which U.S. exports to or imports from. Comparing to "3D Globe", you can view the name of countries and have a better comprehension of the rank of the countries.
As for "Summary Statistics", there are four parts in it, which are designed to analyze trades more in depth from several perspectives. In the tab "Regional Findings", you can see the visualization of trade along the timeline divided by different regions. If you move to the panel for "Market Share", you can see pretty clear maps representing the share and rank for different countries.
For the tab "Exchange rate", you can find on "Mirror Histogram" one country's import and export with U.S. on the same chart according to time. And you can also find the exchange rate shown on the chart. In order to find the relation ship between, the regression results are shown for different if you choose the tab "Regression" on the right.
For the "Clustering Analysis" tab, you can find the clustering results for all countries concerning five commodities' import. This part is mainly for find the similaritis for tading commodities among various countries. The result are shown on the map as well as in the table. Different colors means different clusters, and the number of countries in each cluster and the average magnitude for different commodies are shown in each line of the tavble.
The last part is "Motion Chart", in which you can see the dynamic change of two commodities for import concerning all countries. And if you choose the tab for line chart, the variation of one country/ several selected countries are also visualized.
The above demonstation are mainly what we built for this app.
Following suggestions by RICH FITZJOHN (@richfitz). This folder is orgarnized as follows.
proj/
├── app/
├── lib/
├── data/
├── doc/
└── output/
To reproduce the result, please refer to the app folder and its readme file.
Resources:
Visualization ideas-d3
How to build a 3D globe
3D globe-r blogger
Animation of 3D globe
2D choropleth map
Map using Leaflet
Map using Leaflet-Example Explained in Chinese
Tree Map and Motion Chart-googlevis package in R
How to customize your shinyapp style
CSS