Beefy Boxes and Bandwidth Generously Provided by pair Networks
P is for Practical
 
PerlMonks  

Re: Pattern matching across two files, Need something better than grep -f!

by BrowserUk (Patriarch)
on Apr 10, 2012 at 20:23 UTC ( [id://964405]=note: print w/replies, xml ) Need Help??


in reply to Pattern matching across two files, Need something better than grep -f!

NOTE:The following code assumes that the whitespace in both files consists of single tabs.

Assuming the patterns file has less than say 15 million records, this should process the entire data file in less than 5 minutes:

#! perl -slw use strict; my %patterns; open PAT, '<', 'patterns.txt' or die $!; chomp, undef $patterns{ $_ } while <PAT>; close PAT; open DAT, '<', 'data' or die $!; while( <DAT> ) { my( $key, $v1, $v2 ) = m[(\S+\s+\S+)\s+(\S+)\s+(\S+)]; exists $patterns{ $key } and print "$key\t$v2"; } close DAT;

If the pattern file is a lot bigger than that -- ie. too big to build the hash in your memory -- then you would need to run multiple passes.

If you are seeking to reduce the time to much less than the above code takes, you'll need to look at parallelising the operation.


With the rise and rise of 'Social' network sites: 'Computers are making people easier to use everyday'
Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.

The start of some sanity?

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://964405]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others wandering the Monastery: (5)
As of 2024-03-28 18:32 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found