mulder4786 has asked for the wisdom of the Perl Monks concerning the following question:
And file 2 has 10,002 fields and many rows and looks like:1 19002930 0.74 1 19002931 -0.12
I would like to compare each field starting with field 3 from file 2, to field 3 in file 1. If fields 1 and 2 in files 1 and 2 match, and If the value in file 2 is greater than or equal to field 3 from file 1, I would like to push that value onto an array. The output would look like:1 19002930 0.84 0.12 0.94 ... 1 19002931 0 -.20 .12 ...
I have an R script that does this, but R takes way too long. Would someone be able to help me out?1 19002930 0.84 0.94 ... 1 19002931 0 .12
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: extract values from file if greater than value
by Cristoforo (Curate) on Jun 15, 2016 at 18:18 UTC | |
by Marshall (Canon) on Jun 16, 2016 at 04:23 UTC | |
|
Re: extract values from file if greater than value
by mulder4786 (Novice) on Jun 15, 2016 at 16:22 UTC | |
|
Re: extract values from file if greater than value
by Anonymous Monk on Jun 15, 2016 at 17:14 UTC | |
by mulder4786 (Novice) on Jun 15, 2016 at 18:25 UTC | |
by Marshall (Canon) on Jun 16, 2016 at 03:26 UTC | |
|
Re: extract values from file if greater than value
by Marshall (Canon) on Jun 15, 2016 at 17:57 UTC | |
by mulder4786 (Novice) on Jun 15, 2016 at 18:28 UTC | |
by Marshall (Canon) on Jun 15, 2016 at 19:43 UTC |