Remove duplicate based on condition awk/bash -

-

i remove duplicates dataset has 3 columns

a       0   3238 b       0   3367 c       0   3130 d       1   3130

i need remove lines contain duplicate values in third column, preferentially keeping value '1' in second column. know how remove duplicates using awk, can't work out how add in conditional statment.

thanks

give line try:

awk '{if($3 in a)a[$3]=$2==1?$0:a[$3];else a[$3]=$0}end{for(i in a)print a[i]}' file

Comments

Post a Comment

Popular posts from this blog

c++ - Linked List error when inserting for the last time -

-
so have part of code here this loop 5 times (max = 5) insert word link list. for ( int = 0 ; < max ; i++ ) { string alphabet = g->returnalphabets(); l[i]->addwords(alphabet[i]); } and have insert word part here string line; fstream myfile ("words.txt"); while (!myfile.eof()) { getline(myfile,line); if ( alphabet == line[0] ) { listnode *newnode = new listnode; if ( head == null ) { newnode->item = alphabet; newnode->next = null; head = newnode; } else { newnode->item = line; prev = cur; prev->next = newnode; } cur = newnode; } } myfile.close(); my problem gives me error on last loop. meaning on max = 4, insert node. rest of loop fine. when decrease max 4 meaning loop 4 times, program error-free when program loops 5 times gives error. anyone can poin...
Read more

c++ - Issues with OpenGL referencing when compiling in Ubuntu terminal -

-
i working on compiling directory of c++ files , headers. thought installed opengl, glut , glew keep getting referencing errors when running it. here doing , errors compiler sending me: user@linux-machine:~/documents/hw$ make g++ -g framework.o poly_line.o shader_program.o circle.o controller.o main.o scene.o view.o -lglew -lglut -lglu -o hw framework.cpp:84: error: undefined reference 'glgeterror' check_gl.h:30: error: undefined reference 'glgeterror' check_gl.h:43: error: undefined reference 'glgeterror' poly_line.cpp:23: error: undefined reference 'glgenbuffers' poly_line.cpp:28: error: undefined reference 'glbindbuffer' poly_line.cpp:29: error: undefined reference 'glbufferdata' poly_line.cpp:54: error: undefined reference 'glenable' poly_line.cpp:55: error: undefined reference 'glenable' poly_line.cpp:56: error: undefined reference 'glblendfunc' poly_line.cpp:57: error: undefined reference 'glhint...
Read more

Using Angularjs $http in browser console -

-
i've testing angularjs services in browser console during development quick verification. way inject service console describe in this question or var $inj = angular.injector(['myapp']); var serv = $inj.get('myservice'); serv.dosomething(); that working angularjs 1.0.7. however, after upgrading 1.1.5, doesn't work anymore services uses $http service, no xhr sent. i've tested injecting $http directly, doesn't work. angularjs changelog seems have no record on issue. may know what's problem here? update: it seems angularjs 1.0.7 uncompressed version doesn't work well. tested working version angularjs 1.0.7 minified. it works uncompressed also. $http = angular.element(document.body).injector().get('$http'); then $http.get(...) // or post or whatever
Read more