In [1]:
import numpy as np
import pandas as pd
from pandas import Series, DataFrame
from numpy.random import randn
In [2]:
ser = Series(randn(6), index=[[1,1,1,2,2,2],['a','b', 'c', 'a', 'b', 'c']])
In [3]:
ser
Out[3]:
In [4]:
ser[1]
Out[4]:
In [5]:
ser[1]['a']
Out[5]:
In [6]:
ser[:,'a']
Out[6]:
In [7]:
dframe = ser.unstack()
In [8]:
dframe
Out[8]:
In [10]:
dframe2 = DataFrame(np.arange(16).reshape(4,4), index=[['a','a','b','b'],[1,2,1,2]],
columns=[['NY', 'NY', 'LA', 'SF'], ['cold', 'hot', 'hot', 'cold']])
dframe2
Out[10]:
In [11]:
dframe2.index.names
Out[11]:
In [12]:
dframe2.index.names = ['INDEX_1', 'INDEX_2']
dframe2.columns.names = ['Cities', 'Temp']
dframe2
Out[12]:
In [13]:
dframe2.swaplevel('Cities','Temp', axis=1)
Out[13]:
In [14]:
dframe2.sortlevel(1)
Out[14]:
In [16]:
dframe2.swaplevel('Cities','Temp', axis=1).sortlevel(0, axis=1)
Out[16]:
In [ ]: