R Data Import: Read Any File Format

1 year ago
Isabella Edwards
1 minute

In the R programming language, various functions can be used to read and import data files in different formats, as shown below:

  1. – Use the function read.table()
  2. Import a CSV file into R.
data <- read.table("data.txt", header = TRUE)
# 或
data <- read.csv("data.csv")
  1. “view Excel sheets”
  2. import the data from an Excel file
  3. The term “readxl” can be interpreted as reading Excel files using R programming language.
install.packages("readxl")
library(readxl)
data <- read_excel("data.xlsx")
  1. Database Interface
  2. Database Interface
install.packages("DBI")
library(DBI)
con <- dbConnect(RSQLite::SQLite(), "database.db")
data <- dbGetQuery(con, "SELECT * FROM table")
  1. from another country
  2. open the SPSS file
  3. – from another country
install.packages("foreign")
library(foreign)
data <- read.spss("data.sav", to.data.frame = TRUE)
  1. jsonlite is a library for working with JSON data in R.
  2. convert JSON to an object
  3. jsonlite is a package in R used for working with JSON data.
install.packages("jsonlite")
library(jsonlite)
data <- fromJSON("data.json")

By using the above methods, it is easy to read and import various types of data files into R for analysis and processing.

bannerAds