Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Average for every day

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Average for every day
# 8  
Old 11-01-2012
Quote:
Originally Posted by ripat
... or a blend of the two solutions:
@Scrutinizer your snippet doesn't seem to return the expected result. At least on my sample file. Or is it me?
And same for your script also - don't give expected result.

I already tried with "\t" and space as delimiter..Smilie

please look..

Code:
awk '{print NF}' FS="[- ]" file
9
9
11
10
11
9

and

Code:
$ awk '{print NF}' FS="[-\t]" file
2
2
2
2
2
2

# 9  
Old 11-01-2012
Try with
Code:
FS="-| +"

Not sure how the fields are separated in the OP's sample file.
# 10  
Old 11-01-2012
Quote:
Originally Posted by ripat
... or a blend of the two solutions:
@Scrutinizer your snippet doesn't seem to return the expected result. At least on my sample file. Or is it me?
Quote:
Originally Posted by pamu
And same for your script also - don't give expected result.

I already tried with "\t" and space as delimiter..Smilie
[..]
The OP stated that the field separator is '\t' , so in order to use the input sample you first need to modify it by replacing any repetition of spaces by a single TAB character...
# 11  
Old 11-01-2012
Oh my bad. I missed that line. ok, even with \t as FS, I can not yield the same result with my snippet and yours. On the attached file

Code:
$ awk -F'[\t-]' 'p!=$1{if(p)print p, a/n, b/n; a=b=n=0; p=$1}{a+=$6; b+=$8; n++} END{print p, a/n, b/n}' file
05/18/12 19.9499 17.0846
05/19/12 15.3993 13.9434
05/02/12 15.9193 14.4067
05/13/12 13.2694 13.171
05/15/12 15.6814 13.6885
05/16/12 19.4222 17.1549
05/18/12 20.1258 17.0612
05/19/12 15.6013 13.9685


Code:
$ awk '{d5[$1]+=$6;d7[$1]+=$8;n[$1]+=1}END{for (d in d5) print d,d5[d]/n[d],d7[d]/n[d]}' FS="[-\t]" ff
05/13/12 13.2694 13.171
05/02/12 15.9193 14.4067
05/18/12 20.0554 17.0706
05/19/12 15.5003 13.9559
05/15/12 15.6814 13.6885
05/16/12 19.4222 17.1549

file.txt (1.1 KB) 
# 12  
Old 11-01-2012
Yes that solution will only work if the time stamps are in the right order, which appears to be the case with the input sample that the OP posted...
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Julian day to dates in YEAR-MONTH-DAY

hello, I have many files called day001, day002, day003 and I want to rename them by day20070101, day20070102, etc. I need to do it for several years and leap years as well. What is the best way to do it ? Thank you. (1 Reply)
Discussion started by: Ggg
1 Replies

2. UNIX for Dummies Questions & Answers

Move the files between Current day & a previous day

Hi All, I have a requirement where I need to first capture the current day & move all the files from a particular directory based on a previous day. i.e move all the files from one directory to another based on current day & a previous day. Here is what I am trying, but it gives me errors.... (2 Replies)
Discussion started by: dsfreddie
2 Replies

3. Shell Programming and Scripting

Script to check if last modified day is previous day

Hi, I would like to write a script that checks if a file ('counter') was modified the previous day, if so erase its contents and write 00000000 into it. For e.g. if the file 'counter' was last modified at 11.30pm on 24th May and the script runs at 12.15am of 25th May, it should erase it's... (1 Reply)
Discussion started by: hegdepras
1 Replies

4. Shell Programming and Scripting

Code creates day 32 instead of 1st day of next month.

I am using the code below modified from a post I saw here regarding having the script write out future dates. The problem is that instead of making 8/1 it makes 7/32! Please help! yy=`date +%Y` mm=`date +%m` dd=`date +%d` echo "Today is : $yy $mm $dd" #!/usr/bin/ksh date '+%m... (5 Replies)
Discussion started by: libertyforall
5 Replies

5. Solaris

May i know the day to day activities of a Solaris system administrator?

Recently i have attended a telephonic interview. As i dont have work experience in solaris i was not able to deliver correct answer for this question. Your answer will help for the people like me who is looking to become Solaris System administrator. (4 Replies)
Discussion started by: Sesha
4 Replies

6. Shell Programming and Scripting

Script to find previous month last day minus one day timestamp

Hi All, I need to find the previous month last day minus one day, using shell script. Can you guys help me to do this. My Requirment is as below: Input for me will be 2000909(YYYYMM) I need the previous months last day minus 1 day timestamp. That is i need 2000908 months last day minus ... (3 Replies)
Discussion started by: girish.raos
3 Replies

7. Solaris

/var size is increasing day by day

Hi experts, I am facing a big problem. i use solaris 9. i found size of /var is increasing day by. snapshot of a yester moring- /dev/vx/dsk/var 15G 14G 1.1G 94% /var snapshot of a yesterday everning- /dev/vx/dsk/var 15G 14G 824M 95% /var I am... (11 Replies)
Discussion started by: thepurple
11 Replies

8. Shell Programming and Scripting

Write a shell script to find whether the first day of the month is a working day

Hi , I am relatively new to unix... Can u pls help me out to find out if the first day of the month is a working day ie from (Monday to Friday)...using Date and If clause in Korn shell.. This is very urgent. Thanks for ur help... (7 Replies)
Discussion started by: phani
7 Replies

9. Shell Programming and Scripting

How to compare prev day file to current day file

Hi all: I am new to this board and UNIX programming so please forgive if I don't explain something correctly. I am trying to write a script to keep track of our links, we link one program written for Client A to Client B's directory. What we want to do is to keep track of our linked programs... (1 Reply)
Discussion started by: Smurtzy
1 Replies
Login or Register to Ask a Question