Save a table#
To a CSV#
table.to_csv('filename.csv')
To JSON#
table.to_json('filename.json')
To newline-delimited JSON#
table.to_json('filename.json', newline=True)
To a SQL database#
Use the agate-sql extension.
import agatesql
table.to_sql('postgresql:///database', 'output_table')