擅长:python、mysql、java
<p>以下3个步骤:</p>
<pre><code># 1. create a list in each row
df['SourceTechAttributes'] = (df['SourceTechAttributes']
.apply(lambda x: str(x).replace(" ", "")
.replace(":", ",")
.split(",")))
# 2. create a dictionary in each row
df['SourceTechAttributes'] = (df['SourceTechAttributes']
.apply(lambda x: dict(zip(x[::2], x[1::2]))))
# 3. create new columns
df['srcMediaFormat'] = (df['SourceTechAttributes']
.apply(lambda x: x['MediaFormat']))
</code></pre>
<p>我只创建了一个新列<code>srcMediaFormat</code>作为示例。在</p>