python dataframe是否为空_python – 与空DataFrame合并

我正在尝试将数据帧(df1)与另一个df2可能为空的数据帧(df2)合并.合并条件是df1.index = df2.z(df1永远不会为空),但是我收到以下错误.

有没有办法让这个工作？

In [31]:

import pandas as pd

In [32]:

df1 = pd.DataFrame({'a': [1, 2, 3], 'b': [4, 5, 6], 'c': [1, 2, 3]})

df2 = pd.DataFrame({'x':[], 'y':[], 'z':[]})

dfm = pd.merge(df1, df2, how='outer', left_index=True, right_on='z')

---------------------------------------------------------------------------

IndexError Traceback (most recent call last)

in ()

----> 1 dfmb = pd.merge(df1, df2, how='outer', left_index=True, right_on='z')

/usr/local/lib/python2.7/dist-packages/pandas/tools/merge.pyc in merge(left, right, how, on, left_on, right_on, left_index, right_index, sort, suffixes, copy)

37 right_index=right_index, sort=sort, suffixes=suffixes,

3