Data + Journalism: A Story-Driven Approach to Learning Data Reporting by Mike Reilley & Samantha Sunne
Author:Mike Reilley & Samantha Sunne
Language: eng
Format: epub
Publisher: Routledge
Published: 2022-11-29T00:00:00+00:00
Exercise 3
Weâre going to find out which months had the most COVID cases, using a pivot table.
Create a new pivot table by clicking Insert > Pivot table.
In the pop-âup window, confirm your data range. It should be your full dataset, consisting of several columns and more than 1,000 rows.
Check the radio button for New Sheet and click Create. This will open the pivot table editor in a new tab.
In the pivot table editor, we have four options to work with: Rows, Columns, Values and Filters. Clicking the Add button will create a new instance of that category for every instance of that variable. For instance, clicking Add > University in the Columns section would create 14 new columns, because there are 14 universities in the Big Ten Conference (Figure 6.5).
Figure 6.5 The pivot table editor. So, before creating a pivot table, think: What would my ideal table look like? You can even sketch it out on a napkin. If you end up with far too many columns, or the wrong values in your rows, you can click the X in the variable box to delete it.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Cecilia; Or, Memoirs of an Heiress — Volume 1 by Fanny Burney(32029)
Cecilia; Or, Memoirs of an Heiress — Volume 3 by Fanny Burney(31441)
Cecilia; Or, Memoirs of an Heiress — Volume 2 by Fanny Burney(31391)
The Lost Art of Listening by Michael P. Nichols(7143)
We Need to Talk by Celeste Headlee(5400)
Asking the Right Questions: A Guide to Critical Thinking by M. Neil Browne & Stuart M. Keeley(5340)
On Writing A Memoir of the Craft by Stephen King(4650)
Dialogue by Robert McKee(4148)
Pre-Suasion: A Revolutionary Way to Influence and Persuade by Robert Cialdini(3964)
I Have Something to Say: Mastering the Art of Public Speaking in an Age of Disconnection by John Bowe(3768)
Elements of Style 2017 by Richard De A'Morelli(3230)
The Book of Human Emotions by Tiffany Watt Smith(3130)
Fluent Forever: How to Learn Any Language Fast and Never Forget It by Gabriel Wyner(2904)
Name Book, The: Over 10,000 Names--Their Meanings, Origins, and Spiritual Significance by Astoria Dorothy(2831)
Good Humor, Bad Taste: A Sociology of the Joke by Kuipers Giselinde(2816)
Why I Write by George Orwell(2764)
The Grammaring Guide to English Grammar with Exercises by Péter Simon(2640)
The Art Of Deception by Kevin Mitnick(2619)
Don't Sleep, There Are Snakes by Daniel L. Everett(2495)
