11-10-2008
hi franklin..
Many thanks for your help.
The above script helped me find row wise percentage,total and average..
How about column level wise(percentage,total,average)...Can we still modify the script .Pls let me knw
Name M1 M2 M3
joy 55 66 77
ruby 77 88 99
saloni 88 44 33
regards
Whizkid
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have below awk statement and I need to convert the second field ( substr($0,8,6))from minutes to hours with 2 decimail place. How can I achieve this?
/usr/bin/awk '{print substr($0,23,4),substr($0,8,6)}' /tmp/MANAGER_LIST.$$ >> /tmp/NEWMANAGER_LIST.$$
Thanks for any help! (4 Replies)
Discussion started by: whatisthis
4 Replies
2. UNIX for Dummies Questions & Answers
Suppose I have 500 files in a directory and I need to Use awk to calculate average of column 3 for each of the file, how would I do that? (6 Replies)
Discussion started by: grossgermany
6 Replies
3. Shell Programming and Scripting
Hi
I need a awk script to calculate percentage.
I have to pass the pararmeters in to the awk script and calculate the percentage.
Sum = 50
passed = 43
failed = 7
I need to pass these value in to the awk script and calculate the percentage.
Please advice me. (8 Replies)
Discussion started by: bobprabhu
8 Replies
4. Shell Programming and Scripting
Hi
First field is the Record Type. A Record Type 5 can have multiple Record Type 6's before another Record Type 5 appears.
I want to calculate the total of fields at position 8-11 on Record type 6 when Record Type 5 has a field at position 11-14 equals to '2222'. then it should delete the lines... (2 Replies)
Discussion started by: appsguy616
2 Replies
5. Shell Programming and Scripting
Is there any awk command to calculate P Value ?(Probability)
Is it possib;e to calculate P va;ue for this data for ex?
7.891284
8.148193
7.749575
7.958188
7.887702
7.714877
8.141548
7.51845
8.27736
7.929853
7.92456
8.249126
7.989113
8.012573
8.351206 (2 Replies)
Discussion started by: stateperl
2 Replies
6. Shell Programming and Scripting
I want to make a bash shell script that accepts as argument a file name (cars.txt) and: 1) calculates the total price per year and per model.
2) For each car that it's number starts with TK, I want to print the surname and name of the owner and the total cost for them.
NBE3452... (3 Replies)
Discussion started by: Mark_orig
3 Replies
7. Shell Programming and Scripting
Hello,
I'm trying to create a shell script (#!/bin/sh) which should tell me the age of a file in minutes...
I have a process, which delivers me all 15 minutes a new file and I want to have a monitoring script, which sends me an email, if the present file is older than 20 minutes.
To do... (10 Replies)
Discussion started by: worm
10 Replies
8. Shell Programming and Scripting
I want to calculate the average line by line of some files with several lines on them, the files are identical, just want to average the 3rd columns of those files.:wall:
Example file:
File 1
001 0.046 0.667267
001 0.047 0.672028
001 0.048 0.656025
001 0.049 ... (2 Replies)
Discussion started by: AriasFco
2 Replies
9. Shell Programming and Scripting
Hi all,
I have a tab-delimited text file in which i have a few columns which look like,
X Y U V
2 3 4 5
4 5 3 4
6 4 3 2
For example, I want to calculate the ratio (X+Y)/(X+Y+U+V) for each row and print the output.
X Y U V ... (3 Replies)
Discussion started by: mehar
3 Replies
10. Shell Programming and Scripting
Trying to use awk to print the lines in file that have either REF or SNV in $3, add a header line, sort by $4 in numerical order. The below code does that already, but where I am stuck is on the last part where the total lines are counted and printed under Total_Targets, under Targets_less_than is... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT REDHAT
mpstat
MPSTAT(1) Linux User's Manual MPSTAT(1)
NAME
mpstat - Report processors related statistics.
SYNOPSIS
mpstat [ -P { cpu | ALL } ] [ -V ] [ interval [ count ] ]
DESCRIPTION
The mpstat command writes to standard output activities for each available processor, processor 0 being the first one. Global average
activities among all processors are also reported. The mpstat command can be used both on SMP and UP machines, but in the latter, only
global average activities will be printed.
The interval parameter specifies the amount of time in seconds between each report. A value of 0 indicates that processors statistics are
to be reported for the time since system startup (boot). The count parameter can be specified in conjunction with the interval parameter
if this one is not set to zero. The value of count determines the number of reports generated at interval seconds apart. If the interval
parameter is specified without the count parameter, the mpstat command generates reports continuously.
REPORTS
The report generated by the mpstat command has the following format:
CPU
Processor number. The keyword all indicates that statistics are calculated as averages among all processors.
%user
Show the percentage of CPU utilization that occurred while executing at the user level (application).
%nice
Show the percentage of CPU utilization that occurred while executing at the user level with nice priority.
%system
Show the percentage of CPU utilization that occurred while executing at the system level (kernel).
%idle
Show the percentage of time that the CPU or CPUs were idle.
intr/s
Show the total number of interrupts received per second by the CPU or CPUs.
OPTIONS
-P cpu | ALL
Indicate the processor number for which statistics are to be reported. cpu is the processor number. Note that processor 0 is the
first processor. The ALL keyword indicates that statistics are to be reported for all processors.
-V Print version number and usage then exit.
ENVIRONMENT
The mpstat command takes into account the following environment variable:
S_TIME_FORMAT
If this variable exists and its value is ISO then the current locale will be ignored when printing the date in the report header.
The mpstat command will use the ISO format (YYYY-MM-DD) instead.
EXAMPLES
mpstat 2 5
Display five reports of global statistics among all processors at two second intervals.
mpstat -P ALL 2 5
Display five reports of statistics for all processors at two second intervals.
BUGS
/proc filesystem must be mounted for the mpstat command to work.
Only a few activities are supplied by the Linux kernel for each processor.
FILES
/proc contains various files with system statistics.
AUTHOR
Sebastien Godard <sebastien.godard@wanadoo.fr>
SEE ALSO
sar(1), sadc(8), sa1(8), sa2(8), iostat(1), vmstat(8)
http://perso.wanadoo.fr/sebastien.godard/
Linux MAY 2000 MPSTAT(1)