Hello, I want to quickly match two files according to the first column. Thank you in advance for any help! Best, Yue 


Input tmp01:

PeptideID    ProteinID
6    109521
7    741
11    681
11    780
20    2352
27    1490
27    1491
27    1492
28    51996
29    1490
29    1491
29    1492
30    1490
30    1491
30    1492



Input tmp02:

PeptideID    SpectrumID    Sequence
6    53663    KMGEGR
7    53663    KPPSGK
11    144492    NNDALR
20    15547    SPAKPK
27    55547    LHKPPK
28    55547    LFVGRK
29    55504    LHKPPK
30    55602    LHKPPK


Output tmp11_quick:

PeptideID    ProteinID    SpectrumID    Sequence
6    109521    53663    KMGEGR
7    741    53663    KPPSGK
11    681    144492    NNDALR
11    780    144492    NNDALR
20    2352    15547    SPAKPK
27    1490    55547    LHKPPK
27    1491    55547    LHKPPK
27    1492    55547    LHKPPK
28    51996    55547    LFVGRK
29    1490    55504    LHKPPK
29    1491    55504    LHKPPK
29    1492    55504    LHKPPK
30    1490    55602    LHKPPK
30    1491    55602    LHKPPK
30    1492    55602    LHKPPK



#!/usr/bin/perl
use warnings;
use strict;

use Fcntl ':seek';


open my $TAB01, '<', 'tmp01' or die "Cannot open 'tmp01' because: $!";
open my $TAB02, '<', 'tmp02' or die "Cannot open 'tmp02' because: $!";
open my $OUT, '>', 'tmp11_QUICK' or die "Cannot open 'tmp12_01' becaus
+e: $!";

my $pos = tell $TAB01;
my %tab01_data;
while ( <$TAB01> ) {
    my ( $first,$second) = split /\t+/;
    print $OUT ",$_" unless length $first;
    push @{ $tab01_data{ $first } }, $pos;
    $pos = tell $TAB01;
    }


my %tab02_data;
while ( <$TAB02> ) {
    my ( $first,$second, $third ) = split /\t+/ ;
    next unless exists $tab01_data{ $first };
    for my $pos ( @{ $tab01_data{ $first } } ) {
        seek $TAB01, $pos, SEEK_SET or die "Cannot seek on 'tmp01' bec
+ause: $!";
        print $OUT "$tab01_data","$tab02_data{$second}" ,scalar <$TAB0
+1>;
        }
    }

close $TAB01;
close $TAB02;
close $OUT;

[download]

In reply to match two files by yueli711

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.