pandas中对DataFrame结构的增删改查

1.自己定义一个DataFrame

data = [[1,2,3],[4,5,6]]
index = ['a','b']
columns = ['A','B','C']

df = pd.DataFrame(data=data,index=index,columns = columns)
df

2.查操作

df['A']
df.iloc[0]
df.loc['a']

3.改操作

df.loc['a']['A']
df.loc['a']['A'] = 150
df
df.index = ['f','g']
df

4.增操作

df.loc['c'] = [1,2,3]
df

data = [[1,2,3],[4,5,6]]
index = ['j','k']
columns = ['A','B','C']

df2 = pd.DataFrame(data=data,index=index,columns = columns)
df2

df3 = pd.concat([df,df2],axis = 0)
df3

df2['Tang'] = [10,11]
df2

df4 = pd.DataFrame([[10,11],[12,13]],index=['j','k'],columns=['D','E'])
df4

df5 = pd.concat([df2,df4],axis = 1)
df5

5.删操作

df5.drop(['j'],axis=0,inplace = True)
df5
del df5['Tang']
df5 
df5.drop(['A','B','C'],axis = 1,inplace = True)
df5