Ranking functions return a ranking value for each row in a partition. Depending on the function that is used, some rows might receive the same value as other rows. Ranking functions are non-deterministic.
Questions tagged [ranking-functions]
193 questions
0
votes
1 answer
Ranking evaluation approach in two stage document retrieval
I have created a two-stage ranking system based on textual similarity ( cosine similarity ) between query-documents pair. Now I need to validate my ranking system whether the retrieved duly-ranked items are correct or not with respect to the user,…
pankaj kashyap
- 372
- 2
- 4
- 13
0
votes
3 answers
How to rank multiple variables in a large data set?
I have a data set of around 50 million records with around 30 variables(columns).
I need to rank the dataset for each variable.
Proc rank does not work since it required lot of memory for this large dataset.
To give rank manually, I have to sort…
Bhargav Ch
- 1
- 4
0
votes
1 answer
Find Salesperson's second highest sale SQL
I have 3 obvious tables, salesperson, orders and customers. In the order table I have a list of all the orders and the SalesPersonID.
I want to find each salesperson with more than 2 orders and find the order value for the second highest order. I…
AbeeCrombie
- 597
- 1
- 5
- 22
0
votes
1 answer
How to use ntile without dividing the partition and incrementing each bucket by one
How can I use the ntile ranking function without specifying the number to divide each partition by and instead assign each partition an incrementing number?
I want to group items that have a subset of fields with the same values and then flag them…
H.T
- 21
- 1
- 7
0
votes
1 answer
Ranking functions inside views
Is it reliable to use ranking functions inside views in sql server (2008 r2) and especially the
over (order by ...)
clause ?
It is known that the
order by
clause inside views in not a good approach, even if you specify the
top (100)…
George Mavritsakis
- 6,829
- 2
- 35
- 42
0
votes
2 answers
Excel Ranking Not Working
I am trying to make a list of top 25 based on the rank function in excel, but my list is missing the 11th and 20th value. Upon inspection, I noticed that there are identical values in these spots preventing them from ranking correctly. Is there a…
Matt C.
- 1
- 1
- 1
0
votes
1 answer
"Intelligent" way to sort options based on user's previous usage
We have a UIPickerView in our app that currently shows its list of options (about 7 of them) in an order set by the code.
I've been asked to add some "intelligent" ordering of these options so that the most commonly used work their way to the…
Fogmeister
- 76,236
- 42
- 207
- 306
0
votes
1 answer
R function for weighting teams by strength of opponent?
I'm analyzing some sports data, and I have a set of win/loss records for about 40 teams. I would like to come up with a ranking where each win is weighted by the strength of the opponent. This would have to be some iterative/recursive sort of thing…
user3037237
- 385
- 2
- 11
0
votes
1 answer
The most efficient way to calculate rankings in real time games
I want to know the fastest and most efficient way to compute points and ranking in real time.
I'm doing a betting football game (a game where users try to predict the outcome of a game before it). In my country is called "Quiniela".
Players put…
Fingolricks
- 1,196
- 2
- 14
- 30
0
votes
1 answer
Assigning rank to a variable based on 2 other variables in stata
I have a longitudinal data with some variables as: firm id, event date, abnormal return, where event date is acquisition announcement date by each firm and abnormal return is the event-announcement return for each firm over a window of 5 days…
Suparna Ray
- 3
- 2
- 6
0
votes
2 answers
Ranking algorithm with missing values and bias
The problem is :
A set of 5 independent users where asked to rate 50 products given to them. All 50 products would have been used by the users in some point of time. Some users have more bias towards certain products. One user did not truly complete…
Vinith
- 105
- 6
0
votes
1 answer
Adding pagination in WordPress Football Pool
I'm using a wordpress plugin to make a football pool. A really nice plugin but there is nog pagination in the ranking. So when you have over 1000 participants you will get a very long list.
The plugin author provided a class wich you can use to…
user1511766
- 125
- 1
- 1
- 9
0
votes
1 answer
Perl: How to make an optimal ranking
My brother has thousands of items ids and the number of items sold in the following fashion:
$VAR1 = {
'sold_times' => 4,
'item_id' => 1,
};
$VAR2 = {
'sold_times' => 1,
…
ado
- 1,451
- 3
- 17
- 27
0
votes
1 answer
Ranking algorithms for nodes with subnodes?
I am working on a site where there are nodes that users can vote on (upvotes/downvotes). Each node has a list of subnodes. Users can vote on each of these subnodes as well. Think of the relationship between posts and comments on reddit.
What ranking…
pgorsira
- 202
- 3
- 12
0
votes
1 answer
How to choose the first record based on time
I have two tables and call table and a after call work table. These two tables have a one to one relationship even tho the after call work records are stored in the call table. You can link a call to a after call work call by joining on three values…
Richard C
- 389
- 2
- 5
- 16