Add Calculated Column to Parquet Files Online
Add a new column to Parquet files computed from an arithmetic expression over existing columns. No formulas, no code — just point and click.
About this tool
Add a new computed column to a Parquet file by combining two existing columns (or a column and a constant) with an arithmetic operator. Multiply a price column by a quantity column, subtract a cost from a revenue, compute a percentage — without opening a spreadsheet or writing code. All calculation runs locally in your browser.
Frequently Asked Questions
What arithmetic operations are supported when adding a column to a Parquet file?
Addition (+), subtraction (−), multiplication (×), division (÷), and modulo (%). You can combine two columns, two constants, or one column and one constant.
What happens if I divide by zero when calculating a column in a Parquet file?
Division by zero returns NULL rather than throwing an error. The resulting column will have NULL in any row where the divisor is zero or null.
Can I chain multiple calculations in a Parquet file?
This tool adds one calculated column at a time. To chain calculations — for example, first compute revenue = price × quantity, then profit = revenue − cost — run the tool twice. Each run adds the new column to the downloaded result.
Is my data private?
Yes — completely. Your file is never uploaded to any server. Everything runs locally in your browser using WebAssembly — processing happens entirely inside your tab. Once you close the tab, nothing is retained.
What is the maximum file size?
The free limit is 50 MB. For larger files, performance depends on your device's available memory — most modern machines handle 500 MB to 1 GB comfortably.
Related Tools
Add Moving Average to Parquet Files Online
Add a moving average, rolling sum, rolling min, or rolling max column to Parquet files directly in your browser. Choose window size, order-by column, and optional partitioning — no upload required.
Search Text in Parquet Files Online
Search for text across all string columns in Parquet files directly in your browser. Filter rows to only those containing your search term and download the results — no upload required.
Get Top N Rows from Parquet Files Online
Extract the top N rows per group from Parquet files directly in your browser. Get the top 5 products per category, highest scores per team, or any ranked subset — no upload required.
Add Percent of Total to Parquet Files Online
Add a percentage-of-total column to Parquet files directly in your browser. Show each row's share of the grand total, or the share within each group — no upload required.
Parse URL Column in Parquet Files Online
Parse URL columns in Parquet files and extract host, path, query string, and fragment into separate columns — directly in your browser, no upload required.