Summary does not respect "column:operation" order

[tetedange13]

Prerequisites

• [x] make sure you're are using the latest version by csvtk version
• [x] read the usage

Describe your issue

• [x] describe the problem

csvtk summary apply operations based on column order in file, rather than CLI-provided order

• [x] provide a reproducible example

$ csvtk csv2md test.csv

ReadNB	Lane	Density	ClusterPF	Reads	ReadsPF
Read 1	1	231	89.08	49.93	44.48
Read 1	2	232	88.76	50.11	44.48
Read 1	3	228	89.19	49.23	43.91
Read 1	4	229	88.67	49.48	43.87
Read 3	1	231	89.08	49.93	44.48
Read 3	2	232	88.76	50.11	44.48
Read 3	3	228	89.19	49.23	43.91
Read 3	4	229	88.67	49.48	43.87

$ csvtk summary --groups Lane -f ReadsPF:sum -f Reads:sum -f ClusterPF:first -f Density:first test.csv | csvtk headers

Lane Density:sum ClusterPF:sum Reads:first ReadsPF:first

Instead of expected (based on above command-line) :

Lane Density:first ClusterPF:first Reads:sum ReadsPF:sum

Thank you

I'm grateful to users who have greatly helped to report bugs and suggested new features.

I may respond to issues or fix bugs quickly, but I usually implement new features periodically (two or more weeks).

[shenwei356]

Fixed.

csvtk summary --groups Lane -f ReadsPF:sum -f Reads:sum -f ClusterPF:first -f Density:first test.csv  \
     | csvtk pretty 

Lane   ReadsPF:sum   Reads:sum   ClusterPF:first   Density:first
----   -----------   ---------   ---------------   -------------
1      88.96         99.86       89.08             231          
2      88.96         100.22      88.76             232          
3      87.82         98.46       89.19             228          
4      87.74         98.96       88.67             229 

• csvtk_darwin_amd64.tar.gz
• csvtk_darwin_arm64.tar.gz
• csvtk_linux_amd64.tar.gz