New feature: csvtk join to prefix only duplicated column names

[stas-malavin]

Prerequisites

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

Describe your issue

I would like to have the possibility to prefix only duplicated column names. The second and third examples below showcase the desired effect of the imaginary --prefix-duplicates flag.

$ csvtk join --prefix-filename \
    <(echo -e 'name,attr,tool\nStas,stubborn,tube\nShenwei,smart,computer') \
    <(echo -e 'name,attr,food\nStas,microbiologist,sandwich\nShenwei,computer scientist,noodles') | \
    csvtk pretty
name      63-attr    63-tool    62-attr              62-food 
-------   --------   --------   ------------------   --------
Stas      stubborn   tube       microbiologist       sandwich
Shenwei   smart      computer   computer scientist   noodles 

$ csvtk join --prefix-filename --prefix-duplicates\
    <(echo -e 'name,attr,tool\nStas,stubborn,tube\nShenwei,smart,computer') \
    <(echo -e 'name,attr,food\nStas,microbiologist,sandwich\nShenwei,computer scientist,noodles') | \
    csvtk pretty
name      63-attr    tool       62-attr              food 
-------   --------   --------   ------------------   --------
Stas      stubborn   tube       microbiologist       sandwich
Shenwei   smart      computer   computer scientist   noodles 

$ csvtk join --prefix-duplicates\
    <(echo -e 'name,attr,tool\nStas,stubborn,tube\nShenwei,smart,computer') \
    <(echo -e 'name,attr,food\nStas,microbiologist,sandwich\nShenwei,computer scientist,noodles') | \
    csvtk pretty
name      attr       tool       attr1                food 
-------   --------   --------   ------------------   --------
Stas      stubborn   tube       microbiologist       sandwich
Shenwei   smart      computer   computer scientist   noodles 

It may also be a default behavior. Thank you!

[shenwei356]

Added a new flag -P/--prefix-duplicates, but it needs to be used along with --prefix-filename`.

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

$  csvtk join --prefix-filename --prefix-duplicates\
    <(echo -e 'name,attr,tool\nStas,stubborn,tube\nShenwei,smart,computer') \
    <(echo -e 'name,attr,food\nStas,microbiologist,sandwich\nShenwei,computer scientist,noodles') | \
    csvtk pretty
name      attr       tool       62-attr              food    
-------   --------   --------   ------------------   --------
Stas      stubborn   tube       microbiologist       sandwich
Shenwei   smart      computer   computer scientist   noodles 

[stas-malavin]

You're blasting-fast, thank you! :)

[stas-malavin]

It works, confirm