擅长:python、mysql、java
<p>您可以使用<code>str.split('>')</code>简单地拆分并展开数据帧</p>
<pre><code>import pandas as pd
d = {'col1': ['a>b>c'],'col2':['a>b>c']}
df = pd.DataFrame(data=d)
print(df)
col='col1'
#temp = df[col].str.split('>',expand=True).add_prefix(col)
temp = df[col].str.split('>',expand=True).rename(columns=lambda x: col + str(int(x)+1))
temp.merge(df,left_index=True,right_index=True,how='outer')
</code></pre>
<p>输出:</p>
<pre><code> col1 col11 col12 col13
0 a>b>c a b c
</code></pre>
<p>如果你想在多个列上做,你也可以</p>
<pre><code>for col in df.columns:
temp = df[col].str.split('>',expand=True).rename(columns=lambda x: col + str(int(x)+1))
df = temp.merge(df,left_index=True,right_index=True,how='outer')
</code></pre>
<p>输出:</p>
<pre><code> col21 col22 col23 col11 col12 col13 col1 col2
0 a b c a b c a>b>c a>b>c
</code></pre>