Average is based on 2nd column if 2nd column values are in between 0-250000 average them then if values are in between 250001-500000 average them them if values are in between 500001-750000 average them the interval for each is 250000.
Your answer is almost near but i have huge data file to perform this so i may get error in final output.
Anyways thanks for replying.
---------- Post updated at 05:23 PM ---------- Previous update was at 05:05 PM ----------
Dear Guyz:)
I have 2 different input files like this. I would like to pick the values or letters from the inputfile2 based on inputfile1 keys (A,F,N,X,Z).
I have done similar task by using awk but in that case the inputfiles are similar like in inputfile2 (all keys in 1st column and values in... (16 Replies)
Hi,
I'm new to shell programming, can anyone help me on this? I want to do following operations -
1. Average salary for each country
2. Total salary for each city
and data that looks like -
salary country city
10000 zzz BN
25000 zzz BN
30000 zzz BN
10000 yyy ZN
15000 yyy ZN
... (3 Replies)
Hi,
I would like to calculate the average of column 'y' based on the value of column 'pos'.
For example, here is file1
id pos y c
11 1 220 aa
11 4333 207 f
11 5333 112 ee
11 11116 305 e
11 11117 310 r
11 22228 781 gg
11 ... (2 Replies)
I have a list of columns with values that I need to transform into a row containing the range of each column. For example:
"Column A"
1
2
3
4
10
12
14
15
16
17
18
"Column B"
1
4
5
6 (4 Replies)
Hello, I have a file with nearly 57K lines. I want to filter the lines based on the range of values in a column. For e.g. print lines whose 3rd filed is >=0.02.
Input file:
LOC_Os09g32030 LOC_Os02g18880 0.0200037219149773 undirected NA NA
LOC_Os03g58630 LOC_Os09g35690 ... (1 Reply)
Dear Experts,
Kindly help me please,
I have a big file where there is duplicate values in col 11 till col 23, every 2 rows appers a new numbers, but in each row there is different coordinates x and y in col 57 till col 74.
Please i will like to get a single value and average of the x and y... (8 Replies)
Hi,
My input file
Gene1 1
Gene1 2
Gene1 3
Gene1 0
Gene2 0
Gene2 0
Gene2 4
Gene2 8
Gene3 9
Gene3 9
Gene4 0
Condition:
If the first column matches, then look in the second column. If there is a value of zero in the second column, then don't consider that record while averaging.
... (5 Replies)
Im looking for a way to average the values in field 14 (when field 2 is equal to 2016) and fields 3 and 4 (when field 2 is equal to 2017).
Any help is appreciated.
001001 2016 33.22 38.19 48.07 51.75 59.77 67.68 70.86 72.21 66.92 53.67 42.31 40.15
001001 2017 ... (10 Replies)
Discussion started by: ncwxpanther
10 Replies
LEARN ABOUT HPUX
ruptime
ruptime(1) General Commands Manual ruptime(1)NAME
ruptime - show status of local machines
SYNOPSIS DESCRIPTION
outputs a status line for each machine on the local network that is running the daemon. status lines are formed from packets broadcast
once every 3 minutes between daemons (see rwhod(1M)) on each host on the network. Each status line has a field for the name of the
machine, the status of the machine (up or down), how long the machine has been up or down, the number of users logged into the machine, and
the 1-, 5- and 15-minute load averages for the machine when the packet was sent.
The status of the machine is reported as ``up'' unless no report has been received from the machine for 11 minutes or more.
The length of time that the machine has been up is shown as:
Load averages are the average number of jobs in the run queue over the last 1-, 5- and 15-minute intervals when the packet was sent.
An example status line output by might be:
The above status line would be interpreted as follows:
is presently ``up'' and has been up for 1 day, 5 hours and 15 minutes. It currently has 7 users logged in. Over the last 1-minute inter-
val, an average of 1.47 jobs were in the run queue. Over the last 5-minute interval, an average of 1.16 jobs were in the run queue. Over
the last 15-minute interval, an average of 0.80 jobs were in the run queue.
If a user has not used the system for an hour or more, the user is considered idle. Idle users are not shown unless the option is speci-
fied.
Options
If no options are specified, the listing is sorted by host name. Options change sorting order as follows:
Sort by load average.
Sort by up time.
Sort by the number of users.
Reverse the sort order.
DIAGNOSTICS
No status report files in
Ask the system administrator to check whether the daemon is running.
AUTHOR
was developed by the University of California, Berkeley.
FILES
Data files
SEE ALSO rwho(1), rwhod(1M).
ruptime(1)