Writing time series data to MongoDB
MongoDB is a document database system that stores data in BSON format. When you query data from MongoDB, the data will be represented in JSON format. BSON is similar to JSON; it is the binary encoding of JSON. Unlike JSON, though, it is not in a human-readable format. JSON is great for transmitting data and is system-agnostic. BSON is designed to store data and is associated with MongoDB.
In this recipe, you will explore writing a pandas DataFrame to MongoDB.
Getting ready
You should refer to the recipe “Reading data from a document database” in Chapter 3, Reading Time Series Data from Databases as a refresher on the different ways to connect to MongoDB.
In the Reading data from a document database recipe in Chapter 3, Reading Time Series Data from Databases, we installed pymongo
. For this recipe, you will be using that same library again.
To install using conda, run the following:
$ conda install -c anaconda pymongo -y
To install...