# -*- coding: utf-8 -*-
"""
Created on Thu May 23 15:27:32 2019
@author: User
"""
import pandas as pd
rrank=pd.Series([10,12,9,9,14,4,2,4,9,1])
print(rrank)
print('\n rrank.rank(ascending=False)')
print(rrank.rank(ascending=False))
print("\n rrank.rank(method='first')")
print(rrank.rank(method='first'))
print("\n rrank.rank(method='max')")
print(rrank.rank(method='max'))
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(scoresheet2)
print("\n scoresheet2.rank()")
print(scoresheet2.rank())
运行：
0 10 1 12 2 9 3 9 4 14 5 4 6 2 7 4 8 9 9 1 dtype: int64
rrank.rank(ascending=False) 0 3.0 1 2.0 2 5.0 3 5.0 4 1.0 5 7.5 6 9.0 7 7.5 8 5.0 9 10.0 dtype: float64
rrank.rank(method='first') 0 8.0 1 9.0 2 5.0 3 6.0 4 10.0 5 3.0 6 2.0 7 4.0 8 7.0 9 1.0 dtype: float64
rrank.rank(method='max') 0 8.0 1 9.0 2 7.0 3 7.0 4 10.0 5 4.0 6 2.0 7 4.0 8 7.0 9 1.0 dtype: float64
使用嵌套字典创建DataFram------------------- 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.rank() Name Subject Score 101 5.0 4.0 6.0 102 1.0 3.0 2.0 103 4.0 2.0 4.0 104 6.0 5.0 1.0 105 2.0 6.0 5.0 106 3.0 1.0 3.0
