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

hfsc

HFSC(8)                                                                Linux                                                               HFSC(8)

NAME

       HFSC - Hierarchical Fair Service Curve's control under linux

SYNOPSIS

       tc qdisc add ... hfsc [ default CLASSID ]

       tc class add ... hfsc [ [ rt SC ] [ ls SC ] | [ sc SC ] ] [ ul SC ]

       rt : realtime service curve
       ls : linkshare service curve
       sc : rt+ls service curve
       ul : upperlimit service curve

       o at least one of rt, ls or sc must be specified
       o ul can only be specified with ls or sc

       SC := [ [ m1 BPS ] d SEC ] m2 BPS
              m1 : slope of the first segment
              d  : x-coordinate of intersection
              m2 : slope of the second segment

       SC := [ [ umax BYTE ] dmax SEC ] rate BPS
              umax : maximum unit of work
              dmax : maximum delay
              rate : rate

       For description of BYTE, BPS and SEC - please see UNITS section of tc(8).

DESCRIPTION (qdisc)
       HFSC qdisc has only one optional parameter - default. CLASSID specifies the minor part of the default classid, where packets not classified
       by other means (e.g. u32 filter, CLASSIFY target of iptables) will be enqueued. If default is not specified, unclassified packets  will  be
       dropped.

DESCRIPTION (class)
       HFSC  class is used to create a class hierarchy for HFSC scheduler. For explanation of the algorithm, and the meaning behind rt, ls, sc and
       ul service curves - please refer to tc-hfsc(7).

       As you can see in SYNOPSIS, service curve (SC) can be specified in two ways. Either as maximum delay for certain amount of work,  or  as  a
       bandwidth assigned for certain amount of time. Obviously, m1 is simply umax/dmax.

       Both m2 and rate are mandatory. If you omit other parameters, you will specify linear service curve.

SEE ALSO

       tc(8), tc-hfsc(7), tc-stab(8)

       Please direct bugreports and patches to: <netdev@vger.kernel.org>

AUTHOR

       Manpage created by Michal Soltys (soltys@ziu.info)

iproute2                                                          31 October 2011                                                          HFSC(8)