Hi All
I like to know how can we calculate the number of rows and the average of the values present in the file. I will not know what will be the rowcount, which will be dynamic in nature of the file.
eg.
29
33
48
30
28 (6 Replies)
Dear all,
i have 200 values in a file. How can i calculate a weighted average and output into a new file avg.dat?
INPUT:
file1.dat
1.3453
2.434
2.345
.....
OUTPUT:
avg.dat
file1: 1.762
Thanks.
Po (3 Replies)
Hey guys.....
I have many files (lets say 100 or more) of same size, and I want to create a new output file and calculate the average of first row fifth column in all files and print it in first row of output file, then 2nd row fifth col in all 100 files and print it in 2nd row of output... (1 Reply)
Is there an awk script that can easily perform the following operation?
I have a data file that is in the format of
1944-12,5.6
1945-01,9.8
1945-02,6.7
1945-03,9.3
1945-04,5.9
1945-05,0.7
1945-06,0.0
1945-07,0.0
1945-08,0.0
1945-09,0.0
1945-10,0.2
1945-11,10.5
1945-12,22.3... (3 Replies)
Hi
I have file like below
111,victor,48,12,36
342,Peter,54,58,30
476,Scott,25,36,48
567,Patty,74,17,95
I have written below code to calcualte avereage for every id
Victor = 48+12+36/3
#!/bin/ksh
/usr/xpg4/bin/awk '
BEGIN {FS=","} {sum=0; n=0;i=3 (1 Reply)
Can anyone explain what each line of the code does and how it works? I have no experience with python so I am not sure how the arrays and such work. I found this code while looking through the forums.
f = open("exams","r")
l = f.readline()
while l:
l = l.split(" ")
values = l
... (22 Replies)
I have some files with the following contents.I would like to calculate average of fifth column. How can I do this with awk?
file1
cat 95.9 152 78.0 17.9
rat 67.1 153 36.5 30.6
dog 81.4 154 68.1 13.3
dog 92.0 155 55.5 36.5
rat 73.8 156 23.9 49.9
file2
rat... (4 Replies)
Discussion started by: avina
4 Replies
LEARN ABOUT OSF1
sum
sum(1) General Commands Manual sum(1)NAME
sum - Displays the checksum and byte count in block-size (1024) units of a file
SYNOPSIS
sum [-o | -r] [file...]
The sum command reads file and calculates a 16-bit checksum and the byte count in block-size (1024) units in the file. If the file argu-
ment is omitted, sum reads standard input.
STANDARDS
Interfaces documented on this reference page conform to industry standards as follows:
sum: XCU5.0
Refer to the standards(5) reference page for more information about industry standards and associated tags.
OPTIONS
[Tru64 UNIX] Uses an algorithm to compute the checksum using word-by-word computation. Uses an alternate algorithm to compute the check-
sum (rigorous byte-by-byte computation rather than the word-by-word computation).
[Tru64 UNIX] This is the default.
OPERANDS
The file for which a checksum is to be computed. If this operand is omitted, standard input is used.
DESCRIPTION
The checksum and number of blocks are written to standard output. The sum command is generally used to determine if a file that was copied
or communicated over transmission lines is an exact copy of the original. The sum command writes the space used in 1024-byte units.
[Tru64 UNIX] The checksum is calculated using a rigorous byte-byte computation by default.
System V Compatibility
[Tru64 UNIX] The checksum algorithms for the default sum command and the SVID 2 compliant sum command are reversed. The SVID 2 compliant
sum command uses the word-by-word algorithm by default and uses the byte-by-byte algorithm if you specify the -r option on the command
line.
NOTES
The sum utility is marked LEGACY in XCU Issue 5. [Tru64 UNIX] The default algorithm is no longer the word-by-word computation algorithm.
It was changed to the 4.3BSD default algorithm. The algorithms used may not be portable, that is, the same checksum may not be produced
for the same input on different systems. Portable applications should use cksum.
EXIT STATUS
The following exit values are returned: Successful completion. An error occurred.
EXAMPLES
To display the checksum of datafile and the number of blocks in this file, enter: sum datafile
If the checksum of datafile is 1605 and if the file contains 3 blocks, sum displays: 1605 3 datafile
ENVIRONMENT VARIABLES
The following environment variables affect the execution of sum: Provides a default value for the internationalization variables that are
unset or null. If LANG is unset or null, the corresponding value from the default locale is used. If any of the internationalization vari-
ables contain an invalid setting, the utility behaves as if none of the variables had been defined. If set to a non-empty string value,
overrides the values of all the other internationalization variables. Determines the locale for the interpretation of sequences of bytes
of text data as characters (for example, single-byte as opposed to multibyte characters in arguments). Determines the locale for the for-
mat and contents of diagnostic messages written to standard error. Determines the location of message catalogues for the processing of
LC_MESSAGES.
SEE ALSO
Commands: cksum(1), wc(1)
Standards: standards(5)sum(1)