value_counts()是一种查看表格某列中有多少个不同值的快捷方法,并计算每个不同值有在该列中有多少重复值。
1、value_counts()在Series的用法
import pandas as pd import numpy as np from pandas import DataFrame from pandas import Series s1=Series(["timo","mike","anni","timo"]) s1.value_counts()
timo 2 mike 1 anni 1 dtype: int64
2、value_counts()在DataFrame的用法
import pandas as pd import numpy as np from pandas import DataFrame from pandas import Series df1= DataFrame( {"handsome":["timo","anni","timo"], "smart":["mike","anni","mike"]} ) print(df1) df1.apply(pd.value_counts)##数据框要借助apply来应用value_counts()
handsome smart 0 timo mike 1 anni anni 2 timo mike