Normalize data with notebooks

Learn how to create a notebook that normalizes data. Walk through the following example to create a notebook that does the following:

• Inputs sample data from NOAA
• Normalizes sample data with a Flux script
• Outputs normalized data to a bucket

Requirements

• This example uses NOAA water database data. Note that using this data counts towards your total usage.
• Create a destination bucket to write normalized data to. For details, see Create a bucket.

Normalize data with a notebook

1. Create a new notebook (see Create a notebook).
2. Add a Metric Selector cell to select a bucket to query data from:

• In the Choose a bucket dropdown, select your NOAA bucket.
• Select the h2o_temperature field.
• Select the mean function from the aggregate selector in the upper-right.

3. Add a Flux Transformation cell with the following script to bring in data from the previous cell and normalize it:

__PREVIOUS_RESULT__
  |> map(fn: (r) => ({ r with _value: float(v: r._value) / 10.0 }))

4. Add an Output to Bucket cell:

• Select the destination bucket for your normalized data.

5. Add a Markdown cell to add a note to your team about what this notebook does. For example, the cell might say, “This notebook makes h20_temperature easier to view alongside water_level.”
6. Click Preview in the upper left to verify that your notebook runs and preview the output.
7. Run your notebook:

• Click Run to run the notebook and write to the output bucket a single time.
• To write continuously, click Export as Task in the upper right corner of the Output to Bucket cell. For details about working with tasks, see Manage tasks.