Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with analysis data based on particular column content
Top Forums Shell Programming and Scripting Help with analysis data based on particular column content Post 302611097 by balajesuri on Thursday 22nd of March 2012 08:37:47 AM
Old 03-22-2012
Code:
perl -lane '
if (/Total_counts/) { $tot = $F[1]; print }
(/Number_of_count/) && printf "%s\t%s\t%6.2f\%\n", $F[0], $F[1], $F[1]*100/$tot;
(/Number_of_count_false/) && ($false += $F[1]);
(/Total_number_of_false/) && printf "%s\t%d\t%6.2f\%\n", $F[0], $tot-$false, ($tot-$false)*100/$tot' inputfile

Last edited by balajesuri; 03-22-2012 at 09:43 AM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Extract data based on match against one column data from a long list data

My input file: data_5 Ali 422 2.00E-45 102/253 140/253 24 data_3 Abu 202 60.00E-45 12/23 140/23 28 data_1 Ahmad 256 7.00E-45 120/235 140/235 22 data_4 Aman 365 8.00E-45 15/65 140/65 20 data_10 Jones 869 9.00E-45 65/253 140/253 18... (12 Replies)
Discussion started by: patrick87
12 Replies

2. Shell Programming and Scripting

How to add a new line between different column data content?

Input file: Germany 10 500 5000 Germany 20 500 5000 Germany 50 10 500 England 5 10 25 USA 30 25 55 USA 20 35 90 Japan 2 5 60 Singapore 50 30 90 Singapore 150 230 290 Output file: Germany 10 500 5000 Germany 20 500 5000 Germany 50 10 500 England 5 10 25 (7 Replies)
Discussion started by: patrick87
7 Replies

3. Shell Programming and Scripting

Change file content based on data

I have a Transaction File coming into the system. In this file, in all records the relevant data is as follows- Position 1:10 -> Transaction Code Position 252:255 -> 4 digit business code Now based on these 2 fields I have to alter value in Transaction code (Position 1:10)... (6 Replies)
Discussion started by: varunrbs
6 Replies

4. Shell Programming and Scripting

Help with merge two file based on similar column content

Input file 1: A1BG A1BG A1BG A1CF A1CF BCAS BCAS A2LD1 A2M A2M HAT . . Input file 2: A1BG All A1CF TEMP (5 Replies)
Discussion started by: perl_beginner
5 Replies

5. Shell Programming and Scripting

Help with replace column one content based on reference file

Input file 1 testing 10 20 1 A testing 20 40 1 3 testing 23 232 2 1 testing 10 243 2 . . Reference file 1 final 3 used . . Output file (2 Replies)
Discussion started by: perl_beginner
2 Replies

6. Shell Programming and Scripting

Help with replace column one content based on reference file

Input file 1 testing 10 20 1 A testing 20 40 1 3 testing 23 232 2 1 testing 10 243 2 . . Reference file 1 final 3 used . . Output file (1 Reply)
Discussion started by: perl_beginner
1 Replies

7. Shell Programming and Scripting

multiplication of two files based on the content of the first column

Hi, This is something that probably it is more difficult to explain than to do. I have two files e.g. FILE1 A15 8.3102E+00 3.2000E-04 A15 8.5688E+00 4.3000E-05 B13 5.1100E-01 1.9960E+00 B16 5.1100E-01 2.3000E-03 B16 8.6770E-01 1.0000E-07 B16 9.8693E-01 3.4000E-05... (4 Replies)
Discussion started by: f_o_555
4 Replies

8. Shell Programming and Scripting

Help with data rearrangement based on share same content

Input file data_2 USA data_2 JAPAN data_3 UK data_4 Brazil data_5 Singapore data_5 Indo data_5 Thailand data_6 China Desired output file data_2 USA/JAPAN data_3 UK data_4 Brazil data_5 Singapore/Indo/Thailand data_6 China I would like to merge all data content that share same... (2 Replies)
Discussion started by: perl_beginner
2 Replies

9. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

10. Shell Programming and Scripting

Print the column content based on the header

i have a input of csv file as below but the sequence of column get changed. I,e it is not necessary that name comes first then age and rest all, it may vary. name,age,marks,roll,section kevin,25,80,456,A Satch,23,56,789,B Meena,24,78,H245,C So i want to print that column entires which... (12 Replies)
Discussion started by: millan
12 Replies

LEARN ABOUT SUNOS

auditstat

auditstat(1M)						  System Administration Commands					     auditstat(1M)

NAME

       auditstat - display kernel audit statistics

SYNOPSIS

       auditstat [-c count] [-h numlines] [-i interval] [-n] [-v]

DESCRIPTION

       auditstat displays kernel audit statistics. The fields displayed are as follows:

       aud	The total number of audit records processed by the audit(2) system call.

       ctl	This field is obsolete.

       drop	The  total  number  of	audit  records that have been dropped. Records are dropped according to the kernel audit policy. See audi-
		ton(2), AUDIT_CNT policy for details.

       enq	The total number of audit records put on the kernel audit queue.

       gen	The total number of audit records that have been constructed (not the number written).

       kern	The total number of audit records produced by user processes (as a result of system calls).

       mem	The total number of Kbytes of memory currently in use by the kernel audit module.

       nona	The total number of non-attributable audit records that have been constructed. These are audit records that are  not  attributable
		to any particular user.

       rblk	The total number of times that auditsvc(2) has blocked waiting to process audit data.

       tot	The total number of Kbytes of audit data written to the audit trail.

       wblk	The total number of times that user processes blocked on the audit queue at the high water mark.

       wrtn	The  total  number of audit records written. The difference between enq and wrtn is the number of outstanding audit records on the
		audit queue that have not been written.

OPTIONS

       -c count        Display the statistics a total of count times. If count is equal to zero, statistics are displayed  indefinitely.   A  time
		       interval must be specified.

       -h numlines     Display	a  header  for every  numlines of statistics printed. The default is to display the header every 20 lines. If num-
		       lines is equal to zero, the header is never displayed.

       -i interval     Display the statistics every interval where interval is the number of seconds to sleep between each collection.

       -n	       Display the number of kernel audit events currently configured.

       -v	       Display the version number of the kernel audit module software.

EXIT STATUS

       auditstat returns 0 upon success and 1 upon failure.

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWcsu			   |
       +-----------------------------+-----------------------------+

SEE ALSO

       auditconfig(1M), praudit(1M), bsmconv(1M), audit(2), auditon(2), auditsvc(2), attributes(5)

NOTES

       The functionality described in this man page is available only if the Basic Security Module (BSM) has been enabled.  See   bsmconv(1M)  for
       more information.

SunOS 5.10							    6 May 1993							     auditstat(1M)
All times are GMT -4. The time now is 12:40 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy