python写入excel文件出现nan_python – 写入Excel(.xlsx)时Numpy.float64发生了变化

我注意到当某些Numpy float64值保存为Excel文件(通过Pandas DataFrame)时,它们会被更改.首先我认为这与Excel中的一些不精确有关,但Excel似乎将浮点数编码为双精度,所以我对这个观察有点困惑.

>>> import numpy as np

>>> import pandas as pd

# Create a floating point number that exhibits the problem.

>>> ba = bytearray(['\x53', '\x2a', '\xb0', '\x49', '\xf3', '\x79', '\x90', '\x40'])

>>> ba

bytearray(b'S*\xb0I\xf3y\x90@')

>>> f = np.frombuffer(ba)

>>> f[0]

1054.4875857854684

# Write to dataframe to save as Excel file.

>>> df = pd.DataFrame({'a': f})

>>> df.to_excel('test.xlsx', engine='xlsxwriter')

# Read excel file (when viewing the file in LibreOffice, the

# value isn't 1054.4875857854684 any more).

>>> df2 = pd.read_excel('test.xlsx