Let’s say I have a DataFrame and a Dict: df = DataFrame( a = 1:3, b = ["beetle", "fly", "spider"]) arthropod_dict = Dict( "beetle" => "insect", "fly" => "insect", "spider" => "arachnid") And I’d like to apply the Dict like a map to the DataFrame, producing df = DataFrame( …

Transforming a DataFrame column by mapping with a Dict

SailChickenBright May 25, 2021, 1:43am 2

transform(df, :b => ByRow(x -> arthropod_dict[x]) => :c)

5 Likes

Topic		Replies	Views
Replace values in a DataFrame column based on a Dict of corresponding values New to Julia question , dataframes	5	1542	June 4, 2021
[DataFrames Question]: How to convert single column with row of dictionary to multiple columns Specific Domains question , dataframes	4	520	May 14, 2022
Apply a function in-place to a DataFrame column and return a new dataframe with replaced column Data dataframes	1	1412	May 20, 2021
Applying Dict to DataFrame column General Usage	2	1487	October 12, 2017
Transforming string columns in DataFrame with (regex) match General Usage	3	548	October 26, 2021