Became Hot Network Question

occurred Dec 20, 2019 at 23:31

Title said column 3 but body and input data indicate column 4. Also oxford comma

edited Dec 20, 2019 at 15:47

How to get max, min, and mean from values in column 3?4

I have data structured like this

X 43808504 G 1 ^]. < X 43808505 C 3 . 4 X 43808506 T 8 . ? X 43808507 G 5 . C

I want to get the max (8), min (1), and mean (4.25) from column 4 and write that to a file.

I've been wrestling with sorting and then cutting data away but that seems really inefficient.

Thanks for any help

How to get max, min and mean from values in column 3?

I have data structured like this

X 43808504 G 1 ^]. < X 43808505 C 3 . 4 X 43808506 T 8 . ? X 43808507 G 5 . C

I want to get the max (8), min (1) and mean (4.25) from column 4 and write that to a file.

I've been wrestling with sorting and then cutting data away but that seems really inefficient.

Thanks for any help

I have data structured like this

X 43808504 G 1 ^]. < X 43808505 C 3 . 4 X 43808506 T 8 . ? X 43808507 G 5 . C

I want to get the max (8), min (1), and mean (4.25) from column 4 and write that to a file.

I've been wrestling with sorting and then cutting data away but that seems really inefficient.

Thanks for any help

edited tags

edited Dec 20, 2019 at 15:32

asked Dec 20, 2019 at 15:26

I have data structured like this

X 43808504 G 1 ^]. < X 43808505 C 3 . 4 X 43808506 T 8 . ? X 43808507 G 5 . C

I want to get the max (8), min (1) and mean (4.25) from column 4 and write that to a file.

I've been wrestling with sorting and then cutting data away but that seems really inefficient.

Thanks for any help