擅长:python、mysql、java
<p>使用<strong>Regex:</strong></p>
<p><strong>演示:</strong></p>
<pre><code>import pandas as pd
df = pd.DataFrame({"Primary_key" : ["LIT1-1.10_t", "LIT1-1.20_t", "LIT4-1.77_t"]})
df["version_nr"] = df["Primary_key"].str.extract(r"\-(\d+)")
df["ID"] = df["Primary_key"].str.extract(r"\.(\d+)", )
print(df)
</code></pre>
<p><strong>输出:</strong></p>
^{pr2}$