shell - Bash group by on the basis of n number of columns -


this related previous question [asked] (bash command group count)

what if want generalize this? instance input file 

 abc|1|2  abc|3|4  bcd|7|2  abc|5|6  bcd|3|5

the output should be

 abc|9|12  bcd|10|7

the result calculated group first column , adding values of 2nd column, , 3rd column, similar group command in sql.

i tried modifying command provided in link failed. don't know whether i'm making conceptual error or silly mistake know none of mentioned commands aren't working.

command used

awk -f "|" '{arr[$1]+=$2} end arr2[$1]+=$5 end  {for (i in arr) {print i"|"arr[i]"|"arr2[i]}}' sample awk -f "|" '{arr[$1]+=$2} end {arr2[$1]+=$5} end  {for (i in arr) {print i"|"arr[i]"|"arr2[i]}}' sample  awk -f "|" '{arr[$1]+=$2 arr2[$1]+=$5} end  {for (i in arr2) {print i"|"arr[i]"|"arr2[i]}}' sample

additionally, if i'm trying here limit use summing columns upto 2 only. if there n columns , want perform operations such addition in 1 column , subtraction in other? how can further modified?

example

abc|1|2|4|......... upto n columns abc|4|5|6|......... upto n columns def|1|4|6|......... upto n columns

lets if sum needed first column, average may second column, other operation third column, etc. how can tackled?

for 3 fields (key , 2 data fields):

$ awk ' begin { fs=ofs="|" }      # set separators {      a[$1]+=$2             # sum second field hash     b[$1]+=$3             # ... b hash } end {                     # in end     for(i in a)           # loop         print i,a[i],b[i] # , output }' file bcd|10|7 abc|9|12

more generic solution n columns using gnu awk:

$ awk ' begin { fs=ofs="|" } {     for(i=2;i<=nf;i++)                    # loop data fields         a[$1][i]+=$i                      # sum them related cells     a[$1][1]=i                            # set field count first cell } end {     for(i in a) {         for((j=2)&&b="";j<a[i][1];j++)    # buffer output             b=b (b==""?"":ofs)a[i][j]         print i,b                         # output     } }' file bcd|10|7 abc|9|12

latter tested 2 fields (busy @ meeting :).


Comments

Post a Comment

Popular posts from this blog

Is there a better way to structure post methods in Class Based Views -

i'm using class based views in django , never specify url in ajax calls , omit action parameter in form because know these requests go through post method of class based view. notice view - profile page make many requests depending on user updating on page - post method become convoluted , if/else mess example: def post(self, request, *args, **kwargs): # handle user changing available date if request.post.get('availabledate') != none: self.updateavailabledate(request) return jsonresponse({'result':'success'}) if request.post.get('newprojectname') != none: creative_user = creativeuserprofile.objects.get(id = request.user.id) project = project.create_project(creative_user, request.post['newprojectname']) project.save() return jsonresponse({'projectid': project.id }) if request.post.get('projectimage') != none , request.files['file']: proj
Read more

performance - Why is XCHG reg, reg a 3 micro-op instruction on modern Intel architectures? -

i'm doing micro-optimization on performance critical part of code , came across sequence of instructions (in at&t syntax): add %rax, %rbx mov %rdx, %rax mov %rbx, %rdx i thought had use case xchg allow me shave instruction , write: add %rbx, %rax xchg %rax, %rdx however, dimay found agner fog's instruction tables , xchg 3 micro-op instruction 2 cycle latency on sandy bridge, ivy bridge, broadwell, haswell , skylake. 3 whole micro-ops , 2 cycles of latency! 3 micro-ops throws off 4-1-1-1 cadence , 2 cycle latency makes worse original in best case since last 2 instructions in original might execute in parallel. now... cpu might breaking instruction micro-ops equivalent to: mov %rax, %tmp mov %rdx, %rax mov %tmp, %rdx where tmp anonymous internal register , suppose last 2 micro-ops run in parallel latency 2 cycles. given register renaming occurs on these micro-architectures, though, doesn't make sense me done way. why wouldn't register renamer
Read more

jquery - Responsive Navbar with Sub Navbar -

good day, forgive me nav vocabulary not best. if question confusing apologize. i'm working on navigation bar needs centered on page @ 768px , above. items in nav open (or perhaps toggle) subnav lives directly below. these nav should appear centered on page. i have been able work through responsive portion of nav bar, having main items align vertically , sub nav menu of each item roll out below, , gave them indent separation. working well. however, issue not responsive side, behavior @ width greater 768px. happens toggling menu's sub navigation pushes other main items down page below sub nav. here's code: $(document).ready(function () { //stick in fixed 100% height behind navbar don't wrap $('#slide-nav.navbar-inverse').after($('<div class="inverse" id="navbar-height-col"></div>')); $('#slide-nav.navbar-default').after($('<div id="navbar-height-col"></d
Read more