The selected race columns don't look correct

[rebuilt]

merge-csv/merge-csv.py

Line 224 in 73cfb0a

df = combine_rows(df, 'Race', ['Race- self report', 'race', 'Race - self report'])

The "Race - self report" shouldn't get merged in. Peter created two columns, one for "Race - SIS" that came from the student information system. And the other he copied from the survey responses as "Race - self report". He combined those columns to create a column that is used as the 'source of truth' called 'Race'. If information exists in the student information system, we use that. Otherwise we use the self report. Sometimes kids get cheeky and report their race as 'other' and self describe as 'apache helicopter'. The variations of the race column are "race", "RACE", and "Race".

@mnrva-dev

[mnrva-dev]

Just to confirm, the new loc should be df = combine_rows(df, 'Race', ['race']) ? (covers all case permutations of the word race) @rebuilt

[rebuilt]

Yes, that looks right to me.
@mnrva-dev

[mnrva-dev]

Does the Gender column also need to have self reports removed? @rebuilt

[rebuilt]

I missed that. Yes, 'Gender - self report' should be excluded from the final csv.

@mnrva-dev

[mnrva-dev]

Only 'Gender - Self Report' or should 'What is your gender?' and 'What is your gender? - Selected Choice' also be removed? @rebuilt

[rebuilt]

'What is your gender?' is a valid column name. So is 'What is your gender? - Selected Choice'. If those exist, we want the data to show up in the final 'Gender' column.

[mnrva-dev]

Great. Making these changes.