pandas之重排分级数据到整数索引

# coding: utf-8import sys; print('Python %s on %s' % (sys.version, sys.platform))sys.path.extend(['F:\\c++\\callGBDT', 'F:/c++/callGBDT'])get_ipython().magic(u'save d:/log.txt')get_ipython().magic(u'save d:/log.txt%')get_ipython().magic(u'save d:\\\\log.txt%')get_ipython().magic(u'save -r d:\\\\log.txt%')import(/)get_ipython().magic(u'save :d:/log.txt')get_ipython().magic(u'save d:/log.txt')get_ipython().magic(u'save -r d:/log.txt')get_ipython().magic(u'save')get_ipython().magic(u'save log.txt')hhfrom pandas import *get_ipython().magic(u'save log.txt')get_ipython().magic(u'cls ')get_ipython().magic(u'save d:/log.txt')get_ipython().magic(u'save d:/log.txt 1:')get_ipython().magic(u'save d:/log.txt 1:1000')get_ipython().magic(u'cls')get_ipython().magic(u'cls ')frame=DataFrame(np.arange(12).reshape((4,3)),index=['a','a','b','b'],[1,2,1,2],columns=[['Ohio','Ohio','Colorado'],['Green','Red','Green']])frame=DataFrame(np.arange(12).reshape((4,3)),index=['a','a','b','b'],[1,2,1,2],columns=[['Ohio','Ohio','Colorado'],['Green','Red','Green']])import numpy as npframe=DataFrame(np.arange(12).reshape((4,3)),index=['a','a','b','b'],[1,2,1,2],columns=[['Ohio','Ohio','Colorado'],['Green','Red','Green']])from pandas import *import pandas as pd;frame=DataFrame(np.arange(12).reshape((4,3)),index=['a','a','b','b'],[1,2,1,2],columns=[['Ohio','Ohio','Colorado'],['Green','Red','Green']])frame=DataFrame(np.arange(12).reshape((4,3)),index=[['a','a','b','b'],[1,2,1,2]],columns=[['Ohio','Ohio','Colorado'],['Green','Red','Green']])frameframe.index.names=['key1','key2']frame.columns.names=['state','color']frameframe.swaplevel('key1','key2')frame.index.namesframeframe.sortlevel(1)frame.swaplevel(0,1).sortlevel(1)frame.swaplevel(0,1).sortlevel(0)frameframe.sum(level='key2')frameframe.sum(level='color',axis=1)frame =DataFrame({'a':range(7),'b':range(7,0,-1),'c':['one','one','one','one','two','two','two','two'],'d':[0,1,2,0,1,2,3]})frame =DataFrame({'a':range(7),'b':range(7,0,-1),'c':['one','one','one','two','two','two','two'],'d':[0,1,2,0,1,2,3]})frameframe2=frame.set_index(['c','d'])frame2frame2=frame.set_index(['c','d'],drop = False)frame2frame2.reset_index()ser=Series(np.arange(3.))ser[-1]serser2=Series(np.arange(3.),index=['a','b','c'])ser2ser[-1]ser2[-1]ser2serser.ix[:1]ser3=Series(range(3),index=[-5,1,3])ser3ser3.iget_value(2)frame=DataFrame(np.arange(6).reshape(3,2),index=[2,0,1])frameframe.irow(0)get_ipython().magic(u'save d:/log 1:1000')