module sql.pandas_sql_helper
¶
Short summary¶
module pyensae.sql.pandas_sql_helper
Pandas and SQL
Functions¶
function |
truncated documentation |
---|---|
Function which imports a file into a database using pandas. It the table exists, it removes it first. There is no addition. … |
Documentation¶
Pandas and SQL
- pyensae.sql.pandas_sql_helper.import_flatfile_into_database_pandas(filedb, filetext, table=None, engine='SQLite', host='localhost', add_key=None, fLOG=<built-in function print>, **options)¶
Function which imports a file into a database using pandas. It the table exists, it removes it first. There is no addition.
- Parameters:
filedb – something.db3
filetext – something.txt or .tsv
table – table name (in the database), if None, the database name will be the filename without extension
engine – engine to use when using a SQL server (SQLite or ODBCMSSQL)
host – host (server)
fLOG – logging function (will display information through the command line)
add_key – name of a key to add (or None if nothing to add)
encoding – encoding
options – options passed to pandas.read_csv
- Returns:
table name