pandas to dbase?

[andybell]

Pandas have ability to append data directly to sqlite database. This might be a better way to add the transect data joined by timestamp directly into the database rather than saving each month out to a shapefile.

def df2database(data):
    # appends data to SQL database
    data.to_sql(table_name, connection, flavor='sqlite', if_exists='append')
    return

[andybell]

Not relevant anymore.