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 MINIX

mkfile

mkfile(1M)                                                                                                                              mkfile(1M)

NAME

       mkfile - create a file

SYNOPSIS

       mkfile [-nv] size [g | k | b | m]   filename...

       mkfile  creates  one  or  more files that are suitable for use as NFS-mounted swap areas, or as local swap areas. When a root user executes
       mkfile(), the sticky bit is set and the file is padded with zeros by default.   When non-root users execute  mkfile(), they  must  manually
       set the sticky bit using  chmod(1). The default size is in bytes, but it can be flagged as gigabytes, kilobytes, blocks, or megabytes, with
       the g, k, b, or m suffixes, respectively.

       -n       Create an empty filename. The size is noted, but disk blocks are not allocated until data is written to them. Files  created  with
                this option cannot be swapped over local UFS mounts.

       -v       Verbose.  Report the names and sizes of created files.

USAGE

       See largefile(5) for the description of the behavior of mkfile when encountering files greater than or equal to 2 Gbyte ( 2**31 bytes).

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE         |      ATTRIBUTE VALUE        |
       +-----------------------------+-----------------------------+
       |Availability                 |SUNWcsu                      |
       +-----------------------------+-----------------------------+

       chmod(1), swap(1M), attributes(5), largefile(5)

                                                                    2 Feb 2001                                                          mkfile(1M)
All times are GMT -4. The time now is 06:50 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy