sorting - How to find the X lowest values in a list with bash/awk? -

-

ok problem is, have list n given lines, this:

4.96035894  2.94014535  9.71651378 on 8.37470259  9.08139103 10.23145322 off 5.73085411  4.21656546  9.98718707 on 6.40892867  9.44195654  8.83707549 on 4.26065784  3.74966832  7.89520829 on 8.89601431  9.84208918  9.63054539 on 9.10538764  8.58408119 10.87454882 on 6.21494725  4.61164407  9.08378204 off 7.62256424  9.59449339 10.84506558 off 6.49210768  4.03768151 10.75221925 off 5.04079861  4.99362253 10.34349177 off ...

the objective find x (x < n) lines lowest value in third field (it extended given field, let's focus on third) , change fourth field (which string) on/off depending of argument called user, i.e. if argument on change on , if off change off.

in above example if instance wanted change off 3 rows lowest third value, output be:

4.96035894  2.94014535  9.71651378 on 8.37470259  9.08139103 10.23145322 off 5.73085411  4.21656546  9.98718707 on 6.40892867  9.44195654  8.83707549 off // row changed 4.26065784  3.74966832  7.89520829 off // row changed 8.89601431  9.84208918  9.63054539 on 9.10538764  8.58408119 10.87454882 on 6.21494725  4.61164407  9.08378204 off // row changed 7.62256424  9.59449339 10.84506558 off 6.49210768  4.03768151 10.75221925 off 5.04079861  4.99362253 10.34349177 off ...

i think specific case of x=1, lowest-value row, don't know how extend arbitrary x. maybe x-sized array filling , being edited while going through list?

interesting problem, need clever arrays this:

begin {     if (!x)                           # if x wasn't set using -v default 3         x=3     if (!field)                       # if field wasn't set using -v default 3         field=3 } {     lines[nr]=$0                                    # store each line in array     sort[nr]=$field                                 # store field in array     field_a[$field]=$0                              # line lookup on field  } end{     asort(sort)                                     # sort fields        (j=1;j<=nr;j++) {                           # every line in file         for(i=1;i<=x;i++) {                         # top x values             if (lines[j] == field_a[sort[i]]) {     # if current line in top x                 sub(/on/,"off",lines[j])            # subsitution                 break                               # grab next line             }         }         print lines[j]                              # print line     } }

save file such script.awk , run like:

$ awk -f script.awk file 4.96035894  2.94014535  9.71651378 on 8.37470259  9.08139103 10.23145322 off 5.73085411  4.21656546  9.98718707 on 6.40892867  9.44195654  8.83707549 off 4.26065784  3.74966832  7.89520829 off 8.89601431  9.84208918  9.63054539 on 9.10538764  8.58408119 10.87454882 on 6.21494725  4.61164407  9.08378204 off 7.62256424  9.59449339 10.84506558 off 6.49210768  4.03768151 10.75221925 off 5.04079861  4.99362253 10.34349177 off

by default turns off lowest 3 values in field 3 can specify both field , number of values using -v option. instances lets turn off lowest 10 values in field 3 leaving maximum value turned on:

$ awk -v x=10 -f script.awk file 4.96035894  2.94014535  9.71651378 off 8.37470259  9.08139103 10.23145322 off 5.73085411  4.21656546  9.98718707 off 6.40892867  9.44195654  8.83707549 off 4.26065784  3.74966832  7.89520829 off 8.89601431  9.84208918  9.63054539 off 9.10538764  8.58408119 10.87454882 on 6.21494725  4.61164407  9.08378204 off 7.62256424  9.59449339 10.84506558 off 6.49210768  4.03768151 10.75221925 off 5.04079861  4.99362253 10.34349177 off

how maximum field 2:

$ awk -v x=10 -v field=2 -f script.awk file 4.96035894  2.94014535  9.71651378 off 8.37470259  9.08139103 10.23145322 off 5.73085411  4.21656546  9.98718707 off 6.40892867  9.44195654  8.83707549 off 4.26065784  3.74966832  7.89520829 off 8.89601431  9.84208918  9.63054539 on 9.10538764  8.58408119 10.87454882 off 6.21494725  4.61164407  9.08378204 off 7.62256424  9.59449339 10.84506558 off 6.49210768  4.03768151 10.75221925 off 5.04079861  4.99362253 10.34349177 off

note: use of asort() function requires gnu awk.


Comments

Post a Comment

Popular posts from this blog

Perl - how to grep a block of text from a file -

-
it can in xml or text format. how in general grep block of text in perl? <track type="ws"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>0</locationindex> <propertyindex>0</propertyindex> </range> </track> <track type="ps" id="1"> <range> <rangestart>0</rangestart> <rangeend>146.912</rangeend> <locationindex>1</locationindex> <propertyindex>1</propertyindex> </range> </track> i want grep type="ps" , till </range> . one solution open file, read line line , match block. open(fh, "file.txt"); foreach $line (<fh>) { if ($line =~ m/type="cc"(.*?)<\/range>/) { print $1; } } but there more optimal solution without reading file line l
Read more

delphi - How to remove all the grips on a coolbar if I have several coolbands? -

-
Image
if set mycoolbar.fixedorder true,only grip on first band hidden. well,if use delphi 7 create vcl forms application,then put coolbar on , create 3 coolbans hold other controls,only grip , top coolbands can hidden setting mycoolbar.fixedorder:=true. i've uploaded picture make things clear. you got fixedorder property wrong. fixed property not allow bands rearranged if set true . setting property of coolbar true keep user changing bands order @ runtime, user can still move , resize bands. can give advice can do, actual solution problem, well, have wait answer. my advice use 3 coolbars in row , setting "fixedorder" property true , bandborderstyle bsnone . way grip hidden on of them. about property, it's not bug of ide, actual preference of property.
Read more

javascript - Animating array of divs; only the final element is modified -

-
this baffling me @ moment. i'm experienced programmer looking throw bit of surprise fiancee on countdown page our wedding. desired effect simulated confetti falling behind main page. setup follows: i have array of divs in javascript. each div absolutely positioned on page. have interval set updates every 50 or milliseconds. on each tick, run loop on array of divs, , calculations , update positions. problem problem having, however, though can see divs created, stored array, , modified (in case, each has slight randomized rotation) during initialization phase, once tick update position starts, div stored in whatever last slot of array gets position updated. tried hard-coding each div index testing purposes, strictly last element update position. upon printing current "left" , "top" style values each div before , after calculations shows value has been changed, no visible change noticeable. here's basic code: javascript var container;
Read more