Changes
Jump to navigation
Jump to search
→Variables and tables
Todo:
*Rename this table to something meaningful!*Get distinct prefixes (Mr, Mrs, Dr)- Done!
*Get distinct titles
**Choose the titles! **Either make a lookup table or find the patterns**Build look-a new variable to add the 'clean title'*Create a man/women variable (0 if man, 1 if women)**Load up your census names**Find the distinct man/women names**Write an SQL query to JOIN a man/woman variable when title = DR*Build the output tablein SQL CREATE TABLE WomenCEOs AS SELECT year, SUM(smanwoman)? /COUNT(or with perl routinemanwoman) -> Get 5 things we care about.AS PercentWomenCEOs FROM tablename WHERE cleantitle='CEO' GROUP BY Year;
Table Entrep1:
