- If you can only remember one thing, remember Figure.NZ
- If you can only remember two things, remember to add
/data.csvto Figure.NZ urls
- Make a copy of your original data
- Delete unnecessary columns (but don't forget what the units were)
Sometimes data jobs like this:
When what you need is:
Then it is time for a pivot table.
- Select all the data your need to pivot
- Click on 'Data' -> 'Pivot table'
- Select your columns - probably the variable name
- Select your rows - probably time
- Select your values - probably value
- Deselect the 'Create totals' options
- Copy the result into datawrapper
Using the tools at hand; size, colour, shape, and position to represent (encode) the values in the data.
- Different charts will highlight different aspects of your data more effectively.
- Choose the chart that shows the aspect of the data that you are interested in
- Line and Bar charts are often a safe choice
- Take care with maps and pie charts
- Charts and graphs can be used to deceive
- Don't do this.
The most common bad things are:
- Incorrect, missing, or misleading labels
- Inconsistenct scales
- Truncating scales
- Comparing things that shouldn't be
- Too many things
- Barcharts always start at 0
- Line charts don't need to start at 0, but always ask yourself if the range you select is going to make an insignificant change look important
- Only use pie charts for parts of a whole and only when there are less than 5 categories
- Avoid maps for showing quantities
Pick a couple of charts from Figure.NZ and remake it.
- Have you made them better or worse?
- If you have improved them is the data being shown in a different way?
- Workbench Data is built for journalists
- Replaces spreadsheets in your workflow
- Pivot is called reshape
This is long data
This is wide data
New Zealand is a mess (this doesn't cover DHBs, Police Districts, Civil Defense, or Fire and Emergency areas)
Ask for help!