Sponsored Content
Top Forums Shell Programming and Scripting Awk getting statistics of a grid file, Post 302526896 by rdcwayx on Wednesday 1st of June 2011 11:33:33 PM
Old 06-02-2011
I still don't understand the 1100 come from, but let we start it first.

Do you ask for something like this:

Code:
awk '{print $0, int(($1+7)/8)-int(1100/8)}' infile

5001    1001 489
5001    1002 489
5001    1003 489
5001    1004 489
5001    1005 489
5001    1006 489
5001    1007 489
5001    1008 489
5001    1009 489
5001    1010 489

or

 awk '{print $0, int(($1+7)/8)-int($2/8)}' infile

5001    1001 501
5001    1002 501
5001    1003 501
5001    1004 501
5001    1005 501
5001    1006 501
5001    1007 501
5001    1008 500
5001    1009 500

 

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 .......... (1 Reply)
Discussion started by: tonet
1 Replies

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. (1 Reply)
Discussion started by: zing_foru
1 Replies

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... (9 Replies)
Discussion started by: acsg
9 Replies

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... (7 Replies)
Discussion started by: Diya123
7 Replies

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"); (3 Replies)
Discussion started by: perl_beginner
3 Replies

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... (2 Replies)
Discussion started by: elemonier
2 Replies

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... (6 Replies)
Discussion started by: ks_reddy
6 Replies

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... (6 Replies)
Discussion started by: Anjan Ganguly
6 Replies

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... (3 Replies)
Discussion started by: kartikirans
3 Replies
Goo::Canvas::Table(3pm) 				User Contributed Perl Documentation				   Goo::Canvas::Table(3pm)

NAME
Goo::Canvas::Table - wrapper for GooCanvasTable HIERARCHY
Glib::Object +----Goo::Canvas::ItemSimple +----Goo::Canvas::Group +----Goo::Canvas::Table INTERFACES
Goo::Canvas::Item METHODS
item = Goo::Canvas::Table->new ($parent, ...) o $parent (Goo::Canvas::Item) o ... (list) PROPERTIES
'column-spacing' (double : default 0 : readable / writable) The default space between columns 'homogeneous-columns' (boolean : default false : readable / writable) If all columns are the same width 'homogeneous-rows' (boolean : default false : readable / writable) If all rows are the same height 'horz-grid-line-width' (double : default 0 : readable / writable) The width of the grid line to draw between rows 'row-spacing' (double : default 0 : readable / writable) The default space between rows 'vert-grid-line-width' (double : default 0 : readable / writable) The width of the grid line to draw between columns 'x-border-spacing' (double : default 0 : readable / writable) The amount of spacing between the lefmost and rightmost cells and the border grid line 'y-border-spacing' (double : default 0 : readable / writable) The amount of spacing between the topmost and bottommost cells and the border grid line SEE ALSO
Glib::Object, Goo::Canvas::ItemSimple, Goo::Canvas::Group COPYRIGHT
Copyright (C) 2011 Gtk2-Perl Team perl v5.14.2 2011-11-16 Goo::Canvas::Table(3pm)
All times are GMT -4. The time now is 10:13 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy