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