sorting

Hello! I am working with a very large medicationprescription dataset (over 50 000 participants). In addition, every participant have on average 10 medications listed vertically, so that each participant occupy many cases vertically. I have to merge one file with the prescription data with...

Let's say we have one contestant who played 1 game and won (1 out of 1), another who played 50 and won 49 of them (49 of 50), and so on. I need to produce a ranking of those contestants even though the count of games is different. The higher number of played games should give higher certainty...