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
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.