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

vend::ship::postal

Vend::Ship::Postal(3pm) 				User Contributed Perl Documentation				   Vend::Ship::Postal(3pm)

NAME

       Vend::Ship::Postal -- Calculate US Postal service international rates

SYNOPSIS

	(in catalog.cfg)

	   Database   usps	       ship/usps.txt		  TAB
	   Database   air_pp	       ship/air_pp.txt		  TAB
	   Database   surf_pp	       ship/surf_pp.txt 	  TAB

	(in shipping.asc)

	   air_pp: US Postal Air Parcel
	       crit	       weight
	       min	       0
	       max	       0
	       cost	       e No shipping needed!
	       at_least        4
	       adder	       1
	       aggregate       70
	       table	       air_pp

	       min	       0
	       max	       1000
	       cost	       s Postal

	       min	       70
	       max	       9999999
	       cost	       e Too heavy for Air Parcel

	   surf_pp:    US Postal Surface Parcel
	       crit	       weight
	       min	       0
	       max	       0
	       cost	       e No shipping needed!
	       at_least        4
	       adder	       1
	       aggregate       70
	       table	       surf_pp

	       min	       0
	       max	       1000
	       cost	       s Postal

	       min	       70
	       max	       9999999
	       cost	       e Too heavy for Postal Parcel

DESCRIPTION

       Looks up a service zone by country in the "usps" table, then looks in the appropriate rate table for a price by that zone.

       Can aggregate shipments greater than 70 pounds by assuming you will ship multiple 70-pound packages (plus one package with the remainder).

perl v5.14.2							    2010-03-25						   Vend::Ship::Postal(3pm)
All times are GMT -4. The time now is 01:15 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy