擅长:python、mysql、java
<p>在将数据输入数据帧构造函数之前,应先清理数据。下面是一个简单的脚本:</p>
<pre><code>import pandas as pd
data = [['34', '345'],
['12', '23,534,34'],
['1', '13,42']]
new_data = []
for row in data:
x, yvals = row
for y in yvals.split(','):
new_data.append([x,y])
df = pd.DataFrame(new_data, columns=['UserID', 'ListID'])
</code></pre>