Lesson 2.
Create Data Driven Reports using Jupyter Notebooks2013 Colorado Flood Data


A well documented scientific workflow is valuable because it makes it easier for us all to build off of each other’s work. Below you will consider the elements of a well-documented workflow using Jupyter Notebooks.

Learning Objectives

After completing this tutorial, you will be able to:

  • List some of the components of a project that make it more easily re-usable (reproducible) to you when working with other people

What You Need

You will need a computer with internet access to complete this activity.

A Data Report

Your colleague put together the very informative data report below. The topic of the report is the 2013 Colorado floods. Examine the report. Then answer the questions below.

  1. What sources of data were used to create the plots?

  2. How were the data processed?

  3. How did your colleague generate this report? When was it last updated?

  4. Who contributed to this report?

  5. You’d like to make some changes to the report - can you do that easily? If you wanted to make changes, what process and tools would you use to make those changes?

  6. What units are the precipitation data in?

  7. Create a list of the things that would make editing this report easier.


My Report - 2013 Colorado Flood Data

Precipitation Data

A lot of rain impacted Colorado. See below.

Downloading from https://ndownloader.figshare.com/files/7010681
Downloading from https://ndownloader.figshare.com/files/7010681
STATIONSTATION_NAMEELEVATIONLATITUDELONGITUDEDATEHPCPMeasurement FlagQuality Flag
0COOP:050843BOULDER 2 CO US1650.540.03389-105.2811120030101 01:000.0g
1COOP:050843BOULDER 2 CO US1650.540.03389-105.2811120030201 01:000.0g
2COOP:050843BOULDER 2 CO US1650.540.03389-105.2811120030202 19:000.2
3COOP:050843BOULDER 2 CO US1650.540.03389-105.2811120030202 22:000.1
4COOP:050843BOULDER 2 CO US1650.540.03389-105.2811120030203 02:000.1
Plot of daily precipitation for Boulder, Colorado from 2003-2013.
Plot of daily precipitation for Boulder, Colorado from 2003-2013.

Fall 2013 Precipitation

Let’s check out the data for a few months.

Plot of Daily Total Precipitation from Aug to Oct 2013 for Boulder Creek.
Plot of Daily Total Precipitation from Aug to Oct 2013 for Boulder Creek.
Plot of Total Monthly Precipitation for Boulder, CO.
Plot of Total Monthly Precipitation for Boulder, CO.

Leave a Comment