distinct

import pymongo

client = pymongo.MongoClient('192.168.0.136',27017) 
db = client.fangjia_stat
cl=db.rent_average_lg1013.distinct("city")
ll=list(cl)
print(ll)

import pymongo

client = pymongo.MongoClient('192.168.0.136',27017) 
db = client.fangjia
#cl=db.rent_1101_lg.distinct("city")
gg=db.average_statistics.distinct( "name",{"city":'苏州','region':'张家港'})
print(gg)

考虑时间戳的过滤

def distinct(i):
    import pymongo
    import pandas
    client = pymongo.MongoClient('192.168.0.136',27017) 
    db = client.fangjia_stat
    cl=db.test_lg5.distinct("city")
    stamp= pandas.Timestamp('2017-01-24')
    gg=db.test_lg5.distinct("region",{"city":i,'weekend':{"$gt":stamp }})
    #print(gg)
    #{weekend:{$gt:new Date(2017,0,31)}}
    ll=list(cl)
    return len(gg)