Replace values in a DataFrame column based on a Dict of corresponding values

[jd-foster]

A couple of other options were discussed recently here

Transforming a DataFrame column by mapping with a Dict

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( a = 1:3, b = ["beetle", "fly", "spider"], c = ["insect", "insect", "arachnid"]) Is there a way to do that using transform or another DataFrame function so that I can apply the Dict within a @…