Search Results

Thank you a lot, Scrutinizer and rdrtx1, for ur quick help!!

good day!

Hi all,

I have a data file. It contains one header line followed by a new line which is one row of different characters without separators (charahters can be dots, dash, capital and small...

Thank you all very much for explanations and codes! Very educational and useful!

Dear all,
thank you for quick attempts to solve the sorting!

jim mcnamara (https://www.unix.com/members/32659.html): yes, this sorting literally means moving columns based on values in the first...

Dear all, will be thankful if you can help on sort command.

My data looks like (tab separated; number of columns 2317; N of rows ~200000):

a b c d V10 V2 V8 V4 V7
xx ...

thanks a lot for all your quick help!
best, kush

thank you a lot!!!

Hi, all, I have a file that looks like:

## XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
## YYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYYY ...

vgersh99, thank you very much!

May I ask one more addition to this code? the number of digits in output in the third column is always 6, meaning the bigger number becomes, less decimal digits remain: e.g. when number in third...

one more time, thank a lot to all of u, will work with codes, it takes time for me

thanks guys a lot!

Robin, thanks a lot!
If i get
(standard_in) 1: illegal character: M
(standard_in) 1: illegal character: P

should the code be modified?

yes, sorry, i gave only 'heads' of real input as an example, because both datasets are very long. E.g.
data1 has 61951 lines
data2 has 256895 lines.

If to extract some arbitrary lines, then it...

hi, Robin,
1) ''Are both files sorted numerically according to the first column before we start?''
BP in both datasets are in an ascending order (from smaller to higher numbers).
2) ''Will there...

Dear all, could you help me with following question. There are two datasets (below). I need to find match between BP values from data1 and data2, and add corresponding CM value from data2 into data1....

to pilnet101 (https://www.unix.com/members/302155117.html):

I know, that between dataset1 and dataset2 there are around 60.000 matches between numbers in the first columns. Number of rows in both...

Dear all, could you help with following:
i have two large datasets that contain two columns.
dataset1:
752566 rs3094315
752721 rs3131972
753541 rs2073813
760300 rs11564776
768448 ...

RudiC, thanks a lot!

Makarand Dodmis and Skrynesaver, thank u a lot, both ways worked! (https://www.unix.com/members/302158544.html)

hello!
could u, please, help:
i have a file that includes 6 columns space delimited

1 rs4477212 0 82154 0 T
1 rs6680825 0 91472 0 G
1 rs9326626 0 570178 ...

yes, thank u, Pamu, i cleared for myself the structure of my file and i got why i get such result after running ur code! And i'll utilise ur code.
Thank u very much! (and hope u all have patience...

dear Pamu, thank u for quick reaction! i tried the code, and it removes 80 duplicates, but i know that there are 3544 in total duplicated values in the 2nd and 3rd columns in my file. And may i...

hi!
could u help in the following? I have the data (long list!) that looks like (three coumns white space separated):
rs3094315 0.0665173 742429
rs12562034 0.0738998 758311
rs3934834 0.396449...

thank u a lot, bartus!