擅长:python、mysql、java
<p>获取所有3列:</p>
<pre><code>import pandas as pd
df = pd.DataFrame(["message1 message2 notmessage",
"message1 message2",
"message1 message2 message3 notmessage"
],
columns=["Column1"]
)
df['A'] = df['Column1'].str.extract('(^\w+)',
expand=True
)
df['b'] = df['Column1'].str.extract('(?<=\s)(\w+).*',
expand=True
)
df['c'] = df['Column1'].str.extract('(\w+3).*',
expand=True
)
print(df)
</code></pre>
<p>结果:</p>
<pre><code> Column1 A b c
0 message1 message2 notmessage message1 message2 NaN
1 message1 message2 message1 message2 NaN
2 message1 message2 message3 notmessage message1 message2 message3
</code></pre>