Add data to a Deep Origin Database

This document describes how to add data to a Deep Origin Database.

Consider the following dataframe constructed from a database using:

from deeporigin.data_hub import api
df = api.get_dataframe("xy")
df

Add new rows

To add new rows to the underlying database, use the add_databse_rows function:

data = dict(X=[1, 2], Y=[2, 3])
api.add_database_rows(database_id="xy", data=data)

data should be a dictionary where the keys are column names and the values are lists of values to be written to the corresponding columns. add_database_rows will add this data to the database, creating as many new rows as needed.

add_database_rows returns a list of the row IDs created during this process.

Add fragments of new rows

Similarly, fragments of rows (subsets of columns) can be written to the database:

data = dict(X=[10, 20]) # note Y is not specified
api.add_database_rows(database_id="xy", data=data)

add_database_rows returns a list of the row IDs created during this process, for example:

["row-1", "row-2"]

Reference

The reference documentation for add_database_rows