Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Iterate a min/max awk script over time-series temperature data
Top Forums UNIX for Dummies Questions & Answers Iterate a min/max awk script over time-series temperature data Post 302275240 by jim mcnamara on Friday 9th of January 2009 01:37:53 PM
Old 01-09-2009
try something like this:
Code:
awk ' BEGIN {for (i=1; i<32; i++)
             {
             	min[i]=999
             	max[i]=-999
             } 
            }
      {
       	if( $5 < min[$3] ) { min[$3]=$5 }
       	if( $5 > max[$3] ) { max[$3]=$5 }
      }
      END {for(i in min) {if( min[i] < 999 ) {print i, min[i], max[i]} }
      }
     '  weather_01.dat  > 01minmax.dat

 

10 More Discussions You Might Find Interesting

1. 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 Replies)
Discussion started by: nica
5 Replies

2. Shell Programming and Scripting

Count time min/max/average for ping

I am redirecting my ping output to a file. The sample output is like this: 64 bytes from xx.xx.xx.167: icmp_seq=4490 ttl=116 3.75 ms 2011Jul12- 15 40 16 64 bytes from xx.xx.xx.167: icmp_seq=4491 ttl=116 5.29 ms 2011Jul12- 15 40 17 64 bytes from xx.xx.xx.167: icmp_seq=4492 ttl=116 4.88 ms... (6 Replies)
Discussion started by: zorrox
6 Replies

3. Shell Programming and Scripting

Data stream between min and max

Hi, I have a text file containing numbers. There are up to 6 numbers per row and I need to read them, check if they are 0 and if they are not zero check if they are within a given interval (min,max). If they exceed the max or min they should be set to max or min respectively, if they are in the... (4 Replies)
Discussion started by: f_o_555
4 Replies

4. Shell Programming and Scripting

AWK script - extracting min and max values from selected lines

Hi guys! I'm new to scripting and I need to write a script in awk. Here is example of file on which I'm working ATOM 4688 HG1 PRO A 322 18.080 59.680 137.020 1.00 0.00 ATOM 4689 HG2 PRO A 322 18.850 61.220 137.010 1.00 0.00 ATOM 4690 CD ... (18 Replies)
Discussion started by: grincz
18 Replies

5. Programming

Resample time series data with replacement any way to do this in awk or just bash script

I have some time series data that I need to resample or downsample at some specific time intervals. The firs column is time in decimal hours. I am tryiong to resample this data every 3 minutse. So I need a data value ever 0.05. Here is the example data and as you can see, there time slot for 0.1500... (3 Replies)
Discussion started by: malandisa
3 Replies

6. Shell Programming and Scripting

awk script to find min and max value

I need to find the max/min of columns 1 and 2 of a 2 column file what contains the special character ">". I know that this will find the max value of column 1. awk 'BEGIN {max = 0} {if ($1>max) max=$1} END {print max}' input.file But what if I needed to ignore special characters in the... (3 Replies)
Discussion started by: ncwxpanther
3 Replies

7. Shell Programming and Scripting

How to get min and max values using awk?

Hi, I need your kind help to get min and max values from file based on value in $5 . File1 SP12.3 stc 2240806 2240808 + ID1_N003 ID2_N003T0 SP12.3 sto 2241682 2241684 + ID1_N003 ID2_N003T0 SP12.3 XE 2239943 2240011 + ID1_N003 ID2_N003T0 SP12.3 XE 2240077 2241254 + ID1_N003 ... (12 Replies)
Discussion started by: redse171
12 Replies

8. Programming

Php number array from max, min, step size mysql data

I want to create a form with data values in a dropdown list. The values in the dropdown list need to be generated on the fly from max, min and increment values contained in a mysql database. Hopefully this makes sense, I really have no idea where to start :confused: Thanks (6 Replies)
Discussion started by: barrydocks
6 Replies

9. Shell Programming and Scripting

Find min and max time taken from a log file

You have a log file as attached in sample input with various operations and time taken by each of them. Write a script to find the min and max time taken for each operation. Sample output is attached. Sample Input is given as below: operation1,83621 operation2,72321 operation3,13288... (1 Reply)
Discussion started by: Chandan_Bose
1 Replies

10. UNIX for Beginners Questions & Answers

How to count respon time max min avg for nginx logs?

Hi All, need your help, i want count respon time max and average my nginx logs, based on hourly or minutes per api... my nginx.log sample : 10.1.1.1 - - "POST /v2/api/find/outlet/ HTTP/1.1" 200 2667 "-" "okhttp/3.12.0" "118.215.153.47" 0.178 0.178 . 10.1.1.1 - - "POST... (4 Replies)
Discussion started by: fajar_3t3
4 Replies

LEARN ABOUT DEBIAN

lockward

lockward(6x)							XScreenSaver manual						      lockward(6x)

NAME

       lockward - Rotating spinning color-cycling things

SYNOPSIS

       lockward  [-display  displayspec]  [-root]  [-window]  [-visual	arg]  [-window-id  arg]  [-delay usec] [-pair] [-fps] [-blink | -no-blink]
       [-rotateidle-min msec] [-rotateidle-max msec] [-blinkidle-min msec] [-blinkidle-max msec] [-blinkdwell-min msec] [-blinkdwell-max msec]

DESCRIPTION

       lockward draws a spinning, rotating set of notched wheels overlaid with some flashing effects, using OpenGL.  It's a sort of cross  between
       the wards in a combination lock and those old information displays that animated via polarized light.

OPTIONS

       -visual visual
	       Specify which visual to use.  Legal values are the name of a visual class, or the ID number (decimal or hex) of a specific visual.

       -window Draw on a newly-created window (default).

       -root   Draw on the root window.

       -delay microseconds
	       Per-frame delay, in microseconds.  Default: 20000 (50 frames/sec).

       -blink | -no-blink
	       Enables/disables the blinking effects.  Default: Enabled.

       -fps    Display the current frame rate, CPU load, and polygon count.

       -rotateidle-min milliseconds

       -rotateidle-max milliseconds
	       The minimum and maximum time each spinner will sit idle, in milliseconds.  Defaults: Min 1000, max 6000.

       -blinkidle-min milliseconds

       -blinkidle-max milliseconds
	       The minimum and maximum time between blinking effects, in milliseconds.	Defaults: Min 1000, max 9000.

       -blinkdwell-min milliseconds

       -blinkdwell-max milliseconds
	       The minimum and maximum dwell time for the blinking effects, in milliseconds.  This affects how quickly the blinks actually happen.
	       Defaults: Min 100, max 600.

ENVIRONMENT

       DISPLAY Default host and display number.

       XENVIRONMENT
	       Name of a resource file that overrides the global resources stored in the RESOURCE_MANAGER property.

SEE ALSO

       X(1), xscreensaver(1)

AUTHORS

       Leo L. Schwab <ewhac@best.com>

X Version 11							5.15 (28-Sep-2011)						      lockward(6x)
All times are GMT -4. The time now is 09:14 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy