Inferring Gender from Title or Honorific and Gender Reversal

Clinton Jones
Clinton Jones Experian Elite
edited December 2023 in General

Sometimes it might be useful to determine the gender of a person from their honorific, so for example deciding that the greeting should be Sir or Madam depending on the Mr or Mrs or Miss honorific.

The interesting aspect of this inferral task is that in Data Studio there are a good many ways that you can achieve this result.

Here's one that uses the EQUALS condition evaluation and IF THEN ELSE operators

The result is then as follows


You can also look at using lookups but this would require you to have a lookup list that has both Honorific and Saluation in the same dataset.

Is there another way you could do this, perhaps using a regular expression?

Comments

  • You might hit trouble when eg you start getting military rankings, clergy eg Major Smith, The Right Reverend Green - Male or Female?

    The recent adoption of Mx causes similar issues too..

  • Clinton Jones
    Clinton Jones Experian Elite

    @Nigel Light yes that is a good point but then you might use a combination of conditional IF then logic. Most important though, is aside from the use of a lookup, is this really the only way to determine an appropriate salutation?

  • Lookup table?

    It would then allow the table to be used in other applications and promote improved governance rather than hard-coding in the program itself

    Nige

  • Clinton Jones
    Clinton Jones Experian Elite

    Yes, you could consider something that appends a salutation based on the honorific identified