utils.data_storage.dataframe2sql module

Facilities for interfacing dataframes to SQL databases

append_dataframe_to_sqlite(dataframe, dbname='', tablename='results', dtypes=None, log_git_info=True)[source]

Append dataframe to a SQLite

Parameters

  • dataframe (pandas.Dataframe) –

  • dbname –

  • tablename –

  • types –

read_pkl_sql(dbname='', tablename='results', dtypes=None)[source]

Read results from a SQLite database to a dataframe and reconstruct pickled objects

Parameters

  • dbname (str) –

  • tablename (str) –

  • dtypes (dict, None) –

Returns

Return type

pd.DataFrame