pandas 终极版3：DataFrame 的增、删、改、查、排序

最新推荐文章于 2023-05-15 11:07:04 发布

lxb1022

最新推荐文章于 2023-05-15 11:07:04 发布

阅读量1k

点赞数 2

分类专栏： pandas 文章标签： pandas 数据分析 DataFrame

本文链接：https://blog.csdn.net/lxb1022/article/details/76884299

版权

pandas常见的操作主要是增、删、改、查几个动作。

Out[66]: 
                   A         B         C         D
2017-08-08 -0.251957  1.408053 -0.085674  0.365377
2017-08-09 -0.141047  0.445702 -0.560573  0.251600
2017-08-10 -0.218148  1.619402 -1.799525 -0.697128
2017-08-11 -0.542612 -1.401814 -0.158879  0.969136
2017-08-12  0.268779 -1.376531  0.950630 -1.041401
2017-08-13  0.488717 -0.267509  0.112117 -1.166227

1.新增一个列 ,增加相同值为：df['F']=1 或 df['F']=[1,2,3,4,5,6]

In [68]: df['E']=pd.Series([1,2,3,4,5,6],index=df.index)

In [69]: df
Out[69]: 
                   A         B         C         D  E
2017-08-08 -0.251957  1.408053 -0.085674  0.365377  1
2017-08-09 -0.141047  0.445702 -0.560573  0.251600  2
2017-08-10 -0.218148  1.619402 -1.799525 -0.697128  3
2017-08-11 -0.542612 -1.401814 -0.158879  0.969136  4
2017-08-12  0.268779 -1.376531  0.950630 -1.041401  5
2017-08-13  0.488717 -0.267509  0.112117 -1.166227  6

2.新增一行

In [75]: df.loc['2017-08-14']=pd.Series(np.random.rand(5),index=df.columns)

In [76]: df
Out[76]: 
                            A         B         C         D         E
2017-08-08 00:00:00 -0.251957  1.408053 -0.085674  0.365377  1.000000
2017-08-09 00:00:00 -0.141047  0.445702 -0.560573  0.251600  2.000000
2017-08-10 00:00:00 -0.218148  1.619402 -1.799525 -0.697128  3.000000
2017-08-11 00:00:00 -0.542612 -1.401814 -0.158879  0.969136  4.000000
2017-08-12 00:00:00  0.268779 -1.376531  0.950630 -1.041401  5.000000
2017-08-13 00:00:00  0.488717 -0.267509  0.112117 -1.166227  6.000000
2017-08-14           0.323022  0.166814  0.912841  0.266087  0.847414

3.修改行标签df.index ，修改列标签df.columns=list()

In [81]: df.index=['one','two','three','four','five','six','seven']

In [82]: df
Out[82]: 
              A         B         C         D         E
one   -0.251957  1.408053 -0.085674  0.365377  1.000000
two   -0.141047  0.445702 -0.560573  0.251600  2.000000
three -0.218148  1.619402 -1.799525 -0.697128  3.000000
four  -0.542612 -1.401814 -0.158879  0.969136  4.000000
five   0.268779 -1.376531  0.950630 -1.041401  5.000000
six    0.488717 -0.267509  0.112117 -1.166227  6.000000
seven  0.323022  0.166814  0.912841  0.266087  0.847414

4.插入一列数据到任意位