How to calculate the difference between two adjacent columns?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk to calculate difference of split and sum the difference

In the awk I am trying to subtract the difference $3-$2 of each matching $4 before the first _ (underscore) and print that value in $13. I think the awk will do that, but added comments. What I am not sure off is how to add a line or lines that will add sum each matching $13 value and put it in...

2. Shell Programming and Scripting

Calculate percentage difference between two columns

I have a input text file in this format: ITEM1 10.9 20.1 ITEM2 11.6 12 ITEM3 14 15.7 ITEM5 20 50.6 ITEM6 25 23.6 I want to print those lines which have more than 5% difference between second and third columns.

3. Shell Programming and Scripting

How to calculate difference:?

Experts, file1 : Want to find the difference of $3 field from next line's 3rd field, The difference to be calculated from next lines 3rd field, to current lines lines 3rd field. file1 : Jun24_2013.06242013 3301244928 3133059904 167370640 95% Jun25_1124.06252013 3301244928...

4. Shell Programming and Scripting

Calculate the difference of two columns and keep the line with specific value

Hi everyone, I am trying to find sty all day. I have two files: File 1: N 82 AAA A 1 0.67 N 83 BBB B 1 0.79 N 84 CCC C 1 0.11 File 2: N 82 AAA A 1 0.63 N 83 BBB B 1 0.03 N 84 CCC C 1 0.08 I want to calculate...

5. Shell Programming and Scripting

How to Calculate the difference between two dates?

I want the difference between two following date using scripts in terms of no.of days. How I can accomplish this. lastdate=Tue Nov 13 10:30:56 2012 currdate=Wed Dec 15 15:58:21 PAKST 2012 Ouput should be like this: Your Password will expire after = 32 Days on Wed Dec 15 15:58:21 PAKST...

6. UNIX for Dummies Questions & Answers

help to identify duplicate columns adjacent value

Hi friends, I have a xlsheet like below first column having id ABCfollowed by 7digit numbers and the next column have title against the ids. Titles are unique and duplicateboth, but ids are unique even for duplicate title.Now I need to identify those duplicate title having the highest id for...

7. Shell Programming and Scripting

Calculate age of a file | calculate time difference

Hello, I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes... I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes. To do...

8. Shell Programming and Scripting

How to calculate the time difference.

Hi All, I've written a script which reads all the systems backup information and saves it in a log file. ssh -l ora${sid} ${primaryhost} "tail -1 /oracle/$ORACLE_SID/sapbackup/back$ORACLE_SID.log" | awk '{print $3,$4,$5,$6}' >> ${RESULTFILE} The output comes as below: 2008-09-30 06.00.01...

9. Shell Programming and Scripting

How to calculate the time difference...

Hi All, I've written a script which reads all the systems backup information and saves it in a log file. ssh -l ora${sid} ${primaryhost} "tail -2 /oracle/$ORACLE_SID/sapbackup/back$ORACLE_SID.log" |head -1 | awk '{print echo "PREVIOUS:-- Start Date&Time: " $3,$4,echo "|| End Date&Time:...

10. Shell Programming and Scripting

How to calculate this time difference

Hi, Please help me in calculating the time difference between below mentioned timestamps. a=07/17/2007 02:20:00 AM MST b=07/17/2007 02:07:46 AM MST Thanks

LEARN ABOUT MINIX

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)

Shell Programming and Scripting