Revisions to How to calculate the average number of columns across the rows as well as the maximum numbers of columns in a file in unix?

added 11 characters in body

Source Link

edited May 25, 2017 at 15:01

355.8k
42
735
1.1k

$ awk 'NF > m { m = NF } { s += NF } END { printf("Max = %d\nAvg = %g\n", m, s/NR) }' data.in
Max = 9
Avg = 3.33333

The awk script will keep track of the maximum number of fields (columns) in m and the sum of the number of fields in s. AtWhen reaching the end of the input stream, it will output the stats collected.

The number of fields in the current record (line) is NF, and the number of records read so far is NR.

The following version will also keep track of the record with the most number of fields:

awk 'NF > m { m = NF; r = NR } { s += NF } END { printf("Max = %d (%d)\nAvg = %g\n", m, r, s/NR) }' data.in
Max = 9 (6)
Avg = 3.33333

$ awk 'NF > m { m = NF } { s += NF } END { printf("Max = %d\nAvg = %g\n", m, s/NR) }' data.in
Max = 9
Avg = 3.33333

The awk script will keep track of the maximum number of fields (columns) in m and the sum of the number of fields in s. At the end of input stream, it will output the stats collected.

The number of fields in the current record (line) is NF, and the number of records read so far is NR.

The following version will also keep track of the record with the most number of fields:

awk 'NF > m { m = NF; r = NR } { s += NF } END { printf("Max = %d (%d)\nAvg = %g\n", m, r, s/NR) }' data.in
Max = 9 (6)
Avg = 3.33333

$ awk 'NF > m { m = NF } { s += NF } END { printf("Max = %d\nAvg = %g\n", m, s/NR) }' data.in
Max = 9
Avg = 3.33333

The awk script will keep track of the maximum number of fields (columns) in m and the sum of the number of fields in s. When reaching the end of the input stream, it will output the stats collected.

The number of fields in the current record (line) is NF, and the number of records read so far is NR.

The following version will also keep track of the record with the most number of fields:

awk 'NF > m { m = NF; r = NR } { s += NF } END { printf("Max = %d (%d)\nAvg = %g\n", m, r, s/NR) }' data.in
Max = 9 (6)
Avg = 3.33333

deleted 8 characters in body

Source Link

edited May 25, 2017 at 14:59

Kusalananda ♦

355.8k
42
735
1.1k

$ awk '{ m'NF => NFm >{ m ?= NF :} m;{ s += NF } END { printf("Max = %d\nAvg = %g\n", m, s/NR) }' data.in
Max = 9
Avg = 3.33333

The awk script will keep track of the maximum number of fields (columns) in m and the sum of the number of fields in s. At the end of input stream, it will output the stats collected.

The number of fields in the current record (line) is NF, and the number of records read so far is NR.

The following version will also keep track of the record with the most number of fields:

awk '{ if (NF'NF > m) { m = NF; r = NR } { s += NF } END { printf("Max = %d (%d)\nAvg = %g\n", m, r, s/NR) }' data.in
Max = 9 (6)
Avg = 3.33333

$ awk '{ m = NF > m ? NF : m; s += NF } END { printf("Max = %d\nAvg = %g\n", m, s/NR) }' data.in
Max = 9
Avg = 3.33333

The awk script will keep track of the maximum number of fields (columns) in m and the sum of the number of fields in s. At the end of input stream, it will output the stats collected.

The number of fields in the current record (line) is NF, and the number of records read so far is NR.

The following version will also keep track of the record with the most number of fields:

awk '{ if (NF > m) { m = NF; r = NR } s += NF } END { printf("Max = %d (%d)\nAvg = %g\n", m, r, s/NR) }' data.in
Max = 9 (6)
Avg = 3.33333

$ awk 'NF > m { m = NF } { s += NF } END { printf("Max = %d\nAvg = %g\n", m, s/NR) }' data.in
Max = 9
Avg = 3.33333

The awk script will keep track of the maximum number of fields (columns) in m and the sum of the number of fields in s. At the end of input stream, it will output the stats collected.

The number of fields in the current record (line) is NF, and the number of records read so far is NR.

The following version will also keep track of the record with the most number of fields:

awk 'NF > m { m = NF; r = NR } { s += NF } END { printf("Max = %d (%d)\nAvg = %g\n", m, r, s/NR) }' data.in
Max = 9 (6)
Avg = 3.33333

Source Link

answered May 25, 2017 at 14:52

Kusalananda ♦

355.8k
42
735
1.1k

$ awk '{ m = NF > m ? NF : m; s += NF } END { printf("Max = %d\nAvg = %g\n", m, s/NR) }' data.in
Max = 9
Avg = 3.33333

The awk script will keep track of the maximum number of fields (columns) in m and the sum of the number of fields in s. At the end of input stream, it will output the stats collected.

The number of fields in the current record (line) is NF, and the number of records read so far is NR.

The following version will also keep track of the record with the most number of fields:

awk '{ if (NF > m) { m = NF; r = NR } s += NF } END { printf("Max = %d (%d)\nAvg = %g\n", m, r, s/NR) }' data.in
Max = 9 (6)
Avg = 3.33333

Stack Exchange Network

Return to Answer