Min-Max Scaler
Rescale a numeric CSV column to the [0, 1] range.
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
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?
What if all values are the same?
Min-max or z-score?
Is the result downloadable?
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 YouTubeFinding mean, median, and mode
Khan Academy
Descriptive stats for quick data summaries.
Watch on YouTube
- Introducing JSON
json.org
JSON grammar for data format converters.
- Model for Tabular Data and Metadata on the Web
W3C
Tabular data model behind CSV-oriented workflows.