Documentation

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.
  1. 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 }))
  1. Add an Output to Bucket cell:
  • Select the destination bucket for your normalized data.
  1. 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.”
  2. Click Preview in the upper left to verify that your notebook runs and preview the output.
  3. 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.

Select your region

Upgrade to InfluxDB Cloud or InfluxDB 2.0!

InfluxDB Cloud and InfluxDB OSS 2.0 ready for production.