04-27-2015
The 1.73E+11 = 173,000,000,000 in the last line of the file appears to be a rounding error.
The 1.72929E+11 = 172,929,000,000 is better but still not the exact 172,928,584,848.
So I guess that Unix awk, that uses double-precision, is more precise than the other tool (Excel?).
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have a file file like this. I want to sum all column 1 values.
input
A 2
A 3
A 4
B 4
B 2
Out put
A 9
B 6 (3 Replies)
Discussion started by: suresh3566
3 Replies
2. Shell Programming and Scripting
Hi All,
I have a file which is having 3 columns as (string string integer)
a b 1
x y 2
p k 5
y y 4
.....
.....
Question:
I want get the unique value of column 2 in a sorted way(on column 2) and the sum of the 3rd column of the corresponding rows. e.g the above file should return the... (6 Replies)
Discussion started by: amigarus
6 Replies
3. Shell Programming and Scripting
I have a file in the following layout:
201008005946873001846130058030701006131840000000000000000000
201008006784994001154259058033001009527844000000000000000000
201008007323067002418095058034801002418095000000000000000000
201008007697126001722141058029101002214158000000000000000000... (2 Replies)
Discussion started by: jclanc8
2 Replies
4. Shell Programming and Scripting
12-11-2012,PNL,158406
12-11-2012,RISK,4564
12-11-2012,VAR_1D,310101
12-11-2012,VAR_10D,310101
12-11-2012,CB,866
12-11-2012,STR_VAR_1D,298494
12-11-2012,STR_VAR_10D,309623
09-11-2012,PNL,1024106
09-11-2012,RISK,4565
09-11-2012,VAR_1D,317211
09-11-2012,VAR_10D,317211
09-11-2012,CB,985... (7 Replies)
Discussion started by: manas_ranjan
7 Replies
5. Shell Programming and Scripting
Hi,
My input files is like this
axis1 0 1 10
axis2 0 1 5
axis1 1 2 -4
axis2 2 3 -3
axis1 3 4 5
axis2 3 4 -1
axis1 4 5 -6
axis2 4 5 1
Now, these are my following tasks
1. Print a first column for every two rows that has the same value followed by a string.
2. Match on the... (3 Replies)
Discussion started by: jacobs.smith
3 Replies
6. Shell Programming and Scripting
Hi,
I have a table to be imported for R as matrix or data.frame but I first need to edit it because I've got several lines with the same identifier (1st column), so I want to sum the each column (2nd -nth) of each identifier (1st column)
The input is for example, after sorted:
K00001 1 1 4 3... (8 Replies)
Discussion started by: sargotrons
8 Replies
7. Shell Programming and Scripting
Hi,
i have log like below:
A 2 5
B 4 1
C 6 8
B 0 1
C 1 0
B 2 3
A 0 0
i want to make result if match with A then sum from column 2 and 3
so the results:
A 2 5 (5 Replies)
Discussion started by: justbow
5 Replies
8. Shell Programming and Scripting
this is part of a KT i am going thru.
i am writing a script in bash shell, linux where i have 2 columns where 1st signifies the nth hour like 00, 01, 02...23 and 2nd the file size.
sample data attached.
Desired output is 3 columns which will give the nth hour, number of entries in nth hour and... (3 Replies)
Discussion started by: alpha_1
3 Replies
9. Shell Programming and Scripting
Input file:
101M
10M10D20M1I70M
10M10D39M4I48M
10M10D91M
10M10I13M2I7M1I58M
10M10I15M1D66M
Output file:
101M 101 0 0
10M10D20M1I70M 100 1 10
10M10D39M4I48M 97 4 10
10M10D91M 101 0 10
10M10I13M2I7M1I58M 88 13 0
10M10I15M1D66M 91 10 1
I'm interested to count how many total of... (6 Replies)
Discussion started by: perl_beginner
6 Replies
10. UNIX for Beginners Questions & Answers
I have a file which need to be summed up using date column.
I/P:
2017/01/01 a 10
2017/01/01 b 20
2017/01/01 c 40
2017/01/01 a 60
2017/01/01 b 50
2017/01/01 c 40
2017/01/01 a 20
2017/01/01 b 30
2017/01/01 c 40
2017/02/01 a 10
2017/02/01 b 20
2017/02/01 c 30
2017/02/01 a 10... (6 Replies)
Discussion started by: Booo
6 Replies
LEARN ABOUT DEBIAN
byteprefix
BYTEPREFIX(5) File Formats Manual BYTEPREFIX(5)
NAME
byteprefix - Configuration for display of sizes
DESCRIPTION
There are two standard ways to use units in computing: base 10 (1 k = 10^3 = 1 000) and base 2 (1 K = 2^10 = 1 024). Historically, most
computer programs have used units in base 2, where 1 KB = 1 024 bytes, 1 MB = 1 048 576 bytes, etc. However, users are more likely to
expect and understand sizes in base 10, as this is the norm outside of computing.
This configuration file is a method for configuring programs (that use libkibi) to display sizes in the user's preferred style. It can be
configured through a configuration file or environment variable (which takes precedence).
When not using the "historic" style, IEC-style prefixes (KiB, MiB, etc.) are used for base 2 units, to disambiguate them from base 10 units
(kB, MB, etc.).
OPTIONS
There are three possible styles (Default: base10):
base2 Display all sizes in Base 2 with IEC prefixes.
1 KiB = 1 024 bytes.
1 MiB = 1 024 KiB = 1 048 576 bytes.
1 GiB = 1 024 MiB = 1 048 576 KiB = 1 073 741 824 bytes.
base10 Display all sizes in Base 10, except for sizes of RAM, which use base 2 with IEC prefixes.
Everything except RAM:
1 kB = 1 000 bytes.
1 MB = 1 000 kB = 1 000 000 bytes.
1 GB = 1 000 MB = 1 000 000 kB = 1 000 000 000 bytes.
RAM:
1 KiB = 1 024 bytes.
1 MiB = 1 024 KiB = 1 048 576 bytes.
1 GiB = 1 024 MiB = 1 048 576 KiB = 1 073 741 824 bytes.
historic
Display all sizes in Base 2, without IEC prefixes.
1 KB = 1 024 bytes.
1 MB = 1 024 KB = 1 048 576 bytes.
1 GB = 1 024 MB = 1 048 576 KB = 1 073 741 824 bytes.
Not recommended. This style uses base units 2 with prefixes usually associated with base 10 units. While it uses KB rather than the
SI (base 10) kB, there is no such distinction beyond the kilobyte range, and the units are ambiguous.
ENVIRONMENT
BYTEPREFIX
This environment variable will override the configured or default style. It should just contain one of the style names, listed in
OPTIONS above.
XDG_CONFIG_HOME
The location of the user's configuration files. If not set, it will be assumed to be ~/.config.
FILES
The preferred style can be set in a system-wide configuration file and/or in user's own configuration file (which will take precedence).
If no configuration file exists, the default style is base10.
/etc/byteprefix or XDG_CONFIG_HOME/byteprefix
This file should contain a single line: format=style. Lines beginning with # are treated as comments.
EXAMPLE
A user wanting base 2 display can set the following in ~/.config/byteprefix:
format=base2
SEE ALSO
units(7)
libkibi January 2011 BYTEPREFIX(5)