对我来说,工作参数
skip_blank_lines=False:
df = pd.read_excel ('test.xlsx',parse_cols=1,skip_blank_lines=False)print (df) A B0 first second1 NaN NaN2 NaN NaN3 x y4 z j或者,如果需要省略第一行:
df = pd.read_excel ('test.xlsx',parse_cols=1,skiprows=1, skip_blank_lines=False)print (df) first second0 NaN NaN1 NaN NaN2 x y3 z j


