擅长:python、mysql、java
<p>试试<a href="https://pandas.pydata.org/pandas-docs/stable/generated/pandas.cut.html" rel="nofollow noreferrer">pd.cut</a></p>
<pre><code>import pandas as pd
df = pd.DataFrame({'atomic':[6,34,70]})
bins = [0,5,10,20,25,50,100]
labels = bins[:-1] # [0,5,10,20,25,50]
df['binned'] = pd.cut(df.atomic, bins, labels=labels)
df
atomic binned
0 6 5
1 34 25
2 70 50
</code></pre>
<p>注意binned是一个“类别”而不是一个数字。如果你需要一个号码,请使用</p>
<pre><code>df['binned'] = pd.cut(df.atomic, bins, labels=labels).astype(int)
</code></pre>