pandas merge on_pandas.merge()

总的来说：pandas.merge()才是老大，merge/join 都是臭弟弟。

pandas.DataFrame.merge() 和pandas.DataFrame.join() 为了更加方便的实现数据的pandas.merge()的方法，

举例来说：一下两种方式是等价的。

df1.merge(right=df2, ...)

pandas.merge(left=df1, right=df2, ...).

具体说df.join()和df.merge()两个弟弟的区别:

1. 两表key值类型:
   1. df1.join(df2) 通常joindf2的index
   2. df1.merge(df2) 又可以用数据columns也是可以是index.
2. by default, df1.join(df2) uses the index of df1 and df1.merge(df2) uses column(s) of df1. That can be overridden by specifying
3. df1.join(df2, on=key_or_keys) or df1.merge(df2, left_index=True).
4. left vs inner join: df1.join(df2) does a left join by default (keeps all rows of df1), but df.merge does an inner join by default (returns only matching rows of df1 and df2)