[已解决]能不能把df.info()中是object与其它的分开打印出来或提出来 ？请大师帮忙，谢谢

futui

能不能把df.info()dtype中列名，是object与其它的分开打印出来或提出来 ？请大师帮忙，谢谢

import pandas as pd

data = [["2345", "A", "2022-12-20", "2.1016", "-0.72","2.8", "-0.77",78],
        ["004243", "C", "2022-12-15", "2.0891", ", 45","-0.77",98],
        ["519212", "B", "2022-12-10", "333", "1.9733", "-0.77", "-3.29",567],
        ["162411", "E", "2022-12-9", "0.7071", "-1.64","25", "-1.46",789],
        ["007844", "FC", "2022-11-19", "0.6967", '8', "88","-1.46",834.8],
        ["163208", "G", "2022-11-10", "1.0440", "-0.40","" ,"-0.40",0.568]]
columns = ["编号", "名称", "日期", "AA", "BB","CC","DD","EE"]
df = pd.DataFrame(data, columns=columns)

print(df.info())

object :      "AA", "BB","CC","DD"
float64 :    "EE"

最佳答案

月排行榜 / 总排行榜

歌者文明清理员

2023-5-5 16:45:42

可以使用df.select_dtypes()方法来实现筛选想要的数据类型。示例如下：

```

1. import pandas as pd
   
2. 
   
3. data = [["2345", "A", "2022-12-20", "2.1016", "-0.72","2.8", "-0.77",78],
   
4.         ["004243", "C", "2022-12-15", "2.0891", ", 45","-0.77",98],
   
5.         ["519212", "B", "2022-12-10", "333", "1.9733", "-0.77", "-3.29",567],
   
6.         ["162411", "E", "2022-12-9", "0.7071", "-1.64","25", "-1.46",789],
   
7.         ["007844", "FC", "2022-11-19", "0.6967", '8', "88","-1.46",834.8],
   
8.         ["163208", "G", "2022-11-10", "1.0440", "-0.40","" ,"-0.40",0.568]]
   
9. columns = ["编号", "名称", "日期", "AA", "BB","CC","DD","EE"]
   
10. df = pd.DataFrame(data, columns=columns)
    
11. 
    
12. # 输出所有列的数据类型
    
13. print(df.dtypes)
    
14. 
    
15. # 输出object类型的列名
    
16. print(df.select_dtypes(include=['object']).columns.tolist())
    
17. 
    
18. # 输出非object类型的列名
    
19. print(df.select_dtypes(exclude=['object']).columns.tolist())

复制代码

```

输出结果如下所示:

```

1. 编号      object
   
2. 名称      object
   
3. 日期      object
   
4. AA      float64
   
5. BB       object
   
6. CC       object
   
7. DD       object
   
8. EE      float64
   
9. dtype: object
   
10. ['编号', '名称', '日期', 'BB', 'CC', 'DD']
    
11. ['AA', 'EE']

复制代码

```

跳转到最佳答案楼层

歌者文明清理员

可以使用df.select_dtypes()方法来实现筛选想要的数据类型。示例如下：

```

1. import pandas as pd
   
2. 
   
3. data = [["2345", "A", "2022-12-20", "2.1016", "-0.72","2.8", "-0.77",78],
   
4.         ["004243", "C", "2022-12-15", "2.0891", ", 45","-0.77",98],
   
5.         ["519212", "B", "2022-12-10", "333", "1.9733", "-0.77", "-3.29",567],
   
6.         ["162411", "E", "2022-12-9", "0.7071", "-1.64","25", "-1.46",789],
   
7.         ["007844", "FC", "2022-11-19", "0.6967", '8', "88","-1.46",834.8],
   
8.         ["163208", "G", "2022-11-10", "1.0440", "-0.40","" ,"-0.40",0.568]]
   
9. columns = ["编号", "名称", "日期", "AA", "BB","CC","DD","EE"]
   
10. df = pd.DataFrame(data, columns=columns)
    
11. 
    
12. # 输出所有列的数据类型
    
13. print(df.dtypes)
    
14. 
    
15. # 输出object类型的列名
    
16. print(df.select_dtypes(include=['object']).columns.tolist())
    
17. 
    
18. # 输出非object类型的列名
    
19. print(df.select_dtypes(exclude=['object']).columns.tolist())

复制代码

```

输出结果如下所示:

```

1. 编号      object
   
2. 名称      object
   
3. 日期      object
   
4. AA      float64
   
5. BB       object
   
6. CC       object
   
7. DD       object
   
8. EE      float64
   
9. dtype: object
   
10. ['编号', '名称', '日期', 'BB', 'CC', 'DD']
    
11. ['AA', 'EE']

复制代码

```

isdkz

您可以使用以下代码分别提取并打印对象类型（object）和非对象类型（非object）的列名：

1. import pandas as pd
   
2. 
   
3. data = [["2345", "A", "2022-12-20", "2.1016", "-0.72","2.8", "-0.77",78],
   
4.         ["004243", "C", "2022-12-15", "2.0891", ", 45","-0.77",98],
   
5.         ["519212", "B", "2022-12-10", "333", "1.9733", "-0.77", "-3.29",567],
   
6.         ["162411", "E", "2022-12-9", "0.7071", "-1.64","25", "-1.46",789],
   
7.         ["007844", "FC", "2022-11-19", "0.6967", '8', "88","-1.46",834.8],
   
8.         ["163208", "G", "2022-11-10", "1.0440", "-0.40","" ,"-0.40",0.568]]
   
9. columns = ["编号", "名称", "日期", "AA", "BB","CC","DD","EE"]
   
10. df = pd.DataFrame(data, columns=columns)
    
11. 
    
12. # 提取对象类型（object）和非对象类型（非object）的列名
    
13. object_columns = [col for col in df.columns if df[col].dtype == 'object']
    
14. non_object_columns = [col for col in df.columns if df[col].dtype != 'object']
    
15. 
    
16. # 打印结果
    
17. print("object: ", object_columns)
    
18. print("non-object: ", non_object_columns)
    

复制代码

这将输出：

1. object:  ['编号', '名称', '日期', 'AA', 'BB', 'CC', 'DD']
   
2. non-object:  ['EE']
   

复制代码

这样一来，您就可以看到哪些列是对象类型（object），哪些列是非对象类型（非object）。