擅长:python、mysql、java
<p>用<code>str.findall</code>和<code>groupby</code>检查</p>
<pre><code>for x , y in df.groupby(df.Description.str.findall(r'[0-9]+').str[0]):
print(y)
y.to_excel(str(x)+'.xlsx')
Index Description Quantity Date
0 1 Ketchup400J 5 5/10/2019
3 4 Ketchup400U 7 5/13/2019
5 6 Ketchup400U 9 5/15/2019
Index Description Quantity Date
1 2 Ketchup600J 4 5/11/2019
4 5 Ketchup600J 8 5/14/2019
Index Description Quantity Date
2 3 Ketchup800U 6 5/12/2019
6 7 Ketchup800i 5 5/16/2019
</code></pre>
<hr/>
<p>更新</p>
<pre><code>d={x : y for x , y in df.groupby(df.Description.str.findall(r'[0-9]+').str[0])}
d['400']
</code></pre>