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)
