pandas.io.sql.write_frame¶
- pandas.io.sql.write_frame(frame, name, con, flavor='sqlite', if_exists='fail', **kwargs)¶
DEPRECATED - use to_sql
Write records stored in a DataFrame to a SQL database.
Parameters : frame : DataFrame
name : string
con : DBAPI2 connection
flavor : {‘sqlite’, ‘mysql’}, default ‘sqlite’
The flavor of SQL to use.
if_exists : {‘fail’, ‘replace’, ‘append’}, default ‘fail’
- fail: If table exists, do nothing.
- replace: If table exists, drop it, recreate it, and insert data.
- append: If table exists, insert data. Create if does not exist.
index : boolean, default False
Write DataFrame index as a column
See also
Notes
This function is deprecated in favor of to_sql. There are however two differences:
- With to_sql the index is written to the sql database by default. To keep the behaviour this function you need to specify index=False.
- The new to_sql function supports sqlalchemy engines to work with different sql flavors.