{"id":3372,"date":"2017-11-20T23:11:51","date_gmt":"2017-11-21T07:11:51","guid":{"rendered":"http:\/\/miriamposner.com\/classes\/dh101f17\/?page_id=3372"},"modified":"2017-11-20T23:24:20","modified_gmt":"2017-11-21T07:24:20","slug":"derive-gender-from-a-column-of-first-names","status":"publish","type":"page","link":"http:\/\/miriamposner.com\/classes\/dh101f17\/tutorials-guides\/data-manipulation\/derive-gender-from-a-column-of-first-names\/","title":{"rendered":"Derive gender from a column of first names"},"content":{"rendered":"

This tutorial is based on\u00a0“From OMBD to Gender Data on Film Directors.”<\/a><\/em><\/p>\n

What can you do if you want to perform a gender-based analysis of your dataset, but “gender” isn’t a category in your data? You can use computational methods to perform an educated guess, based on the first name of the person.<\/p>\n

Is it flawless? No way. First names can often be ambiguous, and a woman could easily have a “man’s” name, or vice versa. But often a name is all we have, and sometimes the benefits of performing a gender-based analysis outweigh the problems of computationally deriving gender.<\/p>\n

In this tutorial, we’ll use a tool called genderize.io. Genderize takes advantage of a database of thousands of names and genders to give you a probable gender for a name. It also gives you a probability for each guess at gender. You can read more about it\u00a0here<\/a>.<\/p>\n

An important caveat: Genderize will only give you 1,000 guesses at gender per day, so you may have to divide up your names among team members, or use Genderize in installments.<\/p>\n

<\/a>Make sure you have a column that contains only first names.<\/h2>\n

If your column contains first and last names, you’ll have to use OpenRefine’s “split cells” function to isolate first names in their own column.<\/p>\n

\"\"<\/a><\/p>\n

<\/a>Load your spreadsheet into Google Drive<\/h2>\n

Open your CSV in Google Sheets.<\/p>\n

\"\"<\/a><\/p>\n

<\/a>Insert five blank columns to the right of the column of first names<\/h2>\n

You’ll need those columns to store the information from Genderize.<\/p>\n

\"\"<\/a><\/p>\n

<\/a>Enter the formula to query Genderize<\/h2>\n

In the column to the right of you column of first names, enter the following formula:<\/p>\n

 =\"https:\/\/api.genderize.io\/?name=\"&lower(A2)\r\n<\/code><\/pre>\n
Except instead of\u00a0A2<\/strong>, enter the letter and number that corresponds to the cell containing the first name in your first-name column.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>Copy that formula into every cell in that column<\/h2>\n
You can do that by grabbing the tiny blue square at the bottom right of the cell and dragging it all the way to the bottom of the column. Excel will automatically modify the cell reference (like A2) so that it corresponds to the cell in the appropriate row.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>Enter the formula to send your query to Genderize<\/h2>\n
That formula looks like this:<\/p>\n
 =IMPORTDATA(B2)\r\n<\/code><\/pre>\n
except instead of B2, reference the cell in your own spreadsheet that includes the formula you added in the last step.<\/p>\n
Now drag that formula all the way down to the end of the column, just the way you did in the previous step.<\/p>\n
As you drag, the contents of the cell will read “Loading…” indicating that Genderize is querying its database.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>You have gender!<\/h2>\n
In the blank columns you added earlier, Genderize will fill in the following information: gender, the degree of certainty of that gender (from 0 to 1), and the number of data entries it examined to arrive at the response.<\/p>\n
You may not need the probability and count information, but it’s good to know.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>Copy the gender column and paste it as a value (1)<\/h2>\n
You’ll probably want to modify the cells that begin with\u00a0gender:”<\/strong>\u00a0so that they simply read\u00a0male<\/strong>,\u00a0female<\/strong>, and\u00a0null<\/strong>. But right now, if you try to modify them, Google Sheets will get confused, because it wants to display the results of its query to Genderize.<\/p>\n
To get around this, first insert a new column after the column that contains the\u00a0count<\/strong>\u00a0information.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>Copy the gender column and paste it as a value (2)<\/h2>\n
Now copy the entire column that contains gender information.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>Copy the gender column and paste it as a value (3)<\/h2>\n
Finally, place your cursor in the first cell of your new, blank column. From the\u00a0Edit<\/strong>\u00a0menu, choose\u00a0Paste special<\/strong>\u00a0and then choose\u00a0Values only<\/strong>.<\/p>\n
This will paste only the contents of your gender cells, without any of the formulas used to calculate those values.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>Get rid of the extra characters<\/h2>\n
The easiest way is to use\u00a0Find and replace<\/strong>\u00a0to first replace\u00a0gender:<\/strong>\u00a0with nothing and then replace **” **with nothing.<\/p>\n
\"\"<\/a><\/p>\n
<\/a>You have a column of just gender!<\/h2>\n
Not too hard! You can get rid of the extra columns (columns\u00a0B<\/strong>\u00a0through\u00a0F<\/strong>\u00a0in the spreadsheet below) if you want.<\/p>\n
\"\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
This tutorial is based on\u00a0“From OMBD to Gender Data on Film Directors.” What can you do if you want to<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":139,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_eb_attr":"","footnotes":""},"class_list":["post-3372","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/3372","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/comments?post=3372"}],"version-history":[{"count":0,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/3372\/revisions"}],"up":[{"embeddable":true,"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/pages\/139"}],"wp:attachment":[{"href":"http:\/\/miriamposner.com\/classes\/dh101f17\/wp-json\/wp\/v2\/media?parent=3372"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}