csv2sqlite: convert csv to sqlite from...

In mountainMath/cancensusHelpers: Helper functions for Cancensus

convert csv to sqlite from https://rdrr.io/github/coolbutuseless/csv2sqlite/src/R/csv2sqlite.R

Description

convert csv to sqlite from https://rdrr.io/github/coolbutuseless/csv2sqlite/src/R/csv2sqlite.R

Usage

csv2sqlite(
  csv_file,
  sqlite_file,
  table_name,
  transform = NULL,
  chunk_size = 1e+06,
  append = FALSE,
  col_types = NULL,
  na = c(NA, "..", "F")
)

Arguments

csv_file	input csv path
sqlite_file	output sql database path
table_name	sql table name
transform	optional function that transforms each chunk
chunk_size	optional chunk size to read/write data, default=1,000,000
append	optional parameter, append to database or overwrite, defaul='FALSE'

mountainMath/cancensusHelpers documentation built on May 14, 2022, 12:43 p.m.