rio

rio

Swiss-Army Knife for Data I/O.

Basic Usage

library(rio)

# Import any format
df <- import("data.csv")
df <- import("data.xlsx")
df <- import("data.json")
df <- import("data.sav")    # SPSS
df <- import("data.dta")    # Stata
df <- import("data.sas7bdat") # SAS

# Export any format
export(df, "output.csv")
export(df, "output.xlsx")
export(df, "output.json")

Supported Formats

# Text formats
import("data.csv")
import("data.tsv")
import("data.txt")
import("data.psv")  # pipe-separated

# Excel
import("data.xlsx")
import("data.xls")

# Statistical software
import("data.sav")      # SPSS
import("data.dta")      # Stata
import("data.sas7bdat") # SAS
import("data.por")      # SPSS portable
import("data.xpt")      # SAS transport

# Other formats
import("data.json")
import("data.xml")
import("data.html")
import("data.yml")
import("data.rds")
import("data.rdata")
import("data.feather")
import("data.parquet")
import("data.fst")
import("data.qs")

Excel Sheets

# Specific sheet
df <- import("data.xlsx", which = 2)
df <- import("data.xlsx", sheet = "Sheet2")

# All sheets
sheets <- import_list("data.xlsx")
# Returns named list of data frames

Multiple Files

# Import multiple files
files <- list.files(pattern = "*.csv")
data_list <- import_list(files)

# Bind into single data frame
df <- import_list(files, rbind = TRUE)

# With file identifier
df <- import_list(files, rbind = TRUE, rbind_label = "source")

Export Options

# CSV options
export(df, "output.csv", row.names = FALSE)

# Excel options
export(df, "output.xlsx", overwrite = TRUE)

# Multiple sheets
export(list(sheet1 = df1, sheet2 = df2), "output.xlsx")

# Compressed
export(df, "output.csv.gz")

Format Detection

# rio detects format from extension
# Override with format argument
df <- import("data.txt", format = "csv")
df <- import("data", format = "tsv")

# Check supported formats
rio:::.import_formats
rio:::.export_formats

Conversion