CODE EXAMPLE FOR PYTHON

Map values in Pandas column using dictionary

Subjects = {"Sheldon" : "Science",
            "Raj" : "Chemistry",
            "Leonard" : "Maths",
            "Howard" : "Astronaut",
            "Amy" : "Science"}
                     
df["Subjects"] = df["first_name"].map(Subjects)