read_csv_duckdb {duckplyr} | R Documentation |
Read CSV files using DuckDB
Description
read_csv_duckdb()
reads a CSV file using DuckDB's read_csv_auto()
table function.
Usage
read_csv_duckdb(
path,
...,
prudence = c("thrifty", "lavish", "stingy"),
options = list()
)
Arguments
path |
Path to files, glob patterns |
... |
These dots are for future extensions and must be empty. |
prudence |
Memory protection, controls if DuckDB may convert intermediate results in DuckDB-managed memory to data frames in R memory.
The default is |
options |
Arguments to the DuckDB |
See Also
read_parquet_duckdb()
, read_json_duckdb()
Examples
# Create simple CSV file
path <- tempfile("duckplyr_test_", fileext = ".csv")
write.csv(data.frame(a = 1:3, b = letters[4:6]), path, row.names = FALSE)
# Reading is immediate
df <- read_csv_duckdb(path)
# Names are always available
names(df)
# Materialization upon access is turned off by default
try(print(df$a))
# Materialize explicitly
collect(df)$a
# Automatic materialization with prudence = "lavish"
df <- read_csv_duckdb(path, prudence = "lavish")
df$a
# Specify column types
read_csv_duckdb(
path,
options = list(delim = ",", types = list(c("DOUBLE", "VARCHAR")))
)
[Package duckplyr version 1.1.0 Index]