Creating a new percentage summary file Post: 302655669

Sponsored Content

Top Forums Shell Programming and Scripting Creating a new percentage summary file Post 302655669 by fozrun on Wednesday 13th of June 2012 01:45:00 PM

06-13-2012

Registered User

Yes across the rows

The display is indeed poor, is this better?

So for Prevotellaceae, D1 the result would be =923/3323
Xylanibacter sample D17 would be =41/4704

Code:

taxlevel	 rankID	             taxon	             daughterlevels	 total	        D1	D13	 D17	D19	
0	           0	                     Root	             1	                         167944	3323	4018	4704	3634	
1	           0.1	                     Bacteria	     25	                 167944	3323	4018	4704	3634
5	           0.1.7.4.1.18	     Prevotellaceae     3	                        38447	923	1198	1727	1267
6	           0.1.7.4.1.18.2	     Prevotella	      1	                        24834	658	915	1235	734
7	           0.1.7.4.1.18.2.1     unclassified	      0	                        24834	658	915	1235	734
6	           0.1.7.4.1.18.3	     Xylanibacter	      1	                        756	        3	2	41	3
7	           0.1.7.4.1.18.3.1     unclassified	      0	                        756	        3	2	3	0
6	           0.1.7.4.1.18.5	     uncultured	      1	                        12857	262	281	451	533	
7	           0.1.7.4.1.18.5.1     unclassified	      0	                        12857	262	281	451	533	
5	           0.1.7.4.1.19	     RF16	              1	                        2196	        14	39	77	5

---------- Post updated at 11:45 AM ---------- Previous update was at 11:41 AM ----------

The display is indeed poor, is this better (still can't get it quite right)?

So for Prevotellaceae, D1 the result would be =923/3323
Xylanibacter sample D17 would be =41/4704

Code:

taxlevel	 rankID	             taxon	             daughterlevels	 total	        D1	D13	 D17	D19	
0	           0	                     Root	             1	                    167944	3323	4018	4704	3634	
1	           0.1	                     Bacteria	     1                           167944	3323	4018	4704	3634
5	           0.1.7.4.1.18	     Prevotellaceae     3	                        38447	923	1198	1727	1267
6	           0.1.7.4.1.18.2	     Prevotella	      1	                        24834	658	915	1235	734
7	           0.1.7.4.1.18.2.1     unclassified	      0	                        24834	658	915	1235	734
6	           0.1.7.4.1.18.3	     Xylanibacter	      1	                        756	        3	2	41	3
7	           0.1.7.4.1.18.3.1     unclassified	      0	                        756	        3	2	3	0
6	           0.1.7.4.1.18.5	     uncultured	      1	                        12857	262	281	451	533	
7	           0.1.7.4.1.18.5.1     unclassified	      0	                        12857	262	281	451	533	
5	           0.1.7.4.1.19	     RF16	              1	                        2196	        14	39	77	5

fozrun

View Public Profile for fozrun

Find all posts by fozrun

8 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Create Summary file containg information

Folks, I have multiple files in a folder containing some information (there is around 100 of them). What I would like to do would be able to import some of the information into a summary text file so that it will be easier to read a glance. The name of the files all start with the naming...

2. Shell Programming and Scripting

Need to find the percentage of the directory in the file system.

Hi All, I want to find the percentage occupied by the directory in the file system. Say, i have the file system /home/arun/work under this file system i have the directories /home/arun/work/yesterday /home/arun/work/today /home/arun/work/tomorrow The size of the file system is...

3. Shell Programming and Scripting

awk script to count percentage from log file

Hi, I have a log like this : actually i want to get the log like this : where % can get from : 100 * pmTotNoRrcConnectReqSucc / pmTotNoRrcConnectReq Thanks in advance.. :)

4. AIX

File system percentage to the hole size ?

Hi, I'd like to know how can I figure out my disk space area on AIX machine, for example to the situation of ( df -g ) which I have in my system : the area used by (/opt/oracle) file system is (98%) now. the free area on (/opt/oracle) is (0.75) now. the total size in Gigabyte...

5. Shell Programming and Scripting

Using awk to create a summary of a structured file

I am trying to use awk to create a summary of a structured file. Here is what it looks like: (random text) H1 H2 H3 H4 44 78 99 30 31 -- 32 21 12 33 55 21 I'd like to be able to specify a column, say H2, and then have information about that column printed. ...

6. Shell Programming and Scripting

How to calculate what percentage of X value is there in the file?

Input File: 5081 2058 175 8282 2358 7347 6612 3459 END OF INPUT FILE I need to know how to calculate minimum,maximum,average of the values in the file and also what percentage is the values over some user defined value for example 1000 and what percentage of value is over 5000. By...

7. Shell Programming and Scripting

Summary report csv file

Hello, I have 2 csv files with 4 columns each. file1.csv A, AA, AAA, AAAA B, BB, BBB, BBBB file2.csv C, CC, CCC, CCCC D, DD, DDD, DDDD I would like to use shell commands (sed, awk...) to copy the content of the 2 files (2x4 columns) into a final csv template file. Expected...

8. Shell Programming and Scripting

Help with awk percentage calculation from a file

i have a file say test with the below mentioned details Folder Name Total space Space used /test/test1 500.1GB 112.0 GB /test/test2 3.2 TB 5TB /test/test3 3TB 100GB i need to calculate percentage of each row based on total space and space used and copy...

LEARN ABOUT DEBIAN

racount

RACOUNT(1)						      General Commands Manual							RACOUNT(1)

NAME

       racount - count things from an argus(8) data file/stream.

COPYRIGHT

       Copyright (c) 2000-2003 QoSient. All rights reserved.

SYNOPSIS

       racount -r argus-file [ra options]

DESCRIPTION

       Racount reads argus data from an argus-file list, and prints out various counts from the data in the file.

OPTIONS

       Racount, like all ra based clients, supports a number of ra options including filtering of input argus records through a terminating filter
       expression.  See ra(1) for a complete description of ra options.

EXAMPLE INVOCATION

       racount -r argus.file
       racount	  records	total_pkts	   src_pkts	    dst_pkts	  total_bytes	     src_bytes	      dst_bytes
	   sum	      279	      1112		661		 451	       165567		 94561		  71006

       racount -ar argus.file
       racount	  records	total_pkts	   src_pkts	    dst_pkts	  total_bytes	     src_bytes	      dst_bytes
	   tcp	       47	       777		405		 372	       119782		 66541		  53241
	   udp	      135	       180		137		  43		35987		 20466		  15521
	  icmp	       18		47		 40		   7		 3318		  2814		    504
	    ip	       50		50		 50		   0		 3000		  3000		      0
	   arp	       29		58		 29		  29		 3480		  1740		   1740
	   sum	      279	      1112		661		 451	       165567		 94561		  71006

       racount -r argus.file - tcp and retrans
       racount	  records	total_pkts	   src_pkts	    dst_pkts	  total_bytes	     src_bytes	      dst_bytes
	   tcp	       15	       276		141		 135		22073		  8758		  13315

AUTHORS

       Carter Bullard (carter@qosient.com).

SEE ALSO

       ra(1), rarc(5), argus(8) tcpdump(1),

								 07 November 2000							RACOUNT(1)