I have the 3 collections users: [ {_id: "aaa", name: "John", department: 1}, {_id: "bbb", name: "Charles", department: 1}, {_id: "ccc", name: "Jessy", department: 1"}, {_id: "ddd", name: "Tim", department: 2}, {_id: "eee", name: "Max", department: 2}, {_id: "fff", name:…
I have a database as below. [ { "title": "Data 1", "slug": "data-1", "sub_docs": [ { "name": "Sub Doc 1", "sub_slug": "sub-doc-1", "urls": [ "https://example.com/path-1", ] }, { "name": "Sub Doc 2", "sub_slug": "sub-doc-2", "urls": [ "https://example.com/path-2" ] }, {…
I have a mongo collection that contains data like: {'email': '[email protected]'} {'email': '[email protected]'} {'email': '[email protected]'} I want to get the the result of email that is [email protected] and [email protected], eg: [{'email':'test1gmail.com'},{'email':'test2gmail.com'}] is there a way I can do this with…
I have a large amount of data in a collection in mongodb which I need to analyze, using pandas and pymongo in jupyter. I am trying to import specific data in a dataframe. Sample data. { "stored": "2022-04-xx", ... ...…
I am trying to fetch data based on filter based queries. Right now I am using filter_stuff = {'url': 1, 'organization_name': 1, 'hum_pred':1, 'ml_pred':1, '_id': 0} myData = list(crawlcol.find({'hum_pred': 'null'}, filter_stuff)) This will fetch data where hum_pred have values null.…
I have a mongo database having data record like below [ {"name" : "a", "email" : "[email protected]","ml_pred":"valid","hum_pred":"null", "score":0.92}, {"name" : "b","email" : "[email protected]","ml_pred":"invalid","hum_pred":"null", "score":0.2}, {"name" : "c","email" : "[email protected]","ml_pred":"null","hum_pred":"null"}, {"name" : "d","email" : "[email protected]","ml_pred":"null","hum_pred":"null"}, {"name" : "e","email" : "[email protected]","ml_pred":"null","hum_pred":"null"} ]…
How do we enable PyMongo to read from the nearest? This field db.read_preference is read-only now. from pymongo import ReplicaSetConnection from pymongo import ReadPreference db = ReplicaSetConnection('localhost:27017', replicaSet='rs1')['my_db'] db.read_preference = ReadPreference.NEAREST db.tag_sets = [{'secondaries': 1}]
I'm working on a Discord bot that saves some data to a mongodb database in response to some user commands. The weird thing is it works on repl.it, but I get this error on SparkedHost. I'm getting an odd error…
I have collection like this: mc.db.collection.insert_many([ {"key_array": [1], "another_array": ["a"]}, {"key_array": [2, 3], "another_array": ["b"]}, {"key_array": [4], "another_array": ["c", "d"]}, ]) And I'm using this kind of updates: mc.db.collection.update_one( {"key_array": 5}, {"$addToSet": {"another_array": "f"}}, upsert=True ) It works good with…
As the title suggests, I have a document that contains an array of objects (comments) within an array of objects (notes). Users can comment on each note, but I'm also trying to add a delete function to remove the comments…