In this python pandas program, we will count Country wise population from a given dataset using the pandas library.
Link for Dataset- https://www.kaggle.com/datasets/tanuprabhu/population-by-country-2020?resource=download
Steps to solve the program
- Import pandas library as pd.
- First, read the dataset using pd.read_csv().
- Now drop the unnecessary columns from the dataset using df.drop().
- Print the first 10 countries using df.head(10).
import pandas as pd
df = pd.read_csv("population_by_country_2020.csv")
df1 = df.drop(['Yearly Change','Net Change','Density (P/Km²)','Land Area (Km²)',
'Migrants (net)','Fert. Rate','Med. Age','Urban Pop %','World Share'],axis=1)
print(df1.head(10))
Output :
0 Country (or dependency) Population (2020)
0 China 1440297825
1 India 1382345085
2 United States 331341050
3 Indonesia 274021604
4 Pakistan 221612785
5 Brazil 212821986
6 Nigeria 206984347
7 Bangladesh 164972348
8 Russia 145945524
9 Mexico 129166028