Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Sum every 3 consecutive numbers in a column

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Sum every 3 consecutive numbers in a column
# 1  
Old 11-06-2013
Sum every 3 consecutive numbers in a column
Dear All,

I have a file with only one column. And I want to add every 3 consecutive numbers together and print the result.

Input File:
Code:
21.1
10
10
55
11
99
10
8
4

Expected Output:
Code:
41.1
165
22

I am new in Programming and would appreciate your help.
# 2  
Old 11-06-2013
What have you tried so far? It's pretty similar to your previous thread
# 3  
Old 11-06-2013
Why not adapt the solution to your recent post?
# 4  
Old 11-06-2013
I tried to modify the code but it is just giving me the 1st number.

Code:
awk     'NR==1          
        {printf sum,N; N+=3; sum=0}
           {sum+=$1}
END            {printf sum}
>         ' myfile

# 5  
Old 11-06-2013
As you're only dealing with one column, and working with consecutive numbers it's a lot simpler:
Code:
awk '{sum+=$1} NR%3==0{print sum; sum=0}' file

This User Gave Thanks to Subbeh For This Post:
NamS
# 6  
Old 11-06-2013
You'll have to adapt it thoroughly, as the boundary conditions have changed!
Code:
awk     'NR==1          {N=4}
         NR>=N          {printf "%s\n",sum; N+=3; sum=0}
                        {sum+=$1}
         END            {printf "%s\n", sum}
        ' file
41.1
165
22

But, although this works, it can be improved/simplified . Your turn again...
This User Gave Thanks to RudiC For This Post:
NamS
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Check/print missing number in a consecutive range and remove duplicate numbers

Hi, In an ideal scenario, I will have a listing of db transaction log that gets copied to a DR site and if I have them all, they will be numbered consecutively like below. 1_79811_01234567.arc 1_79812_01234567.arc 1_79813_01234567.arc 1_79814_01234567.arc 1_79815_01234567.arc... (3 Replies)
Discussion started by: newbie_01
3 Replies

2. UNIX for Dummies Questions & Answers

Match sum of values in each column with the corresponding column value present in trailer record

Hi All, I have a requirement where I need to find sum of values from column D through O present in a CSV file and check whether the sum of each Individual column matches with the value present for that corresponding column present in the trailer record. For example, let's assume for column D... (9 Replies)
Discussion started by: tpk
9 Replies

3. Shell Programming and Scripting

Adding the corresponding values for every 5th consecutive numbers

Dear All, I have a file which is as follows: Input File: 231 100.1 233 99 235 200.9 238 80.1 239 90.2 240 77.0 243 99.5 245 16.20 246 13.55 247 11.8 249 13.7 250 99.6 (1 Reply)
Discussion started by: NamS
1 Replies

4. UNIX for Dummies Questions & Answers

How to combine and insert missing consecutive numbers - awk or script?

Hi all, I have two (2) sets of files that are based on some snapshots of database that I want to merge and insert any missing sequential number. Below are example representation of these files: file1: DATE TIME COL1 COL2 COL3 COL4 ID 01/10/2013 0800 100 ... (3 Replies)
Discussion started by: newbie_01
3 Replies

5. Shell Programming and Scripting

Disruption of consecutive numbers

I do have a tab delimited file with the following format 200 46 201 67 204 89 205 98 206 89 208 890 210 23 .. ... 100's of rows I would like to output the missing consecutive number of the first column. The expected output will be: (1 Reply)
Discussion started by: Lucky Ali
1 Replies

6. Shell Programming and Scripting

Print consecutive numbers in column2

Hi, I have an input file of the following style input.txt The 4000 at the end indicates the total no. of columns in that row. I would like to replace all -1s with consecutive 1 and 2 and print the whole line again. So, the output would be output.txt Thanks in advance. (7 Replies)
Discussion started by: jacobs.smith
7 Replies

7. Shell Programming and Scripting

Finding consecutive numbers in version names on a txt file

Hi all. I have a directory which contains files that can be versioned. All the files are named according to a pattern like this: TEXTSTRING1-001.EXTENSION TEXTSTRING2-001.EXTENSION TEXTSTRING3-001.EXTENSION ... TEXTSTRINGn-001.EXTENSION If a file is versioned, a file called ... (10 Replies)
Discussion started by: fox1212
10 Replies

8. Shell Programming and Scripting

Sum of decimal numbers in column

Hi!!! I have n decimal numbers in column: 1.23 3.45 5.16 . . . How to do arithmetic sum of theese numbers??? Thanks!!!:D (4 Replies)
Discussion started by: tdev457
4 Replies

9. Shell Programming and Scripting

Inserting a range of consecutive numbers into a text file

I have a text file in the following format .... START 1,1 2,1 3,1 .. .. 9,1 10,1 END .... I want to change to the output to .... START 1,1 2,1 3,1 .. (4 Replies)
Discussion started by: VNR
4 Replies

10. Shell Programming and Scripting

how to sum numbers in column

Hi, i want to sum all nubers in one column. Example: 12.23 11 23.01 3544.01 I'm trying to do this in awk, but it doesn't work properly. Seems like awk is summing only integers, for example: 12 11 23 3544 It cuts off numbers after dot. I used this command: akw /text/ file.txt |nawk... (1 Reply)
Discussion started by: iahveh
1 Replies
Login or Register to Ask a Question