Track 14 · Lesson 7 of 12

Transforming columns

Derive new columns with vectorised arithmetic, np.where, map, the str accessor and pd.cut, and know when apply is (and isn't) the right tool.

You will be able to

• Add a derived column with vectorised arithmetic or assign
• Choose between two values per row with np.where
• Translate codes with map and a dictionary, handling unmatched values
• Split and reshape text with the str accessor
• Group numbers into labelled bands with pd.cut