Unpivoting Data Adds Granularity: the story of rice since 1961

Introduction

About a month ago I read a short article on The biggest rice producers in the world (in millions of tons) as part of an English language exercise for Mrs W. Since I live in rice farming country that got me interested and I followed up on this site, http://ricepedia.org/, by downloading a lot of basic data on each of ten of the 11 countries in the list of the biggest rice producers. Please note: there was no detailed data for the USA on the ricepedia web site that I could find so I had to drop it from the analysis, leaving these ten countries.

  • China
  • India
  • Indonesia
  • Bangladesh
  • Vietnam
  • Thailand
  • Myanmar
  • Philippines
  • Brazil
  • Japan

I downloaded the data and put each country’s data on its own worksheet, such as this one for Thailand:

To read the rest of this page, download the PDF and Excel files, links below:

PDF rice_data_unpivoted

Excel rice_data_unpivoted

 

Duncan Williamson

2nd April 2017

%d bloggers like this: