Shell Programming and Scripting

root 25 oracle 25  batch 30  griduser 32 admin 35
root 25 oracle 25  batch 30  griduser 32
oracle 25  batch 30  griduser 32 xuser 45 admin 35

root 50 oracle 75  batch 90  griduser 64 user 45 admin 70

root 50 oracle 75 batch 90 griduser 96 user 45 admin 70

RC=`awk 'END { print NR }' $FILENAME`
RC=`expr $RC`
OBJNO=4
if [ "$RC" -ge 4 ]; then
             SETVAL=1
             OBJDETAIL=""
             FIELD1=1
             FIELD2=2
       until [ $OBJNO -eq $SETVAL ]; do
             DATAVAL=`cat $FILENAME | awk '{a[$'$FIELD1']+=$'$FIELD2'}END{for(i in a)print i,",",int((int(a[i])/NR))}' `
             SETVAL=`expr $SETVAL + 1`
             FIELD1=`expr $FIELD1 + 2`
             FIELD2=`expr $FIELD2 + 2`
             OBJDETAIL="$OBJDETAIL"",""$DATAVAL"
        done
     echo $OBJDETAIL
fi

awk '
        {
                for ( i = 1; i <= NF; i += 2 )
                        A[$i] += $( i + 1 )
        }
        END {
                for ( k in A )
                        printf "%s %s ", k, A[k]
                printf "\n"
        }
' file

# cat test.py
#!/usr/bin/env python
import re

text = '''root 25 oracle 25  batch 30  griduser 32 admin 35
root 25 oracle 25  batch 30  griduser 32
oracle 25  batch 30  griduser 32 xuser 45 admin 35'''

users = {}

for k,v in [i for i in re.findall('(?:([a-z]+)\s+(\d+))',text)]:
    if k in users:
        users[k] += int(v)
    else:
        users[k] = int(v)
print users

# ./test.py  
{'admin': 70, 'griduser': 96, 'xuser': 45, 'batch': 90, 'oracle': 75, 'root': 50}

awk '        {                for ( i = 1; i <= NF; i += 2 )                        A[$i] += $( i + 1 )        }        END {                for ( k in A )                        printf "%s %s ", k, A[k]                printf "\n"        }' file