arrays - Gawk distinct and sum column -

-

i new linux , usage of awk , couldn't find answer following question:

i want use awk , file structured that:

date id size 2016-11-09 688 47 2016-11-09 688 56 2016-11-09 31640 55

now want sum size each line has date , id , export .csv file. file should that:

date,id,size 2016-11-09,688,103 2016-11-09,31640 55

i need help, because not figure out how on own, thank you.

if input sorted date , id in sample should use this:

$ cat tst.awk begin { ofs="," } nr==1 { $1=$1; print; next } { curr = $1 ofs $2 } (curr != prev) && (nr > 2) { print prev, sum; sum=0 } { prev = curr; sum += $3 } end { print prev, sum }  $ awk -f tst.awk file date,id,size 2016-11-09,688,103 2016-11-09,31640,55

rather saving whole file in memory. note approach produce output in same order input whereas for .. in .. loop in end section print output in random (hash) order.


Comments

Post a Comment

Popular posts from this blog

javascript - React Maximum Callstack when adding component -

-
i have list component getting information local json file if following works expected. import react 'react'; import casestudies './case-studies.json'; import casestudyitem './case-study-list'; const casestudylist = () => { const casestudyitems = casestudies.map( casestudy => { console.log(casestudy); return ( <div key={casestudy.name}>{casestudy.name}</div> ); }); return ( <ul> {casestudyitems} </ul> ); } export default casestudylist; the expected number of case studies printed out no problem. if replace div inside of casestudies.map statement following <casestudyitem key={casestudy.id} casestudy={casestudy} /> i "maximum callstack size exceed error" if add log statement in there shows spitting out hundred , hundreds of items. cause this? in case needed here casestudyitem component, blank testing purposes. import
Read more

javascript - Uncaught FirebaseError: Messaging: This method is available in a Window context -

-
i'm using firebase service worker web push notification. currently, facing error: uncaught firebaseerror: messaging: method available in window context. (messaging/only-available-in-window). i using website on desktop register sw. how resolve issue? error stack i'm getting in console. browsererrormessage: "failed register serviceworker: serviceworker script evaluation failed" code :"messaging/failed-serviceworker-registration" message :"messaging: unable register default service worker. failed register serviceworker: serviceworker script evaluation failed (messaging/failed-serviceworker-registration)." stack: "firebaseerror: messaging: unable register default service worker. failed register serviceworker: serviceworker script evaluation failed (messaging/failed-serviceworker-registration).↵ @ https://www.gstatic.com/firebasejs/3.7.0/firebase.js:555:225" __proto__: error thank you this method should there in main
Read more

correlation - Autocorrelation in Matlab WITHOUT xcorr -

-
so i'm expected make autocorrelation of multiple signals (in order see difference of power spectrum it's irrelevant) note: don't want other way resolve exercise explanation problem :) the signals periodic , data length multiple of period. the problem don't same answer xcorr function of matlab. i'm using classic (i think) r_x(lag) = sum(k=-inf +inf) of x(k)*x(k-lag). when searching answer found other method 1 used using basically: ifft(fft().*conj(fft())) if understood correctly taking inverse fourier transform of periodigram equivalent power spectrum, fourier transform of autocorrelation. don't know why "classic" way doesn't work.. can please explain why/if code wrong? if don't want run code can go directly % ! autocorrelation! code: % making prbs y, of period 2^size(a,1) -1 , span [-lambda,lambda] = [ 1 0 0 0 0 1;... 1 0 0 0 0 0;... 0 1 0 0 0 0;... 0 0 1 0 0 0;... 0 0 0 1 0 0;... 0 0 0 0 1 0]; c = [
Read more