|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
awk calculation with zero as N/A
Post 302973900 by cmccabe on Monday 23rd of May 2016 05:21:28 PM
05-23-2016
Quote:
Note, however, that $1/$2 is always going to be zero when $1 is a string that starts with non-numeric characters (other than a few magic strings like Infinity and NaN ).
Code:
awk '
function ceil(v) {
return int(v)==v?v:int(v+1)
}
NR==FNR{
f1[$1]=$2
next
}
$1 in f1{
print $1, ($3 == 0) ? "NaN" : (ceil(10000*(1-f1[$1]/$3))/100 "%")
}
{ print ($2 == 0 ? "NaN" : $1 / $2)
}' file1 file2
CHUK 3.85%
0
CHRD NaN
0
.Last edited by cmccabe; 05-23-2016 at 06:21 PM.. Reason: fixed format
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hallo all,
I have a script which creates an output ... see below:
root@a7germ:/tmp/pax > cat 20061117.txt
523.047
521.273
521.034
517.367
516.553
517.793
513.114
513.940
I would like to use awk to calculate the (a)total sum of the numbers (b) The average of the numbers.
Please... (4 Replies)
Discussion started by: kekanap
4 Replies
2. UNIX for Advanced & Expert Users
Dear All
How are you
I have files which look like this :
20080406_12:43:55.779 ISC Sprint- 39 21624032999 218925866728
20080406_12:44:07.811 ISC Sprint- 20 21620241815 218927736810
20080406_12:44:00.485 ISC Sprint- 50 21621910404 218913568053... (0 Replies)
Discussion started by: zanetti321
0 Replies
3. Shell Programming and Scripting
I have a list of coordinate data, sampled below.
54555209 784672723
I want it as:
545552.09 7846727.23
Below is my script:
BEGIN {FS= " "; OFS= ","} {print $1*.01,$2*.01}
This is my outcome:
5.5e7 7.8e8
How do I tell awk that I want to keep all the digits instead of outputting... (1 Reply)
Discussion started by: ndnkyd
1 Replies
4. Shell Programming and Scripting
Hello Friends,
Im calculating file sizes with below AWK script. I do this before some spesific files are transferred. I run the script it works but after several running it stuck with a limit of 2147483647 (2 Gbytes -1 byte) and cant exceed this. Something is wrong and I can't proceed, would... (1 Reply)
Discussion started by: EAGL€
1 Replies
5. Shell Programming and Scripting
Dear Friends,
Anybody knows how to take antilog of an value in unix.
Thanks in advance
Vasanth (2 Replies)
Discussion started by: vasanth.vadalur
2 Replies
6. Shell Programming and Scripting
Hi all!
I have the following problem: I would like to calculate using awk a probability of appearing of a pair of numbers x and y. In other words how frequently do these numbers appear?
In the case of only one integer number x ranged for example from 1 to 100 awk one liner has the form:
awk... (4 Replies)
Discussion started by: jarowit
4 Replies
7. Shell Programming and Scripting
Hi All,
I have some 10 files named samp1.csv, samp2.csv,... samp10.csv
Each file having the same number of fields like,
Count, field1, field2, field3.
And a source.csv file which has three fields field1, field2, field3.
Now, i want to find the total count by taking the field1,... (8 Replies)
Discussion started by: johnwilliams.sp
8 Replies
8. Shell Programming and Scripting
Hi all
i have a text file with columns delimited with ,
2010-08-18,10,24,.09751,39,7,14872,26732
.
.
.
i would to add a extra column in the end with percentage calculation of columns 5 and 8 ie (39/26732)*100
so the output must look like
... (6 Replies)
Discussion started by: posner
6 Replies
9. Programming
hi there again,
i need to do a simple division with my data with a number of rows. i think i wanted to have a simple output like this one:
col1 col2 col3
val1 val2 val1/val2
valn valm valn/valm
any suggestion is very much appreciated. thanks much. (2 Replies)
Discussion started by: ida1215
2 Replies
10. Shell Programming and Scripting
I am trying to run the awk below. My question is when I split the input, then run anotherawk to perform a calculation using that splitas the input there are no issues. When I try to combine them the output is not correct, is the split not working or did I do it wrong? Thank you :).
input
... (8 Replies)
Discussion started by: cmccabe
8 Replies
LEARN ABOUT DEBIAN
extract_font_range
extract_font_range(3alleg4) Allegro manual extract_font_range(3alleg4) NAME
extract_font_range - Extracts a range of characters from a font. Allegro game programming library. SYNOPSIS
#include <allegro.h> FONT *extract_font_range(FONT *f, int begin, int end) DESCRIPTION
This function extracts a character range from a font and returns a new font that contains only the range of characters selected by this function. You can pass -1 for either the lower or upper bound if you want to select all characters from the start or to the end of the font. Example: FONT *myfont; FONT *capitals; FONT *fontcopy; ... /* Create a font of only capital letters */ capitals = extract_font_range(myfont, 'A', 'Z'); /* Create a copy of the font */ fontcopy = extract_font_range(myfont, -1, -1); ... destroy_font(capitals); destroy_font(fontcopy); RETURN VALUE
Returns a pointer to the new font or NULL on error. Remember that you are responsible for destroying the font when you are finished with it to avoid memory leaks. SEE ALSO
get_font_range_begin(3alleg4), get_font_range_end(3alleg4), merge_fonts(3alleg4), transpose_font(3alleg4), exfont(3alleg4) Allegro version 4.4.2 extract_font_range(3alleg4)