I'm working on retrieving the data from world bank master excel sheet. I want to extract the country names and different indicators from the world bank master sheet and create a new data frame.
here is the link for the data https://data.worldbank.org/topic/climate-change
data_cols=['Country Name', 'Indicator Name','2000', '2001', '2002', '2003', '2004',
'2005', '2006', '2007', '2008', '2009', '2010', '2011', '2012','2013', '2014', '2015',
'2016', '2017', '2018',
'2019', '2020', '2021' ]
new_df=df[data_cols]
print(new_df)
new_df = pd.DataFrame(data=new_df)
new_df.dropna()
new_df.select_dtypes(include ='CO2 emissions (kt)')
print (new_df["Urban population"].isin(["Aruba"]))
I've tried this but not working. please suggest a better way
