I am stuck with by DNA clustering analysis. I thought this forum will be a great help with data manipulations. Please help me.
I have a table with 91 columns. First I want to trim the table to only having rows where the column values are single characters which are A,T,G,C or 0. So any row having column values such as AA,AAG, AATG , Y, K etc has to be filtered out.
I figured out the regular expression will be something like [0ATGC]
Next I want to compare all the columns pairwise and group the columns which have the exact same values.The intermediate table output is not required.
Hi Bartus11
Can you also help me filter the single character values other than A,T,G,C and 0? Single characters like Y, M , R etc are present in my input which are not allowed.
Many Thanks
Hi,
i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file
I have tried with join and awk and i keep getting blank outputs or same file
is there an easier way than what i am... (4 Replies)
I am using awk to match columns and output based on those matches. For some reason it is not printing matching columns, am I missing something?
Operating system - windows with cygwin.
Command that I am using:
sed 's/]*,]*/,/g' $tempdir/file1 > $tempdir/file1.$$ && awk -F, 'FNR==NR{f2=$2... (7 Replies)
Hello All,
I want to make a file which will have primarily lines of file2 but when first 2 fields matches with the file1 it should have those lines of file1..
example is as below..
file1
a;b;1
c;d
f;e
t;r;5
file2
b;g
a;b
c;d
v;b
f;e
t;r (2 Replies)
Hi,
I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it.
Basically my data looks like this, with the TICKER columns matching up in each file
File1
TICKER,column 1, column, 2, column, 3, column 4
... (6 Replies)
Hello experts,
I have this problem, I need to match values based on two files, this is what I have:
file1
1.1
1.2
1.3
5.5
1.4
1.5
1.6
file2
1 a
2 B
3 C
4 D
5 z (7 Replies)
Hi to all,
I have two separated files:
FILE1
"V1" "V2" "V3"
Mary James Nicole
Robert Francisco Sophie
Nancy Antony Matt
Josephine Louise Rose
Mark Simon
Charles
FILE2
"V1" "V2" "V3"... (2 Replies)
Hey,
I have two files that have exactly the same format. They are both tab-delimited and contain 12 columns. However the # of rows vary. What I want to do is match columns # 5,6 and 7 between the two files. If they do match exactly (based on numbers) then I want the whole row from file 2 to... (1 Reply)