Data Study on Coffee: World Markets and Trade
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.
Contributed by Chia-An Chen (Anne Chen). She is currently in the NYC Data Science Academy 12-week full time Data Science Bootcamp program taking place between July 5th to September 23rd, 2016. This post is based on her second project - R Shiny (due on 4th week of the program). The R code can be found on GitHub.
A morning without coffee can be devastating...
But have you wondered where coffee comes from? Or how much coffee people consume? Coffee is not only a popular drink that refreshes people, but data shows it's one of the most important commodities in agricultural economies. The global coffee trade app I made visualizes the trading data of coffee around the globe from 1960 to 2015.
Overview of the App
The app has five tabs. “General View” visualizes the trading data as a world map and provides the top ten rankings for the trading category of choice. “Trend” allows users to compare different categories of trading in a specific country, and shows how the attributes change over time. The “Correlation” tab plots two variables of interest and checks if there is a correlation. “Fun Facts” compares annual working hours and coffee consumption in different countries to identify if people drink more coffee per hour they work. “Info” documents how the data was processed and where the datasets were downloaded.
From 2010 to 2015, the European Union and USA consumed the most coffee on average relative to other countries. However, if we normalize the amount of consumption by population, Switzerland and Norway were the top two nations for average domestic consumption.
Exports in the World
On the other hand, while Brazil and Vietnam rank as the top two exporters on average from 2010 to 2015, if we normalize the amount of coffee exported with GDP in USD, Honduras and Nicaragua are the top two countries. This finding may indicate that coffee plays a relatively vital role in economy in those countries that rank high in exporting coffee (kg/GDP).
European Union and Switzerland
The European Union relies solely on imports as the source for domestic consumption(red). Whereas in Switzerland, a portion of imported coffee is roasted and ground for exporting(yellow).
Ecuador and Thailand
The total distribution seems to be shaped by different attributes depending on the countries. In Ecuador, the distribution once relied on local production but has largely relied on import in recent years. While in Thailand, the distribution of coffee fluctuated with bean exports but has shifted to soluble exports lately.
Brazil and Democratic Republic of Congo
There are two primary types of coffee, Arabica and Robusta, which require different growing environments. Countries in South America, like Brazil, usually produce Arabica. And countries in Africa, such as the Democratic Republic of Congo, produce Robusta in general.
By looking at the data with no zero values in 2015, we discover that there is a fairly strong correlation between Imports and Domestic Consumption, and Total Distribution and Production. Note that the dashed lines are the average of each attribute, and dots at zero means that those countries do not either import or produce coffee beans at all.
Surprisingly, there are a few countries that show zero in domestic consumption, which implies that the people in those countries did not drink coffee at all in 2015. These countries are mostly the ones located in Africa, such as Benin, Liberia, Republic of Congo, and Zimbabwe…etc. For the full list of countries under this scenario, please visit the app and zoom in to the bottom left.
Working Hours vs Coffee Consumption
To prevent the data points normalized by population from crowding towards the bottom left of the plot, an amplifying factor of 1,000,000 was applied to the y axis, which is the annual working hour. This bubble chart implies that Norway and Switzerland work less and drink more, while Costa Rica and New Zealand may be the opposite.
Interestingly, since the size of the bubble is proportional to the coffee consumed relative to working hours, we can see that the USA consumes a lot more coffee than other countries per hour worked. It would appear that in some countries, like Norway and Switzerland, coffee is a drink of leisure; while for other countries, like the US, coffee is used as a way to kick start work.
(Potential) Future update for this app: Implement another dataset that lists the price paid to coffee bean growers, and see if the grower’s earnings are related to the GDP.
Hopefully you can find something that interests you after playing around the app. 🙂
Code at a glance (click here for the full R code):