Average of multiple time-stamped data every half hour Post: 302920773

Sponsored Content

Top Forums Shell Programming and Scripting Average of multiple time-stamped data every half hour Post 302920773 by terrychen on Sunday 12th of October 2014 06:55:52 PM

10-12-2014

Registered User

Average of multiple time-stamped data every half hour

Hi All,

Thank you for reading through my post and helping me figure out how I would be able to perform this task.

For example: I have a list of continuous output collected into a file in the format as seen below:

Code:

 Date...........Time........C....A......... B
==========================
"2014-10-13 15:45:00",0,-1.92925,-0.529
"2014-10-13 15:45:00.1",1,-2.0245,-0.65
"2014-10-13 15:45:00.2",2,-2.0245,-0.65

The first two values are date and time (in hh:mm:ss:millisecond , every 10ms =1 second), the third value (C) doesnt really matter, and the last two values are the numbers lets say A and B. Could you please suggest me, how I would be able to calculate the average every half an hour. If possible I would like to store the values to another file once the averages are calculated.

For example the average of values A from 15:45:00 to 16:14:59:9

Thank you for your suggestions.

Regards,
Terry

Last edited by vbe; 10-13-2014 at 08:58 AM.. Reason: Clarity

terrychen

View Public Profile for terrychen

Find all posts by terrychen

9 More Discussions You Might Find Interesting

1. Programming

problem deleting date-time stamped file in a directory

I have a number of files of the format filename.xfr_mmddyy_%H%M%S which i get in a specified directory daily. Now i want to search in the specified directory & delete the files which are more than 2 days old .So I use a command find $DIR/backup/* -ctime +2 -exec rm -f {} \; But after executing...

2. HP-UX

calculate average of multiple line data

I have a question as below and i need to write a shell or perl script for this query:My Input file looks like below RNo Marks 12 50 15 70 18 80 12 40 13 55 18 88 13 75...

3. Shell Programming and Scripting

Help in extracting multiple files and taking average at same time

Hi, I have 20 files which have respective 50 lines with different values. I would like to process each line of the 50 lines in these 20 files one at a time and do an average of 3rd field ($3) of these 20 files. This will be output to an output file. Instead of using join to generate whole...

4. Shell Programming and Scripting

calculate the average of time series data using AWK

Hi, I have two time series data (below) merged into a file. t1 and t2 are in unit of second I want to calculate the average of V1 every second and count how many times "1" in V2 is occur within a second Input File: t1 V1 t2 V2 10.000000...

5. AIX

Time getting reduced by 1 hour

I am setting TZ=EST5EDT,M3.2.0/02:00:00,M11.1.0/02:00:00 Then Setting the date to Mar 14 01:40 EST date 0314014010 Sun Mar 14 01:40:36 EDT 2010 Note that it show it EST. According to my TZ variable 01:40 Should be in EST only. On executing date command once again it shows date Sun Mar...

6. Shell Programming and Scripting

Counting average data per hour

Hi i have log like this : Actually i will process the data become Anybody can help me ?

7. UNIX for Dummies Questions & Answers

Load average spikes once an hour

Hi, I am getting a high load average, around 7, once an hour. It last for about 4 minutes and makes things fairly unusable for this time. How do I find out what is using this. Looking at top the only thing running at the time is md5sum. I have looked at the crontab and there is nothing...

8. Shell Programming and Scripting

How to convert 24 hour time to 12 hour timing?

Hi friends, I want to convert 24 hour timing to 12 hour please help me... my data file looks like this.. 13-Nov-2011 13:27:36 15.32044 72.68502 13-Nov-2011 12:08:31 15.31291 72.69807 16-Nov-2011 01:16:54 15.30844 72.74028 15-Nov-2011 20:09:25 15.35096 ...

9. UNIX for Advanced & Expert Users

Want to get average value for each hour

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|...

LEARN ABOUT PHP

uptime

UPTIME(1)							   User Commands							 UPTIME(1)

NAME

       uptime - Tell how long the system has been running.

SYNOPSIS

       uptime [options]

DESCRIPTION

       uptime  gives  a one line display of the following information.	The current time, how long the system has been running, how many users are
       currently logged on, and the system load averages for the past 1, 5, and 15 minutes.

       This is the same information contained in the header line displayed by w(1).

       System load averages is the average number of processes that are either in a runnable or uninterruptable state.	A process  in  a  runnable
       state is either using the CPU or waiting to use the CPU.  A process in uninterruptable state is waiting for some I/O access, eg waiting for
       disk.  The averages are taken over the three time intervals.  Load averages are not normalized for the number of CPUs in  a  system,  so  a
       load average of 1 means a single CPU system is loaded all the time while on a 4 CPU system it means it was idle 75% of the time.

OPTIONS

       -p, --pretty
	      show uptime in pretty format

       -h, --help
	      display this help text

       -s, --since
	      system up since, in yyyy-mm-dd HH:MM:SS format

       -V, --version
	      display version information and exit

FILES

       /var/run/utmp
	      information about who is currently logged on

       /proc  process information

AUTHORS

       uptime was written by Larry Greenfield <greenfie@gauss.rutgers.edu> and Michael K. Johnson <johnsonm@sunsite.unc.edu>

SEE ALSO

       ps(1), top(1), utmp(5), w(1)

REPORTING BUGS

       Please send bug reports to <procps@freelists.org>

procps-ng							   December 2012							 UPTIME(1)