擅长:python、mysql、java
<p>这是我的版本,不足以回答一句话,但希望它能帮助你!在</p>
<pre><code>import pandas as pd
import numpy as np
data = [['1', 'Toy Story (1995)', "Animation|Children's|Comedy"],
['2', 'Jumanji (1995)', "Adventure|Children's|Fantasy"],
['3', 'Grumpier Old Men (1995)', 'Comedy|Romance']]
cols = ['MovieID', 'Name', 'Year', 'Adventure', 'Children', 'Comedy', 'Fantasy', 'Romance']
final = []
for x in data:
output = []
output.append(x[0])
output.append(x[1].split("(")[0].lstrip().rstrip())
output.append(x[1].split("(")[1][:4])
for h in ['Adventure', 'Children', 'Comedy', 'Fantasy', 'Romance']:
output.append(h in x[2])
final.append(output)
df = pd.DataFrame(final, columns=cols)
print(df)
</code></pre>
<p><strong>输出:</strong></p>
^{pr2}$