擅长:python、mysql、java
<p>试试这个</p>
<p><code>df['ranks'].str.split(', ', expand=True).rename(columns={0:'ranks',1:'url'}</code>)</p>
<pre><code> Keyword ranks search_type search_volume
0 kw1 [{'rank': 1, 'url': example.com}] 1 500
1 kw1 [{'rank': 1, 'url': example.com}] 2 500
2 kw2 [{'rank': 2, 'url': example.com}] 1 1500
3 kw2 [{'rank': 2, 'url': example.com}] 2 1500
4 kw3 [{'rank': 1, 'url': example.com}] 1 60
5 kw3 [{'rank': 1, 'url': example.com}] 2 60
ranks url
0 [{'rank': 1 'url': example.com}]
1 [{'rank': 1 'url': example.com}]
2 [{'rank': 2 'url': example.com}]
3 [{'rank': 2 'url': example.com}]
4 [{'rank': 1 'url': example.com}]
5 [{'rank': 1 'url': example.com}]
</code></pre>