python写入excel文件出现nan_在python中使用Pandas ExcelWriter时处理Nan

我想你可以用^{}：df = df.fillna(0)

或：df['A'] = df['A'].fillna(0)

但最好使用^{}：import pandas as pd

import numpy as np

# Create a Pandas dataframe from the data.

df = pd.DataFrame({'A': [10, 20, 30, 20, 15, 30, 45, np.nan],

'B': [10, 20, 30, 20, 15, 30, 45, np.nan]})

print df

A B

0 10 10

1 20 20

2 30 30

3 20 20

4 15 15

5 30 30

6 45 45

7 NaN NaN

#create subset, because cannot write Series to excel

df1 = df[['A']]

# Create a Pandas Excel writer using XlsxWriter as the engine.

writer = pd.ExcelWriter('f_name.xlsx', engine='xlsxwriter')

# Convert the dataframe to an XlsxWriter Excel object, instead NaN give 0

df1.to_excel(writer, sheet_name='PnL', na_rep=0)

如果要省略索引和头，请添加参数index=False和header=False：df1.to_excel(writer, sheet_name='PnL', na_rep=0, index=False, header=False)