Min-Max Scaler

Rescale a numeric CSV column to the [0, 1] range.

FreeNo accountOn your device

Runs in your browser. How to verify

Loading tool…

About this tool

Rescale one numeric CSV column to the range 0 to 1. The smallest value becomes 0, the largest becomes 1, and everything else lands in between in proportion. The min and max are reported so you can reuse them.

How to use

1
Step 1
Paste the CSV or drop a file.
2
Step 2
Enter the column name.
3
Step 3
Press Process and copy the scaled CSV.

How it works

Each value x becomes (x − min) / (max − min). If every value is equal, all outputs are 0 rather than dividing by zero. Min-max keeps the shape of the distribution but is sensitive to outliers, because they set the min and max.

x′ = (x − min) / (max − min)

Worked example

Scale a column

Input
y: 2.1, 3.9, 6.2, 7.8, 10.1, 12.2, 30
Output
min 2.1, max 30 0, 0.0645, 0.1470, 0.2043, 0.2867, 0.3620, 1
Walkthrough
3.9 becomes (3.9 − 2.1) / 27.9 = 0.0645.

Limitations

  • Only the 0-1 range; custom ranges like -1 to 1 are not offered.
  • One column per run, numeric only.
  • A single outlier compresses all the other values toward 0.

Questions

How do I scale data between 0 and 1?
Use min-max scaling: subtract the minimum and divide by the range. The tool does this for a chosen column.
What if all values are the same?
Every value becomes 0.
Min-max or z-score?
Min-max for bounded inputs such as images or neural networks; z-score when outliers or a Gaussian assumption matter.
Is the result downloadable?
The scaled CSV is in the result and can be copied or saved.

Features

  • 0 to 1 range
  • Min and max returned
  • Runs in your browser

Related resources

Guides and videos from around the web—opens on YouTube or the publisher’s site.

  • What Is A RESTful API?

    Traversy Media

    APIs are how most data tools receive payloads.

    Watch on YouTube
  • Finding mean, median, and mode

    Khan Academy

    Descriptive stats for quick data summaries.

    Watch on YouTube