python3 readexcel pandas問題,Python Pandas read_excel無法識别空單元格

My excel sheet:

A B

1 first second

2

3

4 x y

5 z j

Python code:

df = pd.read_excel (filename, parse_cols=1)

return a correct output:

first second

0 NaN NaN

1 NaN NaN

2 x y

3 z j

If i want work only with second column

df = pd.read_excel (filename, parse_cols=[1])

return:

second

0 y

1 j

I'd have information about empty excel rows (NaN in my df) even if I work only with a specific column.

If output loose NaN information it's not ok, for example, for skiprows paramater, etc

Thanks

解決方案

For me works parameter skip_blank_lines=False:

df = pd.read_excel ('test.xlsx',

parse_cols=1,

skip_blank_lines=False)

print (df)

A B

0 first second

1 NaN NaN

2 NaN NaN

3 x y

4 z j

Or if need omit first row:

df = pd.read_excel ('test.xlsx',

parse_cols=1,

skiprows=1,

skip_blank_lines=False)

print (df)

first second

0 NaN NaN

1 NaN NaN

2 x y

3 z j