User confirmation needed
CSV to Database configuration
Table Name
*
Name of table to be created from csv data.
CSV File
*
Select a CSV file to be uploaded to a database.
Database
Schema
Specify a schema (if database flavor supports this).
Delimiter
*
Delimiter used by CSV file (for whitespace use \s+).
Table Exists
*
Fail
Replace
Append
If table exists do one of the following: Fail (do nothing), Replace (drop and recreate table) or Append (insert data).
Header Row
Row containing the headers to use as column names (0 is first line of data). Leave empty if there is no header row.
Index Column
Column to use as the row labels of the dataframe. Leave empty if no index column.
Mangle Duplicate Columns
Specify duplicate columns as "X.0, X.1".
Skip Initial Space
Skip spaces after delimiter.
Skip Rows
Number of rows to skip at start of file.
Rows to Read
Number of rows of file to read.
Skip Blank Lines
Skip blank lines rather than interpreting them as NaN values.
Parse Dates
A comma separated list of columns that should be parsed as dates.
Infer Datetime Format
Use Pandas to interpret the datetime format automatically.
Decimal Character
Character to interpret as decimal point.
Dataframe Index
Write dataframe index as a column.
Column Label(s)
Column label for index column(s). If None is given and Dataframe Index is True, Index Names are used.
Null values
Json list of the values that should be treated as null. Examples: [""], ["None", "N/A"], ["nan", "null"]. Warning: Hive database supports only single value. Use [""] for empty string.
Save