Pandas工具包实战（5）对象的操作：series, dataframe, 对象的增删改查

1 Series结构的增删改查

import pandas as pd

data = [10,11,12]
index = ['a','b','c']
s = pd.Series(data = data,index = index)
# a    10
# b    11
# c    12
# dtype: int64

2 查操作

s[0]  # 10
s[0:2]  

mask = [True,False,True]
s[mask]
# a    10
# c    12
# dtype: int64

s.loc['b']  # 11
s.iloc[1]  # 11

3 改操作

s1 = s.copy()
s1['a'] = 100
s1.replace(to_replace = 100,value = 101,inplace = True)
# a    101
# b    11
# c    12
# dtype: int64

s1.index  # Index(['a', 'b', 'c'], dtype='object')
s1.index = ['a','b','d']

s1.rename(index = {'a':'A'},inplace = True)
# A    101
# b    11
# c    12
# dtype: int64

4 增操作

data = [100,110]
index = ['h','k']
s2 = pd.Series(data = data,index = index)

s3 = s1.append(s2)
s3['j'] = 500
s3
# A    101
# b     11
# d     12
# j    500
# h    100
# k    110
# dtype: int64

s1.append(s2,ignore_index = True)
# 0    101
# 1     11
# 2     12
# 3    500
# 4    100
# 5    110
# dtype: int64

5 删操作

del s1['A']
s1
# b     11
# d     12
# j    500
# dtype: int64

s1.drop(['b','d'],inplace = True)
s1
# j    500
# dtype: int64

6 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
# 	A	B	C
# a	1	2	3
# b	4	5	6

6.2 查操作是类似的

df['A']  # 列标签
# a    1
# b    4
# Name: A, dtype: int64

df.iloc[0]  # 行索引
df.loc['a'] # 行标签
# A    1
# B    2
# C    3
# Name: a, dtype: int64

6.3 改操作

df.loc['a']['A']  # 1

df.loc['a']['A'] = 150
#	A	B	C
#a	150	2	3
#b	4	5	6

df.index = ['f','g']
df
#	A	B	C
#d	150	2	3
#f	4	5	6

6.4 增操作

df.loc['c'] = [1,2,3]  # 增加行
df
#	A	B	C
#f	150	2	3
#g	4	5	6
#c	1	2	3

data = [[1,2,3],[4,5,6]]
index = ['j','k']
columns = ['A','B','C']
df2 = pd.DataFrame(data=data,index=index,columns = columns)
df2
#	A	B	C
#j	1	2	3
#k	4	5	6

df3 = pd.concat([df,df2],axis = 0)  # 默认追加行
df3
#	A	B	C
#f	150	2	3
#g	4	5	6
#c	1	2	3
#j	1	2	3
#k	4	5	6

df2['Tang'] = [10,11]
df2
#	A	B	C	Tang
#j	1	2	3	10
#k	4	5	6	11

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

df5 = pd.concat([df2,df4],axis = 1)  # 选择按列向右追加
df5
#	A	B	C	Tang	D	E
#j	1	2	3	10	10	11
#k	4	5	6	11	12	13

6.5 删操作

df5.drop(['j'],axis=0,inplace = True)
df5
#	A	B	C	Tang	D	E
#k	4	5	6	11	   12	13

del df5['Tang']
df5 
#	A	B	C	D	E
#k	4	5	6	12	13

df5.drop(['A','B','C'],axis = 1,inplace = True)
df5
#	D	E
#k	12	13