A dummy column is a binary indicator showing whether each record belongs to a category. For semicolon-separated language values, each language becomes its own column containing 1 or 0. section 9.10
Comparing language combinations
Create indicators from LanguageHaveWorkedWith with str.get_dummies(sep=';'), then combine them horizontally with pd.concat. Boolean conditions can select people who know Python and JavaScript but not Java, allowing their mean CompTotal to be calculated. section 9.10 section 9.9
A practical workflow is:
- Convert the delimited language column into one indicator column per language. section 9.10
- Append the indicators to the original DataFrame along its columns axis. section 9.10
- Combine equality tests with boolean operators to filter category combinations. section 9.10
