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
2 answers

Re Ranking data within a csv after row removal

I have some csv data and a piece of code that automatically removes rows within the csv. What I need is a pice of code that can re rank the csv in colum 10, column 10 is originally ranking column 11 however this was achieved in excel. Note in the…
SMNALLY
  • 1,361
  • 3
  • 14
  • 23
0
votes
1 answer

Finding the rank or index of some name in an array returned by query

I am firing a query which returns minimum 1000 rows containing name, amount in order amount desc. I want the index of some name from that array, I don't know how to do it? As I am using Ruby, I use arr.index(name)+1 method which returns the index…
Salil
  • 46,566
  • 21
  • 122
  • 156
0
votes
1 answer

Information Architecture & Retreival - Prioritizing queries

I've got an application that displays data to the user based on a relevancy score. There are 5 to 7 different types of information that I can display (e.g. Users Tags, Friends Tags, Recommended Tags, Popular Tags, etc.) Each information type would…
Jeff Ryan
  • 586
  • 2
  • 7
  • 19
0
votes
1 answer

How to reordering a list of numbers?

I have a query that generates the following output. PART TEST ---- ---- 10 2 10 4 10 5 11 1 11 2 11 4 11 5 17 1 17 2 17 3 17 4 17 5 18 1 18 2 18 3 18 4 18 …
jlimited
  • 685
  • 2
  • 11
  • 20
0
votes
1 answer

How to optimize a score/rank table with different specific scores and ranks?

in our project we've got an user table where userdata with name and different kind of scores (overall score, quest score etc. is stored). How the values are calculated doesn't matter, but take them as seperated. Lets look table 'users' like below …
bish
  • 3,381
  • 9
  • 48
  • 69
0
votes
1 answer

Can I create a ranked dict by iterating over an existing dict?

I've been searching for the answer to this for a while, but no joy. I have a dict containing hotel names and prices. mydict = {'HotelA': 100, 'HotelB': 300, 'HotelC': 200} I would simply like to iterate over the dict and return a separate dict…
user2781522
  • 119
  • 10
0
votes
1 answer

Why Sphinx ranking affect result count

If ranking serve to influence the "weight" It would influence sorting. So why with my ranking, I have less result than with another ? Manual say SPH_MATCH_ANY uses SPH_RANK_MATCHANY ranker; and later in manual SPH_RANK_MATCHANY =…
Moosh
  • 386
  • 1
  • 8
0
votes
1 answer

Ranking of Student based on their Mark and Average

Here's my problem: If a student gets a score of 49 and below in any subject, he won't be included in the ranking. Those students who will get above 49 in all subjects shall be rank according to their average And if the students get an equal…
nine05
  • 11
  • 2
0
votes
1 answer

student ranking ties score php code

Please help me in ranking with a formula like for example: std_no score rank 1 50 1 4 45 2 3 45 3 2 45 4 5 45 5 6 30 6 the…
0
votes
2 answers

ElasticSearch Results with a really low score?

I have a problem regarded to the results of ElasticSearch. In one document I have 800 pages sized text in one field. The word I want to query for just appears once in this document. When I search my index ElasticSearch doesn't list it in the…
Sentient6
  • 17
  • 5
0
votes
2 answers

Rank values in a 2D array

Hi basically I want to input a 2D array and then create a new ranked array with the values from lowest to highest. The array I am using is an elevation raster converted to a numpyarray. This array has a value for elevation. I only want to sort by…
Nick Jones
  • 225
  • 4
  • 13
0
votes
3 answers

Isolating rows from a table that have columns ranked in a desired manner

I have a tab delineated table in which the last three columns contain statistical values, and I would like to retrieve only rows in which the columns are ranked in a desired manner. The rows I am interested in are those where the values in the…
user2439887
  • 61
  • 1
  • 11
0
votes
2 answers

Finding the rank of the Given string in list of all possible permutations

I am trying to find the Rank of the given string in the list of possible permutations. I tried to come up with a solution that tries to find all possible permutations, assign a rank to them and then display it. But this drastically reduces the…
Sushanth --
  • 55,259
  • 9
  • 66
  • 105
0
votes
4 answers

In PHP/CodeIgniter how do you calculate Class & Form Rank based on grades for a student?

I have a database table that holds the following grade information for a student: student_id subject_id gpa letter_grade (which is calculated based on gpa, & inserted when record is saved) semester 6 518 95 A+ 1 6 534 100 A+ 1 I then…
Rasiel
  • 2,823
  • 6
  • 31
  • 37
0
votes
1 answer

Mysql rank, asc or desc

I have a query below that uses a ranking method based on points. The problem is if I order by asc the ranking still shows 1, 2, 3, 4 etc. Instead of 4, 3, 2, 1.( Or if wanted to get only one persons rank (where username=name1) the result comes back…