擅长:python、mysql、java
<p>这样做</p>
<pre class="lang-py prettyprint-override"><code>import pandas as pd
tags = [
"letter1=A&letter2=B&letter3=C",
"letter1=D&letter2=E&letter3=F",
"letter1=G&letter2=H&letter3=I",
"letter1=J&letter2=K&letter3=L",
"letter1=M&letter2=N&letter3=O",
"letter1=P&letter2=R&letter3=S"
]
df = pd.DataFrame({"tags": tags})
df["letter1"] = df["tags"].apply(lambda x: x.split("&")[0].split("=")[-1])
df["letter2"] = df["tags"].apply(lambda x: x.split("&")[1].split("=")[-1])
df["letter3"] = df["tags"].apply(lambda x: x.split("&")[2].split("=")[-1])
df = df[["letter1", "letter2", "letter3"]]
df
</code></pre>
<p><a href="https://i.stack.imgur.com/iXUPE.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/iXUPE.jpg" alt="enter image description here"/></a></p>