Filtering Data

This tutorial uses Google spreadsheets to filter data. Other spreadsheet programs work in a similar way – play around and see how they differ.

There is sample data for this tutorial here.

Filtering data in a spreadsheet allows you to shut out the values you don’t want to see. For example, in the sample data, some “Country Names” are actually not countries? You’ll find things like “World”, “North America” and “Arab World”. Let’s filter them out.

Walkthrough: Filtering Data

  1. Select the whole table.

  2. Select “Filter” from the “Data” menu.

  3. You now should see triangles next to the column names in the first row.

  4. Click on the triangle next to country name.

  5. you should see a long list of country names in the box.

    http://farm9.staticflickr.com/8316/8070573150_2cf29b914f_o_d.png

  6. Find those that are not a country and click on them (the green check mark will disappear).

  7. Now you have successfully filtered your dataset.

  8. Go ahead and play with it – the data will not be deleted, it’s just not displayed.

Any questions? Got stuck? Ask School of Data!

Last updated on Sep 02, 2013.