如何从Pandas的value_counts()中提取值名称和计数?
要提取值名称和计数,请先创建一个带有4个列的数据框 –
dataFrame = pd.DataFrame({"Car": ['BMW','Mustang','Tesla','Mustang','Mercedes','Tesla','Audi'],“Cubic Capacity”:[2000,1800,1500,2500,2200,3000,2000],“Reg Price”:[7000,1500,5000,8000,9000,6000,1500],“Units Sold”:[ 200, 120, 150, 120, 210, 250, 220]
})
获取特定Car列的值名称和计数 –
res = dataFrame ['Car'] .value_counts()
获取特定列Units Sold的值名称和计数 –
res = dataFrame ['Units Sold'] .value_counts()
样例
以下是完整代码 –
导入pandas as pd
# creating dataframe
dataFrame = pd.DataFrame({"Car": ['BMW','Mustang','Tesla','Mustang','Mercedes','Tesla','Audi'],“Cubic Capacity”:[2000,1800,1500,2500,2200,3000,2000],“Reg Price”:[7000,1500,5000,8000,9000,6000,1500],“Units Sold”:[ 200, 120, 150, 120, 210, 250, 220]
)
print(“数据框...\n”,dataFrame)
res = dataFrame ['Car'] .value_counts()
print(“\n从列Car显示值名称和计数:\n”,res)
res = dataFrame ['Units Sold'] .value_counts()
print(“\n从列Units Sold显示值名称和计数:\n”,res)
输出
这将产生以下输出 –
DataFrame ...
Car Cubic Capacity Reg Price Units Sold
0 BMW 2000 7000 200
1 Mustang 1800 1500 120
2 Tesla 1500 5000 150
3 Mustang 2500 8000 120
4 Mercedes 2200 9000 210
5 Tesla 3000 6000 250
6 Audi 2000 1500 220
从列Car显示值名称和计数:
Mustang 2
特斯拉 2
奥迪 1
宝马 1
梅赛德斯 1
Name:Car,dtype:int64
从列Units Sold显示值名称和计数:
120 2
150 1
220 1
210 1
250 1
200 1
Name:Units Sold,dtype:int64