python dataframe join

用Dataframe实现SQL中的inner join, left join, right join
首先准备二张表,df1, df2

import pandas as pddf1 = pd.DataFrame([{'col1':'a', 'col2':1}, {'col1':'b', 'col2':2}])df2 = pd.DataFrame([{'col1':'a', 'col3':11}, {'col1':'c', 'col3':33}])print df1print df2

df1

   co12 col10     1    a1     2    b

df2

   co13 col10    11    a1    33    c

inner join

print pd.merge(left=df1, right=df2, how='inner', left_on='col1', right_on='col1')----------   co12 col1  co130     1    a    11

left join

print pd.merge(left=df1, right=df2, how='left', left_on='col1', right_on='col1')----------   co12 col1  co130     1    a    111     2    b   NaN

right join

print pd.merge(left=df1, right=df2, how='left', left_on='col1', right_on='col1')----------   co12 col1  co130     1    a    111   NaN    c    33