title: Is there a module in Python that does something like "sqldf" for R?
body: <p>List comprehensions are very good. But some kind of "... Join ..." would be very useful. Thanks.
  So for example. I have a Set A= {1,0}, a list B = [[1,1],[2,3]]. I would like to find all rows in B where the second colomu is one of the values in A.  Or some thing more general, I have 2 CSV files. I want to find out all the rows where  the values of some colonm from the two files match. Just like some kind of 'join' of two files. One of the files is GB size. 
  <a href="http://code.google.com/p/sqldf/" rel="noreferrer">sqldf is <em>"SQL select on R data frames."</em></a></p>