擅长:python、mysql、java
<p>您可以通过每个组的最大和最小日期时间找到差异,将时间增量转换为天,然后使用<a href="http://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.cut.html" rel="nofollow noreferrer">^{<cd1>}</a>进行装箱:</p>
<pre><code>df['Date'] = pd.to_datetime(df['Date'], dayfirst=True)
df['Days'] = df.groupby('Location')['Date'].transform(lambda x: x.max() - x.min()).dt.days
df['Rating'] = pd.cut(df['Days'], bins=[0, 150, 200, 250, 367], labels=False).add(1)
</code></pre>