擅长:python、mysql、java
<p>数据(temp.csv):</p>
<pre><code>Name,Book,Rating
John,Moby Dick, 5
John,The Alchemist, 3
John,The Da Vinci Code, 4
Peter,Moby Dick, 4
Peter,Lolita, 5
Mike,The Alchemist, 4
Mike,The Da Vinci Code, 3
</code></pre>
<p>代码:</p>
<pre><code>df = pd.read_csv('temp.csv')
print(df)
print(df.pivot(values='Rating', columns='Book', index='Name').fillna(0))
</code></pre>
<p><strong>输出</strong></p>
<pre><code>Book Lolita Moby Dick The Alchemist The Da Vinci Code
Name
John 0.0 5.0 3.0 4.0
Mike 0.0 0.0 4.0 3.0
Peter 5.0 4.0 0.0 0.0
</code></pre>