Add floating point numbers from file


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Add floating point numbers from file
# 1  
Old 05-05-2011
Add floating point numbers from file

How do I use bash to add all the floating point numbers saved in a file like this?

490.47
244.61
263.07
131.59
246.81
115.20
# 2  
Old 05-05-2011
Code:
awk '{s+=$1}END{print s}' infile

---------- Post updated at 06:54 PM ---------- Previous update was at 06:39 PM ----------
Code:
[ctsgnb@shell ~/sand]$ cat tst2
490.47
244.61
263.07
131.59
246.81
115.20
[ctsgnb@shell ~/sand]$ awk '{s+=$1}END{print s}' tst2
1491.75
[ctsgnb@shell ~/sand]$

# 3  
Old 05-05-2011
Fixed-point

Hi.

To use only bash (compared with awk):
Code:
#!/usr/bin/env bash

# @(#) s1	Demonstrate awk vs bash for fractional addition, fixed-point.

# Utility functions: print-as-echo, print-line-with-visual-space, debug.
pe() { for i;do printf "%s" "$i";done; printf "\n"; }
pl() { pe;pe "-----" ;pe "$*"; }
db() { ( printf " db, ";for i;do printf "%s" "$i";done; printf "\n" ) >&2 ; }
db() { : ; }
C=$HOME/bin/context && [ -f $C ] && . $C

FILE=${1-data1}

pl " Input file $FILE:"
cat $FILE

pl " Results, awk:"
awk '{v+=$1} END{print v}' $FILE

pl " Results, bash (with scaling):"
v2=0
while read line
do
  v1=${line/./}
  pe " Line scaled is :$v1:"
  (( v2+=v1 ))
done <$FILE
v3=${v2%??}
v4=${v2/#$v3/}
pe " total    is :$v2:"
pe " integer  is :$v3:"
pe " fraction is :$v4:"
v5="${v3}.${v4}"
pe " Re-scaled   :$v5:"

exit 0

producing:
Code:
% ./s1

Environment: LC_ALL = C, LANG = C
(Versions displayed with local utility "version")
OS, ker|rel, machine: Linux, 2.6.26-2-amd64, x86_64
Distribution        : Debian GNU/Linux 5.0.7 (lenny) 
GNU bash 3.2.39

-----
 Input file data1:
490.47
244.61
263.07
131.59
246.81
115.20

-----
 Results, awk:
1491.75

-----
 Results, bash (with scaling):
 Line scaled is :49047:
 Line scaled is :24461:
 Line scaled is :26307:
 Line scaled is :13159:
 Line scaled is :24681:
 Line scaled is :11520:
 total    is :149175:
 integer  is :1491:
 fraction is :75:
 Re-scaled   :1491.75:

See man bash for details and Fixed-point arithmetic - Wikipedia, the free encyclopedia for information on fixed-point ... cheers, drl
# 4  
Old 05-05-2011
Code:
paste -sd+ myFile |bc

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Comparison of floating point numbers in bash

I have the following code snippet in bash if ]; then minm=`echo "$diff" | bc` fi It works well for most of the cases. However lets say diff is -0.17 and minm is -0.0017. In such a case the comparison seems to fail. Is the correct way to compare a mixture of positive and... (12 Replies)
Discussion started by: ngabrani
12 Replies

2. Shell Programming and Scripting

Floating Point Numbers in c shell!

I have started using bash but this script which I am working on it, is in c chell. So here is my simple problem: set x = 0.4124\0.234 echo $x 0.4124.0.234 Same operation in Bash gives me correct result in my terminal. So there is something with my c shell that is causing this behaviour.... (8 Replies)
Discussion started by: dixits
8 Replies

3. Shell Programming and Scripting

Add leading zeros in floating point variable

I need to add leading zeros in a floating point numbers. The length of the number should be 13 including decimal. The input number is changing so number of leading zeros is not fix. For example input output 216.000 000000216.000 1345.000 000001345.000 22345.500 ... (4 Replies)
Discussion started by: reeta_shri
4 Replies

4. Programming

Floating Point

Anyone help me i cant found the error of floating point if needed, i added the code complete #include <stdio.h> #include <string.h> #include <stdlib.h> #include <ctype.h> typedef struct { int hh; int mm; int ss; char nom; int punt; }cancion; typedef struct... (9 Replies)
Discussion started by: Slasho
9 Replies

5. Programming

Testing floating point numbers

Hi guys I have problem with my simple calculator, author of my book wrote One way I tried is to test if one the inpur number is grater than zero, and then substatct And my protptype function is #include <stdio.h> int main(void) { float a, b , result; ... (11 Replies)
Discussion started by: solaris_user
11 Replies

6. Shell Programming and Scripting

How to compare floating point numbers in shell script?

How can we compare 2 floating point numbers in SHELL script? (11 Replies)
Discussion started by: dearanik
11 Replies

7. Shell Programming and Scripting

floating point numbers in if

# if > then > echo "1" > else > echo "2" > fi -bash: How can i compare floating point numbers inside statement? (15 Replies)
Discussion started by: proactiveaditya
15 Replies

8. Shell Programming and Scripting

sed to extract only floating point numbers from HTML

Hi All, I'm trying to extract some floating point numbers from within some HTML code like this: <TR><TD class='awrc'>Parse CPU to Parse Elapsd %:</TD><TD ALIGN='right' class='awrc'> 64.50</TD><TD class='awrc'>% Non-Parse CPU:</TD><TD ALIGN='right' class='awrc'> ... (2 Replies)
Discussion started by: pondlife
2 Replies

9. Shell Programming and Scripting

How to Compare Floating point / real numbers

Hai, Can you please guide me, to compare the floating point numbers. Eg. If then echo "value1 is grater " fi This code is not working properly when i excuted with floating values or real numbers (13 Replies)
Discussion started by: padarthy
13 Replies

10. Shell Programming and Scripting

problem with floating point numbers in awk

hi all, i have the following problem using awk in a script i want to read the values from a column with real numbers and calculate the mean.the problem is that when i use a statement such as this num = $4 i cant find a way to convert the variable from string to floating point to perform... (7 Replies)
Discussion started by: kanagias
7 Replies
Login or Register to Ask a Question