How to Sort Documents in Ascending Order in Python


In this example, we will learn how to sort the documents in ascending order using sort() method in Python MongoDB.

Source Code

from pymongo import MongoClient

client = MongoClient("localhost", 27017)
db = client["mydatabase"]
collection = db["us_state"]

for x in collection.find().sort("Capital"):
    print(x)

Output:

{'_id': 10, 'State_name': 'Georgia', 'Abbreviation': 'GA', 'Capital': 'Atlanta', 'Total_area': 59425}
{'_id': 6, 'State_name': 'Colorado', 'Abbreviation': 'CO', 'Capital': 'Denver', 'Total_area': 104094}
{'_id': 8, 'State_name': 'Delaware', 'Abbreviation': 'DE', 'Capital': 'Dover', 'Total_area': 2489}
{'_id': 7, 'State_name': 'Connecticut', 'Abbreviation': 'CT', 'Capital': 'Hartford', 'Total_area': 5543}
{'_id': 2, 'State_name': 'Alaska', 'Abbreviation': 'AK', 'Capital': 'Juneau', 'Total_area': 665384}
{'_id': 4, 'State_name': 'Arkansas', 'Abbreviation': 'AR', 'Capital': 'Little Rock', 'Total_area': 53179}
{'_id': 1, 'State_name': 'Alabama', 'Abbreviation': 'AL', 'Capital': 'Montgomery', 'Total_area': 52420}
{'_id': 3, 'State_name': 'Arizona', 'Abbreviation': 'AZ', 'Capital': 'Phoenix', 'Total_area': 113990}
{'_id': 5, 'State_name': 'California', 'Abbreviation': 'CA', 'Capital': 'Sacramento', 'Total_area': 163695}
{'_id': 9, 'State_name': 'Florida', 'Abbreviation': 'FL', 'Capital': 'Tallahassee', 'Total_area': 65758}
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments