because there is a pair of SDS and next line of peon
so the calculation is subtract 3rd column of row starting with SDS with 2nd column of row starting with peon.
Dears,
I have a list as follows,
2
4
8
If I want to find the difference between two consecutive rows. Then I have to store the specific rows in two variables and then find the difference. Could someone tell how this can be done.
Regards, (7 Replies)
Hi,
I have a file in the following format
a1 b1 c1 d1
a2 b2 c2 d2
a3 b3 c3 d3
a4 b4 c4 d4
I need a script to find the difference between corresponding values of successive rows. So the output would have one less row than the input file and should look like:
a2-a1 b2-b1 c2-c1 d2-d1... (4 Replies)
Hi All,
I have a huge (and its really huge!) matrix about 400GB in size (2 million rows by 1.5 million columns) . I am trying to optimize its space by creating a sparse representation of it.
Miniature version of the matrix looks like this (matrix.mtx):
3.4543 65.7876 54.564
2.12344... (4 Replies)
Hello,
I want to extract several columns and rows from a huge tab delimited file
for example: I want to print from from column 3 to 68 till row number 30.
I have tried using cut command but it was extracting whole 3rd and 68th column.
Please suggest a solution.
Ryan (8 Replies)
Hi Friends,
I have come across some files where some of the columns don not have data.
Key, Data1,Data2,Data3,Data4,Data5
A,5,6,,10,,
A,3,4,,3,,
B,1,,4,5,,
B,2,,3,4,,
If we see the above data on Data5 column do not have any row got filled. So remove only that column(Here Data5) and... (4 Replies)
I have a file that has multiple lines, of grouped data, that typically all have the same values in the 1st field, however, I would like to search the 1st field for any differences and set a flag to use in an "if" statement to run some other routine.
An example of the typical file is below,... (2 Replies)
Hi all, I know this sounds suspiciously like a homework course; but, it is not.
My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I... (6 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Hallo,
I would need to extract only rows which has different value in the second and third column.
Thank you very much for any advices
Input:
A 0 0
B 0 1
C 1 1
D 1 3
Output
B 0 1
D 1 3 (4 Replies)
16:45:51 10051 77845
16:45:51 10051 77845
16:46:52 10051 77846
16:46:53 10051 77846
Match the last PID then subtract second line time with first line.
Please help me with any command or script.
working in media company on a project OS: RHEl7
tried command:
awk 'function... (2 Replies)
Discussion started by: vivekn
2 Replies
LEARN ABOUT DEBIAN
grd2xyz
GRD2XYZ(l) GRD2XYZ(l)
NAME
grd2xyz - Converting a grdfile to an ASCII or binary table
SYNOPSIS
grd2xyz grdfile [ -H[nrec] ] [ -L ] [ -Rwest/east/south/north[r] [ -S[r ] [ -V ] [ -Z[flags] ] [ -bo[s][n] ]
DESCRIPTION
grd2xyz reads a binary 2-D grdfile and writes out xyz-triplets in ASCII [or binary] format to standard output. Modify the precision of the
ASCII output format by editing the D_FORMAT parameter in your .gmtdefaults file, or choose binary output using single or double precision
storage. As an option you may output z-values without the (x,y) in a number of formats, see -Z below.
grdfile
The 2-D binary file to be converted.
OPTIONS -H Output 1 header record based on information in the grdfile header. Ignored if binary output is selected. [Default is no header].
-L Indicates that the x values are longitudes (necessary for -: to work).
-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.
-S Suppress output for nodes whose z-value equals NaN [Default outputs all nodes]. Append r to reverse the suppression, i.e., only
output the nodes whose z-value equals NaN.
-V Selects verbose mode, which will send progress reports to stderr [Default runs "silently"].
-Z Write a 1-column ASCII [or binary] table. Output will be organized according to the specified ordering convention contained in
flags. If data should be written by rows, make flags start with T(op) if first row is y = ymax or B(ottom) if first row is y =
ymin. Then, append L or R to indicate that first element should start at left or right end of row. Likewise for column formats:
start with L or R to position first column, and then append T or B to position first element in a row. For gridline registered
grids: If grid is periodic in x but the outcoming data should not contain the (redundant) column at x = xmax, append x. For grid
periodic in y, skip writing the redundant row at y = ymax by appending y. If the byte-order needs to be swapped, append w. Select
one of several data types (all binary except a):
a ASCII representation
c signed 1-byte character
u unsigned 1-byte character
h short 2-byte integer
i 4-byte integer
l long (4- or 8-byte) integer
f 4-byte floating point single precision
d 8-byte floating point double precision
Default format is scanline orientation of ASCII numbers: -ZTLa. Note that -Z only applies to 1-column output.
-bo Selects binary output. Append s for single precision [Default is double]. This option only applies to xyz output; see -Z for z ta-
ble output.
EXAMPLES
To edit individual values in the 5' by 5' hawaii_grv.grd file, try
grd2xyz hawaii_grv.grd > hawaii_grv.xyz
To write a single precision binary file without the x,y positions from the file raw_data.grd file, using scanline orientation, try
grd2xyz raw_data.grd -ZTLf > hawaii_grv.b
SEE ALSO gmtdefaults(1gmt), gmt(1gmt), grdedit(1gmt), xyz2grd(1gmt)
1 Jan 2004 GRD2XYZ(l)