I think you have a typo or some other error in your program as I just did a test with your sample data and query and it works - see the GIF

Below is my test code which connects to the database called so and the collection speciesCollection, maybe you find the error in yours with it

import pymongo

client = pymongo.MongoClient('dockerhostlinux1', 30000)
db = client.so
coll = db.speciesCollection

result = coll.find({"SPCOMNAME":{"$in":['paddlefish','lake sturgeon']}})
for doc in result:
    print(doc)

GIF

Pymongo $in Query Not Working - Stack Overflow

https://stackoverflow.com/questions/38919756/pymongo-in-query-not-working

I think you have a typo or some other error in your program as I just did a test with your sample data and query and it works - see the GIF.

How to Query a MongoDB Database using PyMongo in Python?

https://www.analyticsvidhya.com/blog/2020/08/query-a-mongodb-database-using-pymongo/

Aug 21, 2020 ... Table of Contents. What is PyMongo? Installation Steps; Insert the data into the database; Query the database. Filter based on Fields; Filter based ...

pymongo · PyPI

https://pypi.org/project/pymongo/

The PyMongo distribution contains tools for interacting with MongoDB database from Python. The bson package is an implementation of the BSON format for ...

Installing / Upgrading — PyMongo 3.11.3 documentation

https://pymongo.readthedocs.io/en/stable/installation.html

PyMongo comes with its own bson package; doing “pip install bson” or “ easy_install bson” installs a third-party package that is incompatible with PyMongo.

How to Install PyMongo and Connect to MongoDB in Python ...

https://kb.objectrocket.com/mongo-db/how-to-install-pymongo-and-connect-to-mongodb-in-python-363

Jun 3, 2019 ... x Python driver for the MongoDB client are the recommended versions to use. Installing the pymongo module using Python 3. Use the following ...

mongodb/mongo-python-driver: PyMongo - the Python ... - GitHub

https://github.com/mongodb/mongo-python-driver

The PyMongo distribution contains tools for interacting with MongoDB database from Python. The bson package is an implementation of the BSON format for ...

Installing / Upgrading — PyMongo 2.7.2 documentation

https://api.mongodb.com/python/2.7.2/installation.html

pip does not support installing python packages in .egg format. If you would like to install PyMongo from a .egg provided on pypi use easy_install instead. Installing ...

Flask-PyMongo — Flask-PyMongo 2.3.0 documentation

https://flask-pymongo.readthedocs.io/en/latest/

Flask-PyMongo¶. MongoDB is an open source database that stores flexible JSON-like “documents,” which can have any number, name, or hierarchy of fields  ...

Pymongo :: Anaconda.org

https://anaconda.org/anaconda/pymongo

... linux-64 v3.11.3; win-32 v3.11.3; osx-64 v3.11.3; linux-32 v3.7.2; win-64 v3. 11.3. To install this package with conda run: conda install -c anaconda pymongo  ...

Pymongo in soatest — Parasoft Forum

https://forums.parasoft.com/discussion/3007/pymongo-in-soatest

how to add the pymongo in soa test. and from where can i download the pymongo jar file for jython?