Pandas学习 | 常用函数

【走在成长的路上】总纲

describe()

• 可以快速查看数据的统计摘要
• 例：df.describe()

             A         B         C         D
      count  6.000000  6.000000  6.000000  6.000000
      mean   0.073711 -0.431125 -0.687758 -0.233103
      std    0.843157  0.922818  0.779887  0.973118
      min   -0.861849 -2.104569 -1.509059 -1.135632
      25%   -0.611510 -0.600794 -1.368714 -1.076610
      50%    0.022070 -0.228039 -0.767252 -0.386188
      75%    0.658444  0.041933 -0.034326  0.461706
      max    1.212112  0.567020  0.276232  1.071804

sort_index()

• 按轴（行索引）排序
• 例：df.df.sort_index(axis=1, ascending=False)

                          D         C         B         A
      2013-01-01 -1.135632 -1.509059 -0.282863  0.469112
      2013-01-02 -1.044236  0.119209 -0.173215  1.212112
      2013-01-03  1.071804 -0.494929 -2.104569 -0.861849
      2013-01-04  0.271860 -1.039575 -0.706771  0.721555
      2013-01-05 -1.087401  0.276232  0.567020 -0.424972
      2013-01-06  0.524988 -1.478427  0.113648 -0.673690

sort_values()

• 按某列值排序

• 例：df.sort_values(by='B')

               A         B         C         D
  2013-01-03 -0.861849 -2.104569 -0.494929  1.071804
  2013-01-04  0.721555 -0.706771 -1.039575  0.271860
  2013-01-01  0.469112 -0.282863 -1.509059 -1.135632
  2013-01-02  1.212112 -0.173215  0.119209 -1.044236
  2013-01-06 -0.673690  0.113648 -1.478427  0.524988
  2013-01-05 -0.424972  0.567020  0.276232 -1.087401