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 302275244 by jim mcnamara on Friday 9th of January 2009 01:45:30 PM
Old 01-09-2009
The next logical q -- do it for 12 months - this is a primitive pass at a next step.
Code:
#!/bin/ksh
mkfile()
{
   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]} }
      }
     '  "$1"  >  "$2"
     
}

for i in 01 02 03 04 05 06 07 08 09 10 11 12
do
    infile="weather_"$i".dat"
    outfile=$i"minmax.dat
    mkfile $infile $outfile
done

 

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

volumeselect

volumesel(1Vi)															    volumesel(1Vi)

NAME

       volumesel - select volumes from a volume set

SYNOPSIS

       volumesel  <options> [infile] [outfile]

DESCRIPTION

       volumesel  selects  volumes from a set of volumes according to some given selection criterion. Possible criteria are: size, circularity and
       compactness.

       "Size" refers to be number of voxels belonging to the volume.

       "Circularity" is a measure of roundness defined as:

	 (3.0 * size) / (4.0 * pi * rmax)

       where "rmax" is the radius of the smallest enclosing sphere.  Thus if the volume is a sphere, this value will be "1", The further the  vol-
       ume's shape deviates from spherical shape, the smaller this value will become.

       "Compactness" is defined as the ratio between the number of border voxels and volume size. Thus, if most voxels belonging to the volume are
       interior voxels this value will be close to "1".

       The input image must be of type "volumes". The output image will be also be of type "volumes".

COMMAND LINE OPTIONS

       volumesel accepts the following options:

       -help	      Prints a message describing options.

       -in infile     Specifies the Vista data file containing the first input image.

       -image infile  Specifies the Vista data file containing the second input image.

       -out outfile   Specifies where to write the output images as a Vista data file.

       -feature outfile
		      Specifies the selection criterion. Possible choices are: size | circularity | compactness. Default: size.

       -min min       Specifies the lower bound for the feature value.

       -max max       Specifies the upper bound for the feature value.

       Input and output files can be specified on the command line or allowed to default to the standard input and output streams.

SEE ALSO

       VImage(3Vi), Vista(7Vi)

AUTHOR

       Gabriele Lohmann <lohmann@cns.mpg.de>

Vista Version 2.0						  15 Februar 1994						    volumesel(1Vi)
All times are GMT -4. The time now is 07:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy