Last active
January 4, 2019 19:07
-
-
Save dawaldron/98afdbb7afc542ff39fa4913f7376af4 to your computer and use it in GitHub Desktop.
dplyr/data.table comparison
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DEGFIELDD fieldOfDegree | |
| 0000 N/A | |
| 1100 General Agriculture | |
| 1101 Agriculture Production and Management | |
| 1102 Agricultural Economics | |
| 1103 Animal Sciences | |
| 1104 Food Science | |
| 1105 Plant Science and Agronomy | |
| 1106 Soil Science | |
| 1199 Miscellaneous Agriculture | |
| 1300 Environment and Natural Resources | |
| 1301 Environmental Science | |
| 1302 Forestry | |
| 1303 Natural Resources Management | |
| 1401 Architecture | |
| 1501 Area, Ethnic, and Civilization Studies | |
| 1900 Communications | |
| 1901 Communications | |
| 1902 Journalism | |
| 1903 Mass Media | |
| 1904 Advertising and Public Relations | |
| 2001 Communication Technologies | |
| 2100 Computer and Information Systems | |
| 2101 Computer Programming and Data Processing | |
| 2102 Computer Science | |
| 2105 Information Sciences | |
| 2106 Computer Information Management and Security | |
| 2107 Computer Networking and Telecommunications | |
| 2201 Cosmetology Services and Culinary Arts | |
| 2300 General Education | |
| 2301 Educational Administration and Supervision | |
| 2303 School Student Counseling | |
| 2304 Elementary Education | |
| 2305 Mathematics Teacher Education | |
| 2306 Physical and Health Education Teaching | |
| 2307 Early Childhood Education | |
| 2308 Science and Computer Teacher Education | |
| 2309 Secondary Teacher Education | |
| 2310 Special Needs Education | |
| 2311 Social Science or History Teacher Education | |
| 2312 Teacher Education: Multiple Levels | |
| 2313 Language and Drama Education | |
| 2314 Art and Music Education | |
| 2399 Miscellaneous Education | |
| 2400 General Engineering | |
| 2401 Aerospace Engineering | |
| 2402 Biological Engineering | |
| 2403 Architectural Engineering | |
| 2404 Biomedical Engineering | |
| 2405 Chemical Engineering | |
| 2406 Civil Engineering | |
| 2407 Computer Engineering | |
| 2408 Electrical Engineering | |
| 2409 Engineering Mechanics, Physics, and Science | |
| 2410 Environmental Engineering | |
| 2411 Geological and Geophysical Engineering | |
| 2412 Industrial and Manufacturing Engineering | |
| 2413 Materials Engineering and Materials Science | |
| 2414 Mechanical Engineering | |
| 2415 Metallurgical Engineering | |
| 2416 Mining and Mineral Engineering | |
| 2417 Naval Architecture and Marine Engineering | |
| 2418 Nuclear Engineering | |
| 2419 Petroleum Engineering | |
| 2499 Miscellaneous Engineering | |
| 2500 Engineering Technologies | |
| 2501 Engineering and Industrial Management | |
| 2502 Electrical Engineering Technology | |
| 2503 Industrial Production Technologies | |
| 2504 Mechanical Engineering Related Technologies | |
| 2599 Miscellaneous Engineering Technologies | |
| 2600 Linguistics and Foreign Languages | |
| 2601 Linguistics and Comparative Language and Literature | |
| 2602 French, German, Latin and Other Common Foreign Language Studies | |
| 2603 Other Foreign Languages | |
| 2901 Family and Consumer Sciences | |
| 3200 Law | |
| 3201 Court Reporting | |
| 3202 Pre-Law and Legal Studies | |
| 3300 English Language, Literature, and Composition | |
| 3301 English Language and Literature | |
| 3302 Composition and Speech | |
| 3400 Liberal Arts and Humanities | |
| 3401 Liberal Arts | |
| 3402 Humanities | |
| 3501 Library Science | |
| 3600 Biology | |
| 3601 Biochemical Sciences | |
| 3602 Botany | |
| 3603 Molecular Biology | |
| 3604 Ecology | |
| 3605 Genetics | |
| 3606 Microbiology | |
| 3607 Pharmacology | |
| 3608 Physiology | |
| 3609 Zoology | |
| 3611 Neuroscience | |
| 3699 Miscellaneous Biology | |
| 3700 Mathematics | |
| 3701 Applied Mathematics | |
| 3702 Statistics and Decision Science | |
| 3801 Military Technologies | |
| 4000 Interdisciplinary and Multi-Disciplinary Studies (General) | |
| 4001 Intercultural and International Studies | |
| 4002 Nutrition Sciences | |
| 4003 Neuroscience | |
| 4005 Mathematics and Computer Science | |
| 4006 Cognitive Science and Biopsychology | |
| 4007 Interdisciplinary Social Sciences | |
| 4008 Multi-disciplinary or General Science | |
| 4101 Physical Fitness, Parks, Recreation, and Leisure | |
| 4801 Philosophy and Religious Studies | |
| 4901 Theology and Religious Vocations | |
| 5000 Physical Sciences | |
| 5001 Astronomy and Astrophysics | |
| 5002 Atmospheric Sciences and Meteorology | |
| 5003 Chemistry | |
| 5004 Geology and Earth Science | |
| 5005 Geosciences | |
| 5006 Oceanography | |
| 5007 Physics | |
| 5008 Materials Science | |
| 5098 Multi-disciplinary or General Science | |
| 5102 Nuclear, Industrial Radiology, and Biological Technologies | |
| 5200 Psychology | |
| 5201 Educational Psychology | |
| 5202 Clinical Psychology | |
| 5203 Counseling Psychology | |
| 5205 Industrial and Organizational Psychology | |
| 5206 Social Psychology | |
| 5299 Miscellaneous Psychology | |
| 5301 Criminal Justice and Fire Protection | |
| 5400 Public Affairs, Policy, and Social Work | |
| 5401 Public Administration | |
| 5402 Public Policy | |
| 5403 Human Services and Community Organization | |
| 5404 Social Work | |
| 5500 General Social Sciences | |
| 5501 Economics | |
| 5502 Anthropology and Archeology | |
| 5503 Criminology | |
| 5504 Geography | |
| 5505 International Relations | |
| 5506 Political Science and Government | |
| 5507 Sociology | |
| 5599 Miscellaneous Social Sciences | |
| 5601 Construction Services | |
| 5701 Electrical and Mechanic Repairs and Technologies | |
| 5801 Precision Production and Industrial Arts | |
| 5901 Transportation Sciences and Technologies | |
| 6000 Fine Arts | |
| 6001 Drama and Theater Arts | |
| 6002 Music | |
| 6003 Visual and Performing Arts | |
| 6004 Commercial Art and Graphic Design | |
| 6005 Film, Video and Photographic Arts | |
| 6006 Art History and Criticism | |
| 6007 Studio Arts | |
| 6099 Miscellaneous Fine Arts | |
| 6100 General Medical and Health Services | |
| 6102 Communication Disorders Sciences and Services | |
| 6103 Health and Medical Administrative Services | |
| 6104 Medical Assisting Services | |
| 6105 Medical Technologies Technicians | |
| 6106 Health and Medical Preparatory Programs | |
| 6107 Nursing | |
| 6108 Pharmacy, Pharmaceutical Sciences, and Administration | |
| 6109 Treatment Therapy Professions | |
| 6110 Community and Public Health | |
| 6199 Miscellaneous Health Medical Professions | |
| 6200 General Business | |
| 6201 Accounting | |
| 6202 Actuarial Science | |
| 6203 Business Management and Administration | |
| 6204 Operations, Logistics and E-Commerce | |
| 6205 Business Economics | |
| 6206 Marketing and Marketing Research | |
| 6207 Finance | |
| 6209 Human Resources and Personnel Management | |
| 6210 International Business | |
| 6211 Hospitality Management | |
| 6212 Management Information Systems and Statistics | |
| 6299 Miscellaneous Business and Medical Administration | |
| 6402 History | |
| 6403 United States History |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| OCC2010 occupation | |
| 0010 Chief executives and legislators/public administration | |
| 0020 General and Operations Managers | |
| 0030 Managers in Marketing, Advertising, and Public Relations | |
| 0100 Administrative Services Managers | |
| 0110 Computer and Information Systems Managers | |
| 0120 Financial Managers | |
| 0130 Human Resources Managers | |
| 0140 Industrial Production Managers | |
| 0150 Purchasing Managers | |
| 0160 Transportation, Storage, and Distribution Managers | |
| 0205 Farmers, Ranchers, and Other Agricultural Managers | |
| 0220 Constructions Managers | |
| 0230 Education Administrators | |
| 0300 Architectural and Engineering Managers | |
| 0310 Food Service and Lodging Managers | |
| 0320 Funeral Directors | |
| 0330 Gaming Managers | |
| 0350 Medical and Health Services Managers | |
| 0360 Natural Science Managers | |
| 0410 Property, Real Estate, and Community Association Managers | |
| 0420 Social and Community Service Managers | |
| 0430 Managers, nec (including Postmasters) | |
| 0500 Agents and Business Managers of Artists, Performers, and Athletes | |
| 0510 Buyers and Purchasing Agents, Farm Products | |
| 0520 Wholesale and Retail Buyers, Except Farm Products | |
| 0530 Purchasing Agents, Except Wholesale, Retail, and Farm Products | |
| 0540 Claims Adjusters, Appraisers, Examiners, and Investigators | |
| 0560 Compliance Officers, Except Agriculture | |
| 0600 Cost Estimators | |
| 0620 Human Resources, Training, and Labor Relations Specialists | |
| 0700 Logisticians | |
| 0710 Management Analysts | |
| 0720 Meeting and Convention Planners | |
| 0730 Other Business Operations and Management Specialists | |
| 0800 Accountants and Auditors | |
| 0810 Appraisers and Assessors of Real Estate | |
| 0820 Budget Analysts | |
| 0830 Credit Analysts | |
| 0840 Financial Analysts | |
| 0850 Personal Financial Advisors | |
| 0860 Insurance Underwriters | |
| 0900 Financial Examiners | |
| 0910 Credit Counselors and Loan Officers | |
| 0930 Tax Examiners and Collectors, and Revenue Agents | |
| 0940 Tax Preparers | |
| 0950 Financial Specialists, nec | |
| 1000 Computer Scientists and Systems Analysts/Network systems Analysts/Web Developers | |
| 1010 Computer Programmers | |
| 1020 Software Developers, Applications and Systems Software | |
| 1050 Computer Support Specialists | |
| 1060 Database Administrators | |
| 1100 Network and Computer Systems Administrators | |
| 1200 Actuaries | |
| 1220 Operations Research Analysts | |
| 1230 Statisticians | |
| 1240 Mathematical science occupations, nec | |
| 1300 Architects, Except Naval | |
| 1310 Surveyors, Cartographers, and Photogrammetrists | |
| 1320 Aerospace Engineers | |
| 1350 Chemical Engineers | |
| 1360 Civil Engineers | |
| 1400 Computer Hardware Engineers | |
| 1410 Electrical and Electronics Engineers | |
| 1420 Environmental Engineers | |
| 1430 Industrial Engineers, including Health and Safety | |
| 1440 Marine Engineers and Naval Architects | |
| 1450 Materials Engineers | |
| 1460 Mechanical Engineers | |
| 1520 Petroleum, mining and geological engineers, including mining safety engineers | |
| 1530 Engineers, nec | |
| 1540 Drafters | |
| 1550 Engineering Technicians, Except Drafters | |
| 1560 Surveying and Mapping Technicians | |
| 1600 Agricultural and Food Scientists | |
| 1610 Biological Scientists | |
| 1640 Conservation Scientists and Foresters | |
| 1650 Medical Scientists, and Life Scientists, All Other | |
| 1700 Astronomers and Physicists | |
| 1710 Atmospheric and Space Scientists | |
| 1720 Chemists and Materials Scientists | |
| 1740 Environmental Scientists and Geoscientists | |
| 1760 Physical Scientists, nec | |
| 1800 Economists and market researchers | |
| 1820 Psychologists | |
| 1830 Urban and Regional Planners | |
| 1840 Social Scientists, nec | |
| 1900 Agricultural and Food Science Technicians | |
| 1910 Biological Technicians | |
| 1920 Chemical Technicians | |
| 1930 Geological and Petroleum Technicians, and Nuclear Technicians | |
| 1960 Life, Physical, and Social Science Technicians, nec | |
| 1980 Professional, Research, or Technical Workers, nec | |
| 2000 Counselors | |
| 2010 Social Workers | |
| 2020 Community and Social Service Specialists, nec | |
| 2040 Clergy | |
| 2050 Directors, Religious Activities and Education | |
| 2060 Religious Workers, nec | |
| 2100 Lawyers, and judges, magistrates, and other judicial workers | |
| 2140 Paralegals and Legal Assistants | |
| 2150 Legal Support Workers, nec | |
| 2200 Postsecondary Teachers | |
| 2300 Preschool and Kindergarten Teachers | |
| 2310 Elementary and Middle School Teachers | |
| 2320 Secondary School Teachers | |
| 2330 Special Education Teachers | |
| 2340 Other Teachers and Instructors | |
| 2400 Archivists, Curators, and Museum Technicians | |
| 2430 Librarians | |
| 2440 Library Technicians | |
| 2540 Teacher Assistants | |
| 2550 Education, Training, and Library Workers, nec | |
| 2600 Artists and Related Workers | |
| 2630 Designers | |
| 2700 Actors, Producers, and Directors | |
| 2720 Athletes, Coaches, Umpires, and Related Workers | |
| 2740 Dancers and Choreographers | |
| 2750 Musicians, Singers, and Related Workers | |
| 2760 Entertainers and Performers, Sports and Related Workers, All Other | |
| 2800 Announcers | |
| 2810 Editors, News Analysts, Reporters, and Correspondents | |
| 2825 Public Relations Specialists | |
| 2840 Technical Writers | |
| 2850 Writers and Authors | |
| 2860 Media and Communication Workers, nec | |
| 2900 Broadcast and Sound Engineering Technicians and Radio Operators, and media and communication equipment workers, all other | |
| 2910 Photographers | |
| 2920 Television, Video, and Motion Picture Camera Operators and Editors | |
| 3000 Chiropractors | |
| 3010 Dentists | |
| 3030 Dieticians and Nutritionists | |
| 3040 Optometrists | |
| 3050 Pharmacists | |
| 3060 Physicians and Surgeons | |
| 3110 Physician Assistants | |
| 3120 Podiatrists | |
| 3130 Registered Nurses | |
| 3140 Audiologists | |
| 3150 Occupational Therapists | |
| 3160 Physical Therapists | |
| 3200 Radiation Therapists | |
| 3210 Recreational Therapists | |
| 3220 Respiratory Therapists | |
| 3230 Speech Language Pathologists | |
| 3240 Therapists, nec | |
| 3250 Veterinarians | |
| 3260 Health Diagnosing and Treating Practitioners, nec | |
| 3300 Clinical Laboratory Technologists and Technicians | |
| 3310 Dental Hygienists | |
| 3320 Diagnostic Related Technologists and Technicians | |
| 3400 Emergency Medical Technicians and Paramedics | |
| 3410 Health Diagnosing and Treating Practitioner Support Technicians | |
| 3500 Licensed Practical and Licensed Vocational Nurses | |
| 3510 Medical Records and Health Information Technicians | |
| 3520 Opticians, Dispensing | |
| 3530 Health Technologists and Technicians, nec | |
| 3540 Healthcare Practitioners and Technical Occupations, nec | |
| 3600 Nursing, Psychiatric, and Home Health Aides | |
| 3610 Occupational Therapy Assistants and Aides | |
| 3620 Physical Therapist Assistants and Aides | |
| 3630 Massage Therapists | |
| 3640 Dental Assistants | |
| 3650 Medical Assistants and Other Healthcare Support Occupations, nec | |
| 3700 First-Line Supervisors of Correctional Officers | |
| 3710 First-Line Supervisors of Police and Detectives | |
| 3720 First-Line Supervisors of Fire Fighting and Prevention Workers | |
| 3730 Supervisors, Protective Service Workers, All Other | |
| 3740 Firefighters | |
| 3750 Fire Inspectors | |
| 3800 Sheriffs, Bailiffs, Correctional Officers, and Jailers | |
| 3820 Police Officers and Detectives | |
| 3900 Animal Control | |
| 3910 Private Detectives and Investigators | |
| 3930 Security Guards and Gaming Surveillance Officers | |
| 3940 Crossing Guards | |
| 3950 Law enforcement workers, nec | |
| 4000 Chefs and Cooks | |
| 4010 First-Line Supervisors of Food Preparation and Serving Workers | |
| 4030 Food Preparation Workers | |
| 4040 Bartenders | |
| 4050 Combined Food Preparation and Serving Workers, Including Fast Food | |
| 4060 Counter Attendant, Cafeteria, Food Concession, and Coffee Shop | |
| 4110 Waiters and Waitresses | |
| 4120 Food Servers, Nonrestaurant | |
| 4130 Food preparation and serving related workers, nec | |
| 4140 Dishwashers | |
| 4150 Host and Hostesses, Restaurant, Lounge, and Coffee Shop | |
| 4200 First-Line Supervisors of Housekeeping and Janitorial Workers | |
| 4210 First-Line Supervisors of Landscaping, Lawn Service, and Groundskeeping Workers | |
| 4220 Janitors and Building Cleaners | |
| 4230 Maids and Housekeeping Cleaners | |
| 4240 Pest Control Workers | |
| 4250 Grounds Maintenance Workers | |
| 4300 First-Line Supervisors of Gaming Workers | |
| 4320 First-Line Supervisors of Personal Service Workers | |
| 4340 Animal Trainers | |
| 4350 Nonfarm Animal Caretakers | |
| 4400 Gaming Services Workers | |
| 4420 Ushers, Lobby Attendants, and Ticket Takers | |
| 4430 Entertainment Attendants and Related Workers, nec | |
| 4460 Funeral Service Workers and Embalmers | |
| 4500 Barbers | |
| 4510 Hairdressers, Hairstylists, and Cosmetologists | |
| 4520 Personal Appearance Workers, nec | |
| 4530 Baggage Porters, Bellhops, and Concierges | |
| 4540 Tour and Travel Guides | |
| 4600 Childcare Workers | |
| 4610 Personal Care Aides | |
| 4620 Recreation and Fitness Workers | |
| 4640 Residential Advisors | |
| 4650 Personal Care and Service Workers, All Other | |
| 4700 First-Line Supervisors of Sales Workers | |
| 4720 Cashiers | |
| 4740 Counter and Rental Clerks | |
| 4750 Parts Salespersons | |
| 4760 Retail Salespersons | |
| 4800 Advertising Sales Agents | |
| 4810 Insurance Sales Agents | |
| 4820 Securities, Commodities, and Financial Services Sales Agents | |
| 4830 Travel Agents | |
| 4840 Sales Representatives, Services, All Other | |
| 4850 Sales Representatives, Wholesale and Manufacturing | |
| 4900 Models, Demonstrators, and Product Promoters | |
| 4920 Real Estate Brokers and Sales Agents | |
| 4930 Sales Engineers | |
| 4940 Telemarketers | |
| 4950 Door-to-Door Sales Workers, News and Street Vendors, and Related Workers | |
| 4965 Sales and Related Workers, All Other | |
| 5000 First-Line Supervisors of Office and Administrative Support Workers | |
| 5010 Switchboard Operators, Including Answering Service | |
| 5020 Telephone Operators | |
| 5030 Communications Equipment Operators, All Other | |
| 5100 Bill and Account Collectors | |
| 5110 Billing and Posting Clerks | |
| 5120 Bookkeeping, Accounting, and Auditing Clerks | |
| 5130 Gaming Cage Workers | |
| 5140 Payroll and Timekeeping Clerks | |
| 5150 Procurement Clerks | |
| 5160 Bank Tellers | |
| 5165 Financial Clerks, nec | |
| 5200 Brokerage Clerks | |
| 5220 Court, Municipal, and License Clerks | |
| 5230 Credit Authorizers, Checkers, and Clerks | |
| 5240 Customer Service Representatives | |
| 5250 Eligibility Interviewers, Government Programs | |
| 5260 File Clerks | |
| 5300 Hotel, Motel, and Resort Desk Clerks | |
| 5310 Interviewers, Except Eligibility and Loan | |
| 5320 Library Assistants, Clerical | |
| 5330 Loan Interviewers and Clerks | |
| 5340 New Account Clerks | |
| 5350 Correspondent clerks and order clerks | |
| 5360 Human Resources Assistants, Except Payroll and Timekeeping | |
| 5400 Receptionists and Information Clerks | |
| 5410 Reservation and Transportation Ticket Agents and Travel Clerks | |
| 5420 Information and Record Clerks, All Other | |
| 5500 Cargo and Freight Agents | |
| 5510 Couriers and Messengers | |
| 5520 Dispatchers | |
| 5530 Meter Readers, Utilities | |
| 5540 Postal Service Clerks | |
| 5550 Postal Service Mail Carriers | |
| 5560 Postal Service Mail Sorters, Processors, and Processing Machine Operators | |
| 5600 Production, Planning, and Expediting Clerks | |
| 5610 Shipping, Receiving, and Traffic Clerks | |
| 5620 Stock Clerks and Order Fillers | |
| 5630 Weighers, Measurers, Checkers, and Samplers, Recordkeeping | |
| 5700 Secretaries and Administrative Assistants | |
| 5800 Computer Operators | |
| 5810 Data Entry Keyers | |
| 5820 Word Processors and Typists | |
| 5840 Insurance Claims and Policy Processing Clerks | |
| 5850 Mail Clerks and Mail Machine Operators, Except Postal Service | |
| 5860 Office Clerks, General | |
| 5900 Office Machine Operators, Except Computer | |
| 5910 Proofreaders and Copy Markers | |
| 5920 Statistical Assistants | |
| 5940 Office and administrative support workers, nec | |
| 6005 First-Line Supervisors of Farming, Fishing, and Forestry Workers | |
| 6010 Agricultural Inspectors | |
| 6040 Graders and Sorters, Agricultural Products | |
| 6050 Agricultural workers, nec | |
| 6100 Fishing and hunting workers | |
| 6120 Forest and Conservation Workers | |
| 6130 Logging Workers | |
| 6200 First-Line Supervisors of Construction Trades and Extraction Workers | |
| 6210 Boilermakers | |
| 6220 Brickmasons, Blockmasons, and Stonemasons | |
| 6230 Carpenters | |
| 6240 Carpet, Floor, and Tile Installers and Finishers | |
| 6250 Cement Masons, Concrete Finishers, and Terrazzo Workers | |
| 6260 Construction Laborers | |
| 6300 Paving, Surfacing, and Tamping Equipment Operators | |
| 6320 Construction equipment operators except paving, surfacing, and tamping equipment operators | |
| 6330 Drywall Installers, Ceiling Tile Installers, and Tapers | |
| 6355 Electricians | |
| 6360 Glaziers | |
| 6400 Insulation Workers | |
| 6420 Painters, Construction and Maintenance | |
| 6430 Paperhangers | |
| 6440 Pipelayers, Plumbers, Pipefitters, and Steamfitters | |
| 6460 Plasterers and Stucco Masons | |
| 6500 Reinforcing Iron and Rebar Workers | |
| 6515 Roofers | |
| 6520 Sheet Metal Workers, metal-working | |
| 6530 Structural Iron and Steel Workers | |
| 6600 Helpers, Construction Trades | |
| 6660 Construction and Building Inspectors | |
| 6700 Elevator Installers and Repairers | |
| 6710 Fence Erectors | |
| 6720 Hazardous Materials Removal Workers | |
| 6730 Highway Maintenance Workers | |
| 6740 Rail-Track Laying and Maintenance Equipment Operators | |
| 6765 Construction workers, nec | |
| 6800 Derrick, rotary drill, and service unit operators, and roustabouts, oil, gas, and mining | |
| 6820 Earth Drillers, Except Oil and Gas | |
| 6830 Explosives Workers, Ordnance Handling Experts, and Blasters | |
| 6840 Mining Machine Operators | |
| 6940 Extraction workers, nec | |
| 7000 First-Line Supervisors of Mechanics, Installers, and Repairers | |
| 7010 Computer, Automated Teller, and Office Machine Repairers | |
| 7020 Radio and Telecommunications Equipment Installers and Repairers | |
| 7030 Avionics Technicians | |
| 7040 Electric Motor, Power Tool, and Related Repairers | |
| 7100 Electrical and electronics repairers, transportation equipment, and industrial and utility | |
| 7110 Electronic Equipment Installers and Repairers, Motor Vehicles | |
| 7120 Electronic Home Entertainment Equipment Installers and Repairers | |
| 7125 Electronic Repairs, nec | |
| 7130 Security and Fire Alarm Systems Installers | |
| 7140 Aircraft Mechanics and Service Technicians | |
| 7150 Automotive Body and Related Repairers | |
| 7160 Automotive Glass Installers and Repairers | |
| 7200 Automotive Service Technicians and Mechanics | |
| 7210 Bus and Truck Mechanics and Diesel Engine Specialists | |
| 7220 Heavy Vehicle and Mobile Equipment Service Technicians and Mechanics | |
| 7240 Small Engine Mechanics | |
| 7260 Vehicle and Mobile Equipment Mechanics, Installers, and Repairers, nec | |
| 7300 Control and Valve Installers and Repairers | |
| 7315 Heating, Air Conditioning, and Refrigeration Mechanics and Installers | |
| 7320 Home Appliance Repairers | |
| 7330 Industrial and Refractory Machinery Mechanics | |
| 7340 Maintenance and Repair Workers, General | |
| 7350 Maintenance Workers, Machinery | |
| 7360 Millwrights | |
| 7410 Electrical Power-Line Installers and Repairers | |
| 7420 Telecommunications Line Installers and Repairers | |
| 7430 Precision Instrument and Equipment Repairers | |
| 7510 Coin, Vending, and Amusement Machine Servicers and Repairers | |
| 7540 Locksmiths and Safe Repairers | |
| 7550 Manufactured Building and Mobile Home Installers | |
| 7560 Riggers | |
| 7610 Helpers--Installation, Maintenance, and Repair Workers | |
| 7630 Other Installation, Maintenance, and Repair Workers Including Wind Turbine Service Technicians, and Commercial Divers, and Signal and Track Switch Repairers | |
| 7700 First-Line Supervisors of Production and Operating Workers | |
| 7710 Aircraft Structure, Surfaces, Rigging, and Systems Assemblers | |
| 7720 Electrical, Electronics, and Electromechanical Assemblers | |
| 7730 Engine and Other Machine Assemblers | |
| 7740 Structural Metal Fabricators and Fitters | |
| 7750 Assemblers and Fabricators, nec | |
| 7800 Bakers | |
| 7810 Butchers and Other Meat, Poultry, and Fish Processing Workers | |
| 7830 Food and Tobacco Roasting, Baking, and Drying Machine Operators and Tenders | |
| 7840 Food Batchmakers | |
| 7850 Food Cooking Machine Operators and Tenders | |
| 7855 Food Processing, nec | |
| 7900 Computer Control Programmers and Operators | |
| 7920 Extruding and Drawing Machine Setters, Operators, and Tenders, Metal and Plastic | |
| 7930 Forging Machine Setters, Operators, and Tenders, Metal and Plastic | |
| 7940 Rolling Machine Setters, Operators, and Tenders, metal and Plastic | |
| 7950 Cutting, Punching, and Press Machine Setters, Operators, and Tenders, Metal and Plastic | |
| 7960 Drilling and Boring Machine Tool Setters, Operators, and Tenders, Metal and Plastic | |
| 8000 Grinding, Lapping, Polishing, and Buffing Machine Tool Setters, Operators, and Tenders, Metal and Plastic | |
| 8010 Lathe and Turning Machine Tool Setters, Operators, and Tenders, Metal and Plastic | |
| 8030 Machinists | |
| 8040 Metal Furnace Operators, Tenders, Pourers, and Casters | |
| 8060 Model Makers and Patternmakers, Metal and Plastic | |
| 8100 Molders and Molding Machine Setters, Operators, and Tenders, Metal and Plastic | |
| 8130 Tool and Die Makers | |
| 8140 Welding, Soldering, and Brazing Workers | |
| 8150 Heat Treating Equipment Setters, Operators, and Tenders, Metal and Plastic | |
| 8200 Plating and Coating Machine Setters, Operators, and Tenders, Metal and Plastic | |
| 8210 Tool Grinders, Filers, and Sharpeners | |
| 8220 Metal workers and plastic workers, nec | |
| 8230 Bookbinders, Printing Machine Operators, and Job Printers | |
| 8250 Prepress Technicians and Workers | |
| 8300 Laundry and Dry-Cleaning Workers | |
| 8310 Pressers, Textile, Garment, and Related Materials | |
| 8320 Sewing Machine Operators | |
| 8330 Shoe and Leather Workers and Repairers | |
| 8340 Shoe Machine Operators and Tenders | |
| 8350 Tailors, Dressmakers, and Sewers | |
| 8400 Textile bleaching and dyeing, and cutting machine setters, operators, and tenders | |
| 8410 Textile Knitting and Weaving Machine Setters, Operators, and Tenders | |
| 8420 Textile Winding, Twisting, and Drawing Out Machine Setters, Operators, and Tenders | |
| 8450 Upholsterers | |
| 8460 Textile, Apparel, and Furnishings workers, nec | |
| 8500 Cabinetmakers and Bench Carpenters | |
| 8510 Furniture Finishers | |
| 8530 Sawing Machine Setters, Operators, and Tenders, Wood | |
| 8540 Woodworking Machine Setters, Operators, and Tenders, Except Sawing | |
| 8550 Woodworkers including model makers and patternmakers, nec | |
| 8600 Power Plant Operators, Distributors, and Dispatchers | |
| 8610 Stationary Engineers and Boiler Operators | |
| 8620 Water Wastewater Treatment Plant and System Operators | |
| 8630 Plant and System Operators, nec | |
| 8640 Chemical Processing Machine Setters, Operators, and Tenders | |
| 8650 Crushing, Grinding, Polishing, Mixing, and Blending Workers | |
| 8710 Cutting Workers | |
| 8720 Extruding, Forming, Pressing, and Compacting Machine Setters, Operators, and Tenders | |
| 8730 Furnace, Kiln, Oven, Drier, and Kettle Operators and Tenders | |
| 8740 Inspectors, Testers, Sorters, Samplers, and Weighers | |
| 8750 Jewelers and Precious Stone and Metal Workers | |
| 8760 Medical, Dental, and Ophthalmic Laboratory Technicians | |
| 8800 Packaging and Filling Machine Operators and Tenders | |
| 8810 Painting Workers and Dyers | |
| 8830 Photographic Process Workers and Processing Machine Operators | |
| 8850 Adhesive Bonding Machine Operators and Tenders | |
| 8860 Cleaning, Washing, and Metal Pickling Equipment Operators and Tenders | |
| 8910 Etchers, Engravers, and Lithographers | |
| 8920 Molders, Shapers, and Casters, Except Metal and Plastic | |
| 8930 Paper Goods Machine Setters, Operators, and Tenders | |
| 8940 Tire Builders | |
| 8950 Helpers--Production Workers | |
| 8965 Other production workers including semiconductor processors and cooling and freezing equipment operators | |
| 9000 Supervisors of Transportation and Material Moving Workers | |
| 9030 Aircraft Pilots and Flight Engineers | |
| 9040 Air Traffic Controllers and Airfield Operations Specialists | |
| 9050 Flight Attendants and Transportation Workers and Attendants | |
| 9100 Bus and Ambulance Drivers and Attendants | |
| 9130 Driver/Sales Workers and Truck Drivers | |
| 9140 Taxi Drivers and Chauffeurs | |
| 9150 Motor Vehicle Operators, All Other | |
| 9200 Locomotive Engineers and Operators | |
| 9230 Railroad Brake, Signal, and Switch Operators | |
| 9240 Railroad Conductors and Yardmasters | |
| 9260 Subway, Streetcar, and Other Rail Transportation Workers | |
| 9300 Sailors and marine oilers, and ship engineers | |
| 9310 Ship and Boat Captains and Operators | |
| 9350 Parking Lot Attendants | |
| 9360 Automotive and Watercraft Service Attendants | |
| 9410 Transportation Inspectors | |
| 9420 Transportation workers, nec | |
| 9510 Crane and Tower Operators | |
| 9520 Dredge, Excavating, and Loading Machine Operators | |
| 9560 Conveyor operators and tenders, and hoist and winch operators | |
| 9600 Industrial Truck and Tractor Operators | |
| 9610 Cleaners of Vehicles and Equipment | |
| 9620 Laborers and Freight, Stock, and Material Movers, Hand | |
| 9630 Machine Feeders and Offbearers | |
| 9640 Packers and Packagers, Hand | |
| 9650 Pumping Station Operators | |
| 9720 Refuse and Recyclable Material Collectors | |
| 9750 Material moving workers, nec | |
| 9800 Military Officer Special and Tactical Operations Leaders | |
| 9810 First-Line Enlisted Military Supervisors | |
| 9820 Military Enlisted Tactical Operations and Air/Weapons Specialists and Crew Members | |
| 9830 Military, Rank Not Specified | |
| 9920 Unemployed, with No Work Experience in the Last 5 Years or Earlier or Never Worked |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(data.table) | |
| library(magrittr) | |
| library(bit64) | |
| # lookup tables | |
| dt_occ2010 <- fread('occ2010.txt') | |
| dt_degfieldd <- fread('degfieldd.txt') | |
| # microdata file | |
| starttime <- Sys.time() | |
| dt_ipums <- fread('usa_00128.csv') # 1.5GB : 15.8M rows by 30 columns | |
| difftime(Sys.time(), starttime, units = 'secs') | |
| # get top occupations | |
| starttime <- Sys.time() | |
| dt_occs <- dt_ipums[EMPSTAT == 1, | |
| .(people = sum(PERWT)), | |
| .(DEGFIELDD, OCC2010)] %>% | |
| .[order(-people), rank := 1:.N, .(DEGFIELDD)] %>% | |
| .[rank <= 5] %>% | |
| .[, rank := paste0('occ_', rank)] %>% | |
| dt_occ2010[., on = 'OCC2010'] %>% | |
| dcast(DEGFIELDD ~ rank, value.var = 'occupation') | |
| difftime(Sys.time(), starttime, units = 'secs') | |
| # summarize by field of study | |
| starttime <- Sys.time() | |
| dt_degs <- dt_ipums[, | |
| .(people = sum(PERWT), | |
| pctFemale = sum((SEX == 2) * PERWT) / sum(PERWT), | |
| unemploymentRate = sum((EMPSTAT == 2) * PERWT) / sum((EMPSTAT %in% 1:3) * PERWT), | |
| avgWage = sum(INCEARN * PERWT) / sum(PERWT)), | |
| .(DEGFIELDD)] %>% | |
| dt_degfieldd[., on = 'DEGFIELDD'] %>% | |
| dt_occs[., on = 'DEGFIELDD'] | |
| difftime(Sys.time(), starttime, units = 'secs') | |
| fwrite(dt_degs, 'degree major stats.csv') |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| library(tidyverse) | |
| # lookup tables | |
| df_occ2010 <- read_tsv('occ2010.txt') | |
| df_degfieldd <- read_tsv('degfieldd.txt') | |
| # microdata file | |
| starttime <- Sys.time() | |
| df_ipums <- read_csv('usa_00128.csv') # 1.5GB : 15.8M rows by 30 columns | |
| difftime(Sys.time(), starttime, units = 'secs') | |
| # get top occupations | |
| starttime <- Sys.time() | |
| df_occs <- df_ipums %>% | |
| filter(EMPSTAT == 1) %>% | |
| group_by(DEGFIELDD, OCC2010) %>% | |
| summarise(people = sum(PERWT)) %>% | |
| arrange(desc(people)) %>% | |
| group_by(DEGFIELDD) %>% | |
| mutate(rank = row_number()) %>% | |
| filter(rank <= 5) %>% | |
| mutate(rank = paste0('occ_', rank)) %>% | |
| left_join(df_occ2010, by = 'OCC2010') %>% | |
| select(DEGFIELDD, rank, occupation) %>% | |
| spread(rank, occupation) | |
| difftime(Sys.time(), starttime, units = 'secs') | |
| # summarize by field of study | |
| starttime <- Sys.time() | |
| df_degs <- df_ipums %>% | |
| group_by(DEGFIELDD) %>% | |
| summarise(people = sum(PERWT), | |
| pctFemale = sum((SEX == 2) * PERWT) / sum(PERWT), | |
| unemploymentRate = sum((EMPSTAT == 2) * PERWT) / sum((EMPSTAT %in% 1:3) * PERWT), | |
| avgWage = sum(INCEARN * PERWT) / sum(PERWT)) %>% | |
| left_join(df_degfieldd, by = 'DEGFIELDD') %>% | |
| left_join(df_occs, by = 'DEGFIELDD') | |
| difftime(Sys.time(), starttime, units = 'secs') | |
| write_csv(dt_degs, 'degree major stats.csv') |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment