Pyhton科学计算工具Pandas(三) —— 数据结构Dataframe的基本操作
dataframe的基本操作
查看和转置
df = pd.DataFrame(np.random.rand(16).reshape(8,2)*100,
columns=['a','b'])
print(df.head(3))
print(df.tail(2))
print('---------')
print(df.T)
a b
0 50.973343 19.208659
1 16.702960 98.460643
2 30.013108 8.446435
a b
6 8.339462 69.308221
7 28.236923 53.976490
---------
0 1 2 3 4 5 \
a 50.973343 16.702960 30.013108 1.118677 34.971555 51.606055
b 19.208659 98.460643 8.446435 35.377823 64.811959 46.874331
6 7
a 8.339462 28.236923
b 69.308221 53.976490
添加和修改
df = pd.DataFrame(np.random.rand(16).reshape(4,4)*100,
columns=['a','b','c','d'])
print(df)
print('-----------')
df['e'] = 200
df.loc[4] = 300
print(df)
print('------------')
df['e'] = 12