python (65.1k questions)

javascript (44.2k questions)

reactjs (22.7k questions)

java (20.8k questions)

c# (17.4k questions)

html (16.3k questions)

r (13.7k questions)

android (12.9k questions)

Questions - select

Changing values in a dataframe based on multiple conditions, using np.select

I would like to change values in a dataframe using np.select However, I'm getting an error and google didn't find any solution for similar issues. Could somebody help me out? Thank you in advance for ...
test-img

Amilovsky

python

pandas

numpy

select

Votes: 0

Answers: 1

Latest Answer

You could try this instead - I believe rounding the decimals to zero digits obeys all your conditions as well : # default decimals is 0 df_new = df.round() # or this if you need more control on each...
test-img

skimmed_code1

Selecting Rows of Data Based on Multiple Conditions

I am working with the R programming language. I have this dataset in R: v <- c(1,2,3,4,5,6,7,8,9,10) var_1 <- as.factor(sample(v, 10000, replace=TRUE, prob=c(0.1,0.1,0.1,0.1,0.1, 0.1,0.1,0.1,0....
test-img

stats_noob

r

select

data-manipulation

Votes: 0

Answers: 1

Latest Answer

The problem is, that you have lists in your conditions. class(conditions[1,7]) # [1] "list" Solution: unlist. my_data[my_data$var_1 %in% unlist(conditions[1,7]) & my_data$var_...
test-img

jay.sf

Oracle PL/SQL. SELECT with AND condicionated

I want to do a Query like this: v_name VARCHAR2(60); SELECT * FROM book WHERE name = v_name But if "v_name" is NULL, the program must be: SELECT * FROM book I don't wan't to set the filter ...
test-img

Samuel

oracle

select

plsql

where-clause

Votes: 0

Answers: 3

Latest Answer

One way to match null with all books when v_name is null or match only a book (assuming NAME is unique) when v_name is not null is to do it by typing fewer characters: select * from BOOK where v_na...
test-img

Jeff Holt

MYSQL - not distinct but eliminate

From a SELECT I get this result: u.id, c.id 101, 33 104, 57 105, 51 A UNION SELECT DISTINCT finds following records: u.id, c.id 104, 57 The final result is: u.id, c.id 101, 33 104, 57 105, 51 But I wa...
test-img

J&#248;rn Vase

mysql

select

union

distinct

sql-delete

Votes: 0

Answers: 0

Posts

Questions

Blogs

Jobs