擅长:python、mysql、java
<p>我想您需要先转换<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.to_datetime.html" rel="nofollow noreferrer">^{<cd1>}</a>列<code>starttime</code>。在</p>
<p>然后按<a href="http://pandas.pydata.org/pandas-docs/stable/indexing.html#boolean-indexing" rel="nofollow noreferrer">^{<cd3>}</a>过滤。在</p>
<p>如果所有<code>workday</code>都需要一个标量值,请使用<code>loc</code>来选择带有<code>mean</code>的列:</p>
<pre><code>def a4(rides):
rides['starttime'] = pd.to_datetime(rides['starttime'])
m = (rides['starttime'].dt.dayofweek < 5) & (rides['User Type'] == 'Subscriber')
return round(rides.loc[m, 'tripduration'].mean(), 2)
print (a4(rides))
825.33
</code></pre>
<p>如果每天需要分别使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.dt.dayofweek.html" rel="nofollow noreferrer">^{<cd7>}</a>添加新条件,然后使用聚合<code>mean</code>添加{a4}:</p>
^{pr2}$
<p>如果不需要天数,请使用<a href="http://pandas.pydata.org/pandas-docs/stable/generated/pandas.Series.dt.weekday_name.html" rel="nofollow noreferrer">^{<cd10>}</a>:</p>
^{3}$