EGD-mine Changeset - 402daa48409f

Changeset - 402daa48409f

Parent rev.

Child rev.

[Not reviewed]

default

0 2 0

Laman - 7 years ago 2018-06-15 00:40:03

lifespans: omezeno na hráče od 20k, přidán max_rating

2 files changed with 6 insertions and 5 deletions:

.hgignore

queries.py

0 comments (0 inline, 0 general)

.hgignore

➞

Show inline comments

 ^\.
 all.hst
 tlist.html
 egd.db
 __pycache__
 histograms

queries.py

➞

Show inline comments

@@ @@ -224,25 +224,25 @@ def timeToPeak(): @@
 	# join on pin, max_rating může duplikovat řádky, když měl hráč stejný max_rating vícekrát.
 	# proto ten ošklivý vnější group by :-ú
 	query="""
 		select subq.pin,min(min_rating),min(max_rating),min(_min_datum) as min_datum,min(datum) as peak_datum,(julianday(min(datum))-julianday(min(_min_datum)))/365.25 as time_to_peak
 			from players_performance_tournaments as ppt
 				join (select pin,min(rating_before) as min_rating,max(rating_after) as max_rating,min(datum) as _min_datum from players_performance_tournaments group by pin having min_rating<=600) as subq on ppt.pin=subq.pin and ppt.rating_after=max_rating
 			group by ppt.pin
 	"""
 	tournamentCounts=_tournamentsToPeak()
 	res=cursor.execute(query)
-	print("pin\tmin rating\tmax rating\tprvní turnaj\tdosažení max ratingu\troky k max ratingu\tturnaje k max ratingu")
+	print("pin\tmin rating\tmax_rating\tprvní turnaj\tdosažení max ratingu\ttime_to_peak\tturnaje k max ratingu")
 	for rec in res:
 		pin=rec[0]
 		print("\t".join([str(x) for x in rec]+[str(tournamentCounts[pin])]))
 def playersProgress():
 	"""Všem hráčům vypíše rating po jednotlivých letech. Zobrazuje rating na konci roku, zaokrouhlený dolů na stovky. Nula značí rok bez záznamu v databázi."""
 	y1=1996
 	y2=2018
 	class Player:
 		def __init__(self):
@@ @@ -269,32 +269,32 @@ def playersProgress(): @@
 			players[pin]=p
 		if year not in p.rating: p.rating[year]=round(rating//100*100)
 		if i%1000==0: print(i,"/ ?","\r",end="",file=sys.stderr)
 	print(" "*20,file=sys.stderr)
 	print("pin\tkód země\tpočet turnajů\t"+"\t".join(str(y) for y in range(y1,y2)))
 	for (pin,p) in players.items():
 		print(pin,p.country,p.tournamentCount,*(p.rating.get(y,0) for y in range(y1,y2)),sep="\t")
 def lifeSpans():
 	"""Životnosti hráčů. Datum prvního a posledního turnaje, jejich rozdíl v letech, počet odehraných turnajů."""
 	query="""select pin,min(datum) as min_datum,max(datum) as max_datum,(julianday(max(datum))-julianday(min(datum)))/365.25 as lifespan,count(datum) as t_count
 		from players_performance_tournaments group by pin"""
 	query="""select pin,min(datum) as min_datum,max(datum) as max_datum,(julianday(max(datum))-julianday(min(datum)))/365.25 as lifespan,count(datum) as t_count,max(rating_after) as max_rating
 		from players_performance_tournaments group by pin having min(rating_before)<=100"""
 	res=cursor.execute(query)
 	print("pin\tmin datum\tmax datum\tmax-min\tpočet turnajů")
+	print("pin\tmin datum\tmax datum\tmax-min\tpočet turnajů\tmax rating")
 	for rec in res:
 		print("\t".join([str(x) for x in rec]))
 # playerHistory("Kotowski Jaroslav")
 # timeRank(2017,"CZ")
 # yearsByCountry(2001,2018)
 # populationStrength(2001,2018,"RU")
 # populationAge(2001,2018,"RU")
 # tournamentAttendance(2001,2018)
 # fetchByRating(2600,"CZ")
 # timeToPeak()
 # playersProgress()
-# lifeSpans()
 lifeSpans()

0 comments (0 inline, 0 general)