Query with lambda function in pymongo?

Question

I use the following query to fish for all men in a database:

f = pd.DataFrame(x for x in collection.find({"gender": "M"},{"_id":0}))

How could I find only the men where the "name" starts with an "A". Obviously I could filter the resulting huge DataFrame but how can I avoid creating this Frame in the first place.

Many thanks

A. Jesse Jiryu Davis · Accepted Answer · 2017-03-01 13:33:43Z

2

You can use a MongoDB regular expression query, something like:

from bson.regex import Regex

f = pd.DataFrame(x for x in collection.find({"gender": "M", "name": Regex(r"^A.*")},{"_id":0}))

answered Mar 1, 2017 at 13:33

A. Jesse Jiryu Davis

24.1k5 gold badges60 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

Query with lambda function in 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