擅长:python、mysql、java
<p>你几乎是对的。Pivot可以以这种方式工作,但是,它需要三件事:要透视的值、要透视的列和索引</p>
<p>我不认为有必要在这里手动计数</p>
<pre><code># Get number of entities in long list
n_entities = int(len(df)/len(column_names))
# Generates n-repetitions of column_names and assign to df for pivot
df['col_name'] = column_names * n_entities
# Generate and assign an index column
index_vals = []
for i in range(n_entities):
index_vals.extend([str(i)]*len(column_names))
df['index_val'] = index_vals
df.pivot(index = 'index_val', columns='col_name', values=0)
</code></pre>