尽管Pandas数据帧是不平等的

Question

我在Python 3.10.3上使用pandas==1.4.1和dython==0.7.1运行此测试。我从日期数据创建了一个简单的相关性数据帧，并将其和我期望得到的数据进行比较。尽管如此，根据Pandas的说法，DF并不相等，尽管它们具有相同的数据和相同的dtypes。我错过了什么？

import pandas as pd
from datetime import datetime, timedelta
from dython.nominal import associations
def test_datetime_data():
dt = datetime(2020, 12, 1)
end = datetime(2020, 12, 2)
step = timedelta(seconds=5)
result = []
while dt < end:
result.append(dt.strftime('%Y-%m-%d %H:%M:%S'))
dt += step
nums = list(range(len(result)))
df = pd.DataFrame({'dates':result, 'up': nums, 'down': sorted(nums, reverse=True)})
df['dates'] = pd.to_datetime(df['dates'], format="%Y-%m-%d %H:%M:%S")  # without this, this column is considered as object rather than dates
correct_corr = pd.DataFrame(columns=['dates', 'up', 'down'], index=['dates', 'up', 'down'],
data=[[1.0, 1.0, -1.0],
[1.0, 1.0, -1.0],
[-1.0, -1.0, 1.0]])
corr = associations(df, plot=False)['corr']
assert corr.equals(correct_corr), f'datetime associations are incorrect. Test should have returned an empty dataframe, received: {corr.head()}'

corr和correct_corr都是[[1.0, 1.0, -1.0], [1.0, 1.0, -1.0], [-1.0, -1.0, 1.0]]和float64，但测试仍然失败。。

Answer 1

您可能需要检查数据帧中的数据类型，以确保它们是相同的。

corr.info()
correct_corr.info()