awk - 为包括负数的范围创建类似 bin 的直方图

Question

我的数字范围为 -4至 4 ，包括 0 ，如

-0.526350041828112
-0.125648350883331
0.991377353361933
1.079241128983
1.06322905224238
1.17477528478982
-0.0651086035371559
0.818471811380787
0.0355593553368815

我需要像桶一样创建直方图，并且一直在尝试使用它

BEGIN { delta = (delta == "" ? 0.1 : delta) }
{
    bucketNr = int(($0+delta) / delta)
    cnt[bucketNr]++
    numBuckets = (numBuckets > bucketNr ? numBuckets : bucketNr)
}
END {
    for (bucketNr=1; bucketNr<=numBuckets; bucketNr++) {
        end = beg + delta
        printf "%0.1f %0.1f %d\n", beg, end, cnt[bucketNr]
        beg = end
    }
} 

来自 Create bins with awk histogram-like
输出看起来像

-2.4 -2.1 8
-2.1 -1.8 25
-1.8 -1.5 108
-1.5 -1.2 298
-1.2 -0.9 773
-0.9 -0.6 1067
-0.6 -0.3 1914
-0.3 0.0 4174
0.0 0.3 3969
0.3 0.6 2826
0.6 0.9 1460
0.9 1.2 752
1.2 1.5 396
1.5 1.8 121
1.8 2.1 48
2.1 2.4 13
2.4 2.7 1
2.7 3.0 1

我想我必须运行这个 2x，一个带有 delta让我们说 0.3另一个是 delta -0.3 ，并把这两个猫放在一起。
但我不确定这种直觉是否正确。

Answer 1

这可能对你有用:

BEGIN { delta = (delta == "" ? 0.1 : delta) }
{
    bucketNr = int(($0<0?$0-delta:$0)/delta)
    cnt[bucketNr]++
    maxBucket = (maxBucket > bucketNr ? maxBucket : bucketNr)
    minBucket = (minBucket < bucketNr ? minBucket : bucketNr)
}
END {
    beg = minBucket*delta
    for (bucketNr=minBucket; bucketNr<=maxBucket; bucketNr++) {
        end = beg + delta
        printf "%0.1f %0.1f %d\n", beg, end, cnt[bucketNr]
        beg = end
    }
}

它基本上是您发布的代码+处理负数。