Data + Journalism: A Story-Driven Approach to Learning Data Reporting by Mike Reilley & Samantha Sunne

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



Copyright Disclaimer:
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.