Search Results

Can you do in with awk script? Thanks!

Phoebe

Hi all,

Does anyone can help me the following question? I would like to write an AWK script.
In the following input file, each number in "start" is paired with numbers in column "end".

...

I have an input file (more than 20K records) as following. The information I'm interested to manipulate are at column 10, 11 and 13.

Column 13: It's item name, item name may appear more than once...

this is a small part in my awk script. the input data is not in file, but it was manipulated in my script.

Could you suggest a code to solve this?

Thanks!

---------- Post updated at 09:38 AM...

Hi,

I would like to do the following sorting, but the output is not what i expected. Why 222 and 2222 are not at the last two elements of array?


awk...

Hi there,

Can someone let me know how to sort the 2 dimensional array below by column 1 then by column 2?

22 55
2222 2230
33 66
44 58
222 240
11 25
22 60
33 45

output:
11 25
22...

Hi all,

I have difficulty to solve the followign problem.

mydata:

StartPoint EndPoint
22 55
2222 2230
33 66
44 58
222 ...

Hi there,

Can someone tell me why the why the element of output is not the same order as the original data?

Below is the value of column 11 of 2nd line,...

What if I want to output the sum of column 3 for each unique value?

baby 36.8
flower 33.6
cake 99.4
fruits 22.3

Thanks!

Hi,

I have problem in writing an awk script.

I would like to find out unique value of column 2.

input:

1 baby 25.6
2 flower 33.6
3 cake 33.4
4 baby 11.2
5 fruits 22.3
6 cake...

I have code below to randomly select number of records (1 line for each record only) from file.
I'm thinking to modify this code in a way like, if the selected random number is 6, which means record...

Hi,

I have a data file with millions of record (N). Each record was saved in 4 lines. So there are total of NX4 lines in the data file.

For Example:

Host1
a
b
c
d
Host2
e
f
g
h...

Hi,

I get correct number of unique "SampleID", but not "SNP". I wonder why it didn't work for "SNP" (column 1).

I used
$ cat abc.csv | cut -f1 -d , | uniq
to get list of unique "SNP", and ...

Hi all,

I have a huge csv file with the following format of data,

[HEADER]
Num SNPs, 549997
Total SNPs,555352
Num Samples, 157
[Data]
SNP, SampleID, Allele1, Allele2
A001,AB1,A,A...