|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Calculating average from files
Post 302960733 by summer_cherry on Thursday 19th of November 2015 04:13:02 AM
11-19-2015
Code:
awk 'BEGIN{
FS="[ ]+"
}
{
arr[$1]+=$5
brr[$1]+=1
}
END{
for(i in arr){
avg=arr[i]/brr[i]
print i,avg
}
}' a b| Moderator's Comments: | ||
|
Last edited by Don Cragun; 11-19-2015 at 06:05 PM.. Reason: ADD CODE tags again!
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
This is the cronjob
----------------------
root@a7germ:/home/paxtemp > crontab -l|grep test
57 * * * * /home/paxtemp/test_1.sh
0,5,10,15,20,25,30,35,40,45,50,55 * * * * /home/paxtemp/test.sh
root@a7germ:/home/paxtemp >
This is the contents of test.sh script... (2 Replies)
Discussion started by: kekanap
2 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: pk_eee
6 Replies
3. UNIX for Dummies Questions & Answers
Hi,
i have 12 float variables in a bash file and i want to calculate the average of them.
Can any body help? (6 Replies)
Discussion started by: limadario
6 Replies
4. UNIX for Dummies Questions & Answers
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)
Discussion started by: chen.xiao.po
3 Replies
5. Shell Programming and Scripting
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)
Discussion started by: CAch
1 Replies
6. Shell Programming and Scripting
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)
Discussion started by: ncwxpanther
3 Replies
7. Shell Programming and Scripting
I need to find the average from a file like:
data => BW:123 M:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0'
data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0'
data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0'
data => BW:123 N:30 RTD:0 1 0 1 0 0 1 1 1 1 0 0 1 1 0'
data => BW:123 N:30 RTD:0 1... (4 Replies)
Discussion started by: Slagle
4 Replies
8. Shell Programming and Scripting
Hi
I have 2 files
file1
aac 23 25
aac 87 90
aac 33 67
file2
23 0.9
24 0.8
25 0.4
........
67 0.55
........
I want to get output as (11 Replies)
Discussion started by: anurupa777
11 Replies
9. UNIX for Dummies Questions & Answers
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)
Discussion started by: stew
1 Replies
10. Shell Programming and Scripting
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)
Discussion started by: totoro125
22 Replies
LEARN ABOUT PHP
collator_sort_with_sort_keys
COLLATOR_SORT_WITH_SORT_KEYS(3) 1 COLLATOR_SORT_WITH_SORT_KEYS(3) Collator::sortWithSortKeys - Sort array using specified collator and sort keys Object oriented style SYNOPSIS
public bool Collator::sortWithSortKeys (array &$arr) DESCRIPTION
Procedural style bool collator_sort_with_sort_keys (Collator $coll, array &$arr) Similar to collator_sort(3) but uses ICU sorting keys produced by ucol_getSortKey() to gain more speed on large arrays. PARAMETERS
o $coll -Collator object. o $arr -Array of strings to sort RETURN VALUES
Returns TRUE on success or FALSE on failure. EXAMPLES
Example #1 collator_sort_with_sort_keys(3) example <?php $arr = array( 'Kopfe', 'Kypper', 'Kopfe' ); $coll = collator_create( 'sv' ); collator_sort_with_sort_keys( $coll, $arr ); var_export( $arr ); ?> The above example will output: array ( 0 => 'Kopfe', 1 => 'Kypper', 2 => 'Kopfe', ) SEE ALSO
Collator constants, collator_sort(3), collator_asort(3). PHP Documentation Group COLLATOR_SORT_WITH_SORT_KEYS(3)