Data WDI 15 Negara

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" ...

Including Plots

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.