I’m trying to use the ternary operator and get an error message: ERROR: ArgumentError: It is only allowed to pass a vector as a column of a DataFrame." Here’s my code: using DataFrames # Sample DataFrame with two columns df = DataFrame(column1 = [10, 5, 8, 3, 12], column2 = [7, …

(I’ve edited the title of your question to be clearer to others what this topic is about :slight_smile: ) I suspect the first error occurs on the assignment; you presumably can’t assign a single value like "red" to a whole column in a dataframe. There is usually little to no implicit widening to ar…

[image] eweiss: df.color .= df.column1 .< df.column2 ? "red" : "green" The ternary operator ? is not vectorized — the predicate must be a single (scalar) boolean value, not an array thereof.

This gives a result but I don’t think it’s what you’re looking for df.color .= df.column1 < df.column2 ? "red" : "green" you could use the ternary operator like this (to justify the title :smile:): transform(df,1:2=>ByRow((x,y)->x<y ? "red" : "green")=>"color") or like this if you don’t like m…

DataFramesMeta.jl is useful here @rtransform df :color = :column1 < :column2 ? "red" : "green"

Thanks. I tried the first bit of code and as you guessed, setting each row to the value of “green” isn’t what I’m looking for. I’ve learned something about Julia from your other suggestions.

[image] pdeffebach: @rtransform df :color = :column1 < :column2 ? "red" : "green" Neat.

Sorry, this is a response to rocco_sprmnt21.

[image] rocco_sprmnt21: (df.column1 .< df.column2) .|> x->x ? "red" : "gren" Pretty nice.

This is an issue in Base Julia not DataFrames.jl. In my opinion a standard translation, if we want to stay with Base Julia, that can be vectorized is the ifelse function: ifelse.(df.column1 .< df.column2, "red", "green")

Ternary Operator `?:` on a DataFrame :)

New to Julia

Jollywatt August 16, 2023, 12:04am 11

(Another thread about broadcasting the ternary operator: Is this an expected behavior of rand.()?)

Topic		Replies	Views
CASE WHEN style operation on DataFrames General Usage dataframes	7	1219	June 23, 2021
If-else applied to a DataFrame New to Julia	11	2371	August 20, 2020
Ifelse in a DataFrame New to Julia dataframes	13	1701	February 15, 2022
Indexing a DataFrame with a boolean DataFrame Data dataframes	3	1261	June 21, 2022
How to replace/set/change value in array/dataframe if value is less/greater than? New to Julia	3	5404	December 1, 2020

Ternary Operator `?:` on a DataFrame :)

Related topics