<p>非常感谢你的帮助</p>
<p>我试着这样做。我相信有更好的代码</p>
<pre><code>import pandas as pd # Import the data
df = pd.DataFrame({'EmployeeId': ['157', '292', '643', '124', '355'],
'City': ['Mumbai|Bangalore', 'Pune|Mumbai|Delhi', 'Mumbai|Bangalore', 'Mumbai|Pune', 'Bangalore']})
#print(df)
df1 = df["City"].str.split("|", expand=True).stack().reset_index(level=1, drop=True)
#print(df1)
df2 = pd.concat([df, df1], axis=1, sort=False)
#print(df2)
df2 = df2.drop(["City"], axis=1)
#print(df2)
df2.loc[(df2["EmployeeId"].duplicated() ), ["EmployeeId"]] = ''
df2.columns = ['EmployeeId', 'City New']
print(df2)
df2.to_html('test1.html')
</code></pre>
<p>输出:</p>
<pre><code> EmployeeId City New
0 157 Mumbai
0 Bangalore
1 292 Pune
1 Mumbai
1 Delhi
2 643 Mumbai
2 Bangalore
3 124 Mumbai
3 Pune
4 355 Bangalore
</code></pre>
<p>将其导出到html时,我得到以下信息:</p>
<p><a href="https://i.stack.imgur.com/JexsG.png" rel="nofollow noreferrer">Image 1: With Grid</a></p>
<p>是否有任何方式可以在没有网格的情况下导出它(可能有样式)</p>
<p><a href="https://i.stack.imgur.com/fxrAc.png" rel="nofollow noreferrer">Image 2: Without Grid</a></p>