数据框分组的条形图 [英] Bar graph from dataframe groupby
本文介绍了数据框分组的条形图的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
df = pd.read_csv("arrests.csv")
df = df.replace(np.nan,0)
df = df.groupby(['home_team'])['arrests'].mean()
我正在尝试为数据框创建条形图.在home_team下是一堆团队名称.在逮捕中,每个日期都有许多逮捕.我基本上是按团队对数据进行分组,并得出该团队的平均逮捕人数.我正在尝试为此创建条形图,但由于一列没有标题,因此不确定如何进行操作.
I'm trying to create a bar graph for dataframe. Under home_team are a bunch of team names. Under arrests are a number of arrests at each date. I've basically grouped the data by teams with the average arrests for that team. I'm trying to create a bar graph for this but am not sure how to proceed since one column doesn't have a header.
推荐答案
从链接中复制数据并运行df = pd.read_clipboard()
copying data from your link and running df = pd.read_clipboard()
然后使用您的代码
df = df.replace(np.nan,0)
df = df.groupby(['home_team'])['arrests'].mean()
df.plot.bar()
这篇关于数据框分组的条形图的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文