How to calculate the difference between two adjacent columns? Post: 302377152

Sponsored Content

Top Forums Shell Programming and Scripting How to calculate the difference between two adjacent columns? Post 302377152 by Fredrick on Thursday 3rd of December 2009 08:48:36 AM

12-03-2009

Registered User

How to calculate the difference between two adjacent columns?

Dear All,

I need to find the difference between two adjacent columns. The file is having 'i' columns and i need to find the difference between two adjacent columns (like $1 difference $2; $2 difference $3; .... and $(i-1) difference $i). I have used the following coding

HTML Code:

awk '{ for (i=1; i<NF; i++) if (($i - $i+1) > 10) print 1; else print 0}' input > output

While using the above in the command line, i am getting the values only in the first column of the output file. I need to print the difference in columns.
(for example; output $1 = input $1 difference input $2...etc..)

The problem here is, i need to get the difference between the two adjacent columns (for example: if the first column first element is 10 and the second column first element is 40, then $1 - $2 = -30, which is less than 10, so the output will be 0 in this case) But if you see the difference is 30. So i need to check the difference is > 10 or not.

Is there any difference operator in awk? (like $1 ~ $2).
I need your help in this regard.

Expecting your reply and thanks in advance.

Regards
Fredrick.

Fredrick

View Public Profile for Fredrick

Find all posts by Fredrick

10 More Discussions You Might Find Interesting

1. 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

2. 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:...

3. 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...

4. 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...

5. 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...

6. 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...

7. 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...

8. 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...

9. 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.

10. 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...

LEARN ABOUT REDHAT

pnmpsnr

pnmpsnr(1)						      General Commands Manual							pnmpsnr(1)

NAME

       pnmpsnr - compute the difference between two images (the PSNR)

SYNOPSIS

       pnmpsnr [pnmfile1] [pnmfile2]

DESCRIPTION

       Reads  two  PBM,  PGM, or PPM files, or PAM equivalents, as input.  Prints the peak signal-to-noise ratio (PSNR) difference between the two
       images.	This metric is typically used in image compression papers to rate the distortion between original and decoded image.

       If the inputs are PBM or PGM, pnmpsnr prints the PSNR of the luminance only.  Otherwise, it prints the separate PSNRs of the luminance, and
       chrominance (Cb and Cr) components of the colors.

       The  PSNR  of  a  given component is the ratio of the mean square difference of the component for the two images to the maximum mean square
       difference that can exist betwee any two images.  It is expressed as a decibel value.

       The mean square difference of a component for two images is the mean square difference of the component value, comparing  each  pixel  with
       the pixel in the same position of the other image.  For the purposes of this computation, components are normalized to the scale [0..1].

       The maximum mean square difference is identically 1.

       So the higher the PSNR, the closer the images are.  A luminance PSNR of 20 means the mean square difference of the luminances of the pixels
       is 100 times less than the maximum possible difference, i.e. 0.01.

SEE ALSO

       pnm(5)

								   04 March 2001							pnmpsnr(1)