Stack Overflow
Stack Overflow

Questions tagged [rank]

Rank refers to the relative position, value, worth, complexity, power, level etc. of an object.

Rank refers to the relative position, value, worth, complexity, power, importance, authority, level etc. of a person or object (source).

From Wikipedia:

In computer programming, rank with no further specifications is usually a synonym for (or refers to) "number of dimensions"; thus, a bi-dimensional array has rank two, a three-dimensional array has rank three and so on. Strictly, no formal definition can be provided which applies to every programming language, since each of them has its own concepts, semantics and terminology; the term may not even be applicable or, to the contrary, applied with a very specific meaning in the context of a given language.

1637 questions
0
votes
2 answers

python subtraction of zero ranked arrays

I am attempting to subtract two zero ranked numpy arrays a and b. I would like a-b to return an error when they are not of the same size. For example, if shape(a)=[300,] and shape(b)=[450,]; a-b returns an array of shape[300,450]. I would instead…
user2581695
  • 21
  • 3
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…
Mike Kochendorfer
  • 9
  • 1
  • 4
0
votes
3 answers

How to implement rank function of SQL in mapreduce?

I have a situation where I need to replicate SQL rank function in mapreduce. It is similar to this: QUALIFY Row_number() over(partition by a.column1 order by a.column2 desc, d.column3 desc) =1 Thank you.
pras
  • 1
  • 2
0
votes
2 answers

How to compute orthonormal basis for rank deficient rectangular matrix

I'm doing a project which needs to compute the orthonormal basis of a rectangular matrix and this matrix may or may not be rank deficient. In matlab, we can just call function orth() which is based on svd to handle this problem, but I need to…
Jin Yan
  • 199
  • 12
0
votes
2 answers

Rank subsets of a dataset

I'm new to R and have a relatively simple problem that I can't figure out. I have a dataset that is about 30,000 rows and 3 columns. Every 30 rows is one sample, but there is no identifiers for the samples. I want to Rank each of the rows for…
user2449619
  • 1
0
votes
1 answer

RANK() OVER(PARTITION BY

I need to rank by several columns; ORDER_SEQ = RANK() OVER(PARTITION BY A.ORDER_ID, A.ORDER_NAME, A.START_DT_TM ORDER BY A.START_DT_TM) The problem is that I need the third argument in the partition to be by the date only and not the datetime. Any…
cbm64
  • 1,059
  • 2
  • 12
  • 24
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

Use RANK function for cell range based on criteria in separate cell range

I have a question regarding the RANK function in MS Excel 2010. I have a large worksheet whose rows I want to rank based on the values in a column. These values can be positive or negative. I found helpful advice here which explains how to rank the…
rf2012
  • 233
  • 2
  • 7
  • 13
0
votes
5 answers

PHP: A "Rank" System

I have a mysql database that consists of users. In that database, there is a "score" column. I want to make a profile for the users, but it will show their rank. I don't want to do this server-sided, so i'm trying to do it from the profile page…
Robert Doe
  • 21
  • 1
  • 4
0
votes
2 answers

What is the rank of the rating in which maximum movies fell into?

Hi i have the following data model. I need to find the rank of the rating in which maximum movies fell into. I have written the following query which my trainer tells me is wrong. SELECT COUNT(DISTINCT r.movieratingid) AS rank FROM Rating r…
user1844638
  • 1,067
  • 3
  • 23
  • 48
0
votes
1 answer

MS Access - Rank on TEXT fields

In MS Access 2000, I have a table named [Stack Trace] from which I should randomly pull 400 records with distinct of one of the text columns. I looked at one of the examples in here and added an autonumber field to the table and wrote the query as…
user007
  • 1,504
  • 2
  • 18
  • 51
0
votes
1 answer

What are the best stars ranking system (libs) to implement on IOS 6 app?

I have this system, but I it's frame based, I want another solution with views or another kind to place on the exact position. With frames it's hard to place the stars on the right places and handle them. I want a system with 5 stars and with the…
Fabio Cardoso
  • 1,181
  • 1
  • 14
  • 37
0
votes
2 answers

SQL rank percentile

I've made an SQL query which rank pages by how many times they have been viewed. For instance, ╔══════╦═══════╗ ║ PAGE ║ VIEWS ║ ╠══════╬═══════╣ ║ J ║ 100 ║ ║ Q ║ 77 ║ ║ 3 ║ 55 ║ ║ A ║ 23 ║ ║ 2 ║ 6…
Marlboro Goodluck
  • 289
  • 1
  • 4
  • 12
0
votes
1 answer

How do I delete repeating rows from a table but leave the distinct of them?

Catch is, the entire row is the same. Table: Hello Hello Hello Bye Bye Good Morning Good Morning I want to LEAVE: Hello Bye Good Morning I know you can use RANK() here but I have never really used it so I'm not too sure. Can anyone give me a hand?
JJ.
  • 9,580
  • 37
  • 116
  • 189
0
votes
3 answers

python dict key sort by multiple values ranking

Its easy to sort a dict to list by values, but I need to order keys by kind of boosting specific values in correlation to others. An example: x = [('key1', {'s': 'foo', 'w': 30}), ('key2', {'s': 'bar', 'w': 26}), ('key3', {'s': 'foo', 'w':…
rebeling
  • 718
  • 9
  • 31
1 2 3
…
99
100