AttributeError: 'DataFrame' object has no attribute 'dt'. Did you mean: 'at'?

这个错误通常是因为DataFrame对象没有dt属性，但是你尝试访问了它。正确的属性应该是dtypes，它返回一个Series，其中包含DataFrame中每列的数据类型。你可以使用以下代码来查看DataFrame中每列的数据类型：

import pandas as pd
data = pd.read_excel(r"C:\Users\ASUS\Desktop\0012\data7.1.2.xlsx")
print(data.dtypes)

如果你想查看特定列的数据类型，可以使用以下代码：

print(data['score'].dtype)

相关问题

AttributeError: DataFrame object has no attribute append . Did you mean: _append ?

This error occurs when you try to call the `append` method on a Pandas DataFrame object, but the object does not have an `append` attribute.

One possible reason for this error is that you are trying to append a DataFrame to another DataFrame using the `append` method, but you are not using it correctly. In Pandas, the `append` method does not modify the original DataFrame, but instead it returns a new DataFrame that contains the rows from both DataFrames. Therefore, you need to assign the result of the `append` method to a new variable or to the original DataFrame, like this:

df1 = pd.DataFrame({'A': [1, 2], 'B': [3, 4]})
df2 = pd.DataFrame({'A': [5, 6], 'B': [7, 8]})
df3 = df1.append(df2)

In this example, `df3` will contain the rows from both `df1` and `df2`.

If you are still getting the AttributeError, it's possible that the DataFrame object you are trying to append to does not have an `append` attribute. In this case, you can try using the `_append` attribute instead, which is a private method that is used internally by Pandas. However, be aware that using private methods may not be supported in future versions of Pandas and may cause unexpected behavior.

df1._append(df2)

AttributeError: DataFrame object has no attribute iteritems

AttributeError: 'DataFrame' object has no attribute 'iteritems' 是一个常见的错误，通常在使用较新版本的pandas库时出现。在较新的版本中，iteritems()方法已被弃用，并被items()方法所取代。

要解决这个错误，你需要将iteritems()方法替换为items()方法。下面是一个示例代码，演示如何使用items()方法来迭代DataFrame对象的键值对：

import pandas as pd

# 创建一个DataFrame对象
data = {'col1': [1, 2, 3], 'col2': ['A', 'B', 'C']}
df = pd.DataFrame(data)

# 使用items()方法迭代键值对
for key, value in df.items():
    print(key, value)

在上面的代码中，使用items()方法替代了iteritems()方法来迭代DataFrame对象的键值对。你可以根据实际需求来处理键值对的数据。

希望这个解决方法能帮助到你。如果你还有其他问题，请随时提问。