count number of rows based on other column values Post: 302449166

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How to assign scores to rows based on column values

Hi, I'm trying to assign a score to each row which will allow me to identify which rows differ. In the example file below, I've used "," to indicate column separators (my actual file has tab separators). In this example, I'd like to identify that row 1 and row 5 are the same, and row 2 and row...

2. UNIX for Dummies Questions & Answers

how to count number of rows and sum of column using awk

Hi All, I have the following input which i want to process using AWK. Rows,NC,amount 1,1202,0.192387 2,1201,0.111111 3,1201,0.123456 i want the following output count of rows = 3 ,sum of amount = 0.426954 Many thanks

3. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ...

4. UNIX for Dummies Questions & Answers

Extracting rows from a text file based on numerical values of a column

I have a text file where the second column is a list of numbers going from small to large. I want to extract the rows where the second column is smaller than or equal to 0.0001. My input: rs10082730 9e-08 12 46002702 rs2544081 1e-07 12 46015487 rs1425136 1e-06 7 35396742 rs2712590...

5. Shell Programming and Scripting

join rows based on the column values

Hi, Please help me to convert the input file to a new one. input file: -------- 1231231231 3 A 4561223343 0 D 1231231231 1 A 1231231231 2 A 1231231231 4 D 7654343444 2 A 4561223343 1 D 4561223343 2 D the output should be: -------------------- 1231231231 3#1#2 A 4561223343 0 D...

6. UNIX for Dummies Questions & Answers

Extracting rows from a space delimited text file based on the values of a column

I have a space delimited text file. I want to extract rows where the third column has 0 as a value and write those rows into a new space delimited text file. How do I go about doing that? Thanks!

7. UNIX for Dummies Questions & Answers

count number of distinct values in each column with awk

Hi ! input: A|B|C|D A|F|C|E A|B|I|C A|T|I|B As the title of the thread says, I would need to get: 1|3|2|4 I tried different variants of this command, but I don't manage to obtain what I need: gawk 'BEGIN{FS=OFS="|"}{for(i=1; i<=NF; i++) a++} END {for (b in a) print b}' input ...

8. Shell Programming and Scripting

Choosing rows based on column values

I have a .csv file: A,B,0.6 C,D,-0.7 D,E,0.1 A,E,0.45 D,G, -0.4 I want to select rows based on the values of the 3rd columns such that it is >=0.5 or <= -0.5 Thanks. A,B,0.6 D,G, -0.7

9. Shell Programming and Scripting

UNIX command -Filter rows in fixed width file based on column values

Hi All, I am trying to select the rows in a fixed width file based on values in the columns. I want to select only the rows if column position 3-4 has the value AB I am using cut command to get the column values. Is it possible to check if cut -c3-4 = AB is true then select only that...

10. Shell Programming and Scripting

Count number of unique values in each column of array

What is an efficient way of counting the number of unique values in a 400 column by 1000 row array and outputting the counts per column, assuming the unique values in the array are: A, B, C, D In other words the output should look like: Value COL1 COL2 COL3 A 50 51 52...

LEARN ABOUT X11R4

input

INPUT(1)                                                      General Commands Manual                                                     INPUT(1)

NAME

       input - Yagi-Uda project antenna defining program

SYNOPSIS

       input [ - h ]

DESCRIPTION

       The  program  input  is  one  of  a  number of executable programs that forms part of a set of programs, collectively known as the Yagi-Uda
       project , which were designed for analysis and optimisation of Yagi-Uda antennas.  input is an interactive program, that asks the user  for
       information  about a Yagi design, such as position of elements, spacing between elements, frequency span of interest and a filename to save
       the data to.  input then writes this information into an ASCII file, which can be read by yagi or optimise The file is ASCII and it's  for-
       mat is easily understood by inspection (there are comments printed in it), so it can if necessary be edited manually.

       After  running  input and specifying a filename (for example 144e10) you should then type yagi 144e10 and then output 144e10 and optionally
       optimise 144e10

OPTIONS

       -h     Print a help message.

FILES

       filename         ASCII data file in which design is put.

PLATFORMS

       Both DOS and Unix versions have been built. The DOS version as distributed requires a 386 PC with a 387 maths coprocessor.

AUTHORS

       Dr. David Kirkby G8WRB (david.kirkby@onetel.net).  with help with in converting to DOS/PC from Dr. Joe Mack NA3T (mack@fcrfv2.ncifcrf.gov)

SEE ALSO

       first(1), yagi(), output(1), optimise(1), input (5), first(5), yagi(5), output(5) and optimise(5).

       Bugs should be reported to
       david.kirkby@onetel.net.
       Bugs tend actually to be fixed if they can be isolated, so it is in your interest to report them in such a way  that  they  can  be  easily
       reproduced.

       If  a  mistake is made during inputting of data (such as entering an incorrect length), it is not possible to go back and correct this. You
       should make a note of the error, and edit the ASCII text file with a text editor (vi, DOS edit etc).

Version 1.16                                                    24th October  2000                                                        INPUT(1)