How to read data from an Excel .xlsx file in R

To read directly from a .xlsx in the same directory as your R script:

> data <- read.xlsx(“yourdata.xlsx”)

… or …

To read from a workspace directory containing a .xlsx file:

> wdir = “C:/workspace/yourdirectory”
> data <- read.xlsx(paste(wdir, “yoursubdirectory”, “yourdata.xlsx”, sep=“/”))

… or …

To read from the second sheet of a .xlsx workbook:

> wdir = “C:/workspace/yourdirectory”
> data <- read.xlsx(paste(wdir, “yoursubdirectory”, “yourdata.xlsx”, sep=“/”), sheet = 2)

 
0
Kudos
 
0
Kudos

Now read this

How to manually convert an IP address to binary

For IP Address: 182.167.10.48 the complete binary value is: 10110110.10100111.00001010.00110000 Each decimal number in an IP address is represented at a binary octet (8 binary digits). Using the table below for each decimal in the IP... Continue →