Changes
Jump to navigation
Jump to search
no edit summary
===Ethnicity===
The data was preprocessed to assign individuals who reported more than one gender as being of 'mixed' race. The variable 'ethnicity' is a interger categorization for fast sorting, and the label are provided in the variable 'ethnicitylabels'.
+------------------+--------+------------+
| none | 563167 | 0.3120 |
+------------------+--------+------------+
The distribution for the reported number of ethnicities (with >1 assigned to mixed) is:
+-----------------+----------+
| num_ethnicities | COUNT(*) |
+-----------------+----------+
| 1 | 1699537 |
| 2 | 83676 |
| 3 | 14781 |
| 4 | 3348 |
| 5 | 976 |
| 6 | 330 |
| 7 | 243 |
| 8 | 409 |
| 9 | 1693 |
+-----------------+----------+
===Location===
Zip3 was provided in the data, but I was cautioned that the third number was not meaningul (i.e. added randomly for obscurification). Zip2 and Zip1 (the later is reported below) are coded as variables.
See:
*The [http://en.wikipedia.org/wiki/ZIP_code#Primary_State_Prefixes Wikipedia Zip Code page] for a map of Zip codes
*[http://en.wikipedia.org/wiki/List_of_ZIP_code_prefixes List of Zip Code Prefixes]
+------+--------+------------+
===Age===
The age ranges were created arbitrarily - though they have worked out reasonable well. Further refinement is possible. The variable 'age_rnum' is a integer categorization, and 'age_range' provides the variable. Ages were calculated using 'birth_year' using 2010 as the reference point.
+-----------+--------+------------+
| >60 | 33175 | 0.0184 |
+-----------+--------+------------+
Birth year is self-reported almost surely wrongly so in some case. It ranges from 1900 to 1995.
===Account Age===
The account age range variables, 'acc_age_rnum' for the interger categorization and 'acc_age_range' for the labels, were created arbitrarily. These could easily be refined, but were created to examine differences in messaging and viewing activitiy - and to provide a normalization base. The oldest account is 2,613 days. The youngest is 0 days.
+---------------+--------+------------+
| 366-3650 | 540035 | 0.2992 |
+---------------+--------+------------+
===Other variables===
Quit times range from:
*2008-07-19 (youngest)
*2010-12-17 (oldest)
Deleted or blacklisted accounts:
+------------------------+----------+
| deleted_or_blacklisted | Count |
+------------------------+----------+
| 0 | 1519319 |
| 1 | 285674 |
+------------------------+----------+
==Outstanding Data Issues==
*The variables 'num_essays' and 'profile_length' need fixing