<commit_before># Excel or text file of Racers. Assumes that the first row is a header row. 
# Updates membership to current year. If there are no more events in the current year, updates membership to next year.
class RacersFile < GridFile
  COLUMN_MAP = {
    'team'                                   => 'team_name',
    'Cycling Team'                           => 'team_name',
    'fname'                                  => 'first_name',
    'lname'                                  => 'last_name',
    'f_name'                                 => 'first_name',
    'l_name'                                 => 'last_name',
    'FirstName'                              => 'first_name',
    'LastName'                               => 'last_name',
    'Birth date'                             => 'date_of_birth',
    'Birthdate'                              => 'date_of_birth',
    'year of birth'                          => 'date_of_birth',
    'dob'                                    => 'date_of_birth',
    'address'                                => 'street',
    'Address1_Contact address'               => 'street',
    'Address2_Contact address'               => 'street',
    'address1'                               => 'street',
    'City_Contact address'                   => 'city',
    'State_Contact address'                  => 'state',
    'Zip_Contact address'                    => 'zip',
    'Phone'                                  => 'home_phone',
    'DayPhone'                               => 'home_phone',
    'cell/fax'                               => 'cell_fax',
    'e-mail'                                 => 'email',
    'category'                               => 'road_category',
    'road cat'                               => 'road_category',
    'Cat.'                                   => 'road_category',
    'cat'                                    => 'road_category',
    'Road Category - '                       => 'road_category',
    'Road Age Group - '                      => 'road_category',
    'USCF Category'                          => 'road_category',
    'track cat'                              => 'track_category',
    'Track Category - '                      => 'track_category',
    'Track Age Group - '                     => 'track_category',
    'Cyclocross Category - '                 => 'ccx_category',
    'ccx cat'                                => 'ccx_category',
    'Cyclocross Age Group -'                 => 'ccx_category',
    'Cross Country Mountain Bike Category -' => 'mtb_category',
    'mtn cat'                                => 'mtb_category',
    'Cross Country Mountain Age Group -'     => 'mtb_category',
    'Downhill Mountain Bike Category - '     => 'dh_category',
    'dh cat'                                 => 'dh_category',
    'Downhill Mountain Bike Age Group -'     => 'dh_category',
    '2007 road'                              => 'road_number',<commit_msg>Mapped 'number' to 'road_number'<commit_after># Excel or text file of Racers. Assumes that the first row is a header row. 
# Updates membership to current year. If there are no more events in the current year, updates membership to next year.
class RacersFile < GridFile
  COLUMN_MAP = {
    'team'                                   => 'team_name',
    'Cycling Team'                           => 'team_name',
    'fname'                                  => 'first_name',
    'lname'                                  => 'last_name',
    'f_name'                                 => 'first_name',
    'l_name'                                 => 'last_name',
    'FirstName'                              => 'first_name',
    'LastName'                               => 'last_name',
    'Birth date'                             => 'date_of_birth',
    'Birthdate'                              => 'date_of_birth',
    'year of birth'                          => 'date_of_birth',
    'dob'                                    => 'date_of_birth',
    'address'                                => 'street',
    'Address1_Contact address'               => 'street',
    'Address2_Contact address'               => 'street',
    'address1'                               => 'street',
    'City_Contact address'                   => 'city',
    'State_Contact address'                  => 'state',
    'Zip_Contact address'                    => 'zip',
    'Phone'                                  => 'home_phone',
    'DayPhone'                               => 'home_phone',
    'cell/fax'                               => 'cell_fax',
    'e-mail'                                 => 'email',
    'category'                               => 'road_category',
    'road cat'                               => 'road_category',
    'Cat.'                                   => 'road_category',
    'cat'                                    => 'road_category',
    'Road Category - '                       => 'road_category',
    'Road Age Group - '                      => 'road_category',
    'USCF Category'                          => 'road_category',
    'track cat'                              => 'track_category',
    'Track Category - '                      => 'track_category',
    'Track Age Group - '                     => 'track_category',
    'Cyclocross Category - '                 => 'ccx_category',
    'ccx cat'                                => 'ccx_category',
    'Cyclocross Age Group -'                 => 'ccx_category',
    'Cross Country Mountain Bike Category -' => 'mtb_category',
    'mtn cat'                                => 'mtb_category',
    'Cross Country Mountain Age Group -'     => 'mtb_category',
    'Downhill Mountain Bike Category - '     => 'dh_category',
    'dh cat'                                 => 'dh_category',
    'Downhill Mountain Bike Age Group -'     => 'dh_category',
    'number'                                 => 'road_number',
    '2007 road'                              => 'road_number',
{'fraction_non_alphanumeric': 0.11120401337792642, 'fraction_numerical': 0.0023411371237458192, 'mean_word_length': 0.9811195760185492, 'pattern_counts': {'":': 0, '<': 5, '<?xml version=': 0, '>': 90, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 55, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3917170', 'n_tokens_mistral': 1512, 'n_tokens_neox': 1433, 'n_words': 336}