Round Numbers in Parquet Files Online
Round numeric columns in Parquet files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
How to round Numbers in Parquet files
- Drop your file onto the upload area. Every numeric column is listed with its type, ticked, and set to 2 decimal places.
- Untick columns you want to leave alone, such as IDs, or use the All and None links.
- Drag each column's slider to set its decimal places, from 0 to 6. Each column can have its own setting.
- Click Round, check the preview of the first 200 rows, and download the file in the same format.
Your file is processed locally in your browser and is never uploaded. The free limit is 50 MB per file; larger files work if your device has the memory for them.
Worked example
A rainfall log from regional weather stations carries GPS coordinates to five decimals and rainfall to three. A public dashboard only needs about 100 m accuracy and one decimal of rain.
Input (Parquet)
Parquet file (binary, columnar) — shown as a table with its schema
| station | lat | lon | rain_mm |
|---|---|---|---|
| Kelburn | -41.28496 | 174.76785 | 12.46 |
| Ohakea | -40.20611 | 175.38872 | 0.05 |
| Paraparaumu | -40.90431 | 174.98556 | 3.349 |
| Masterton | -40.97512 | 175.63089 | NULL |
Schema: station VARCHAR, lat DOUBLE, lon DOUBLE, rain_mm DOUBLE
Settings
- lat: 3 decimal places
- lon: 3 decimal places
- rain_mm: 1 decimal place
Result
| station | lat | lon | rain_mm |
|---|---|---|---|
| Kelburn | -41.285 | 174.768 | 12.5 |
| Ohakea | -40.206 | 175.389 | 0.1 |
| Paraparaumu | -40.904 | 174.986 | 3.3 |
| Masterton | -40.975 | 175.631 | NULL |
Each column is rounded to its own number of places. Halves round away from zero, so 0.05 becomes 0.1 and -41.28496 becomes -41.285. Masterton has no reading and stays empty. The station column is text and is not listed. Rounding changes the stored value, not just the display.
Working with Parquet files
Parquet keeps exact numeric types, and rounding respects them. A DOUBLE or FLOAT column stays floating-point, so a value rounded to 2 places can still carry tiny binary noise when read by another tool. A DECIMAL column gets a new, smaller scale. DECIMAL(10,4) rounded to 2 places becomes DECIMAL(10,2), and the stored values are exact. Integer columns are listed but unchanged by any setting from 0 to 6.
Rounding high-precision measurements before writing Parquet often improves compression, because repeated values encode better. Sensor readings with six noisy decimals are a typical case. Only the ticked columns are touched. Column names, order and every other type are preserved in the new file. If a downstream schema expects the original DECIMAL scale, keep that column unticked or cast it back afterwards. NULL values in a rounded column stay NULL. Nested struct columns are not listed, even when they contain numbers.
Frequently Asked Questions
Does rounding change the type of a Parquet DECIMAL column?
It keeps it DECIMAL but reduces the scale to the number of places you chose, for example DECIMAL(10,4) to DECIMAL(10,2). DOUBLE and FLOAT columns keep their type.
Why do rounded Parquet doubles show extra digits in another tool?
DOUBLE is a binary floating-point type, so some decimals such as 0.1 cannot be stored exactly. The value is as close as the type allows. Use a DECIMAL column if you need exact decimals.
How are halves rounded?
Away from zero. 2.5 rounds to 3 and -2.5 rounds to -3 at 0 places. This matches Excel's ROUND, not the banker's rounding used by some programming languages.
Can I round down, round up, or truncate instead?
No. The tool only does standard rounding. For floor, ceiling or truncation, use the SQL workspace with floor(), ceil() or trunc().
Can I round to the nearest 10 or 100?
No. The slider runs from 0 to 6 decimal places. To round to tens or hundreds, use round(x, -1) or round(x, -2) in the SQL workspace.
Related Tools
Aggregate Parquet Files Online
Group and aggregate Parquet files by any column directly in your browser. Calculate sum, average, min, max, and count for any numeric column — no upload required.
Bin Column in Parquet Files Online
Bucket a numeric column in Parquet files into labelled ranges — equal-width bins or custom edges. Runs entirely in your browser.
Normalize Columns in Parquet Files Online
Normalize numeric columns in Parquet files using min-max scaling (0–1) or z-score standardisation (mean=0, std=1). Adds new columns alongside the originals — no upload required.
Round Numbers in CSV Files Online
Round numeric columns in CSV files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
Round Numbers in Excel Files Online
Round numeric columns in Excel files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
Round Numbers in JSON Files Online
Round numeric columns in JSON files to any number of decimal places directly in your browser. Set precision per column with a simple slider — no upload required.
Parquet Viewer Online
View and inspect Parquet files directly in your browser. Browse rows, check column names and data types — no upload required, your data stays on your device.
Convert Parquet to CSV Online
Convert Parquet files to CSV format directly in your browser. No upload required — your data never leaves your device.