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 ULTRIX
sa
sa(8) System Manager's Manual sa(8)Name
sa, accton - print process accounting statistics
Syntax
/etc/sa [ options ] [ file ]
/etc/accton [ file ]
Arguments
file With an argument naming an existing file, causes system accounting information for every process executed to be placed at the end
of the file. If no argument is given, accounting is turned off.
Description
The command reports on, cleans up, and generally maintains accounting files.
The is able to condense the information in into a summary file which contains a count of the number of times each command was called and
the time resources consumed. This condensation is desirable because on a large system can grow by 100 blocks per day. The summary file is
normally read before the accounting file, so the reports include all available information.
If a file name is given as the last argument, that file will be treated as the accounting file. The file is the default.
Output fields are labeled: "cpu" for the sum of user+system time (in cpu seconds), "re" for real time (also in cpu seconds), "k" for cpu-
time averaged core usage (in 1k units), "avio" for average number of I/O operations per execution. With options fields labeled "tio" for
total I/O operations, "k*sec" for cpu storage integral (kilo-core seconds), "u" and "s" for user and system cpu time alone (both in cpu
seconds) will sometimes appear.
Options-a List all command names including those containing unprintable characters and those used only once. By default, places all command
names containing unprintable characters and those used only once under the name `***other.'
-b Sort output by sum of user and system time divided by number of calls. Default sort is by sum of user and system times.
-c Besides total user, system, and real time for each command, print percentage of total time over all commands.
-d Sort by average number of disk I/O operations.
-D Print and sort by total number of disk I/O operations.
-f Force no interactive threshold compression with option.
-i Do not read in summary file.
-j Instead of total minutes for each category, give seconds per call.
-k Sort by cpu-time average memory usage.
-K Print and sort by cpu-storage integral.
-l Separate system and user time; normally they are combined.
-m Print number of processes and number of CPU minutes for each user.
-n Sort by number of calls.
-r Reverse order of sort.
-s Merge accounting file into summary file when done.
-t For each command, report ratio of real time to the sum of user and system times. If the sum of user and system times is too small
to report, `*ignore*' appears in this field.
-u Superseding all other flags, print for each command in the accounting file the user ID and command name.
-v Followed by a number n, types the name of each command used n times or fewer. Await a reply from the terminal; if it begins with
`y', add the command to the category `**junk**.' This is used to strip out garbage.
Restrictions
Accounting is suspended when there is less than 2% free space on disk. Accounting resumes when free space rises above 4%.
Files
Raw accounting
Summary
Per-user summary
See Alsoacct(2), ac(8)sa(8)