Generating histogram


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Generating histogram
# 1  
Old 08-21-2017
Generating histogram

Hi,
I have 2 files with similar structure - reference and test that I would like to BIN both and generate the comparison.

input files structure is:
Code:
a 3
b 10
c 3
d 7
e 1
f  4
g 9
h 6

I would like the output to be (lets say both reference and test are the file above - no diff)
Code:
BIN     <2   <5   <7  <10
REF       1     4     5      7
TST       1     4     5      7

Thanks in advance

Last edited by yan1; 08-21-2017 at 09:45 AM.. Reason: code tags please...
# 2  
Old 08-21-2017
What method is BIN?

Last edited by rdrtx1; 08-21-2017 at 11:52 AM..
# 3  
Old 08-21-2017
they are pre-given constants, subject to change on rare occasion by the user.
for the example I gave they are: 2 5 7 10
# 4  
Old 08-21-2017
something along these lines to start with:
awk -v OFS='\t' -f yan.awk refFile tstFile
where yan.awk is:
Code:
BEGIN {
  n=split("2 5 7 10", binA)
  printf("%s%s", "BIN", OFS)
  for(i=1;i<=n; i++)
    printf("%s%s", "<" binA[i], (i==n)?ORS:OFS)
}
function out(name,  i,empty)
{
  for(i in rangeA)
     empty++
  if (!empty) return

  printf("%s%s", name, OFS)
  for(i=1;i<=n; i++)
    printf("%d%s", rangeA[i], (i==n)?ORS:OFS)

}

FNR==1 {
  out(name)
  name=FILENAME
  split("",rangeA)
}
{
  for(i=1; i<=n; i++)
    if ($2<binA[i])
      rangeA[i]++
}
END {
  out(name)
}


Last edited by vgersh99; 08-21-2017 at 02:41 PM..
This User Gave Thanks to vgersh99 For This Post:
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk Sort 2d histogram output from min(X,Y) to max(X,Y)

I've got Gnuplot-format 2D histogram data output which looks as follows. 6.5 -1.25 10.2804 6.5404 -1.25 10.4907 6.58081 -1.25 10.8087 6.62121 -1.25 10.4686 6.66162 -1.25 10.506 6.70202 -1.25 10.3084 6.74242 -1.25 9.68256 6.78283 -1.25 9.41229 6.82323 -1.25 9.43078 6.86364 -1.25 9.62408... (1 Reply)
Discussion started by: chrisjorg
1 Replies

2. Programming

Frequency percentage distribution histogram with R

I am new to R and would like to calculate the percentage frequency distribution of h1 and h2. How can I combine h1 and h2 in one plot? I tried the following code. h1=c(5.18,4.61,3.30,7.58,3.00,3.80,1.95,2.67,2.77,2.73,2.33,3.36,3.50,1.91,4.25,3.87,2.86,2.26,2.00,3.86,3.33,3.59,4.00)... (0 Replies)
Discussion started by: ayyappa342
0 Replies

3. UNIX for Dummies Questions & Answers

Help with xmgrace histogram

Hi All, I am new to Grace and would like to plot histograms. My input files have one column for frequencies and another column for distances, for example: 1 2.6 4 2.7 5 2.8 2 3.9 2 4.0 4 4.7 4 4.8 4 4.9 ... I want to plot a histogram ranging from 0 to 10 with... (0 Replies)
Discussion started by: sxiong
0 Replies

4. Shell Programming and Scripting

Generating password

Hi, I am new to shell scripting, my requirement is I have to generate password for Users automatically using script and it should send on mail on that particular date using crontab. how to do this? (1 Reply)
Discussion started by: manoj.solaris
1 Replies

5. Shell Programming and Scripting

awk for histogram

I have a single file that looks like this: 1.62816 1.62816 0.86941 0.86941 0.731465 0.731465 1.03174 1.03174 0.769444 0.769444 0.981181 0.981181 1.14681 1.14681 1.00511 1.00511 1.20385 1.20385 (2 Replies)
Discussion started by: kayak
2 Replies

6. Shell Programming and Scripting

AWK counting interval / histogram data

My data looks like this: frame phi psi 0 68.466774 -58.170494 1 75.128593 -51.646816 2 76.083946 -64.300102 3 77.578056 -76.464218 4 63.180199 -76.067680 5 77.203979 -58.560757 6 66.574913 -60.000214 7 73.218269 -70.978203 8 70.956879 -76.096558 9 65.538872 -76.716568... (19 Replies)
Discussion started by: chrisjorg
19 Replies

7. UNIX for Dummies Questions & Answers

histogram or counter

Dear all, I have numerous dat files (a.dat, b.dat...) containing 500 numeric values each. I would like to count them, based on their range and obtain a histogram or a counter. INPUT: a.dat 1.3 2.16 0.34 ...... b.dat 1.54 0.94 3.13 ..... ... (2 Replies)
Discussion started by: chen.xiao.po
2 Replies

8. UNIX for Dummies Questions & Answers

gnuplot easy histogram

hello experts, I have been trying to plot a histogram of a data like; -54 -56 -43 -65 -67 -78 ... I have 156.000 rows of these kind of values between 0 and -100. I just want to make x axis takes values 5 spacing in between like; -100 -95 -90 .............. 0 And I want y... (4 Replies)
Discussion started by: enes71
4 Replies

9. UNIX for Dummies Questions & Answers

Gnuplot - Histogram Fitting

Hi I am trying to fit my histogram data with a gaussian model and am encountering two problems: 1. I can't seem to fit the histogram data with a model fit y(x) 'bin.txt' using 2:xtic(1) via a,b,c (error: need 2 to 7 using specs) 2. Even when I manually guess the correct parameters for my fit and... (1 Reply)
Discussion started by: goffinj
1 Replies

10. AIX

Generating a Subsystem

Hello, I'm trying to generate a subsystem which supports startsrc, stopsrc and refresh I want to specify special arguments in case of stopsrc and refresh for example: startsrc: /bin/testscript start stopsrc: /bin/testscript stop refresh: /bin/testscript restart which should be... (0 Replies)
Discussion started by: funksen
0 Replies
Login or Register to Ask a Question