value_counts()的用法

https://blog.csdn.net/weixin_33950035/article/details/91272268

value_counts()是一种查看表格某列中有多少个不同值的快捷方法，并计算每个不同值有在该列中有多少重复值。
value_counts()是Series拥有的方法，一般在DataFrame中使用时，需要指定对哪一列或行使用。

1. import pandas as pd

2. import numpy as np

3. filepath='C:\python\data_src\GFSCOFOG_03-05-2018 03-04-36-54_timeSeries\GFSCOFOG_CHA.csv'

4. data = pd.read_csv(filepath,encoding='utf-8')

查看Unit Name中有哪些不同的值，并计算每个值有多少个重复值

data['Unit Name'].value_counts()

1. data['Unit Name'].value_counts()

2. #输出

3. Percent of GDP 3561

4. Domestic currency 3561

5. Percent of total expenditure 470

6. Name: Unit Name, dtype: int64

 

查看Sector Name中有哪些不同的值，并计算每个值有多少个重复值

data['Sector Name'].value_counts()

1. data['Sector Name'].value_counts()

2. #输出结果

3. Extrabudgetary central government 1020

4. Social security funds 1002

5. Central government (incl. social security funds) 944

6. Budgetary central government 944

7. Local governments 944

8. General government 944

9. Central government (excl. social security funds) 944

10. State governments 850

11. Name: Sector Name, dtype: int64

转载于:https://www.jianshu.com/p/f773b4b82c66