python笔记：3.2.2.1pandas数据操作

# -*- coding: utf-8 -*- """ Created on Thu May 23 14:28:08 2019 @author: User """ import pandas as pd ssort=pd.Series(range(5), index=['a','b','c','d','e']) print(ssort) print('\n ssort.sort_index() :') print(ssort.sort_index()) print('\n ssort.sort_index(ascending=False) :') print(ssort.sort_index(ascending=False)) print('\n使用嵌套字典创建DataFram-------------------') dfdata2={'Name':{101:'Zhang San',102:'Li Si',103:'Wang Wu',104:'Zhao Liu',105:'Qian Qi',106:'Sun Ba'}, 'Subject':{101:'Literature',102:'History',103:'English',104:'Maths',105:'Physics',106:'Chemics'}, 'Score':{101:98,102:76,103:84,104:70,105:93,106:83} } scoresheet2=pd.DataFrame(dfdata2) print("\n scoresheet2:") print(scoresheet2) print("\n scoresheet2.index=[102,101,106,104,103,105]:") scoresheet2.index=[102,101,106,104,103,105] print(scoresheet2) print("\n scoresheet2.sort_index():") print(scoresheet2.sort_index()) print("\n scoresheet2.sort_index(axis=0,ascending=False):") print(scoresheet2.sort_index(axis=0,ascending=False)) print("\n 列顺序降序排列 scoresheet2.sort_index(axis=1,ascending=False):") print(scoresheet2.sort_index(axis=1,ascending=False)) print("\n 列顺序降序排列 scoresheet2.sort_values(by='Score',ascending=False):") print(scoresheet2.sort_values(by='Score',ascending=False))

运行：

a    0 b    1 c    2 d    3 e    4 dtype: int64

 ssort.sort_index() : a    0 b    1 c    2 d    3 e    4 dtype: int64

 ssort.sort_index(ascending=False) : e    4 d    3 c    2 b    1 a    0 dtype: int64

使用嵌套字典创建DataFram-------------------

 scoresheet2:           Name     Subject  Score 101  Zhang San  Literature     98 102      Li Si     History     76 103    Wang Wu     English     84 104   Zhao Liu       Maths     70 105    Qian Qi     Physics     93 106     Sun Ba     Chemics     83

 scoresheet2.index=[102,101,106,104,103,105]:           Name     Subject  Score 102  Zhang San  Literature     98 101      Li Si     History     76 106    Wang Wu     English     84 104   Zhao Liu       Maths     70 103    Qian Qi     Physics     93 105     Sun Ba     Chemics     83

 scoresheet2.sort_index():           Name     Subject  Score 101      Li Si     History     76 102  Zhang San  Literature     98 103    Qian Qi     Physics     93 104   Zhao Liu       Maths     70 105     Sun Ba     Chemics     83 106    Wang Wu     English     84

 scoresheet2.sort_index(axis=0,ascending=False):           Name     Subject  Score 106    Wang Wu     English     84 105     Sun Ba     Chemics     83 104   Zhao Liu       Maths     70 103    Qian Qi     Physics     93 102  Zhang San  Literature     98 101      Li Si     History     76

 列顺序降序排列 scoresheet2.sort_index(axis=1,ascending=False):         Subject  Score       Name 102  Literature     98  Zhang San 101     History     76      Li Si 106     English     84    Wang Wu 104       Maths     70   Zhao Liu 103     Physics     93    Qian Qi 105     Chemics     83     Sun Ba

 列顺序降序排列 scoresheet2.sort_values(by='Score',ascending=False):           Name     Subject  Score 102  Zhang San  Literature     98 103    Qian Qi     Physics     93 106    Wang Wu     English     84 105     Sun Ba     Chemics     83 101      Li Si     History     76 104   Zhao Liu       Maths     70