Thank you very much for the code its just what I needed, thanks for saving my night,
---------- Post updated at 09:42 PM ---------- Previous update was at 08:53 PM ----------
There is one more glitch, am sorry for missing this out. I have some rows with entirely null values and as such using the previous code I ended up with getting fatal error (attempted division by zero). how can it be resolved? how to tell the script that when all values in the row is null (NaN), put NaN on that corresponding row average.
Code:
1.4 1.2 1.5 NaN 1.6 = (1.4+1.2+1.5+1.6)/4
1.3 1.1 NaN 1.3 NaN = (1.3+1.1+1.3)/3
2.4 1.3 1.5 NaN 1.5 = (2.4+1.3+1.5+1.5)/4
NaN 1.2 NaN 1.4 NaN = (1.2+1.4)/2
NaN NaN NaN NaN NaN = NaN
NaN NaN NaN NaN NaN = NaN
Hello. Im just starting to learn awk so hang in there with me...I have a large text file formatted as such everything is in a single column
ID001
value 1
value 2
value....n
ID002
value 1
value 2
value... n
I want to be able to calculate the average for values for each ID from the... (18 Replies)
Hi
I need to do some thing like "find and insert before that " in a file which contains many records. This will be clear with the following example.
The original data record should be some thing like this
60119827 RTMS_LOCATION_CDR INSTANT_POSITION_QUERY 1236574686123083rtmssrv7 ... (8 Replies)
Hi,
Can someone help me comparing Null values.
Scenario is as follows:
I have a variable which "cache_prd" which can have either some integer or nothing(Null)
if it is integer I have to again do some comparision but these comparisons give me this error:( "line 32: [: 95: unary operator... (3 Replies)
Hi
I have a file with the values
abc
res
set
kls
lmn
ops
i want to sort this file with the null values at the bottom of the file
OUTPUT should look like this
abc
kls
lmn
ops (6 Replies)
Hello
I have file that consist of 2 columns of millions of entries
timestamp and throughput
I want to find the average (throughput ) for each equal timestamp before change it to proper format
e.g : i want to average 2 coloumnd fot all 1308154800 values in column 1
and then
print... (4 Replies)
Hello all, I need to compute a row-wise average of files with a single column based on the pattern of the filenames. I really appreciate any help on this. it would just be very difficult to do them manually as the rows are mounting to 100,000 lines. the filenames are as below with convention as... (2 Replies)
Hello everyone
I am doing a join command. Obviously, before I need two files sorted first. ( Both files have headers and have about 2 million lines each one )
The problem is, one of the files has null values in the key to sort (which is the first filed ). For example I have the original... (4 Replies)
Hi All ,
below is my shell program.
!/bin/sh
set -x
#----------------------------------------------------------------------------------------
# Program : weekly_remove_icd_file.sh
# Author :
# Date : 04/06/2013
# Purpose : Execute the script to... (3 Replies)
hi,
I had a small question.I had a file from which i need to extract data.
I have written the below script to check if the file exists and if it exists extract requierd columns from the file.
IFILE=/home/home01/Report_1.csv
OFILE=/home/home01/name.csv.out1
if #Checks if file exists... (1 Reply)
I have a file of the form.
16:00:26,83.33 16:05:26,83.33 16:10:26,83.33 16:15:26,83.33 16:20:26,90.26 16:25:26,83.33 16:30:26,83.33 17:00:26,83.33 17:05:26,83.33 17:10:26,83.33 17:15:26,83.33 17:20:26,90.26 17:25:26,83.33 17:30:26,83.33
For the timestamp 16:00:00 to 16:55:00, I need to... (5 Replies)
Discussion started by: Saidul
5 Replies
LEARN ABOUT MOJAVE
cexpf
CEXP(3) BSD Library Functions Manual CEXP(3)NAME
cexp -- complex exponential function
SYNOPSIS
#include <complex.h>
double complex
cexp(double complex z);
long double complex
cexpl(long double complex z);
float complex
cexpf(float complex z);
DESCRIPTION
cexp(z) returns the complex exponential of z.
cexp(conj(z)) = conj(cexp(z)), for all complex floating-point numbers z.
SPECIAL VALUES
The conjugate symmetry of cexp() is used to abbreviate the specification of special values.
cexp(+-0 + 0i) returns 1 + 0i.
cexp(x + inf i) returns NaN + NaN i, and raises the invalid flag, for finite x.
cexp(x + NaN i) returns NaN + NaN i, for finite x.
cexp(inf + 0i) returns inf + 0i.
For the following two cases, cis(y) denotes cos(y) + I*sin(y).
cexp(-inf + yi) returns 0*cis(y), for finite y.
cexp(inf + yi) returns inf*cis(y), for finite nonzero y.
cexp(-inf + inf i) returns -0 + 0i.
cexp(inf + inf i) returns -inf + NaN i, and raises the invalid flag.
cexp(-inf + NaN i) returns -0 + 0i.
cexp(inf + NaN i) returns -inf + NaN i.
cexp(NaN + 0i) returns NaN + 0i.
cexp(NaN + yi) returns NaN + NaN i for all nonzero numbers y.
cexp(NaN + NaN i) returns NaN + NaN i.
SEE ALSO exp(3)clog(3)complex(3)STANDARDS
The cexp() function conforms to ISO/IEC 9899:2011.
4th Berkeley Distribution December 11, 2006 4th Berkeley Distribution
03-22-2012
