python (DataFrame练习01)
import pandas as pd
import numpy as np
onedic={}
onearray=np.loadtxt('League of Legends.csv',dtype=str,delimiter=',')
# oneframe=pd.DataFrame(onearray[1::],index=range(159,0,-1),columns=onearray[:1:,::].flatten())
oneframe = pd.DataFrame(onearray[1:10:], columns=onearray[:1:, ::].flatten())
# DataFrame取值先列(1轴),后行(0轴)
# print(oneframe['英雄名称'])
# print(type(oneframe['英雄名称']))
# print(oneframe['英雄名称'][2])
# print(oneframe.values) 类似于 numpy array
# print(oneframe.ndim)
# print(oneframe.shape)
# 如果要先0轴,后1轴,可以在nd.array里面操作
# print(oneframe.values[2:3:,2:3:])
# print(oneframe.values[2][2])
# 切片
# print(oneframe.loc[158:155:,'英雄称号':'蓝色精萃'])
#iloc
# print(oneframe.iloc[0:10,1::])
##set_index是找出index,不对原表重新排,只是单独拎出来,而set_index会对原表重新排列
# print(oneframe.set_index(keys=['英雄名称','英雄称号']))
twoframe=oneframe.set_index(keys=['英雄名称','英雄称号'],drop=True,inplace=False)
# twoframe=oneframe.set_index(keys=['英雄名称','英雄称号'],drop=True)
# print(oneframe)
# print(twoframe)
# print(twoframe.values)
# print(twoframe.index)
print(oneframe)
twoframe.reset_index(drop=False,inplace=True)
print(twoframe)
print(twoframe.values)