Python数据分析（6）数据转换和数据聚合

#coding=gbk
#数据处理
import numpy as np
import pandas as pd
#轴向旋转：按照行重新调整列的顺序，或者相反
frame=pd.DataFrame(np.arange(9).reshape(3,3),
                   index=['white','blue','black'],
                   columns=['ball','book','pen'])
print(frame)
#        ball  book  pen
# white     0     1    2
# blue      3     4    5
# black     6     7    8
s=frame.stack()
print(s)
# white  ball    0    入栈函数，将DataFrame转换成Series对象
#        book    1
#        pen     2
# blue   ball    3
#        book    4
#        pen     5
# black  ball    6
#        book    7
#        pen     8
# dtype: int32
f=s.unstack()   #出栈函数
print(f)
#        ball  book  pen
# white     0     1    2
# blue      3     4    5
# black     6     7    8

#coding=gbk
#数据处理
import numpy as np
import pan