擅长:python、mysql、java
<p>我很确定有一个较短的方法解决这个问题,但您可以尝试以下方法:</p>
<pre><code>newdf = pd.DataFrame()
for index,row in df.iterrows():
if row['Name'].find('\\') != -1:
splitstr = row['Name'].split('\\')
domain = splitstr[0]
id = splitstr[1]
else:
domain = np.nan
id = row['Name']
final = pd.DataFrame([[row['Course'],row['Name'],domain,id]],columns=['Course','Name','Domain','Id'])
newdf = newdf.append(final)
</code></pre>