I am using a script which does smoothing of the $4 values but I would like to print $2,$3,$5,$6 values intact. My script does not do that and changes all the other columns that need not require change.
Please suggest.
The script that I am using is -
Code:
BEGIN {
m=int((n+1)/2)
}
{L[NR]=$4; sum+=$4}
NR>=m {d[++i]=$1}
NR>n {sum-=L[NR-n]}
NR>=n{
a[++k]=sum/n
}
END {
for (j=1; j<=k; j++)
print d[j],$2,$3,a[j],$5,$6
Thanks
---------- Post updated at 10:22 AM ---------- Previous update was at 10:01 AM ----------
In the future, please show us your entire awk script. The script you showed us is at least missing a closing } and you have not shown us how the awk variable n was set.
If I correctly understand what you're trying to do, maybe this will do what you want:
Code:
awk -v n=5 '
BEGIN { m = int((n + 1) / 2)
}
{ f[o = NR % n] = $1 OFS $2 OFS $3 OFS
d[o] = $4
l[o] = OFS $5 OFS $6
}
NR >= n {
for(c = i = 0; i < n; i++)
c += d[i]
c /= n
i = (NR - m + 1) % n
printf("%s%.5f%s\n", f[i], c, l[i])
}' file
If you want to try this on a Solaris/SunOS system, change awk to /usr/xpg4/bin/awk or nawk.
With the sample input you provided, the above script produces the output:
How to calculate percentage non zero value occurrence base on value col 1 and 2
2017 a 0
2017 a 2
2017 a 4
2017 a 2
2017 a 0
2017 b 2
2017 b 6
2016 a 2
2016 a 2
2016 b 2
2016 b 8
2016 b 0
2016 b 0
2016 c 2
2016 c 2
2016 c 0
i manage to get average
# awk '{A++;B+=$3}END{for(X in... (1 Reply)
I want to get CPU average value only (not required user CPU & memory) with each hours on individual date. The sample output is below
| | | User |Memory| User |
Date | Time |CPU %|CPU % | % |Mem % |
03/02/2015|00:00:00| 24.56| 20.66| 89.75| 63.48|... (13 Replies)
Can some one help me related to .sql file issue.
I have a .sqlfile and tried to read the file thru unix. In the .sqlfile I have error rows as well and when error comes I dont want to proceed further and need to roll back all the transactions.
sample .sql file below
insert into
test... (2 Replies)
I am writing a software product and hope that it will work on a variety of Linux distributions. At the moment, I am trying to create some kind of Linux version of patches/upgrades of installed software. Gathering information on available updates isn't hard, nor is installation of updates, but I... (27 Replies)
Hi,
I'm thinking of running a script via cron (every hour) to do the log rolling.
The file is "file.txt" and there going to be 10 files rolling (file.txt.n).
The file is being written constantly by an application.
The script will do the following:
1. cat file.txt > file.txt.0
2. cat... (0 Replies)
Hi Friends,
Can any one help me with count average of student marks in this file (i can not change structure of the input file):
input file:
1 - student ID
2 - student name
3 - group ID
4 - teacher ID
5 - marks (numbers of marks are different)
1:John Smith:2:3:2 3 4 5
2:Mark... (1 Reply)
If I have a file like this, could anyone please guide me how to find the average value in each metrix. The file has got about 130,000 metrixs.
Grid-ref= 142, 235
178 182 203 240 273 295 289 293 283 262 201 176
167 187 187 246 260 282 299 312 293 276 230 191
169 ... (2 Replies)
Hi all,
Have a small problem.
Back in October the pervious sys-admin (of a client's company) made the necessary adjustments to the system clock for daylight savings (Sydney time - +11 GMT).
As far as I can gather, they just amended the time - NO TIMEZONE !?!
Is there an effective and safe... (5 Replies)
07-24-2015
