CSV group summary
Grouping by specified columns, the count, total, average, min and maximum value of the numeric columns are calculated.
CSV group summary User manual
- Fill in the parameters or select the file according to the form, and check the unit and format first.
- The same city has two amounts of 10 and 20, totaling 30, an average of 15.
- Click the processing button to view the results, you can copy or download and save.
Calculation method and processing rules
The first behavior header, the group keys are recognized according to the original text, and the numerical column must be a limited decimal number.
scope of use
Up to 2000 rows and 200 columns, using double-precision calculation, it is not suitable for high-precision accounting; empty value reports errors instead of zero.
Will the input content be saved on the server?
This tool handles input in the browser, and does not upload files or form content. Typing practice scores are only saved in the native browser.
Why may the result be different from other tools?
Up to 2000 rows and 200 columns, using double-precision calculation, it is not suitable for high-precision accounting; empty value reports errors instead of zero. Please compare the input unit, rounding method, applicable rules and data version first.