Home / ubuntu / Questions / 1193534
Accepted
Nicola Gambaro
Asked: 2019-12-04 09:09:59 +0800 CST

How to add new columns to CSVs with the same text in all lines

  • 772

This a sample of my input file:

22/12/1999,conductivity,42,uS/cm
06/01/2000,conductivity,22,uS/cm
26/01/2000,conductivity,26,uS/cm
09/02/2000,conductivity,32,uS/cm
23/02/2000,conductivity,33,uS/cm

I would like to reformat it so that it matches another database. The first column needs to say COMPTON in all lines, a sixth needs to say PRECIPITATION, and a seventh NOT APPLICABLE.

I probably need to use some awk function but am unsure.

bash awk csv

1 Answers

  1. Best Answer

    Using Miller (https://github.com/johnkerl/miller) you can run

    mlr --csv -N put '$a="COMPTON";$b="PRECIPITATION";$c="NOT APPLICABLE"' then reorder -f a  input.csv

    to have

    +---------+------------+--------------+----+-------+---------------+----------------+
| COMPTON | 22/12/1999 | conductivity | 42 | uS/cm | PRECIPITATION | NOT APPLICABLE |
| COMPTON | 06/01/2000 | conductivity | 22 | uS/cm | PRECIPITATION | NOT APPLICABLE |
| COMPTON | 26/01/2000 | conductivity | 26 | uS/cm | PRECIPITATION | NOT APPLICABLE |
| COMPTON | 09/02/2000 | conductivity | 32 | uS/cm | PRECIPITATION | NOT APPLICABLE |
| COMPTON | 23/02/2000 | conductivity | 33 | uS/cm | PRECIPITATION | NOT APPLICABLE |
+---------+------------+--------------+----+-------+---------------+----------------+
    • 4