Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Rearranging Data Set
Top Forums Shell Programming and Scripting Rearranging Data Set Post 302986945 by Evilknievel on Friday 2nd of December 2016 11:45:36 AM
Old 12-02-2016
Rearranging Data Set
Hello everybody,

I've got the following problem:

The data set I have is an ASCII file containing a header over 4 lines and the actual data comprised of dezimal numbers in a 1000x1000 grid (1000 lines and 1000 columns).

Since I want to plot the data in GMT I need to convert it into the following format:

[x coordinate] [y coordinate] [value]

This means every single value will be in a single line preceeded by its coordinates. For simplicity lets say the upper left corner has coordinats 0,0 and the grid spacing is 500 in both directions.

I tried the following using "awk"

Code:
awk 'BEGIN {
xUL=0
yUL=0
for (i=1; i<=1000; i++)
      print "xUL+($i-1)*500", yUL+($i-1)*500, $i
}'

input.txt > output.txt

Since I'm posting my problem here it is obvious the the code above is not working. Can anybody tell why it is not working or a better solution?

Cheers
Evil

PS: I'm scripting in bash.
 

7 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

rearranging the data in file (from columnwise to rowwise)

Hi I have one file which is having data like 10201 10202 10205 10206 10207 10208 10209 10210 10211 10213 10215 10801 10802 11406 11415 11422 11426 11513 11514 11515 11516 11517 11518 11519 11520 11521 11522 11523 11524 11525 11530 11604 11608 11611 11717 11718 11719 11722 11725... (3 Replies)
Discussion started by: reldb
3 Replies

2. Shell Programming and Scripting

Unable to set a data to array

Hi All, Iam trying to set the value to the array... Still its not happening Following is the code: #!/usr/bin/ksh filenames="x"; filenames="y"; echo $filenames; echo $filenames; O/P: x x Iam expecting (2 Replies)
Discussion started by: kiranlalka
2 Replies

3. Shell Programming and Scripting

Help with sum of data set

Input file 2 1159,310, 4 142,199,218,91, 3 91,273,349, Desired output result 2 1469 4 650 3 713 I have long list of input file as shown above. It has a "," delimited to separate between each record in column 2.... (1 Reply)
Discussion started by: perl_beginner
1 Replies

4. Shell Programming and Scripting

Help with reformat data set

Input file 4CL1 O24145 CoA1 4CL1 P31684 CoA1 4CL1 Q54P77 CoA_1 73 O36421 Unknown 4CL3 Q9S777 coumarate 4CL3 Q54P79 coumarate 4CL3 QP7932 coumarate Desired output result 4CL1 O24145#P31684 CoA1 4CL1 Q54P77 CoA_1 73 O36421 Unknown 4CL3 Q9S777#Q54P79#QP7932 coumarate I... (5 Replies)
Discussion started by: perl_beginner
5 Replies

5. Shell Programming and Scripting

Data rearranging from rows to column

Hello Everyone, I have a input file looks like -0.005-0.004-0.003-0.002-0.00100.0010.0020.0030.0040.005My desired output should look like -0.005 -0.004 -0.003 -0.002 -0.001 0 0.001 0.002 0.003 0.004 0.005I had some success in getting the desired output. But i face a problem when i... (15 Replies)
Discussion started by: dinesh.n
15 Replies

6. Shell Programming and Scripting

Help with sum range of data set together

Input File: 2000 3 1998 2 1997 2 1994 1 1991 1 1989 1 1987 2 1986 2 1985 1 1984 1 . . 10 277256 9 278274 8 282507 7 284837 6 287066 5 292967 (4 Replies)
Discussion started by: perl_beginner
4 Replies

7. Programming

C++ help in large data set

Hi All, We are trying to replace a 3rdparty where we don't know how they handled the reader part here. The query below is getting 197 * 2038017 row in the table. In the below code we are trying to run the query and execute in the DB part and fetch and read the record. That is where it is... (1 Reply)
Discussion started by: arunkumar_mca
1 Replies

LEARN ABOUT XFREE86

glmapgrid1d

GLMAPGRID(3G)															     GLMAPGRID(3G)

NAME

       glMapGrid1d, glMapGrid1f, glMapGrid2d, glMapGrid2f - define a one- or two-dimensional mesh

C SPECIFICATION

       void glMapGrid1d( GLint un,
			 GLdouble u1,
			 GLdouble u2 )
       void glMapGrid1f( GLint un,
			 GLfloat u1,
			 GLfloat u2 )
       void glMapGrid2d( GLint un,
			 GLdouble u1,
			 GLdouble u2,
			 GLint vn,
			 GLdouble v1,
			 GLdouble v2 )
       void glMapGrid2f( GLint un,
			 GLfloat u1,
			 GLfloat u2,
			 GLint vn,
			 GLfloat v1,
			 GLfloat v2 )

PARAMETERS

       un  Specifies the number of partitions in the grid range interval [u1, u2].  Must be positive.

       u1, u2
	   Specify the mappings for integer grid domain values i=0 and i=un.

       vn  Specifies the number of partitions in the grid range interval [v1, v2]
	   (glMapGrid2 only).

       v1, v2
	   Specify the mappings for integer grid domain values j=0 and j=vn
	   (glMapGrid2 only).

DESCRIPTION

       glMapGrid  and  glEvalMesh  are used together to efficiently generate and evaluate a series of evenly-spaced map domain values.	glEvalMesh
       steps through the integer domain of a one- or two-dimensional grid, whose range is the domain of the evaluation maps  specified	by  glMap1
       and glMap2.

       glMapGrid1  and	glMapGrid2  specify  the  linear  grid mappings between the i (or i and j) integer grid coordinates, to the u (or u and v)
       floating-point evaluation map coordinates.  See glMap1 and glMap2 for details of how u and v coordinates are evaluated.

       glMapGrid1 specifies a single linear mapping such that integer grid coordinate 0 maps exactly to u1, and integer grid  coordinate  un  maps
       exactly to u2.  All other integer grid coordinates i are mapped so that

								    u=i(u2-u1)/un+u1

       glMapGrid2  specifies  two  such  linear  mappings.   One  maps integer grid coordinate i=0 exactly to u1, and integer grid coordinate i=un
       exactly to u2.  The other maps integer grid coordinate j=0 exactly to v1, and integer grid coordinate j=vn exactly to  v2.   Other  integer
       grid coordinates i and j are mapped such that

								    u=i(u2-u1)/un+u1

								    v=j(v2-v1)/vn+v1

       The mappings specified by glMapGrid are used identically by glEvalMesh and glEvalPoint.

ERRORS

       GL_INVALID_VALUE is generated if either un or vn is not positive.

       GL_INVALID_OPERATION is generated if glMapGrid is executed between the execution of glBegin and the corresponding execution of glEnd.

ASSOCIATED GETS

       glGet with argument GL_MAP1_GRID_DOMAIN
       glGet with argument GL_MAP2_GRID_DOMAIN
       glGet with argument GL_MAP1_GRID_SEGMENTS
       glGet with argument GL_MAP2_GRID_SEGMENTS

SEE ALSO

       glEvalCoord(3G), glEvalMesh(3G), glEvalPoint(3G), glMap1(3G), glMap2(3G)

																     GLMAPGRID(3G)
All times are GMT -4. The time now is 11:18 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy