library(readxl)
## Warning: package 'readxl' was built under R version 4.6.2
file_path <- "C:/Users/USER/Downloads/P_Data_Extract_From_World_Development_Indicators.xlsx"
data_mentah <- read_excel(file_path, sheet = "Data")
head(data_mentah)
## # A tibble: 6 × 29
##   `Country Name` `Country Code` `Series Name`      `Series Code` `2001 [YR2001]`
##   <chr>          <chr>          <chr>              <chr>                   <dbl>
## 1 Indonesia      IDN            Foreign direct in… BX.KLT.DINV.…          -1.86 
## 2 Indonesia      IDN            GDP per capita gr… NY.GDP.PCAP.…           2.21 
## 3 Indonesia      IDN            Unemployment, tot… SL.UEM.TOTL.…           6.08 
## 4 Indonesia      IDN            Exports of goods … NE.EXP.GNFS.…          39.0  
## 5 Malaysia       MYS            Foreign direct in… BX.KLT.DINV.…           0.597
## 6 Malaysia       MYS            GDP per capita gr… NY.GDP.PCAP.…          -1.87 
## # ℹ 24 more variables: `2002 [YR2002]` <dbl>, `2003 [YR2003]` <dbl>,
## #   `2004 [YR2004]` <dbl>, `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]` <dbl>, …
dim(data_mentah)
## [1] 65 29
names(data_mentah)
##  [1] "Country Name"  "Country Code"  "Series Name"   "Series Code"  
##  [5] "2001 [YR2001]" "2002 [YR2002]" "2003 [YR2003]" "2004 [YR2004]"
##  [9] "2005 [YR2005]" "2006 [YR2006]" "2007 [YR2007]" "2008 [YR2008]"
## [13] "2009 [YR2009]" "2010 [YR2010]" "2011 [YR2011]" "2012 [YR2012]"
## [17] "2013 [YR2013]" "2014 [YR2014]" "2015 [YR2015]" "2016 [YR2016]"
## [21] "2017 [YR2017]" "2018 [YR2018]" "2019 [YR2019]" "2020 [YR2020]"
## [25] "2021 [YR2021]" "2022 [YR2022]" "2023 [YR2023]" "2024 [YR2024]"
## [29] "2025 [YR2025]"
summary(cars)
##      speed           dist       
##  Min.   : 4.0   Min.   :  2.00  
##  1st Qu.:12.0   1st Qu.: 26.00  
##  Median :15.0   Median : 36.00  
##  Mean   :15.4   Mean   : 42.98  
##  3rd Qu.:19.0   3rd Qu.: 56.00  
##  Max.   :25.0   Max.   :120.00

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.