1. Importing CSV in R:
R can read .CSV (Comma separated files). The best way to read .csv file is as follows:
# Read CSV into R Data <- read.csv(file=”D:/m/1.csv”, header=TRUE, sep=”,”)
Here header=TRUE specifies that this data includes a header row and sep=”,” specifies that the data is separated by commas.
2. Importing Excel File
One of the best ways to read an Excel file is to export it to comma delimited file. You can use the xlsx package to access Excel files. The first row should contain column names.
# If First row contains variable names then library(xlsx) Data <- read.xlsx(“D:/m/1.xlsx”,1) # Read in the worksheet named mydata Data <- read.xlsx(“D:/m/1.xlsx”, SheetName=”mydata”)
3. Importing txt File into R
# Reading .txt File as dataframe Data <- read.delim(“D:/m/1.txt”, sept=”\t”, header=TRUE)