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
- Create a new notebook (see Create a notebook).
- 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.
- 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 }))
- Add an Output to Bucket cell:
- Select the destination bucket for your normalized data.
- 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 alongsidewater_level
.” - Click Preview in the upper left to verify that your notebook runs and preview the output.
- 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.
Support and feedback
Thank you for being part of our community! We welcome and encourage your feedback and bug reports for InfluxDB and this documentation. To find support, the following resources are available:
InfluxDB Cloud and InfluxDB Enterprise customers can contact InfluxData Support.