def generateDraft(filename, roster_file, rosterNames): data = {} with open(filename) as draft_file: data = json.load(draft_file) draft_file.close() rNames = {} with open(rosterNames) as s_file: rNames = json.load(s_file) s_file.close() rosters = {} with open(roster_file) as r_file: rosters = json.load(r_file) r_file.close() mappedRosters = list( map(lambda x: { "roster_id": x["roster_id"], "players": x["players"] }, rosters)) groupedRosters = py_.group_by(mappedRosters, "roster_id") # print(groupedRosters) mappedData = list( map( lambda x: { "roster_id": x["roster_id"], "player_id": x["player_id"], }, data)) groupedData = py_.group_by(mappedData, "roster_id") groupedOutput = {} names = [] drafted = [] acquired = [] percentage = [] for key, value in groupedData.items(): players = [] for player in value: players.append(player["player_id"]) rosterPlayers = groupedRosters[key][0]["players"] # print(len(rosterPlayers)) groupedOutput[key] = players output = {} output["drafted"] = py_.intersection(players, rosterPlayers) output["acquired"] = py_.difference(rosterPlayers, players) # print(rNames["players"][str(key)]["display_name"] + "," + str(len(output["drafted"])) + "," + str(len(output["acquired"]))) # table = pandas.DataFrame({"names": rNames["players"][str(key)]["display_name"]}) # print(table) names.append(rNames["players"][str(key)]["display_name"]) drafted.append(len(output["drafted"])) acquired.append(len(output["acquired"])) percentage.append(round(len(output["drafted"]) / 15, 2)) groupedOutput[key] = output table = pandas.DataFrame({ "names": names, "drafted": drafted, "acquired": acquired, "Percentage": percentage }) output = {} output["draft"] = groupedOutput league_id = "458672130456809472" draft_file = "leagues/" + league_id + "/draftSorted.json"
def test_jfykx(): #酒房丫口线 piny = get_pinyin_data() client = MongoClient('localhost', 27017) db = client['kmgd_pe'] collection_fea = db['features'] collection_network = db['network'] collection_edges = db['edges'] one = collection_network.find_one( {'_id': add_mongo_id('570ce0c1ca49c80858320619')}) # print(len(one['properties']['nodes'])) branches = [] l = list(collection_fea.find({'properties.py': { '$regex': '^.*dhpzzx.*$' }})) # 大河平掌支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'大河平掌支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线大河平掌支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': { '$regex': '^.*bszzx.*$' }})) # 控制半山寨支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'控制半山寨支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线控制半山寨支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': { '$regex': '^.*mchzx.*$' }})) # 控制马草河支线支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'控制马草河支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线控制马草河支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': { '$regex': '^.*dpzzx.*$' }})) # 大平掌支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'大平掌支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线大平掌支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': { '$regex': '^.*bjzx.*$' }})) # 碧鸡支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'碧鸡支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线碧鸡支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^jfykxN.*$'}})) ids = _.pluck(l, '_id') main_ids = _.difference(ids, branches) print('len(main_ids)=%d' % len(main_ids)) l = list(collection_fea.find({'_id': {'$in': main_ids}})) # 酒房丫口线 l = sortlist(collection_edges, l) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'酒房丫口线%d, [%s]' % (len(l), s)) name = u'酒房丫口线主线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } collection_network.insert(o)
def test_jfykx():#酒房丫口线 piny = get_pinyin_data() client = MongoClient('localhost', 27017) db = client['kmgd_pe'] collection_fea = db['features'] collection_network = db['network'] collection_edges = db['edges'] one = collection_network.find_one({'_id': add_mongo_id('570ce0c1ca49c80858320619')}) # print(len(one['properties']['nodes'])) branches = [] l = list(collection_fea.find({'properties.py': {'$regex': '^.*dhpzzx.*$'}})) # 大河平掌支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'大河平掌支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线大河平掌支线' o = {'properties':{ 'name':name, 'py':piny.hanzi2pinyin_first_letter(name.replace('#','').replace('II',u'二').replace('I',u'一').replace(u'Ⅱ',u'二').replace(u'Ⅰ',u'一')), 'voltage':'12', 'webgis_type':'polyline_dn', 'nodes':_.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^.*bszzx.*$'}})) # 控制半山寨支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'控制半山寨支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线控制半山寨支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^.*mchzx.*$'}})) # 控制马草河支线支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'控制马草河支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线控制马草河支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^.*dpzzx.*$'}})) # 大平掌支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'大平掌支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线大平掌支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^.*bjzx.*$'}})) # 碧鸡支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'碧鸡支线%d, [%s]' % (len(l), s)) name = u'酒房丫口线碧鸡支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^jfykxN.*$'}})) ids = _.pluck(l, '_id') main_ids = _.difference(ids, branches) print('len(main_ids)=%d' % len(main_ids)) l = list(collection_fea.find({'_id': {'$in': main_ids}})) # 酒房丫口线 l = sortlist(collection_edges, l) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'酒房丫口线%d, [%s]' % (len(l), s)) name = u'酒房丫口线主线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} collection_network.insert(o)
def test_pzzx(): #坪掌寨线 piny = get_pinyin_data() client = MongoClient('localhost', 27017) db = client['kmgd_pe'] collection_fea = db['features'] collection_network = db['network'] collection_edges = db['edges'] one = collection_network.find_one( {'_id': add_mongo_id('570ce0c1ca49c8085832061a')}) branches = [] print(len(one['properties']['nodes'])) l = list(collection_fea.find({'properties.py': { '$regex': '^.*sslzx.*$' }})) #松山林支线 # print(len(l)) l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'松山林支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线松山林支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': { '$regex': '^.*mdszx.*$' }})) # 忙肚山支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'忙肚山支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线忙肚山支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': { '$regex': '^.*mdszx.*$' }})) # 大河边支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'大河边支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线大河边支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': { '$regex': '^.*xdtzx.*$' }})) #下大田支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'下大田支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线下大田支线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^pzzxN.*$'}})) ids = _.pluck(l, '_id') main_ids = _.difference(ids, branches) print('len(main_ids)=%d' % len(main_ids)) l = list(collection_fea.find({'_id': {'$in': main_ids}})) # 坪掌寨线 l = sortlist(collection_edges, l) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'坪掌寨线%d, [%s]' % (len(l), s)) name = u'坪掌寨线主线' o = { 'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace( 'I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') } } collection_network.insert(o)
def test_pzzx():#坪掌寨线 piny = get_pinyin_data() client = MongoClient('localhost', 27017) db = client['kmgd_pe'] collection_fea = db['features'] collection_network = db['network'] collection_edges = db['edges'] one = collection_network.find_one({'_id':add_mongo_id('570ce0c1ca49c8085832061a')}) branches = [] print(len(one['properties']['nodes'])) l = list(collection_fea.find({'properties.py': {'$regex': '^.*sslzx.*$'}})) #松山林支线 # print(len(l)) l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'松山林支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线松山林支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^.*mdszx.*$'}})) # 忙肚山支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'忙肚山支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线忙肚山支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^.*mdszx.*$'}})) # 大河边支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'大河边支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线大河边支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^.*xdtzx.*$'}})) #下大田支线 l = sortlist(collection_edges, l) branches.extend(_.pluck(l, '_id')) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'下大田支线%d, [%s]' % (len(l), s)) name = u'坪掌寨线下大田支线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} # print(o) collection_network.insert(o) l = list(collection_fea.find({'properties.py': {'$regex': '^pzzxN.*$'}})) ids = _.pluck(l, '_id') main_ids = _.difference(ids, branches) print('len(main_ids)=%d' % len(main_ids)) l = list(collection_fea.find({'_id': {'$in': main_ids}})) # 坪掌寨线 l = sortlist(collection_edges, l) s = ','.join(_.deep_pluck(l, 'properties.name')) print(u'坪掌寨线%d, [%s]' % (len(l), s)) name = u'坪掌寨线主线' o = {'properties': { 'name': name, 'py': piny.hanzi2pinyin_first_letter( name.replace('#', '').replace('II', u'二').replace('I', u'一').replace(u'Ⅱ', u'二').replace(u'Ⅰ', u'一')), 'voltage': '12', 'webgis_type': 'polyline_dn', 'nodes': _.pluck(l, '_id') }} collection_network.insert(o)