create_table: create_table Function

In OpenBioMaps/obm.r: OpenBioMaps API interface for R

create_table Function

Description

Create table structure from csv file ./create_table_from_csv.R –file foo.csv [–sep , –quote \' –createtable –project ... –table ... –na_values ...] Default for quote is " Default for sep is , Default for createtable is FALSE. If TRUE, SQL output will be CREATE TABLE... instead of ALTER TABLE... No default for project. If set, table name will be prefixed with this value Default table is the basename of the csv file.

Usage

create_table(
  file = NULL,
  data = NULL,
  sep = ",",
  quote = "'",
  createtable = FALSE,
  project = FALSE,
  table = NULL,
  na_values = ""
)

Arguments

file	csv file for processing
data	instead of input file using a data.frame as input object
sep	separator character in csv file
quote	quote character of fields in csv file
createtable	output as CREATE TABLE ... or ALTER TABLE ... ADD COLUMN ...
project	prefix for table name
table	the output sql table name
na_values	Ommitted na values in type analises. na_value can be a vector or a single value as well. Default is empty the cell "".

OpenBioMaps/obm.r documentation built on Feb. 22, 2023, 5:47 p.m.