创建数组
import pandas as pd
import numpy as np
from pandas import Series, DataFrame
df = DataFrame(np.random.rand(12).reshape((3,4)),
index
设置行和列
import numpy as np
import pandas as pd
df = pd.DataFrame({
'col1':['a','a','b',np.nan,'c'],
'col2':[2, 1, 8, 7, 6],
'col3':[0, 4, 7, 2, 3],
})
df
col1 col2 col3
0 a 2 0
1 a 1 4
2 b 8 7
3 NaN 7 2
4 c 6 3
#修改行标签
df.columns
Index(['col1', 'col2', 'col3'], dtype='object')
df.columns = ['a','b','c']
df
a b c
0 a 2 0
1 a 1 4
2 b 8 7
3 NaN 7 2
4 c 6 3
#修改列标签
df.index = ['a0','a1','a2','a3','a4']
df
col1 col2 col3
a0 a 2 0
a1 a 1 4
a2 b 8 7
a3 NaN 7 2
a4 c 6 3
- right2 = DataFrame({
‘var2’:[5,7],
})
right2.index = [‘a’,‘b’]
right2
right3 = DataFrame({
'val2':[5,7]
},index=['a','b'])
right3