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 - rows

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

removing rows from dataframe if column value condition is met

stables=["usdt","usdc","tusd"] my dataframe called "df" looks like this (actual dataframe has hundreds of rows): pairs apy network ...
test-img

Grx

python

list

dataframe

loops

rows

Votes: 0

Answers: 1

Latest Answer

Assuming that the pairs column actually contains list of strings, you could explode that column, use isin to test which elements are members of the stables list, ang then use a groupby agg np.all to t...
test-img

Serge Ballesta

How to change a data frame from rows to a column stucture

I have the following data frame in R. ID | Year_Month | Amount 10001|2021-06 | 85 10001|2021-07 | 32.0 20032|2021-08 | 63 20032|2021-09 | 44.23 20033|2021-11 | 1...
test-img

alphasqrd

r

dataframe

rows

transpose

Votes: 0

Answers: 1

Latest Answer

You should check out tidyverse package, it has some really good functions for data wrangling. ## Loading the required libraries library(dplyr) library(tidyverse) ## Creating the dataframe df = data.f...
test-img

Deepansh Arora

How to create a new column by iterating a mathematical formula over rows

I have a dataframe df with several rows: df=pd.read_csv('data.csv') df date time data 0 15.01.2012 13:58:00 0.000212 1 15.01.2012 13:58:03 0.052521 2 15.01.20...
test-img

Lucia Iezzi

pandas

dataframe

iteration

formula

rows

Votes: 0

Answers: 1

Latest Answer

Assuming that the dataframe is sorted by time, and the difference between subsequent rows is always 3 seconds, you can simply assign a linear range as the new column: import numpy as np df['seconds']...
test-img

Arne

Posts

Questions

Blogs

Jobs