Awk getting statistics of a grid file, Post: 302527048

Sponsored Content

Top Forums Shell Programming and Scripting Awk getting statistics of a grid file, Post 302527048 by alex2005 on Thursday 2nd of June 2011 07:33:13 AM

06-02-2011

Registered User

Hello,
Please find bellow the formula that will give us the grid values:

Code:

$ awk '{print $0, int(($2+7)/8)-int(1100/8)}' grid.test | more
5001                1001 -11
5001                1002 -11
5001                1003 -11
5001                1004 -11
5001                1005 -11
5001                1006 -11
5001                1007 -11
5001                1008 -11
5001                1009 -10
5001                1010 -10
5001                1011 -10
5001                1012 -10
5001                1013 -10
5001                1014 -10
5001                1015 -10
5001                1016 -10
5001                1017 -9
5001                1018 -9
5001                1019 -9
5001                1020 -9
5001                1021 -9
5001                1022 -9
 
------------------------
5001                1076 -2
5001                1077 -2
5001                1078 -2
5001                1079 -2
5001                1080 -2
5001                1081 -1
5001                1082 -1
5001                1083 -1
5001                1084 -1
5001                1085 -1
5001                1086 -1
5001                1087 -1
5001                1088 -1
5001                1089 0
5001                1090 0
5001                1091 0
5001                1092 0
5001                1093 0
5001                1094 0
5001                1095 0
5001                1096 0
5001                1097 1
5001                1098 1
5001                1099 1
5001                1100 1
5001                1101 1
5001                1102 1
5001                1103 1
5001                1104 1
5001                1105 2
5001                1106 2
5001                1107 2
5001                1108 2
5001                1109 2
5001                1110 2
5001                1111 2
5001                1112 2
5001                1113 3
5001                1114 3
5001                1115 3
5001                1116 3
5001                1117 3
5001                1118 3
5001                1119 3
5001                1120 3
5001                1121 4
5001                1122 4
5001                1123 4
5001                1124 4
5001                1125 4

1100 will define the grid origin (if you'll put 1001 than 1001 will be the grid origin).
Thanks

Last edited by Franklin52; 06-02-2011 at 10:35 AM.. Reason: Please use code tags for code and data examples

alex2005

View Public Profile for alex2005

Find all posts by alex2005

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to create a grid file

Hi everybody: I want to create a grid file for export to statistical program. My aid is create a file with both rows, one row are x coordenates and other for y coordenates. All grid obviousolly are same space. the form that i want is this: x=(400000 ........ 600000) and y=(4000000 ..........

2. UNIX for Dummies Questions & Answers

file statistics??

Is there any command in Unix (HP-UX) which will give me the file statistics .. e.g I have a file called r001 if I created that file on 2nd of aug 2005 and till now I changed that file contents 10 times. So how will I get the history statistic(time & date) of file modification.

3. Shell Programming and Scripting

AWK- extracting values from columns, saving them and gettins statistics

Hello, I am obviously quite new to unix and awk. I need to parse certain columns of a file (delimited by spaces), and somehow save the value of this column somewhere, together with the value of the column just after it (by pairs; so something like ). I'm then supposed to count the times that...

4. Shell Programming and Scripting

statistics using awk

Hi, I have 3 columns in a file listed below. X Y X/(X+Y) 1 1 0.5 1 1 0.5 4 1 0.8 1 1 0.5 6 1 0.857142857 1 1 0.5 23 1 0.958333333 Now I want to find confidence interval using the formula for each row. (p-2 sqrt p(1-p)/(x+y), p+2...

5. Programming

C++ Help with file handle and simple statistics problem asking...

Input_file: >header_1 ASDFFDASADASF >header_2 ASDSAFASDAAFFFAFA Desired output file: 30 Source Code try: // reading a text file #include <iostream> #include <fstream> #include <string> using namespace std; int main () { string line; ifstream myfile ("Input_file");

6. Shell Programming and Scripting

Writing only timing statistics output of Timer to File

I'm running long integrations on a remote server, and I'm working in terminal in a tcsh shell. I'm looking to write ONLY the timing statistics to a file. For example: $time ls >timer.out writes both the files in my current directory & the timer statistics to the file timer.out. I only...

7. Shell Programming and Scripting

awk based script to print the "mode(statistics term)" for each column in a data file

Hi All, Thanks all for the continued support so far. Today, I need to find the most occurring string/number(also called mode in statistics terminology) for each column in a data file (.csv type). For one column of data(1.txt) like below Sample 1 2 2 3 4 1 1 1 2 I can find the mode...

8. Red Hat

CPU Usage statistics Dump in a text file over a period of time

I am facing issue related to performance of one customized application running on RHEL 5.9. The application stalls for some unknown reason that I need to track. For that I require some tool or shell scripts that can monitor the CPU usage statistics (what we get in TOP or in more detail by other...

9. UNIX for Advanced & Expert Users

Need optimized awk/perl/shell to give the statistics for the Large delimited file

I have a file size is around 24 G with 14 columns, delimiter with "|" My requirement- can anyone provide me the fastest and best to get the below results Number of records of the file First column and second Column- Unique counts Thanks for your time Karti ------ Post updated at...

LEARN ABOUT SUNOS

create-jms-resource

asadmin-create-jms-resource(1AS)				   User Commands				  asadmin-create-jms-resource(1AS)

NAME

       asadmin-create-jms-resource, create-jms-resource - registers the JMS resource

SYNOPSIS

       create-jms-resource  --user  admin_user [--password admin_password] [--host localhost] [--port 4848] [--secure|-s][--passwordfile filename]
       [--terse=false]	 [--echo=false]   [--interactive=true]	 --restype   resource_type   [--enabled=true][--description   text]    [--property
       (name=value)[:name=value]*] jndi_name

       Registers the JMS resource. This command is supported in remote mode only.

OPTIONS

       --user		       authorized domain application server administrative username.

       --password	       password to administer the domain application server.

       --host		       machine name where the domain application server is running.

       --port		       port number of the domain application server listening for administration requests.

       --secure 	       if true, uses SSL/TLS to communicate with the domain application server.

       --passwordfile	       file containing the domain application server password.

       --terse		       indicates that any output data must be very concise, typically avoiding human-friendly sentences and favoring well-
			       formatted data for consumption by a script.

       --echo		       setting to true will echo the command line statement on the standard output.

       --interactive	       prompts you for the required options that are not already specified.

       --restype	       JMS   resource	type   which   can   be:   javax.jms.Topic,   javax.jms.Queue,	 javax.jms.TopicConnectionFactory,
			       javax.jms.QueueConnectionFactory.

       --enabled	       determines whether the resource is enabled at runtime.

       --description	       text description of the JMS resource.

       --property	       optional attribute name/value pairs for configuring the JMS resource.

OPERANDS

       jndi_name	       JNDI name of the JMS resource to be created.

       Example 1: Creating a JMS connection factory resource for durable subscriptions

       asadmin> create-jms-resource --user admin1
       --password adminadmin1 --host pigeon --port 5001
       --restype javax.jms.TopicConnectionFactory --description
       "example of creating a JMS connection factory"
       --property ClientId=MyID jms/DurableTopicConnectionFactory
       Command create-jms-resource executed successfully

       Where:  jms/DurableTopicConnectionFactory  is  the  JNDI name of the resource, and the ClientId property sets a client ID on the connection
       factory so that it can be used for durable subsciptions. The JNDI name for a JMS resource customarily includes the jms/ naming subcontext.

       Example 2: Creating a JMS destination resource

       asadmin> create-jms-resource --user admin1
       --password adminadmin1 --host pigeon --port 5001
       --restype javax.jms.Queue
       --property Name=PhysicalQueue jms/MyQueue
       Command create-jms-resource executed successfully

       Where: jms/Queue is the JNDI name of the resource, and the Name property specifies the physical destination that the resource refers to.

EXIT STATUS

       0		       command executed successfully

       1		       error in executing the command

       asadmin-delete-jms-resource(1AS), asadmin-list-jms-resources(1AS), asadmin-create-jmsdest(1AS)

J2EE 1.4 SDK							    March 2004					  asadmin-create-jms-resource(1AS)