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

Simple stats page ranking with MySQL

For some reason this seems easy but I cannot figure it out. So I have a table called "contest_entries" and in it has columns "username" and "rating". The table reads something like this: Username | rating | Contest_id John | 3 | 4 Mike …
Mike Kochendorfer
  • 9
  • 1
  • 4
0
votes
1 answer

Logical ranking in SQL Full-text Search

Below you see my query. The parameter 'ISABOUT("Windsor Col*" WEIGHT(1.0),"Windsor Col" WEIGHT(0.7),"Windsor*" WEIGHT(0.5),"Col*" WEIGHT(0.5))' is actually passed in to a stored function that has the same code. This is for autocomplete, and this…
Caleb Jares
  • 6,163
  • 6
  • 56
  • 83
0
votes
1 answer

SQL Query to fetch Highest Sale for each day

I have a table Sale with the following data Item_ID Rate Quantity Sale_Day (YYYY-MM-DD) -------------------------------------- P1 4 4 2013-06-02 P1 5 2 2013-06-02 P2 1 8 2013-06-02 P1 …
user2389390
  • 3
  • 1
  • 2
0
votes
2 answers

Ranking within Arrays

I have an array $data as below [data] => Array ( [user1] => Array ( [score] => 10 ) [user2] => Array ( [score] => 15 …
Guns
  • 2,678
  • 2
  • 23
  • 51
0
votes
3 answers

Do hidden attributes in CSS style table of pages lower the website power?

In CSS style table of website pages I have used a lot of hidden attributes like overflow:hidden and display:none; Does this has effect for SEO? Is this friendly for search engines (SE)? Can it be punished by search engine (SE)? Can hidden attributes…
aicuxiao
  • 37
  • 3
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
4 answers

How to make ranking system in PHP

I have problem. . In my case i make championship. . You know, the winner is determined by the highest value. . Example : $sql = "SELECT bla bla bla FROM `user` ORDER BY `point` DESC"; $result = mysql_query($sql); $i=0; while($row =…
Dj Uckie
  • 31
  • 1
  • 1
  • 4
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 rank svm_predict() output of libsvm in java?

I am doing a classification task (-1 and +1) using LIBSVM in JAVA. In LIBSVM i use kernel_type=RBF and svm_type=C_SVC and all other parameter value are default. How do I rank output of svm_predict() in java? svm_predict() generates this file: …
Somnath Kadam
  • 6,051
  • 6
  • 21
  • 37
0
votes
1 answer

Rank Across Worksheets

I have 4 worksheets, named Apples, Pears, Bananas, Oranges (in that order in the workbook) with tables of data in them. The data is arranged in exactly the same format. I wish to rank the number of apples in each cell of the sheet "Apples" against…
Mary
  • 788
  • 6
  • 19
  • 43
0
votes
3 answers

Saving Rankings in MySQL

I am planning on calculating regional and global rankings once everyday. There will be multiple rankings, each based on ratings or stats. What would be the best way to save these player rankings? Will it be better to create a table for each…
user1911467
  • 61
  • 2
  • 7
0
votes
0 answers

Add custom ranking mechanism to SQL Server fulltext search

I have a table that is Full Text indexed, on which I query using FREETEXT. The table is filled from other tables that have constant data, rarely changed. Now there are few millions of rows. Table structure: ID (identity), PK Text (varchar), FT…
Hen Wagner
  • 201
  • 3
  • 12
0
votes
1 answer

Example of 'Programming Collective Intelligence' doesn't work

I downloaded source code from here. I tried to run the example from chapter 4 of the book 'Programming Collective Intelligence' by Toby Segaran. My python version is 2.7.2. I type in interpreter this code: import…
Helio Gracie
  • 143
  • 1
  • 2
  • 10
0
votes
2 answers

Access Wont Sort Currency by Total Value - SQL - Rank

This might be a simple question, but surprisingly I haven't found anything that fits here. I've made a query in which I format a number as currency. Specifically: Format((Sum([CombineTables].[Total Extended Price])),'Currency') Now when I try to…
Dm3k1
  • 187
  • 3
  • 8
  • 21
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
1 2 3
…
99 100