How to store datasets and databases from quandl using quandl Python API/module in postgresql or mongodb?

Question

Does anybody know how to use quandl module/API for Python to store datasets and databases into a single database using postgresql or mongodb. Any help will be much appreciated. Thanks.

Answer 1

The data returned from the quandl API are pandas dataframes.

You can save pandas dataframes to mongodb like this using PyMongo:

df = quandl.get("FRED/GDP",returns="pandas")
records = json.loads(df.T.to_json()).values()
db.myCollection.insert(records)

See this post for more information

To write to a SQL database, you can use the to_sql method on the pandas dataframe. See this post for more information