我有一个名为 scene1.csv 的 csv 文件,其中第二列的列名称为“0-4 年高风险”、“65 年以上第一响应者”等。有 20 个这样的值。第 21 行第 2 列具有与第 1 行第 2 列相同的条目。我想将这些值分别重命名为 p1-p20。因此第 21 行将带有 p1 标签。一切都没有引号。我有 150 个这样的文件,名为 scene1.csv、scenario2.csv ... 我该怎么做?以下是较短文件的示例:
t, group, 1, 3, 5
0, 0-4 years low risk, 0, 0, 0
0, 0-4 years high risk, 0, 0, 1
....., ....
0, 0-4 years low risk, 0, 0, 0
每个文件的预期输出:
t, group, 1, 3, 5
0, p1, 0, 0, 0
0, p2, 0, 0, 0
....., ....
0, p1, 0, 0, 0
这是我需要的字典:
0-4 years first responder p1
0-4 years high risk p2
.......
65+ years low risk p19
65+ years pregnant women p20
答案1
由于您没有sponge
安装 GNU AWK:
<<<"$(<treatables-000.csv)" awk -F ',' -v OFS=',' 'NR!=1{$2="p"(NR-2)%20+1}1' >treatables-000.csv
-F ','
:将输入字段分隔符设置为,
;-v OFS=','
:将输出字段分隔符设置为,
;NR!=1{$2="p"(NR-2)%20+1}1
:如果当前记录号大于1
,则将第二个字段设置为一个由p
字符后跟表达式结果组成的字符串(NR-2)%20+1
,并打印该记录;
% cat treatables-000.csv
t,group,1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43,45,47,49,51,53,55,57,59,61,63,65,67,69,71,73,75,77,79,81,83,85,87,89,91,93,95,97,99,101,103,105,107,109,111,113,115,117,119,121,123,125,127,129,131,133,135,137,139,141,143,145,147,149,151,153,155,157,159,161,163,165,167,169,171,173,175,177,179,181,183,185,187,189,191,193,195,197,199,201,203,205,207,209,211,213,215,217,219,221,223,225,227,229,231,233,235,237,239,241,243,245,247,249,251,253,255,257,259,261,263,265,267,269,271,273,275,277,279,281,283,285,287,289,291,293,295,297,299,301,303,305,307,309,311,313,315,317,319,321,323,325,327,329,331,333,335,337,339,341,343,345,347,349,351,353,355,357,359,361,363,365,367,369,371,373,375,377,379,381,383,385,387,389,391,393,395,397,399,401,403,405,407,409,411,413,415,417,419,421,423,425,427,429,431,433,435,437,439,441,443,445,447,449,451,453,455,457,459,461,463,465,467,469,471,473,475,477,479,481,483,485,487,489,491,493,495,497,499,501,503,505,507
0,0-4 years low risk,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
0,0-4 years high risk,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
% <<<"$(<treatables-000.csv)" awk -F ',' -v OFS=',' 'NR!=1{$2="p"(NR-2)%20+1}1' >treatables-000.csv
% cat treatables-000.csv
t,group,1,3,5,7,9,11,13,15,17,19,21,23,25,27,29,31,33,35,37,39,41,43,45,47,49,51,53,55,57,59,61,63,65,67,69,71,73,75,77,79,81,83,85,87,89,91,93,95,97,99,101,103,105,107,109,111,113,115,117,119,121,123,125,127,129,131,133,135,137,139,141,143,145,147,149,151,153,155,157,159,161,163,165,167,169,171,173,175,177,179,181,183,185,187,189,191,193,195,197,199,201,203,205,207,209,211,213,215,217,219,221,223,225,227,229,231,233,235,237,239,241,243,245,247,249,251,253,255,257,259,261,263,265,267,269,271,273,275,277,279,281,283,285,287,289,291,293,295,297,299,301,303,305,307,309,311,313,315,317,319,321,323,325,327,329,331,333,335,337,339,341,343,345,347,349,351,353,355,357,359,361,363,365,367,369,371,373,375,377,379,381,383,385,387,389,391,393,395,397,399,401,403,405,407,409,411,413,415,417,419,421,423,425,427,429,431,433,435,437,439,441,443,445,447,449,451,453,455,457,459,461,463,465,467,469,471,473,475,477,479,481,483,485,487,489,491,493,495,497,499,501,503,505,507
0,p1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
0,p2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
treatables-???.csv
要对当前工作目录中匹配通配模式的所有文件重复此操作,您可以使用 Bashfor
循环:
for f in treatables-???.csv; do <<<"$(<"$f")" awk -F ',' -v OFS=',' 'NR!=1{$2="p"(NR-2)%20+1}1' >"$f"; done
答案2
您可以使用循环来完成任务,nl
(n编号我内)和sed
(s特林e编辑)
for f in scenario*.csv
do
#next will numerate all lines exept first (started without number)
nl -bp^[0-9] -nln -w1 "$f" |
sed '
#add the «p» before line number
s/^[0-9]/p&/
#put «pNUM» on the place of second field started with «NUM-NUM»
s/\(^p[0-9]*\)\s*\([0-9]*,\s*\)[0-9]-[0-9][^,]*/\2\1/
#removes spaces from the line begining (may be for header only)
s/^\s*//
' > out.tmp #outputs changed lines into temporary file
mv out.tmp "$f" #move temp file to original
done
rm out.tmp #delete temp file
答案3
我了解您有一个独特短语列表,并且希望将列表中的第一个短语替换为“p1”,第二个短语替换为“p2”,依此类推。如果您想保留列宽,可以通过以下方式进行:
for filename in *.csv; do
awk '
BEGIN {
FS = ","
n = 0
}
{
if (NR > 1) {
if (!($2 in p)) {
n++
p[$2] = n
}
$2 = "p" p[$2]
}
for (i = 1; i <= NF; i++) {
sub("^[ ]+", "", $i)
if (i != NF) {
$i = $i ","
}
}
# Add more columns and adjust the column widths to
# your liking here.
printf "%-3s%-10s%-3s%-3s%-3s\n", $1, $2, $3, $4, $5
}
' "$filename" > "$filename.tmp"
mv "$filename.tmp" "$filename"
done
答案4
这是一个可以完成这项工作的 Perl 脚本。
您可以%patterns
根据需要向哈希添加更多模式和替换。不要忘记每行末尾的逗号。
请注意,模式被解释为正则表达式,而不是文字字符串。因此,如果您的模式具有任何正则表达式特殊字符(如*
、(
、)
、?
、+
等),则需要使用\
(例如\*
、\(
、\)
、\?
、\+
)对它们进行转义。
该脚本稍微更改了输出,因为它使用,\t
(逗号和单个制表符)连接所有字段,其中原始输入有多个空格。如果这很重要,您可以调整该打印语句以产生相同或相似的输出(例如,通过使用printf
而不是print join()
)
$ cat bissi.pl
#! /usr/bin/perl
use strict;
# optimisation: use qr// for the search patterns so that
# the hash keys are pre-compiled regular expressions.
# this makes the for loop later MUCH faster if there are
# lots of patterns and lots of input lines to process.
my %patterns = (
qr/0-4 years low risk/ => 'p1',
qr/0-4 years high risk/ => 'p2',
qr/65\+ years low risk/ => 'p19',
qr/65\+ years pregnant women/ => 'p20',
);
while(<>) {
chomp;
my @line = split /,\s*/;
foreach my $key (keys %patterns) {
# perl arrays are zero based, so $line[1] is 2nd field
if ($line[1] =~ m/$key/) {
$line[1] = $patterns{$key} ;
last;
}
}
print join(",\t",@line), "\n";
}
这会产生以下输出:
$ ./bissi.pl input.txt
t, group, 1, 3, 5
0, p1, 0, 0, 1
0, p2, 0, 0, 0
0, p1, 0, 0, 0
要转换所有 150 个文件,您可以将其包装在 shell for 循环中,如下所示:
mkdir -p new
for i in {1..150} ; do
./bissi.pl "scenario$i.csv" > "new/scenario$i.csv"
done