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

weather::com::dayforecast

Weather::Com::DayForecast(3pm)				User Contributed Perl Documentation			    Weather::Com::DayForecast(3pm)

NAME

       Weather::Com::DayForecast - class representing a forecast for one day

SYNOPSIS

	 [...]

	 my @locations = $weather_finder->find('Heidelberg');

	 my $forecast = $locations[0]->forecast();
	 my $tomorrow = $forecast->day(1);

	 print "Forecast for tomorrow:
";
	 print " - tomorrow it's the ", $tomorrow->date()->date(), "
";
	 print " - sunrise will be at ", $tomorrow->sunrise()->time(), "
";
	 print " - maximum temperature will be ", $tomorrow->high(), "
";

DESCRIPTION

       Via Weather::Com::DayForecast objects one can access the weather forecast for one specific day.

       This class will not be updated automatically with each call to one of its methods. You need to call a method of your Weather::Com::Forecast
       object to get updated objects.

CONSTRUCTOR

       You usually would not construct an object of this class yourself.  This is implicitely done when you call the "day(number of day)" or the
       "all()" method of a Weather::Com::Forecast object.

METHODS

       date()

       Returns a Weather::Com::DateTime object containing the date the forecast is for.

       high()

       Returns the maximum temperature that will be reached at daytime.

       For day 0 (today), this will be 'N/A' when it's after noon...

       There is a bug in weather.com's date and time mathematics: If you are asking for a location's forecast day 0 and it's short after midnight,
       day 0 will be "yesterday" and you'll get both, yesterday's daytime forecast and night forecast!

       I have not investigated this issue further, yet. If anyone has, please inform me!

       low()

       Returns the minimum temperature that will be reached at night.

       sunrise()

       Returns a Weather::Com::DateTime object containing the time of sunrise.

       sunset()

       Returns a Weather::Com::DateTime object containing the time of sunset.

       day()

       Returns a Weather::Com::DayPart object with all data belonging to the daytime.

       For day 0 (today), this will be "undef" when it's after noon...

       There is a bug in weather.com's date and time mathematics: If you are asking for a location's forecast day 0 and it's short after midnight,
       day 0 will be "yesterday" and you'll get both, yesterday's daytime forecast and night forecast!

       I have not investigated this issue further, yet. If anyone has, please inform me!

       night()

       Returns a Weather::Com::DayPart object with all data belonging to the night.

AUTHOR

       Thomas Schnuecker, <thomas@schnuecker.de>

COPYRIGHT AND LICENSE

       Copyright (C) 2004-2007 by Thomas Schnuecker

       This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

       The data provided by weather.com and made accessible by this OO interface can be used for free under special terms.  Please have a look at
       the application programming guide of weather.com (<http://www.weather.com/services/xmloap.html>)!

perl v5.8.8							    2007-07-09					    Weather::Com::DayForecast(3pm)
All times are GMT -4. The time now is 08:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy