ITADN

pivotp does not allow simplest use case

#3697Closedterefang 创建于 2026-04-11
T
terefangcommented
i have the following data set: ``` GROUP,NAME G1,N1 G2,N1 G3,N2 G4,N2 G5,N1 G5,N2 G5,N3 ``` can only create a pivot like: `qsv pivotp --grand-total -i GROUP -a len -v NAME 'NAME' test.csv` that looks like this: ``` GROUP N1 N2 N3 G1 1 0 0 G2 1 0 0 G3 0 1 0 G4 0 1 0 G5 1 1 1 Grand Total 3 3 1 ``` but there is no way to make it look like: ``` GROUP count G1 1 G2 1 G3 1 G4 1 G5 3 Grand Total 7 ``` what am i missing ?
关闭于 2026-04-12 0 条评论