Stack Overflow
Stack Overflow

Questions tagged [ranking]

Ranking is the sorted order of an element in a list of elements. Usually a high ranking means the element is good in terms of certain metric.

is used in:

  • sorting algorithms
  • information retrieval to represent the relevance of documents with respective to the search queries.
  • recommendation to rank top-k items.
1634 questions
0
votes
1 answer

Insert (intermingle) items into array based on arbitrary rules

I'm really banging my head against the wall with this, as I have very little experience with algorithms. Consider an app that maintains a set of TV shows and the episodes for those shows. The user is allowed to rank the shows (rank, not rate; so…
Farski
  • 1,670
  • 3
  • 15
  • 30
0
votes
2 answers

Order by descending and returning the record number to use for ranking

I'm trying to rank users very simply by their reputation, which is stored as an int column in a MySQL table of users. In order to find out which users have the highest reputation from highest to lowest, I would do something like: SELECT * FROM users…
wnajar
  • 747
  • 1
  • 7
  • 27
0
votes
1 answer

Ranking with ties and skipping certain rows where one condition is not met in mysql

I have been googling since yesterday on how I could do this but with no avail. I can perfectly achieve ranking with ties and return rank of a specific student using php and mysql quesry. But I have one problem. The problem is that if a student fails…
The Reaper
  • 67
  • 8
0
votes
1 answer

how do I generate an ordered list of vectors in R?

In my data I have a list of made-up words and their rating by 30 individuals on a scale 1-5. I have assigned the mean value of the word's rating to individual vectors as follows dox.mean = c(mean(doxrating)) noi.mean = c(mean(noirating))…
emma
  • 3
  • 2
0
votes
1 answer

Getting prior test scores in the same query

I am trying to get prior scores and prior test date of a student in the same query. My current query works fine until the prior score falls exactly on a 28 day difference. The issue is when the scores fall on 29,30 or 31 day. Here is my current…
ozzboy
  • 2,672
  • 8
  • 42
  • 69
0
votes
1 answer

ms sql server 2012 - ranking vendors based on transaction success rates by text area

I have a table of transactions that looks similar to: EXP_ID PICKUP_DATE PICKUP_WARD_TEXT STATUS PRICE 1 21/11/2013 W1 1 20 There are lots of these transactions. Not all of these complete. Status 1 is…
finngeraghty
  • 107
  • 1
  • 8
0
votes
1 answer

Calculate the Ranks of Candidates based on Votes and Total Candidates

How can I claulate the rank of each candidate when I have the total candidates and votes secured by each? I've managed the percentage part, but calculating the rank has me stuck. I'll be using MySql in the end for this, but right now I only need the…
jmenezes
  • 1,888
  • 6
  • 28
  • 44
0
votes
2 answers

R: Create a list of combinations of row names and column names and rank them

I have two matrices: matrix1: col1 col2 row1 5 4 row2 4 6 matrix2: col1 col2 row1 48 50 row2 47 46 What I want is a new matrix or table: Dim1 Dim2 rank row2col1 4 47 1 row1col2 …
Bob
  • 991
  • 8
  • 23
  • 40
0
votes
1 answer

Ranking algorithm based spent time and user level

Think about a game, players are trying to solve problems and every problem is actually means "Level". Players will see realtime ranking when playing. RedisIO has sorted set feature, I'll use it. But I don't know how to score players: PlayerA at 7…
xecute
  • 446
  • 8
  • 23
0
votes
1 answer

Relational Database Querying and Custom Ranking Web-service Gem?

I was planning on building a web service in rails that would receive a users location from a request, through use of an API in a mobile app. It would then query a database based on that persons location as well as another parameter, the bid a…
Sauron
  • 6,399
  • 14
  • 71
  • 136
0
votes
1 answer

Ranking/ weighing search result

I am trying to build an application that has a smart adaptive search engine (lets say for cars). If I search for for 4x4 then the DB will return all the 4x4 cars I have (100 cars) - but as time goes by and I start checking out cars, liking them,…
biso
  • 590
  • 1
  • 4
  • 13
0
votes
1 answer

Full-Text search in Sql server with multiple tables and ranking

We have a website which is running on DNN 7.1 with SQL server. We implemented full text search to show search results. We need to search several tables and show the results to the user. Right now the implementation is user enters search word(s) and…
tigger tigger
  • 109
  • 2
  • 9
0
votes
1 answer

overall rank from three ranked tables in excel 2010

I have three or four tables each of them having 4 to 7 columns. all tables having "name" column common. all tables having rank values but based on different columns. ie; rank values of each table differs. suppose in table1 name x got rank1, in…
durga637
  • 103
  • 1
  • 4
0
votes
1 answer

Time related function for calculate rate like reddit

As we know that reddit has its ranking algorithm as well as stackoverflow. I want to development a ranking algorithm for audit content dynamic ranking. Users can audit the contents by digg/bury. The ranking algorithm is for making the oldest/fewest…
lifei
  • 235
  • 2
  • 10
0
votes
2 answers

Create new matrix with ranks of elements of other matrix, MATLAB

I have a matrix for example A = [21 3 14;0 1 5;8 2 4] and want a new matrix B =[9 4 8;1 2 6;7 3 5] I found a method for creating a vector http://blogs.mathworks.com/loren/2007/08/21/reversal-of-a-sort/#7 but is there a function for…
Alek Morfy
  • 21
  • 4
1 2 3
…
99 100