主页 / ubuntu / 问题 / 1193534
Accepted
Nicola Gambaro
Asked: 2019-12-04 09:09:59 +0800 CST

如何将新列添加到所有行中具有相同文本的 CSV

  • 772

这是我的输入文件的示例：

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

我想重新格式化它，使其与另一个数据库匹配。第一列需要COMPTON在所有行中都说，第六列需要说PRECIPITATION，第七列NOT APPLICABLE。

我可能需要使用一些awk功能，但不确定。

bash awk csv

1 个回答

  1. Best Answer

    使用米勒（https://github.com/johnkerl/miller）你可以运行

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

    具有

    +---------+------------+--------------+----+-------+---------------+----------------+
| 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

相关问题