Data WDI 15 Negara

4 indikator

library(readxl)
## Warning: package 'readxl' was built under R version 4.6.2
file_path <- "C:/Users/User/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 Gross fixed… 19.85… 19.67… 19.42… 19.50… 22.44… 23.64… 24.13… 24.94…
## 2 Indonesia Employment … 45.34… 43.83… 44.45… 46.47… 43.41… 44.11… 42.15… 41.36…
## 3 Indonesia Deposit int… 12.50… 15.48… 15.50… 10.59  6.443… 8.079… 11.41… 7.975…
## 4 Indonesia Total natur… 11.12… 9.291… 7.285… 7.142… 9.120… 10.32… 9.407… 9.757…
## 5 Malaysia  Gross fixed… 25.29… 25.12… 23.48… 22.41… 20.95… 22.30… 21.95… 22.40…
## 6 Malaysia  Employment … 15.26… 15.13… 14.92… 14.26… 14.55… 14.63… 14.63… 14.73…
## # ℹ 17 more variables: `2008` <chr>, `2009` <chr>, `2010` <chr>, `2011` <chr>,
## #   `2012` <chr>, `2013` <chr>, `2014` <chr>, `2015` <chr>, `2016` <chr>,
## #   `2017` <chr>, `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] "Gross fixed capital formation (% of GDP)" "Employment in agriculture (% of total employment) (modeled ILO estimate)" "Deposit interest rate (%)" "Total natural resources rents (% of GDP)" ...
##  $ 2000     : chr [1:65] "19.850854447200216" "45.348077756245701" "12.5033333333333" "11.125736694750501" ...
##  $ 2001     : chr [1:65] "19.67265820416662" "43.8339408350719" "15.4816666666666" "9.2919718311635293" ...
##  $ 2002     : chr [1:65] "19.429164049797308" "44.4511073028184" "15.5025" "7.2859547522191601" ...
##  $ 2003     : chr [1:65] "19.5060592212863" "46.476750556349302" "10.59" "7.1428118800620997" ...
##  $ 2004     : chr [1:65] "22.448616972835314" "43.418815587732297" "6.4433333333333298" "9.1207520930105606" ...
##  $ 2005     : chr [1:65] "23.640511770779106" "44.113854737917201" "8.0791666666666604" "10.325353163284801" ...
##  $ 2006     : chr [1:65] "24.130991528600358" "42.155038659811702" "11.410833333333301" "9.4072289970139202" ...
##  $ 2007     : chr [1:65] "24.946943643022294" "41.367602174637803" "7.9758333333333304" "9.7576625350831208" ...
##  $ 2008     : chr [1:65] "27.698591222092322" "40.704581301065403" "8.4924999999999997" "11.10028650133" ...
##  $ 2009     : chr [1:65] "31.114766557604277" "40.056276355006901" "9.2783333333333307" "6.4259313992844502" ...
##  $ 2010     : chr [1:65] "30.999408825566043" "38.730272800860803" "7.0166666666666604" "7.1356090223889304" ...
##  $ 2011     : chr [1:65] "31.307454036572523" "36.812122889446897" "6.9308333333333296" "8.5631139337505999" ...
##  $ 2012     : chr [1:65] "32.719628065027067" "35.5604756448204" "5.9466666666666601" "5.9456148632056296" ...
##  $ 2013     : chr [1:65] "31.96577956768887" "34.690232071885603" "6.26416666666666" "5.3899090339549502" ...
##  $ 2014     : chr [1:65] "32.516741440510174" "34.004694676718202" "8.7524999999999995" "4.7916210368797802" ...
##  $ 2015     : chr [1:65] "32.811926582392275" "32.777029568774097" "8.3366666666666607" "3.0813673638197798" ...
##  $ 2016     : chr [1:65] "32.577731496602269" "31.555332922147699" "7.1658935677561999" "2.66818993930963" ...
##  $ 2017     : chr [1:65] "32.160638864264463" "30.522202442974201" "6.51833333333333" "3.0801617715227598" ...
##  $ 2018     : chr [1:65] "32.288497089569368" "29.446490076998799" "6.1291666666666602" "4.2166337444965398" ...
##  $ 2019     : chr [1:65] "32.346884551854629" "28.463133613771301" "6.6883333333333299" "3.2358396766883599" ...
##  $ 2020     : chr [1:65] "31.709756451801539" "29.308748165297299" "5.5041666666666602" "2.4386673227510198" ...
##  $ 2021     : chr [1:65] "30.794195058517499" "28.987199819683099" "3.6658333333333299" "5.1570400845170496" ...
##  $ 2022     : chr [1:65] "29.084875529188491" "29.2848629874109" "3.21" ".." ...
##  $ 2023     : chr [1:65] "29.152717252543653" "28.779228057624898" "4.6341666666666601" ".." ...
##  $ 2024     : chr [1:65] "29.145550417046561" "27.9600749776458" "5.42627869005441" ".." ...

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.