1. Memuat Data WDI

# Memanggil library untuk membaca file Excel
library(readxl)

# Ganti "nama_file_kamu.xlsx" dengan nama file Excel kamu
# Pastikan file Excel berada di folder yang sama dengan file R Markdown ini
data_wdi <- read_excel("C:/Users/USER/Downloads/P_Data_Extract_From_World_Development_Indicators.xlsx")

# Menampilkan 10 baris pertama untuk mengecek data
head(data_wdi, 10)
## # A tibble: 10 × 29
##    A                 `Series Code` `Country Name` `Country Code` `2001 [YR2001]`
##    <chr>             <chr>         <chr>          <chr>          <chr>          
##  1 Foreign direct i… BX.KLT.DINV.… Indonesia      IDN            -1.85568619300…
##  2 Foreign direct i… BX.KLT.DINV.… Malaysia       MYS            0.597029318252…
##  3 Foreign direct i… BX.KLT.DINV.… Singapore      SGP            18.93986068573…
##  4 Foreign direct i… BX.KLT.DINV.… Thailand       THA            4.212235095308…
##  5 Foreign direct i… BX.KLT.DINV.… Philippines    PHL            0.962985443934…
##  6 Foreign direct i… BX.KLT.DINV.… Viet Nam       VNM            3.977335452705…
##  7 Foreign direct i… BX.KLT.DINV.… Brunei Daruss… BRN            0.995621601100…
##  8 Foreign direct i… BX.KLT.DINV.… Cambodia       KHM            3.533376690895…
##  9 Foreign direct i… BX.KLT.DINV.… Lao PDR        LAO            1.351579019830…
## 10 Foreign direct i… BX.KLT.DINV.… Myanmar        MMR            3.215657535069…
## # ℹ 24 more variables: `2002 [YR2002]` <chr>, `2003 [YR2003]` <chr>,
## #   `2004 [YR2004]` <chr>, `2005 [YR2005]` <chr>, `2006 [YR2006]` <chr>,
## #   `2007 [YR2007]` <chr>, `2008 [YR2008]` <chr>, `2009 [YR2009]` <chr>,
## #   `2010 [YR2010]` <chr>, `2011 [YR2011]` <chr>, `2012 [YR2012]` <chr>,
## #   `2013 [YR2013]` <chr>, `2014 [YR2014]` <chr>, `2015 [YR2015]` <chr>,
## #   `2016 [YR2016]` <chr>, `2017 [YR2017]` <chr>, `2018 [YR2018]` <chr>,
## #   `2019 [YR2019]` <chr>, `2020 [YR2020]` <chr>, `2021 [YR2021]` <chr>, …

2. Merapikan Struktur Data (Base R)

# Membuang baris keterangan kosong di bagian bawah
data_bersih <- data_wdi[!is.na(data_wdi$`Country Code`) & data_wdi$`Country Code` != "", ]
colnames(data_bersih)[1] <- "Indikator"

# Mengubah kolom tahun (kolom ke-5 sampai ke-29) menjadi format memanjang
tahun_cols <- colnames(data_bersih)[5:ncol(data_bersih)]
data_long <- reshape(
  as.data.frame(data_bersih),
  varying = tahun_cols,
  v.names = "Nilai",
  timevar = "Tahun_Raw",
  times = tahun_cols,
  direction = "long"
)

# Membersihkan angka tahun dan nilai indikator
data_long$Tahun <- as.numeric(substr(data_long$Tahun_Raw, 1, 4))
data_long$Nilai <- suppressWarnings(as.numeric(data_long$Nilai))
rownames(data_long) <- NULL

# Menampilkan daftar 4 indikator
unique(data_long$Indikator)
## [1] "Foreign direct investment, net inflows (% of GDP)"
## [2] "Exports of goods and services (% of GDP)"         
## [3] "Imports of goods and services (% of GDP)"         
## [4] "Population growth (annual %)"

3. Ringkasan Statistik Deskriptif per Indikator

indikator_list <- unique(data_long$Indikator)

ringkasan <- do.call(rbind, lapply(indikator_list, function(ind) {
  sub <- data_long[data_long$Indikator == ind, ]
  data.frame(
    Indikator = ind,
    Jumlah_Data = sum(!is.na(sub$Nilai)),
    Rata_Rata = round(mean(sub$Nilai, na.rm = TRUE), 2),
    Minimum = round(min(sub$Nilai, na.rm = TRUE), 2),
    Maksimum = round(max(sub$Nilai, na.rm = TRUE), 2)
  )
}))

print(ringkasan)
##                                           Indikator Jumlah_Data Rata_Rata
## 1 Foreign direct investment, net inflows (% of GDP)         375      4.12
## 2          Exports of goods and services (% of GDP)         339     54.87
## 3          Imports of goods and services (% of GDP)         339     50.80
## 4                      Population growth (annual %)         375      1.09
##   Minimum Maksimum
## 1   -3.81    32.26
## 2    9.93   228.99
## 3    9.35   208.33
## 4   -4.17     5.32

4. Visualisasi Tren 4 Indikator (15 Negara Selama 25 Tahun)

par(mfrow = c(2, 2), mar = c(4, 4, 3, 1))
negara_list <- unique(data_long$`Country Name`)
warna <- rainbow(length(negara_list))

for (ind in indikator_list) {
  sub_ind <- data_long[data_long$Indikator == ind, ]
  y_range <- range(sub_ind$Nilai, na.rm = TRUE)
  x_range <- range(sub_ind$Tahun, na.rm = TRUE)
  
  plot(x_range, y_range, type = "n",
       main = substr(ind, 1, 45),
       xlab = "Tahun", ylab = "Nilai Indikator")
  grid()
  
  for (i in seq_along(negara_list)) {
    sub_neg <- sub_ind[sub_ind$`Country Name` == negara_list[i], ]
    sub_neg <- sub_neg[order(sub_neg$Tahun), ]
    lines(sub_neg$Tahun, sub_neg$Nilai, col = warna[i], lwd = 1.5)
  }
}

# Menampilkan legenda negara di bawah grafik
par(fig = c(0, 1, 0, 1), oma = c(0, 0, 0, 0), mar = c(0, 0, 0, 0), new = TRUE)
plot(0, 0, type = "n", bty = "n", xaxt = "n", yaxt = "n")
legend("bottom", legend = negara_list, col = warna, lwd = 2, ncol = 5, cex = 0.75, bty = "n")