VidTrade -
TRADE AND COMMERCIAL TRANSPORT ACTIVITY


WQD7001 - Principle of Data Science

26th June 2020


Group Members :

  • NURZUHRAH BINTI HASSAN (17218257)
  • NAZRAH BINTI MUSTAPA (17218099)
  • SHAIDATUL ADDILLA BINTI KHAMIS (17219414)
  • SITI AISYAH BINTI ZAMAKSHSHARI (17218495)

INTRODUCTION


Project Purpose

  • The project purpose is to create a useful product that provides visulization of trade and commercial transport activiti before and after Covid-19 outbreaks. It helps need to consider how to interpret current or future investment possibilities

Project Motivation

  • Transport is an essential to the efficient working of the economy, bringing together the inputs in the production of goods and services and getting outputs from the production process to customers.
  • Estimates suggest that if all other drivers of growth were to increase by 10% and transport infrastructure were to stay constant, then realised growth in income would be just 9%, means 1% point less than it otherwise would have been.

Case for Change

  • With COVID-19 hitting countries at different times and rates, access to global demand via open markets and continued trade will be important for supporting and sustaining economic recovery. Hence, there is thus a need to consider how to interpret current or future investment possibilities.

DATA SCIENCE PROCESS


Asking a Question

  • What application can investers use to predict the future investment possibilities for trade and transport activity?

Finding & Getting Data

  • Raw datasets can be retrieved from here .

Data Preprocessing

  • Change the format for Period column which is yyyymm to yyyy-mm .
  • Combine all the datasets from January 2019 until April 2020 into one file.
  • Extract few columns from original datasets to create new datasets for trade and transport activity.
  • The calculation for total transport frequency and trade value have been done manually in Excel.

SHINY APPLICATION


  • Power by R Shiny .
  • We visualize the trade activity by using Line Graph and transport activity by using Bar Graph. Documentation has been provided on the shiny app .
  • Click on Shiny app to open the dashboard .
  • Find our source codes and data in Github .
  • Video presentation can be accessed here .


References

Transportation

trade


Trade

transport

The graph shows that the regularity of trade transportation for Q1 2020 has dramatically reduced as compared to Q1 2019.The European countirescould maintain regularity of trade during the pandemic COVID-19 as compared to other countries around the world.The graph simply provide a glimpse into some of the major shifts afoot in early Q1 2020 because of the trade diversion impacted by the pandemic. Covid-19 when most countries around the world have taken an action to impose Movement Control Order (MCO) that change the transport mobility landscape. The dataset consist of sea, land and air transportation.



The graph shows the trade had experienced insignificant impact from the pandemic Covid-19 except for the beginning of Q4 2020 the trade jumped in some countries. It may due to festive session and year-end events that led to increase of trade from the retail industry.The small change in trend between Q1 2019 and Q1 2020 that is during the pandemic Covid-19 in Q1 2020 implied the trade activities remainthe same.This is because the trade activities not hugely impacted by the pandemic compared to human activities as people would still need tomeet essentials to save life and livelihoods hence demand on products would still continue during the pandemic. The closure of borders by the whole countries are not seasoned to demand of goods and products as compared to human activities.