Top "Ranking" questions

Ranking is the sorted order of an element in a list of elements.

Using LIMIT within GROUP BY to get N results per group?

The following query: SELECT year, id, rate FROM h WHERE year BETWEEN 2000 AND 2009 AND id IN (SELECT rid FROM table2) …

sql mysql greatest-n-per-group ranking
Find the n most common values in a vector

I have a vector say c(1,1,1,1,1,1,2,3,4,5,7,7,5,7,7,7) How do I count each element, and then return the e.g. 3 most common …

r count ranking
How do I find the closest values in a Pandas series to an input number?

I have seen: how do I find the closest value to a given number in an array? How do I …

python pandas dataframe ranking
Efficient method to calculate the rank vector of a list in Python

I'm looking for an efficient way to calculate the rank vector of a list in Python, similar to R's rank …

python list sorting ranking
String similarity algorithms?

I need to compare 2 strings and calculate their similarity, to filter down a list of the most similar strings. Eg. …

algorithm string comparison filtering ranking
How to add row number column in SQL Server 2012

I'm trying to add a new column to an existing table, where the value is the row number/rank. I …

sql sql-server ranking row-number ranking-functions
Adding a ranking column to a dataframe

This seems like it must be a very common task, but I can't find a solution in google or SO. …

r ranking
"Most popular" GROUP BY in LINQ?

Assuming a table of tags like the stackoverflow question tags: TagID (bigint), QuestionID (bigint), Tag (varchar) What is the most …

.net linq group-by ranking
How to create a Decile and Quintile columns to rank another variable based on size using Python, Pandas?

I have a data frame with a column containing Investment which represents the amount invested by a trader. I would …

python pandas ranking
Ranking array elements

I need an algorithm to rank elements of an array in Javascript. Example : I have an array as follows: [79, 5, 18, 5, 32, 1, 16, 1, 82, 13] I …

javascript arrays algorithm sorting ranking