【pandas学习笔记】综合整理

1. Reindex

Series Reindex

import numpy as np
import pandas as pd

>>>s1 = pd.Series(np.random.randn(1, 4).tolist()[0], index=['A', 'B','C','D']) #先将数组转成list
A    0.523862
B   -0.341507
C   -0.368576
D    0.335503
dtype: float64

>>>s2 = s1.reindex(['A', 'B','C','D','E','F','G'])
A    0.523862
B   -0.341507
C   -0.368576
D    0.335503
E         NaN
F         NaN
G         NaN
dtype: float64

>>>s = s1.reindex(['A', 'B','C','D','E','F','G'],fill_value=0)
A    0.523862
B   -0.341507
C   -0.368576
D    0.335503
E    0.000000
F    0.000000
G    0.000000
dtype: float64

>>>s3 = s2.reindex(['A', 'B','C','D','E','F','G','H'],fill_value=0)
A    0.523862
B   -0.341507
C   -0.368576
D    0.335503
E         NaN
F         NaN
G         NaN
H    0.000000
dtype: float64
# 总结
# reindex是重新重新设置索引，原有索引没有的，用空值处理

Pandas Reindex

df = pd.DataFrame(np.random.randn(4, 4), index = ['r1','r2','r3','r4'], columns=['c1','c2','c3','c4'])

df.reindex(['r1','r2','r3',