You guys really helped me out in the past with manipulating some files with awk commands. Now, the output from the analysis program has changed and I would like to rework the data.
The output now looks something like file below, where the top row will contain 5 initial columns, followed by however many samples have been analysed. The file is tab delimited. I would like to get the percentage sequences, using the Bacteria in each sample as a denominator, above a certain threshold (say 0.005 (a half of a percent) occurring in at least one sample) and have the result in a new file.
Would become something like (calc errors possible, I did it by hand):
Xylanibacter would stay be in the table, as sample D17 is above the threshold, but 0.1.7.4.1.18.3.1 unclassified would not.
Yes, the data lines would start with 0.1 in the second column. However I need this to work over files with different numbers of samples (more or less columns) and incorporate a filter to get rid of low abundance samples (0.005 or greater not occurring in any row).
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... (9 Replies)
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... (2 Replies)
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... (2 Replies)
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. ... (4 Replies)
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... (1 Reply)
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.. :) (8 Replies)
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... (5 Replies)
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... (4 Replies)