library(readxl)
## Warning: package 'readxl' was built under R version 4.6.2
file_path <- "C:/Users/L e n o v o/Downloads/P_Data_Extract_From_World_Development_Indicators (5).xlsx"
excel_sheets(file_path)
## [1] "Data" "Series - Metadata"
wdi_data <- read_excel(file_path)
str(wdi_data)
## tibble [71 × 29] (S3: tbl_df/tbl/data.frame)
## $ Country Name : chr [1:71] "Indonesia" "Indonesia" "Indonesia" "Indonesia" ...
## $ Country Code : chr [1:71] "IDN" "IDN" "IDN" "IDN" ...
## $ Series Name : chr [1:71] "Individuals using the Internet (% of population)" "GDP growth (annual %)" "Mobile cellular subscriptions (per 100 people)" "GDP per capita (constant 2015 US$)" ...
## $ Series Code : chr [1:71] "IT.NET.USER.ZS" "NY.GDP.MKTP.KD.ZG" "IT.CEL.SETS.P2" "NY.GDP.PCAP.KD" ...
## $ 2001 [YR2001]: chr [1:71] "2.01861385948459" "3.6434664472149194" "2.97627085447856" "1868.5917230729222" ...
## $ 2002 [YR2002]: chr [1:71] "2.13413573295808" "4.49947539085764" "5.26817023997574" "1926.3743586814858" ...
## $ 2003 [YR2003]: chr [1:71] "2.38701977959476" "4.7803691216765429" "8.21835801363769" "1991.9182050647314" ...
## $ 2004 [YR2004]: chr [1:71] "2.60028587633414" "5.03087394501685" "13.3098113507561" "2065.7061747084153" ...
## $ 2005 [YR2005]: num [1:71] 3.6 5.69 20.32 2155.45 2.92 ...
## $ 2006 [YR2006]: num [1:71] 4.76 5.5 27.27 2244.08 1.35 ...
## $ 2007 [YR2007]: num [1:71] 5.79 6.35 39.39 2355.15 1.6 ...
## $ 2008 [YR2008]: num [1:71] 7.92 6.01 58.54 2464.6 1.83 ...
## $ 2009 [YR2009]: num [1:71] 6.92 4.629 67.296 2546.22 0.904 ...
## $ 2010 [YR2010]: num [1:71] 10.92 6.22 85.78 2670.81 2.03 ...
## $ 2011 [YR2011]: num [1:71] 12.28 6.17 100.13 2799.62 2.3 ...
## $ 2012 [YR2012]: num [1:71] 14.52 6.03 111.58 2930.52 2.31 ...
## $ 2013 [YR2013]: num [1:71] 14.94 5.56 122.42 3055.24 2.55 ...
## $ 2014 [YR2014]: num [1:71] 17.14 5.01 125.77 3170.72 2.82 ...
## $ 2015 [YR2015]: num [1:71] 22.06 4.88 129.47 3288.22 2.3 ...
## $ 2016 [YR2016]: num [1:71] 25.447 5.033 145.704 3416.81 0.487 ...
## $ 2017 [YR2017]: num [1:71] 32.34 5.07 162.78 3553.52 2.02 ...
## $ 2018 [YR2018]: num [1:71] 39.9 5.17 118.33 3701.32 1.81 ...
## $ 2019 [YR2019]: num [1:71] 47.69 5.02 125.24 3850.9 2.23 ...
## $ 2020 [YR2020]: num [1:71] 53.73 -2.07 129.4 3739.45 1.81 ...
## $ 2021 [YR2021]: chr [1:71] "62.10447842" "3.7028856282775138" "132.199444256099" "3850.6887725390288" ...
## $ 2022 [YR2022]: chr [1:71] "66.48461277" "5.3071972266479861" "122.873012230307" "4024.9122528839089" ...
## $ 2023 [YR2023]: chr [1:71] "69.20836554" "5.0488311785551616" "125.238194847046" "4192.6440103418081" ...
## $ 2024 [YR2024]: chr [1:71] "72.78075544" "5.0325747708851907" "122.514946500491" "4367.9474184793835" ...
## $ 2025 [YR2025]: chr [1:71] ".." "5.10808904438025" ".." "4555.1805572070152" ...
head(wdi_data)
## # A tibble: 6 × 29
## `Country Name` `Country Code` `Series Name` `Series Code` `2001 [YR2001]`
## <chr> <chr> <chr> <chr> <chr>
## 1 Indonesia IDN Individuals using… IT.NET.USER.… 2.018613859484…
## 2 Indonesia IDN GDP growth (annua… NY.GDP.MKTP.… 3.643466447214…
## 3 Indonesia IDN Mobile cellular s… IT.CEL.SETS.… 2.976270854478…
## 4 Indonesia IDN GDP per capita (c… NY.GDP.PCAP.… 1868.591723072…
## 5 Indonesia IDN Foreign direct in… BX.KLT.DINV.… -1.85568619300…
## 6 Indonesia IDN Population ages 1… SP.POP.1564.… 64.46907069075…
## # ℹ 24 more variables: `2002 [YR2002]` <chr>, `2003 [YR2003]` <chr>,
## # `2004 [YR2004]` <chr>, `2005 [YR2005]` <dbl>, `2006 [YR2006]` <dbl>,
## # `2007 [YR2007]` <dbl>, `2008 [YR2008]` <dbl>, `2009 [YR2009]` <dbl>,
## # `2010 [YR2010]` <dbl>, `2011 [YR2011]` <dbl>, `2012 [YR2012]` <dbl>,
## # `2013 [YR2013]` <dbl>, `2014 [YR2014]` <dbl>, `2015 [YR2015]` <dbl>,
## # `2016 [YR2016]` <dbl>, `2017 [YR2017]` <dbl>, `2018 [YR2018]` <dbl>,
## # `2019 [YR2019]` <dbl>, `2020 [YR2020]` <dbl>, `2021 [YR2021]` <chr>, …
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.