i know this is a stupid question but...can awk do more than print? can i have it assign a value from a file list to a variable in the script? (1 Reply)
Hello. Im just starting to learn awk so hang in there with me...I have a large text file formatted as such everything is in a single column
ID001
value 1
value 2
value....n
ID002
value 1
value 2
value... n
I want to be able to calculate the average for values for each ID from the... (18 Replies)
Dear all,
I have the data in the following format. I want to do average of each NR= 5 (rows) for all the 3 ($1,$2, $3) columns and want to print average result in another file in the same format. I dont know how to write code for this in 'awk', can some one help me to write a code for this in... (1 Reply)
Hi, I only have a very limited understanding and experience with writing code and I was hoping I could get some help.
I have a dataset of two columns (txt format, numbers in each row separated by a tab)
Eg.
1 5
2 5
3 6
4 7
5 6
6 6
7 ... (5 Replies)
A happy Monday to you all,
I have a .csv file which contains data taken every 5 seconds. I want to average these 5 second data points into 30 minute averages!
date co2
25/06/2011 08:04 8.31
25/06/2011 08:04 8.32
25/06/2011 08:04 8.33... (18 Replies)
Hey all,
I have a set of 5-second data as shown below. I need to find an hourly average of this data.
date co2
25/06/2011 08:04:00 8.30
25/06/2011 08:04:05 8.31
25/06/2011 08:04:10 8.32
25/06/2011 08:04:15 8.33
25/06/2011 08:04:20 ... (5 Replies)
Hi all,
I have a data file like below, where Time is in the second column
DATE TIME FRAC_DAYS_SINCE_JAN1
2011-06-25 08:03:20.000 175.33564815
2011-06-25 08:03:25.000 175.33570602... (10 Replies)
Hello all, I need to compute a row-wise average of files with a single column based on the pattern of the filenames. I really appreciate any help on this. it would just be very difficult to do them manually as the rows are mounting to 100,000 lines. the filenames are as below with convention as... (2 Replies)
I have a file of the form.
16:00:26,83.33 16:05:26,83.33 16:10:26,83.33 16:15:26,83.33 16:20:26,90.26 16:25:26,83.33 16:30:26,83.33 17:00:26,83.33 17:05:26,83.33 17:10:26,83.33 17:15:26,83.33 17:20:26,90.26 17:25:26,83.33 17:30:26,83.33
For the timestamp 16:00:00 to 16:55:00, I need to... (5 Replies)
Hi
I use multipath linux command to get LUNs info and find out if any failed.
# multipath -ll >/tmp/mpfail
# cat /tmp/mpfail
multipath.conf line 109, invalid keyword: user_friendly_names
multipath.conf line 153, invalid keyword: user_friendly_names
multipath.conf line 193, invalid... (4 Replies)
Discussion started by: prvnrk
4 Replies
LEARN ABOUT DEBIAN
blockmedian
BLOCKMEDIAN(l) BLOCKMEDIAN(l)
NAME
blockmedian - filter to block average (x,y,z) data by L1 norm.
SYNOPSIS
blockmedian [ xyz[w]file(s) ] -Ix_inc[m|c][/y_inc[m|c]] -Rwest/east/south/north[r] [ -C ] [ -F ] [ -H[nrec] ] [ -L ] [ -Q ] [ -V ] [ -W[io]
] [ -: ] [ -bi[s][n] ] [ -bo[s][n] ]
DESCRIPTION
blockmedian reads arbitrarily located (x,y,z) triples [or optionally weighted quadruples (x,y,z,w)] from standard input [or xyz[w]file(s)]
and writes to standard output a median position and value for every non-empty block in a grid region defined by the -R and -I arguments.
Either blockmean, blockmedian, or blockmode should be used as a pre-processor before running surface to avoid aliasing short wavelengths.
These routines are also generally useful for decimating or averaging (x,y,z) data. You can modify the precision of the output format by
editing the D_FORMAT parameter in your .gmtdefaults file, or you may choose binary input and/or output using single or double precision
storage.
xyz[w]file(s)
3 [or 4] column ASCII file(s) [or binary, see -b] holding (x,y,z[,w]) data values. [w] is an optional weight for the data. If no
file is specified, blockmedian will read from standard input.
-I x_inc [and optionally y_inc] is the grid spacing. Append m to indicate minutes or c to indicate seconds.
-R west, east, south, and north specify the Region of interest. To specify boundaries in degrees and minutes [and seconds], use the
dd:mm[:ss] format. Append r if lower left and upper right map coordinates are given instead of wesn.
OPTIONS -C Use the center of the block as the output location [Default uses the median location (but see -Q)]. -C overrides -Q.
-F Block centers have pixel registration. [Default: grid registration.] (Registrations are defined in GMT Cookbook Appendix B on grid
file formats.) Each block is the locus of points nearest the grid value location. For example, with -R10/15/10/15 and and -I1: with
the -F option 10 <= (x,y) < 11 is one of 25 blocks; without it 9.5 <= (x,y) < 10.5 is one of 36 blocks.
-H Input file(s) has Header record(s). Number of header records can be changed by editing your .gmtdefaults file. If used, GMT default
is 1 header record. Not used with binary data.
-L Indicates that the x column contains longitudes, which may differ from the region in -R by [multiples of] 360 degrees [Default
assumes no periodicity].
-Q (Quicker) Finds median z and (x, y) at that z [Default finds median x, median y, median z].
-V Selects verbose mode, which will send progress reports to stderr [Default runs "silently"].
-W Weighted modifier[s]. Unweighted input and output has 3 columns x,y,z; Weighted i/o has 4 columns x,y,z,w. Weights can be used in
input to construct weighted median values in blocks. Weight sums can be reported in output for later combining several runs, etc.
Use -W for weighted i/o, -Wi for weighted input only, -Wo for weighted output only. [Default uses unweighted i/o]
-: Toggles between (longitude,latitude) and (latitude,longitude) input/output. [Default is (longitude,latitude)]. Applies to geo-
graphic coordinates only.
-bi Selects binary input. Append s for single precision [Default is double]. Append n for the number of columns in the binary file(s).
[Default is 3 (or 4 if -W is set) columns].
-bo Selects binary output. Append s for single precision [Default is double].
EXAMPLES
To find 5 by 5 minute block medians from the double precision binary data in hawaii_b.xyg and output an ASCII table, try
blockmedian hawaii_b.xyg -R198/208/18/25 -I5m -bi3 > hawaii_5x5.xyg
SEE ALSO blockmean(1gmt), blockmode(1gmt), gmt(1gmt), gmtdefaults(1gmt), nearneighbor(1gmt), surface(1gmt), triangulate(1gmt)
1 Jan 2004 BLOCKMEDIAN(l)