data <- read_csv("API_19_DS2_en_csv_v2_6542870.csv", skip = 4)
head(data)
## # A tibble: 6 × 68
## `Country Name` `Country Code` `Indicator Name` `Indicator Code` `1960`
## <chr> <chr> <chr> <chr> <dbl>
## 1 Aruba ABW Urban population (% of… SP.URB.TOTL.IN.… 50.8
## 2 Aruba ABW Urban population SP.URB.TOTL 27728
## 3 Aruba ABW Urban population growt… SP.URB.GROW NA
## 4 Aruba ABW Population, total SP.POP.TOTL 54608
## 5 Aruba ABW Population growth (ann… SP.POP.GROW NA
## 6 Aruba ABW Poverty headcount rati… SI.POV.DDAY NA
## # ℹ 63 more variables: `1961` <dbl>, `1962` <dbl>, `1963` <dbl>, `1964` <dbl>,
## # `1965` <dbl>, `1966` <dbl>, `1967` <dbl>, `1968` <dbl>, `1969` <dbl>,
## # `1970` <dbl>, `1971` <dbl>, `1972` <dbl>, `1973` <dbl>, `1974` <dbl>,
## # `1975` <dbl>, `1976` <dbl>, `1977` <dbl>, `1978` <dbl>, `1979` <dbl>,
## # `1980` <dbl>, `1981` <dbl>, `1982` <dbl>, `1983` <dbl>, `1984` <dbl>,
## # `1985` <dbl>, `1986` <dbl>, `1987` <dbl>, `1988` <dbl>, `1989` <dbl>,
## # `1990` <dbl>, `1991` <dbl>, `1992` <dbl>, `1993` <dbl>, `1994` <dbl>, …