new command "scatter" about csvtk HOT 8 CLOSED

Uh-oh, I had 0.24.
Thanks! After upgrading, I get exactly what I need:

csvtk space2tab test.txt|csvtk spread -t -k t -v c|csvtk pretty -t
module    Class   DatatypeProperty   ObjectProperty
-------   -----   ----------------   --------------
address   1       2                  3
agent             4

from csvtk.

There's a 'spread': https://bioinf.shenwei.me/csvtk/usage/#spread

from csvtk.

hi @shenwei356 Does it make sense to add scatter as a synonym of spread?
scatter is a better match for gather: it even rhymes :-)

from csvtk.

Not really :). scatter sounds like the scatter plot.

gather and spread are from the R package tidyr. They perform opposite operations.

$ csvtk -h
Commands for Data Transformation:
  fold            fold multiple values of a field into cells of groups
  gather          gather columns into key-value pairs, like tidyr::gather/pivot_longer
  sep             separate column into multiple columns
  spread          spread a key-value pair across multiple columns, like tidyr::spread/pivot_wider
  transpose       transpose CSV data
  unfold          unfold multiple values in cells of a field

from csvtk.

@shenwei356 Yes: gather != spread = scatter.

"spread" and "scatter" mean the same (in this context", and "scatter" rhymes better with "gather".
I don't know tidyr, that's why I guessed there should be "scatter" as the opposite of "gather".

from csvtk.

Does it make sense to add scatter as a synonym of spread?

OK. But spread remains the main name, for consistence with tidyr, a popular R package widely used for table manipulation.

from csvtk.

sure!

from csvtk.

done.

from csvtk.