def _prepareWeekdayByMonthStats(stats):
# Add day and month columns, and groupby
stats = stats.copy()
stats['day'] = stats['date'].dt.weekday
stats['month'] = stats['date'].dt.month
dataToPlot = stats.groupby(['day', 'month']).mean()
dataToPlot = dataToPlot.reset_index()
dataToPlot['day'].replace(dayOfWeek, inplace=True)
dataToPlot['month'].replace(months, inplace=True)
return dataToPlot
# def plotWeekdayStats(stats, columns):
# """
# Plot aggregated (mean) stats by dayOfWeek
# :param stats: data to plot
# :param columns: columns from stats to plot
# """
# MEASURE_NAME = 'weekday'
# dayOfWeek={0:'Mon', 1:'Tue', 2:'Wed', 3:'Thur', 4:'Fri', 5:'Sat', 6:'Sun'}
# order = ['Mon','Tue','Wed','Thur','Fri','Sat','Sun']
# stats[MEASURE_NAME] = stats[MEASURE_NAME].map(dayOfWeek)
#
# f, axes = getAxes(2,2)
# for i, c in enumerate(columns):
# if c in NAMES:
# c = NAMES[c]
# g = sns.barplot(x=MEASURE_NAME, y=c, data=stats, order=order, ax=axes[i])
# g.set_xlabel('')
# sns.plt.show()
# #plot(stats, columns, MEASURE_NAME, 2, 3, order=order)
评论列表
文章目录