01-09-2009
Iterate a min/max awk script over time-series temperature data
I'm trying to iterate a UNIX awk script that returns min/max temperature data for each day from a monthly weather data file (01_weath.dat). The temperature data is held in $5. The temps are reported each minute so each day contains 1440 temperature enteries. The below code has gotten me as far as returning the min/max for the given day I specify e.g. ($3==1)... that is the third column of data holds the day and I've designated it to read the first day in the code below.
I imagine I need to designate a variable (or array) and a for loop so that it will read each day in the month and return a min/max. When its all done correctly the final output file (01minmax.txt) should have the min/max for each day of the month.
awk -F, ' ($1==101 && $3==1) {print}' 01_weath.dat > foo
awk 'BEGIN {FS=","}
min==""{
min=max=$5
}
{
if ($5 > max){max = $5};
if ($5 < min){min = $5};
}
END {print min,max}
' foo > 01minmax.txt
Any help would be greatly appreciated!
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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
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
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
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
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
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
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
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
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
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)