擅长:python、mysql、java
<p>试试熊猫<a href="https://pandas.pydata.org/pandas-docs/stable/reference/api/pandas.Series.str.contains.html" rel="nofollow noreferrer">^{<cd1>}</a></p>
<pre class="lang-py prettyprint-override"><code>d = {'col1': ['1 in', '2 mm', '3 ft', '4 yd', '5 m', '6cm']}
df = pd.DataFrame(data=d)
df['metric'] = df[df['col1'].str.contains(r'mm|cm|m')]['col1']
df['imperial'] = df[df['col1'].str.contains(r'in|ft|yd')]['col1']
print(df)
# col1 metric imperial
# 0 1 in NaN 1 in
# 1 2 mm 2 mm NaN
# 2 3 ft NaN 3 ft
# 3 4 yd NaN 4 yd
# 4 5 m 5 m NaN
# 5 6cm 6cm NaN
</code></pre>