python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - multiple-conditions

How to order rows according to two conditions?

Given data: df Var1 Var2 Values aaa x 4 aaa y 7 aaa z 6 bbb x 9 bbb y 21 bbb z 13 ccc x 4 ccc y 19 ccc ...
test-img

must

r

dplyr

rows

multiple-conditions

Votes: 0

Answers: 1

Latest Answer

You can use arrange and desc df %>% arrange(desc(Var1), desc(Var2)) Var1 Var2 Values 1 ccc z 0 2 ccc y 19 3 ccc x 4 4 bbb z 13 5 bbb y 21 6 bbb ...
test-img

Maël

Python add / merge rows of a dataframe together based on multiple conditions

Good afternoon, I hope that you are well. I have an xlsx file in the following format that which is output from a Python function I have been using to parse data :- I have loaded this xlsx file into ...
test-img

user60707

python

pandas

dataframe

merge

multiple-conditions

Votes: 0

Answers: 1

Latest Answer

Use groupby_sum: out = df.groupby(['Application ID', 'Test Phase'], as_index=False).sum() print(out) # Output Application ID Test Phase Total Tests A 0 9 SIT 36 ...
test-img

Corralien

Way to prevent case statement from excluding values?

i'm pretty new to the sql world and i've seem to run into a roadblock. Multiple conditions seems to be a regular question but I couldn't find a thread on my current problem. I'm using google data stud...
test-img

J Jo

google-data-studio

multiple-conditions

case-statement

Votes: 0

Answers: 1

Latest Answer

Count them in separate columns for each category: credit: case when contains_text(answer, 'credit bureau') then 1 else 0 end a mini: case when contains_text(answer, 'mini') then 1 else 0 end), profani...
test-img

Bohemian

ranking dataframe using two columns in R

I am new to using R, and I am having hard time trying to rank dataframe using two columns in R. The data is in the form of this. A B 1 1 2 1 2 1 4 4 5 3 I want result to be in the form of A B Rank 1 ...
test-img

Gongsoonyee

r

dataframe

data-manipulation

ranking

multiple-conditions

Votes: 0

Answers: 4

Latest Answer

What you can do is sort on B and A, give it a group ID and then rank on this group ID Data dt <- structure(list(A = c(1L, 2L, 2L, 4L, 5L), B = c(1L, 1L, 1L, 4L, 3L)), row.names = c(NA, -5L), class...
test-img

Merijn van Tilborg

Posts

Questions

Blogs

Jobs