awk的在多个文件中平均相同列（具有一定的范围内） [英] awk average same column in multiple files(with certain range)

问题描述

正如我所说的，我得到的答案从这里：
<一href=\"http://stackoverflow.com/questions/13263963/calculating-average-using-awk-from-multiple-files\">AWK多个文件averge

As I said, I got answer from here: AWK multiple files averge

然而，这是不够的，如果我有多个文件 dummy_0.txt dummy_100.txt dummy_200.txt ... ... dummy_5000.txt dummy_50000.txt 。
我只想平均柱2档范围从 dummy_0.txt到dummy_5000.txt。

However, that is not enough if I have multiple files dummy_0.txt dummy_100.txt dummy_200.txt... dummy_5000.txt ... dummy_50000.txt. I only want to average column 2 of files range from dummy_0.txt to dummy_5000.txt.

而不是这样做的：

awk '{a[FNR]+=$2;b[FNR]++;}END{for(i=1;i<=FNR;i++)print i,a[i]/b[i];}' dummy_*.txt

我需要这样的东西，其中间隔是100

I need something like where interval is 100

awk '{a[FNR]+=$2;b[FNR]++;}END{for(i=1;i<=FNR;i++)print i,a[i]/b[i];}' dummy_[100 - 5000].txt

我该怎么办呢？

推荐答案

您可以使用在bash水珠范围 {start..end..interval} ：

You can use glob range {start..end..interval} in bash:

awk '{a[FNR]+=$2; b[FNR]++}
   END{for(i=1;i<=FNR;i++) print i,a[i]/b[i]}' dummy_{100..5000..100].txt

这篇关于awk的在多个文件中平均相同列（具有一定的范围内）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！