4 indikator
library(readxl)
file_path <- "C:/Users/a s u s/Downloads/Data WDI 15 Negara.xlsx"
excel_sheets(file_path)
## [1] "Data" "Series - Metadata"
data_wdi <- read_excel(file_path)
head(data_wdi)
## # A tibble: 6 × 27
## Negara Indikator `2000` `2001` `2002` `2003` `2004` `2005` `2006` `2007`
## <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr> <chr>
## 1 Indonesia Domestic cr… .. .. .. .. .. .. .. ..
## 2 Indonesia Employment … 38.35… 38.61… 38.02… 36.98… 39.78… 38.36… 40.50… 41.10…
## 3 Indonesia Mortality r… 51.4 49 46.7 44.6 48.6 40.70… 38.9 37.20…
## 4 Indonesia Agricultura… 23.76… 24.20… 24.52… 24.78… 24.83… 24.93… 25.52… 26.04…
## 5 Japan Domestic cr… 205.7… 177.6… 175.2… 175.4… 169.1… 169.4… 167.5… 161.4…
## 6 Japan Employment … 64.11… 65.12… 66.21… 66.30… 67.23… 67.84… 67.88… 68.12…
## # ℹ 17 more variables: `2008` <chr>, `2009` <dbl>, `2010` <dbl>, `2011` <dbl>,
## # `2012` <dbl>, `2013` <dbl>, `2014` <dbl>, `2015` <dbl>, `2016` <dbl>,
## # `2017` <dbl>, `2018` <chr>, `2019` <chr>, `2020` <chr>, `2021` <chr>,
## # `2022` <chr>, `2023` <chr>, `2024` <chr>
str(data_wdi)
## tibble [65 × 27] (S3: tbl_df/tbl/data.frame)
## $ Negara : chr [1:65] "Indonesia" "Indonesia" "Indonesia" "Indonesia" ...
## $ Indikator: chr [1:65] "Domestic credit to private sector (% of GDP)" "Employment in services (% of total employment) (modeled ILO estimate)" "Mortality rate, under-5 (per 1,000 live births)" "Agricultural land (% of land area)" ...
## $ 2000 : chr [1:65] ".." "38.352998056901001" "51.4" "23.764340067930071" ...
## $ 2001 : chr [1:65] ".." "38.612238771833802" "49" "24.202684500130225" ...
## $ 2002 : chr [1:65] ".." "38.0265807831709" "46.7" "24.522255167590849" ...
## $ 2003 : chr [1:65] ".." "36.983998538692298" "44.6" "24.788564057141365" ...
## $ 2004 : chr [1:65] ".." "39.788658362821202" "48.6" "24.837367824240395" ...
## $ 2005 : chr [1:65] ".." "38.364835090415198" "40.700000000000003" "24.939433369249524" ...
## $ 2006 : chr [1:65] ".." "40.503824263964702" "38.9" "25.520854915449593" ...
## $ 2007 : chr [1:65] ".." "41.1092215565331" "37.200000000000003" "26.049014683739554" ...
## $ 2008 : chr [1:65] ".." "41.210525183387702" "35.6" "26.204342006658788" ...
## $ 2009 : num [1:65] 27.7 42 34.1 26.6 166.6 ...
## $ 2010 : num [1:65] 27.3 43 32.6 26.6 158.5 ...
## $ 2011 : num [1:65] 30.1 43.6 31.2 27.1 157.8 ...
## $ 2012 : num [1:65] 33.4 43.8 29.9 27.1 157.9 ...
## $ 2013 : num [1:65] 36.1 44.2 28.6 27.4 161.2 ...
## $ 2014 : num [1:65] 36.4 44.5 27.3 27.5 160.9 ...
## $ 2015 : num [1:65] 39.1 45.1 26.1 27.6 159.3 ...
## $ 2016 : num [1:65] 39.4 46.6 25 27.9 160.5 ...
## $ 2017 : num [1:65] 38.7 47.4 23.8 27.8 165.4 ...
## $ 2018 : chr [1:65] "38.805449666563831" "48.168762274452902" "22.8" "28.411834980098739" ...
## $ 2019 : chr [1:65] "38.372693951660935" "49.135632900147499" "21.8" "28.750329557250819" ...
## $ 2020 : chr [1:65] "38.679539089145287" "49.056846345277101" "20.8" "28.96499050076191" ...
## $ 2021 : chr [1:65] "36.990827055625317" "49.2513693430476" "19.899999999999999" "28.955848781541921" ...
## $ 2022 : chr [1:65] "35.288432963268846" "48.847168554459202" "19.100000000000001" "29.007381817864786" ...
## $ 2023 : chr [1:65] "36.012951258869037" "49.2692149419358" "18.399999999999999" "28.905172451284066" ...
## $ 2024 : chr [1:65] "36.392406709514056" "49.753752667753602" "17.7" "28.933374430838221" ...
You can also embed plots, for example:
Note that the echo = FALSE parameter was added to the
code chunk to prevent printing of the R code that generated the
plot.