awk solution for taking bins Post: 302773651

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash/AWK Newbie taking on more than he can chew.

A few questions: I'm trying to use Bash (although I'm not against using AWK) to try to accomplish a few things, but I'm stumped on a few points. I'm learning most of the basics quickly: but there are a few things I can't figure out. 1. I'm trying to count the number of .txt files in a...

2. Shell Programming and Scripting

Is there a awk solution for this??

I am writing a awk script that gathers certain data from certain fields. I needed a awk solution for this, because it will later become a function in the script. I have the following data that I need output on a single line, but record spans across multilple lines and records are not...

3. Shell Programming and Scripting

Awk solution

Hello! Well, I searched and wasn't able to find a specific example of my dilemma, so hopefully someone could assist? Or maybe there was an example but I missed it? I have two files: file1 = order data file file2 = list of 65,000+ order numbers I would like to extract from 'file1' any...

4. Shell Programming and Scripting

Calculating frequency of values within bins

Hi, I am working with files containing 2 columns in which i need to come up with the frequency/count of values in col. 2 falling within specifics binned values of col. 1. the contents of a sample file is shown below: 15 12.5 15 11.2 16 0.2 16 1.4 17 1.6 18 4.5 17 5.6 12 8.6 11 7.2 9 ...

5. UNIX for Dummies Questions & Answers

taking the output of awk command to a new file

cat doc | nawk -v da="${date}" '$23>199 {print $0 > "doc"+da+".txt"}' Every time(need to run every day) i run this, i want to a create a new file "doc_01 Aug.txt". Basically, i want to create a new file with date appended in it. The above command is creating a file with name "0"....

6. Shell Programming and Scripting

Cannot get the correct ans. Using awk in taking average

Hi all, I think so I’m getting the result is wrong, while using following awk commend, colval=$(awk 'FNR>1 && NR==FNR{a=$4;next;} FNR>1 {a+=$4; print $2"\t"a/3}' filename_f.tsv filename_f2.tsv filename_f3.tsv) echo $colval >> Result.tsv it’s doing the condition 2 times, first result...

7. Shell Programming and Scripting

Taking inputs for awk

Hi, i want to print 2nd column value with the below script. I need to take input of the string i need to search in that file and file name. How can i take these two as inputs? using read command? Getting error for below script. echo "enter SID" read SID echo "enter filename" read filename...

8. Shell Programming and Scripting

awk command line arguments not taking

# more minusf.awk #!/bin/awk -f BEGIN { FS=":"; } { if ( $2 == "" ) { print $1 ": no password!"; } } # ./minusf.awk aa aa aa aa awk: can't open aa

9. Shell Programming and Scripting

awk to select 2D data bins

I wish to use AWK to do something akin: Select all 2D data with 1<$1<2 and -7.5<$2<-6.5 But it's not working awk 'END {print ($1<=2&&$1>=1&&$2<=-6.5&&$2>=-7.5)}' bla Data: -1.06897 -8.04482 -61.469 -1.13613 -8.04482 -61.2271 -1.00182 -8.04482 -61.2081 -1.06897 -8.13518 -60.8544...

10. UNIX for Beginners Questions & Answers

Create bins with totals and percentage

I would like to create bins to get histogram with totals and percentage, e.g. starting from 0. If possible to set the minimum and maximum value in the bins ( in my case value min=0 and max=20 ) Input file 8 5 10 1 11 4 12 4 12 4 13 5 16 7 18 9 16 9 17 7 18 5 19 5 20 1 21 7

LEARN ABOUT CENTOS

histo

HISTO(1)						      General Commands Manual							  HISTO(1)

NAME

       histo - compute 1-dimensional histogram of N data columns

SYNOPSIS

       histo [-c][-p] xmin xmax nbins
       histo [-c][-p] imin imax

DESCRIPTION

       Histo  bins columnular data on the standard input between the given minimum and maximum values.	If three command line arguments are given,
       the third is taken as the number of data bins between the first two real numbers.  If only two arguments are given, they are  both  assumed
       to be integers, and the number of data bins will be equal to their difference plus one.	The bins are always of equal size.

       The  output is N+1 columns of data (for N columns input), where the first column is the centroid of each division, and each row corresponds
       to the frequencies for each column around that value.

       If the -c option is present, then histo computes the cumulative histogram for each column instead of the straight frequencies.	The  upper
       value  of  each	bin  is printed also instead of the centroid.  This may be useful in computing percentiles, for example.  Values below the
       minimum specified are still counted in the cumulative total.

       The -p option tells histo to report the percentage of the total number of input lines rather than the absolute counts.  In the  case  of  a
       cumulative total, this yields the percentile values directly.  Values above the maximum are counted as well as values below in this case.

       All  input data is interpreted as real values, and columns must be white-space separated.  If any value is less than the minimum or greater
       than the maximum, it will be ignored unless the -c option is specified.

EXAMPLE

       To count data values between -1 and 1 in 50 bins:

	 histo -1 1 50 < input.dat

       To count frequencies of integers between 0 and 255:

	 histo 0 255 < input.dat

AUTHOR

       Greg Ward

SEE ALSO

       cnt(1), neaten(1), rcalc(1), rlam(1), tabfunc(1), total(1)

RADIANCE
							      9/6/96								  HISTO(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Bash/AWK Newbie taking on more than he can chew.

Discussion started by: Asylus

2. Shell Programming and Scripting

Is there a awk solution for this??

Discussion started by: timj123

3. Shell Programming and Scripting

Awk solution

Discussion started by: rm -r *

4. Shell Programming and Scripting

Calculating frequency of values within bins

Discussion started by: ida1215