Joining files in a complex way Post: 302401371

Sponsored Content

Top Forums Shell Programming and Scripting Joining files in a complex way Post 302401371 by stateperl on Friday 5th of March 2010 07:11:57 PM

03-05-2010

Banned

Joining files in a complex way

if input1 1st row labels (S1or S2 or S3 or any (actually so many in original text file)) are similar to 1st column of input2 i.e "ID" merge them together based on input1 1st row labels.
for example take S1.....

input1

Code:

"aphab"    "S1"    "S2"    "S3"
"a"    "A/A"    "A/A"    "A/A"
"b"    "A/G"    "A/G"    "A/A"
"c"    "A/A"    "G/G"    "A/A"
"d"    "G/G"    "A/G"    "A/G"
"e"    "A/G"    "G/G"    "A/G"
"f"     "A/A"    "G/G"    "A/G"
"g"    "A/A"    "G/G"    "G/G"
"h"    "A/A"    "G/G"    "G/G"
"I"     "A/A"    "G/G"    "G/G"

input2

Code:

"ID"    "Label"    "log"
"S1"    "xxx"    2.8
"S1"    "xxx"    3
"S1"    "xxx"    4
"S2"    "yyy"    6.8
"S2"    "yyy"    7
"S2"    "yyy"    7.4
"S2"    "yyy"    8
"S3"    "zzz"    12
"S3"    "zzz"    14
"S3"    "zzz"    16
"S3"    "zzz"    18
"S3"    "zzz"    20

output

Code:

"ID"    "Label"    "StYPE"    "Ntype"    "Stype_No"    "log"
"S1"    "xxx"    "A/A"    1    6    2.8
"S1"    "xxx"    "A/G"    2    2    3
"S1"    "xxx"    "G/G"    3    1    4
"S2"    "yyy"    "A/A"    1    1    6.8
"S2"    "yyy"    "A/G"    2    2    7
"S2"    "yyy"    "G/G"    3    6    7.4
"S2"    "yyy"    "NULL"    "null"    "null"    8
"S3"    "zzz"    "A/A"    1    3    12
"S3"    "zzz"    "A/G"    2    3    14
"S3"    "zzz"    "G/G"    3    3    16
"S3"    "zzz"    "NULL"    "null"    "null"    18
"S3"    "zzz"    "NULL"    "null"    "null"    20

4th column just prints 1 for A/A, 2 for A/G and 3 for G/G alphabets.(pink bold letters)
5th column in output.csv represnts number of time the alphabet corresponds specific label (S1-A/A=6 times, S1-A/G= 2 times and so on) repeated in input1.csv
6th column is just the corresponding S1/S2/S3 log values from input2. (S1 has 2.8,3 and 4)

Note: Null values are because of excess log values i.e there are log values but no Stype or Ntype etc... (S2 and S3 has excess log values and you can see them as null and logvalues in output)

Thanx in advance
Pearl

Last edited by stateperl; 03-05-2010 at 10:57 PM.. Reason: Wrong info in previous post and thanks to Tyler for pointing it out.

stateperl

View Public Profile for stateperl

Find all posts by stateperl

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

joining 2 files

Hi, I have two files that I need to find difference between. Do I use diff or join? If join, how do I use it? thanks, webtekie

2. Shell Programming and Scripting

Help with joining two files

Greetings, all. I've got a project that requires I join two data files together, then do some processing and output. Everything must be done in a shell script, using standard unix tools. The files look like the following: File_1 Layout: Acct#,Subacct#,Descrip Sample: ...

3. Shell Programming and Scripting

joining two or more files

i have three files file a has contents 123 234 238 file b has contents 189 567 567 and file c has contents qwe ert ery

4. Shell Programming and Scripting

Joining Three Files

Hi guys, I have three files which needs to be joined to a single file. File 1: Col a, Col b, Col c File 2: Col 1a, Col 1b File 3: Col 2a, Col 2b Output: Col 1a, Col 2a, Col a, Col b, Col c. All the files are comma delimited. I need to join Col b with Col 1b and need to...

5. UNIX for Dummies Questions & Answers

Joining two files

I have two comma separated files. I want to join those filesa nd put the result in separate file. smaple data are: file1: A1,1,100 A2,1,200 B1,2,100 B2,2,200 file2 1,50 1,25 1,25 1,100 1,100 2,50 2,50

6. Shell Programming and Scripting

Joining two files into one

Hi experts, I'm quite newbie here!! I have two seperate files. Contents of file like below File 1: 6213019212001 8063737 File:2 15703784 I want to join these two files into one where content will be File 3: 6213019212001 8063737 15703784 Regards, Ray Seilden

7. Shell Programming and Scripting

Help with joining files and adding headers to files

Hi, I have about 20 tab delimited text files that have non sequential numbering such as: UCD2.summary.txt UCD45.summary.txt UCD56.summery.txt The first column of each file has the same number of lines and content. The next 2 column have data points: i.e UCD2.summary.txt: a 8.9 ...

8. Shell Programming and Scripting

Joining 2 Files

File "A" (column names: Nickname Number GB) Nickname Number GB PROD_DB0034 100A 16 ASMIL1B_DATA_003 100B 16 PSPROD_0000 1014 36 PSPROD_0001 100D 223 ..... File "B" (column names: TYPE DEVICE NUMBER SIZE) TYPE DEVICE NUMBER SIZE 1750500 hdisk2 100A 16384 1750500 hdisk3 ...

9. Shell Programming and Scripting

Please help me in joining two files

I have two files with the below contents : sampleoutput3.txt 20150202;hostname1 20150223;hostname2 20150716;hostname3 sampleoutput1.txt hostname;packages_out_of_date;errata_out_of_date; hostname1;11;0; hostnamea;12;0; hostnameb;11;0; hostnamec;95;38; hostnamed;440;358;...

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

joining 2 files

Discussion started by: webtekie

2. Shell Programming and Scripting

Help with joining two files

Discussion started by: rjlohman

3. Shell Programming and Scripting

joining two or more files

Discussion started by: tomjones

4. Shell Programming and Scripting

Joining Three Files

Discussion started by: mac4rfree

5. UNIX for Dummies Questions & Answers

Joining two files

Discussion started by: pandeesh

6. Shell Programming and Scripting

Joining two files into one

Discussion started by: RayanS

7. Shell Programming and Scripting

Help with joining files and adding headers to files

Discussion started by: rrdavis

8. Shell Programming and Scripting

Joining 2 Files

Discussion started by: Daniel Gate

9. Shell Programming and Scripting

Please help me in joining two files

Discussion started by: rahul2662