Data Visualisation, an Outline

Jessica YungData Science, UncategorizedLeave a Comment

screenshot

  1. Collect your data. My datasource was Mitchell et al (2011). I copied the figures off the PDF and converted them into column data via the free comma delimiter Delim.co. I then transferred the data to Google Sheets.
  2. screenshot
  1. Format your data. I deleted the rows with years in them with a formula (see below), and then deleted all extra rows with the Sheets add-on Remove Blank Rows. I also added my source and the data series name to the sheet.
    1. I wanted to plot quarter-on-quarter GDP growth, so I calculated the growth rates from the monthly real GDP data.
screenshot
  1. Create your visualisation.I used HighCharts. You can make a standard chart easily by editing one of their demos. Info.gram is a nice alternative. (No coding option that I know of for Info.gram and no coding required for either.)
    1. I needed my data to be in an array, so I used Google Sheets to try to . If your data needs to be in JSON, ConvertCSV.com may be useful.
    2. EDIT: I did not realise Highcharts Cloud existed until writing this post and created my chart in JSfiddle. Highcharts Cloud is much easier to work with but is not immediately as flexible, and some features are only available to licensed users.
screenshot
screenshot

Highcharts Cloud.

  1. Publish! The chart is now online on my Data Visualisation Projects page.
screenshot

Leave a Reply