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.