擅长:python、mysql、java
<p>我想你是在尝试多索引。此代码直接来自文档:<br/>
<a href="https://pandas.pydata.org/pandas-docs/stable/user_guide/cookbook.html#cookbook-multi-index" rel="nofollow noreferrer">https://pandas.pydata.org/pandas-docs/stable/user_guide/cookbook.html#cookbook-multi-index</a></p>
<pre><code> row One_X One_Y Two_X Two_Y
0 0 1.1 1.2 1.11 1.22
1 1 1.1 1.2 1.11 1.22
2 2 1.1 1.2 1.11 1.22
# As Labelled Index
In [76]: df = df.set_index('row')
In [77]: df
Out[77]:
One_X One_Y Two_X Two_Y
row
0 1.1 1.2 1.11 1.22
1 1.1 1.2 1.11 1.22
2 1.1 1.2 1.11 1.22
# With Hierarchical Columns
In [78]: df.columns = pd.MultiIndex.from_tuples([tuple(c.split('_'))
....: for c in df.columns])
....:
In [79]: df
Out[79]:
One Two
X Y X Y
row
0 1.1 1.2 1.11 1.22
1 1.1 1.2 1.11 1.22
2 1.1 1.2 1.11 1.22
</code></pre>