In Jupyter Notebook Python
worldbankhealthdata.csv:
6) Use worldbankhealthdata.csv and reshape column "indicator_code" into multiple columns. Name your final datafram wbh_data_reshaped and it should have 99 rows and 84 columns worldbankhealthdata ARM TZA SYR NOR TKM GTM PRE country name country_code indicator name indicator code Middle East & North Africa (IDA & IBRD countries) TMN Population ages 65 and above, male SP.POP.SUP.MA.IN Armenia Nurses and midwives (per 1,000 people) SH.MED.NUMW.P3 Georgia GEO Male population 25-29 SP.POP.2529.MA Tanzania Labor force, total SL. TLF.TOTL.IN Cambodia KHM Age population, age 16, female, interpolated SP.POP.AG16.FE.IN Mongolia MNG Female population 20-24 SP.POP.2024.FE Syrian Arab Republic Population ages 15-84, female % of total SP.POP.1564.FE ZS Solomon Islands Male population 50-54 SP.POP.5064.MA Zimbabwe ZWE Population ages 45-49, female % of female population) SP.POP.4549.FE.5Y Kazakhstan KAZ Female population 80+ SPPOP SOUP.FE Norway Population, male SP.POP TOTL.MA.IN Congo, Dem. Rep. COD Birth rate, crude (per 1,000 people) SP:DYN.CERTIN Libya LBY Rural population (% of total population) SPRUR.TOTL ZS Turkmenistan Mortality rate, adult, female (per 1,000 female adults) SPDYN AMRT.FE Latin America & the Caribbean (IDA & IBRD countries) TLA Life expectancy at birth, total (years) SP.DYN.LEDO.IN Ethiopia ETH Age population, age 18, male, interpolated SP.POP.AG18.MA. IN Guatemala Population ages 65 and above, female SP.POP.65UP.FE.IN Canada CAN Population, female (% of total SP.POP TOTL.FE.ZS Pre-demographic dividend Male population 65-89 SP.POP.6589.MA Slovenia SVN Age population, age 10, female, interpolated SP.POP.AG10.FE.IN Pakistan PAK Population ages 00-14% of total) SP.POP.0014.TO ZS Yemen, Rep. YEM Population ages 05-09, female % of female population SP.POP.0509.FE.5Y Niger NER Low-birthweight babies (% of births) SH.STA.BRTW.ZS Cambodia KHM Population ages 15-64% of total) SP.POP.1584.TO ZS Samoa WSM School enrollment secondary (% grass) SE SEC.ENRR Hong Kong SAR, China Population ages 0-14, male SP.POP.0014.MA.IN Trinidad and Tobago TTO Age population, age 02, female, interpolated SP.POP.AGO2.FE.IN Lebanon LBN Population ages 80 and older, male(% of male population) SP.POP.BOUP.MA.SY Korea, Dem. People's Rep. PRK Immunization, HepB3 (% of one-year-old children SHIMM.HEPB Namibia NAM Age population, age 18, male, interpolated SP.POP.AG18.MAIN Hong Kong SAR, China HKG Age population, age 15, male, interpolated SP.POP.AG15.MAIN Namibia NAM Male population 45-49 SPPOP 4549 MA Switzerland Improved sanitation facilities % of population with access] SH.STALACSN Georgia Improved water source % of population with access SH.H20.SAFE.ZS Uganda UGA Death rate, crude (per 1,000 people) SP.DYN.CDRT.IN Israel Population ages 20-24, female % of female population SP.POP.2024.FE.5Y New Caledonia NCL Population ages 15-84 (% of total SP.POP.1584. TO ZS Bhutan Male population 05-09 SP.POP.0509.MA Nigeria NGA Male population 50-54 SP.POP.5054.MA Syrian Arab Republic Age population, age 09, female, interpolated SP.POP.AGOB.FE.IN Somalia Age population, age 07, female, interpolated SP.POP.AGO7.FE.IN Post-demographic dividend PST Female population 60-64 SP.POP.6064.FE Gambia, The GMB Age population, age 22, male, interpolated SP.POP.AG22.MA. IN Botswana BWA Population ages 00-14, total SP.POP.0014.TO Senegal Urban population growth (annual %) SP.URB.GROW Luxembourg by non-communicable diseases (% of total SH.DTH.NCOMZS France Population ages 65-69, male (% of male population SP.POP.6569.MA.5Y Europe & Central Asia Female population 50-54 SP.POP.5054.FE Ecuador ECU Male population 40-44 SP.POP.4044.MA Lithuania Female population 06-09 SP.POP.0509.FE Turkey TUR Health expenditure, total (current US$) SH.XPD.TOTL.CO Paraguay PRY Age population, age 09, male, interpolated SP.POP.AG09.MAIN Togo TGO Male population 65-89 SP.POP.6569.MA Jamaica Incidence of tuberculosis (per 100,000 people) SH.TBS. INCD Mexico MEX Age population, age 18, male, interpolated SP.POP.AG18.MAIN Thailand THA Population ages 65-69, female % of female population SP.POP.6589.FE.5Y Pacific island small states PSS Population ages 15-84 (% of total SPPOP.1584. TO ZS Guam GUM Female population 40-44 SP.POP.4044.FE year value 1977 2598418 2006 4.92 1965 169351 2015 23025898 1991 84804 1989 105592 2015 58.92591472 1960 1998 2009 2.56940512 2002 120688 1972 1966275 2013 42.394 2004 23.226 1979 183.52 1985 65.76022882 1985 380571 1998 207159 2008 50.43063729 1983 2132405 2011 8721 2001 40.63290068 1998 16.8139426 2008 2012 63.64877087 2001 80.40885 1995 816295 2002 8884 1996 0.796738058 2014 1979 9465 1962 1994 1992 99.9 2011 1998 17.743 2006 7.79097383 1971 58.54267908 1992 2009 2187315 1964 1975 54589 2014 34205403 1996 8934 2008 861814 1988 4.015875207 2000 2013 5.233388957 1992 24103440 1980 188757 1985 128342 2012 41307906459 2001 68348 1998 26737 2008 1963 395085 2015 3.858269521 2009 80.62090482 2008 5525 34705 24098 CHE GEO 97.8 BTN SYR SOM SEN LUX FRA 88.4 LTU JAM GUM Guam United States LKA Israel Sri Lanka Palau Norway Bahamas, The PLW NOR BHS MNA Middle East & North Africa (excluding high income) Indonesia IDN MAR Morocco Finland Latvia Central African Republic Ethiopia Malawi Sweden MWI SWE CHL ISL SLE QAT ARM 0.2 Female population 40-44 SP.POP.4044.FE 2003 5525 Age population, age 08, female, interpolated SP.POP.AGOB.FE.IN 1990 1851232 Prevalence of anemia among pregnant women (%) SH.PRG.ANEM 2001 Age population, age 06, female, interpolated SP.POP.AGOB.FE.IN 1988 190400 Health expenditure per capita, PPP SH.XPD.PCAP.PP.KD 2000 1034.881568 Birth rate, crude (per 1,000 people SP:DYN.CBRT.IN 1961 17.3 Male population 75-79 SP.POP.7579.MA 1988 773 Population, total SPPOP TOTL 1984 189989779 Population ages 15-84, male SP.POP. 1564.MA.IN 2005 74210330 Male population 75-79 SP.POP.7579. MA 1998 91006 Age population, age 02, female, interpolated SP.POP.AG02.FE.IN 1961 40314 Rural population SPRUR.TOTL 1986 811634 Rural population (% of total population) SPRUR.TOTLZS 1980 86.126 Age population, age 18, female, interpolated SP.POP.AG18.FE.IN 1987 409762 Population ages 20-24, male (% of male population SP.POP 2024.MA.SY 1996 9,034834578 Age population, age 25, male, interpolated SP.POP.AG25.MAIN 1972 69649 Age population, age 25, male, interpolated SPPOP.AG25.MAIN 1962 67531 Population ages 80 and older, female % of female populatio SP.POP SOUP.FE.SY 1989 3.063995858 Population ages 35-39, female % of female population SP.POP.3539.FE.5Y 1973 5.639449793 Population ages 15-64, male SP.POP.1564.MA.IN 1999 289348 Prevalence of HIV, total (% of population ages 15-49) SH.DYNAIDS.ZS 2006 Prevalence of wasting, fernale % of children under 5) SH.STA WAST.FE.ZS 1996 0.699999988 Population, female (% of total) SP.POP.TOTL.FE.ZS 1974 51.27831786 Population ages 0-14, fernale SP.POP.0014.FE.IN 1963 11987 Male population 75-79 SP.POP.7579.MA 1974 Population ages 00-14 (% of total SP.POP.0014.TO ZS 1994 27.45874024 Age population, age 20, female, interpolated SP.POP.AG20.FE.IN 2009 1068943 Population ages 65 and above, fernale SP.POP.85UP.FE.IN 2009 2110550 Age population, age 19, female, interpolated SP.POP.AG19.FE.IN 2013 101041 Unemployment, female % of female labor force) SL.UEM.TOTL.FE ZS 1997 7.445000172 Age population, age 03, female, interpolated SP.POP.AGO3.FE.IN 1995 144860 Male population 10-14 SP.POP.1014.MA 1987 120167 Immunization, BCG (% of one-year-old children] SH.IMM.IBCG 1987 Age population, age 0, male, interpolated SP.POP.AGOO.MAN 1982 10970 Health expenditure, total (current USS SH.XPD.TOTL.CO 2005 8223913238 Population ages 00-14, male(% of total SP.POP.0014.MA.ZS 1999 38.02288527 Population ages 65-69, male (% of male population SPPOP6569.MA.5Y 1986 1.17405775 Age population, age 14, female, interpolated SP.POP.AG14.FE.IN 1972 2995 Male population 00-04 SP.POP:0004.MA 1970 1230393 Mortality rate, infant (per 1,000 live births) SPDYNIMRTIN 2013 Survival to age 65, female (% of cohort) SPDYN.TO65.FE.ZS 2009 61.70283977 Literacy rate, youth male (% of males ages 15-24) SE.ADT.1524.LT.MAZ 2011 99.24862 Chile Iceland Sierra Leone Qatar Armenia Honduras Yemen, Rep. Aruba Solomon Islands United Arab Emirates Mexico Philippines Somalia Costa Rica HND YEM ABW SLB ARE MEX PHL SOM CRI Ecuador ECU MRT TUR Mauritania Turkey Estonia Chile Turkmenistan Sudan Equatorial Guinea Korea, Dem. Peoples Rep. EST CHL TKM SDN GNO PRK Kenya KEN Least developed countries: UN classification LDC Bolivia BOL 6) Use worldbankhealthdata.csv and reshape column "indicator_code" into multiple columns. Name your final datafram wbh_data_reshaped and it should have 99 rows and 84 columns worldbankhealthdata ARM TZA SYR NOR TKM GTM PRE country name country_code indicator name indicator code Middle East & North Africa (IDA & IBRD countries) TMN Population ages 65 and above, male SP.POP.SUP.MA.IN Armenia Nurses and midwives (per 1,000 people) SH.MED.NUMW.P3 Georgia GEO Male population 25-29 SP.POP.2529.MA Tanzania Labor force, total SL. TLF.TOTL.IN Cambodia KHM Age population, age 16, female, interpolated SP.POP.AG16.FE.IN Mongolia MNG Female population 20-24 SP.POP.2024.FE Syrian Arab Republic Population ages 15-84, female % of total SP.POP.1564.FE ZS Solomon Islands Male population 50-54 SP.POP.5064.MA Zimbabwe ZWE Population ages 45-49, female % of female population) SP.POP.4549.FE.5Y Kazakhstan KAZ Female population 80+ SPPOP SOUP.FE Norway Population, male SP.POP TOTL.MA.IN Congo, Dem. Rep. COD Birth rate, crude (per 1,000 people) SP:DYN.CERTIN Libya LBY Rural population (% of total population) SPRUR.TOTL ZS Turkmenistan Mortality rate, adult, female (per 1,000 female adults) SPDYN AMRT.FE Latin America & the Caribbean (IDA & IBRD countries) TLA Life expectancy at birth, total (years) SP.DYN.LEDO.IN Ethiopia ETH Age population, age 18, male, interpolated SP.POP.AG18.MA. IN Guatemala Population ages 65 and above, female SP.POP.65UP.FE.IN Canada CAN Population, female (% of total SP.POP TOTL.FE.ZS Pre-demographic dividend Male population 65-89 SP.POP.6589.MA Slovenia SVN Age population, age 10, female, interpolated SP.POP.AG10.FE.IN Pakistan PAK Population ages 00-14% of total) SP.POP.0014.TO ZS Yemen, Rep. YEM Population ages 05-09, female % of female population SP.POP.0509.FE.5Y Niger NER Low-birthweight babies (% of births) SH.STA.BRTW.ZS Cambodia KHM Population ages 15-64% of total) SP.POP.1584.TO ZS Samoa WSM School enrollment secondary (% grass) SE SEC.ENRR Hong Kong SAR, China Population ages 0-14, male SP.POP.0014.MA.IN Trinidad and Tobago TTO Age population, age 02, female, interpolated SP.POP.AGO2.FE.IN Lebanon LBN Population ages 80 and older, male(% of male population) SP.POP.BOUP.MA.SY Korea, Dem. People's Rep. PRK Immunization, HepB3 (% of one-year-old children SHIMM.HEPB Namibia NAM Age population, age 18, male, interpolated SP.POP.AG18.MAIN Hong Kong SAR, China HKG Age population, age 15, male, interpolated SP.POP.AG15.MAIN Namibia NAM Male population 45-49 SPPOP 4549 MA Switzerland Improved sanitation facilities % of population with access] SH.STALACSN Georgia Improved water source % of population with access SH.H20.SAFE.ZS Uganda UGA Death rate, crude (per 1,000 people) SP.DYN.CDRT.IN Israel Population ages 20-24, female % of female population SP.POP.2024.FE.5Y New Caledonia NCL Population ages 15-84 (% of total SP.POP.1584. TO ZS Bhutan Male population 05-09 SP.POP.0509.MA Nigeria NGA Male population 50-54 SP.POP.5054.MA Syrian Arab Republic Age population, age 09, female, interpolated SP.POP.AGOB.FE.IN Somalia Age population, age 07, female, interpolated SP.POP.AGO7.FE.IN Post-demographic dividend PST Female population 60-64 SP.POP.6064.FE Gambia, The GMB Age population, age 22, male, interpolated SP.POP.AG22.MA. IN Botswana BWA Population ages 00-14, total SP.POP.0014.TO Senegal Urban population growth (annual %) SP.URB.GROW Luxembourg by non-communicable diseases (% of total SH.DTH.NCOMZS France Population ages 65-69, male (% of male population SP.POP.6569.MA.5Y Europe & Central Asia Female population 50-54 SP.POP.5054.FE Ecuador ECU Male population 40-44 SP.POP.4044.MA Lithuania Female population 06-09 SP.POP.0509.FE Turkey TUR Health expenditure, total (current US$) SH.XPD.TOTL.CO Paraguay PRY Age population, age 09, male, interpolated SP.POP.AG09.MAIN Togo TGO Male population 65-89 SP.POP.6569.MA Jamaica Incidence of tuberculosis (per 100,000 people) SH.TBS. INCD Mexico MEX Age population, age 18, male, interpolated SP.POP.AG18.MAIN Thailand THA Population ages 65-69, female % of female population SP.POP.6589.FE.5Y Pacific island small states PSS Population ages 15-84 (% of total SPPOP.1584. TO ZS Guam GUM Female population 40-44 SP.POP.4044.FE year value 1977 2598418 2006 4.92 1965 169351 2015 23025898 1991 84804 1989 105592 2015 58.92591472 1960 1998 2009 2.56940512 2002 120688 1972 1966275 2013 42.394 2004 23.226 1979 183.52 1985 65.76022882 1985 380571 1998 207159 2008 50.43063729 1983 2132405 2011 8721 2001 40.63290068 1998 16.8139426 2008 2012 63.64877087 2001 80.40885 1995 816295 2002 8884 1996 0.796738058 2014 1979 9465 1962 1994 1992 99.9 2011 1998 17.743 2006 7.79097383 1971 58.54267908 1992 2009 2187315 1964 1975 54589 2014 34205403 1996 8934 2008 861814 1988 4.015875207 2000 2013 5.233388957 1992 24103440 1980 188757 1985 128342 2012 41307906459 2001 68348 1998 26737 2008 1963 395085 2015 3.858269521 2009 80.62090482 2008 5525 34705 24098 CHE GEO 97.8 BTN SYR SOM SEN LUX FRA 88.4 LTU JAM GUM Guam United States LKA Israel Sri Lanka Palau Norway Bahamas, The PLW NOR BHS MNA Middle East & North Africa (excluding high income) Indonesia IDN MAR Morocco Finland Latvia Central African Republic Ethiopia Malawi Sweden MWI SWE CHL ISL SLE QAT ARM 0.2 Female population 40-44 SP.POP.4044.FE 2003 5525 Age population, age 08, female, interpolated SP.POP.AGOB.FE.IN 1990 1851232 Prevalence of anemia among pregnant women (%) SH.PRG.ANEM 2001 Age population, age 06, female, interpolated SP.POP.AGOB.FE.IN 1988 190400 Health expenditure per capita, PPP SH.XPD.PCAP.PP.KD 2000 1034.881568 Birth rate, crude (per 1,000 people SP:DYN.CBRT.IN 1961 17.3 Male population 75-79 SP.POP.7579.MA 1988 773 Population, total SPPOP TOTL 1984 189989779 Population ages 15-84, male SP.POP. 1564.MA.IN 2005 74210330 Male population 75-79 SP.POP.7579. MA 1998 91006 Age population, age 02, female, interpolated SP.POP.AG02.FE.IN 1961 40314 Rural population SPRUR.TOTL 1986 811634 Rural population (% of total population) SPRUR.TOTLZS 1980 86.126 Age population, age 18, female, interpolated SP.POP.AG18.FE.IN 1987 409762 Population ages 20-24, male (% of male population SP.POP 2024.MA.SY 1996 9,034834578 Age population, age 25, male, interpolated SP.POP.AG25.MAIN 1972 69649 Age population, age 25, male, interpolated SPPOP.AG25.MAIN 1962 67531 Population ages 80 and older, female % of female populatio SP.POP SOUP.FE.SY 1989 3.063995858 Population ages 35-39, female % of female population SP.POP.3539.FE.5Y 1973 5.639449793 Population ages 15-64, male SP.POP.1564.MA.IN 1999 289348 Prevalence of HIV, total (% of population ages 15-49) SH.DYNAIDS.ZS 2006 Prevalence of wasting, fernale % of children under 5) SH.STA WAST.FE.ZS 1996 0.699999988 Population, female (% of total) SP.POP.TOTL.FE.ZS 1974 51.27831786 Population ages 0-14, fernale SP.POP.0014.FE.IN 1963 11987 Male population 75-79 SP.POP.7579.MA 1974 Population ages 00-14 (% of total SP.POP.0014.TO ZS 1994 27.45874024 Age population, age 20, female, interpolated SP.POP.AG20.FE.IN 2009 1068943 Population ages 65 and above, fernale SP.POP.85UP.FE.IN 2009 2110550 Age population, age 19, female, interpolated SP.POP.AG19.FE.IN 2013 101041 Unemployment, female % of female labor force) SL.UEM.TOTL.FE ZS 1997 7.445000172 Age population, age 03, female, interpolated SP.POP.AGO3.FE.IN 1995 144860 Male population 10-14 SP.POP.1014.MA 1987 120167 Immunization, BCG (% of one-year-old children] SH.IMM.IBCG 1987 Age population, age 0, male, interpolated SP.POP.AGOO.MAN 1982 10970 Health expenditure, total (current USS SH.XPD.TOTL.CO 2005 8223913238 Population ages 00-14, male(% of total SP.POP.0014.MA.ZS 1999 38.02288527 Population ages 65-69, male (% of male population SPPOP6569.MA.5Y 1986 1.17405775 Age population, age 14, female, interpolated SP.POP.AG14.FE.IN 1972 2995 Male population 00-04 SP.POP:0004.MA 1970 1230393 Mortality rate, infant (per 1,000 live births) SPDYNIMRTIN 2013 Survival to age 65, female (% of cohort) SPDYN.TO65.FE.ZS 2009 61.70283977 Literacy rate, youth male (% of males ages 15-24) SE.ADT.1524.LT.MAZ 2011 99.24862 Chile Iceland Sierra Leone Qatar Armenia Honduras Yemen, Rep. Aruba Solomon Islands United Arab Emirates Mexico Philippines Somalia Costa Rica HND YEM ABW SLB ARE MEX PHL SOM CRI Ecuador ECU MRT TUR Mauritania Turkey Estonia Chile Turkmenistan Sudan Equatorial Guinea Korea, Dem. Peoples Rep. EST CHL TKM SDN GNO PRK Kenya KEN Least developed countries: UN classification LDC Bolivia BOL
