How to insert a document with null value into mongodb using pymongo?

Question

I have a .csv file with a few cells set to null and am trying to store this data in mongodb using pymongo. However I will be feeding this data to an API so I need the fields to be null instead of a string that says "null". I tried setting the null cells with None-

data.append( {  'date' : row[0] if row[0] != 'null' else None} )

but this produces the following document-

{ "_id" : ObjectId("5f3713b36e752a743d5b293d") }

The field that I set to null is not present, which returns undefined when accessed.

Is there a way to set this to null?

D. SM · Accepted Answer · 2020-08-15 00:18:04Z

4

Storing None puts nulls into the database.

>>> client.foo.foo.insert_one(dict(a=1, b=None))
<pymongo.results.InsertOneResult object at 0x7f6aaa348c00>
>>> client.foo.foo.find_one()
{'_id': ObjectId('5f372970ac9b70fe41e39672'), 'a': 1, 'b': None}

In shell:

MongoDB Enterprise ruby-driver-rs:PRIMARY> db.foo.find()
{ "_id" : ObjectId("5f372970ac9b70fe41e39672"), "a" : 1, "b" : null }

answered Aug 15, 2020 at 0:18

D. SM

14.6k3 gold badges15 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to insert a document with null value into mongodb using pymongo?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related