Employee salaries in Texas administrations

Citation Author(s):
Alexis
Cvetkov-Iliev
Alexandre
Allauzen
Gaël
Varoquaux
Submitted by:
Alexis Cvetkov-Iliev
Last updated:
Mon, 01/31/2022 - 12:02
DOI:
10.21227/wfjs-ya22
License:
249 Views
Categories:
0
0 ratings - Please login to submit your rating.

Abstract 

This dataset contains information about employees in 14 Texas administrations: salary, job title, work experience, gender, ethnicity...

Instructions: 

This dataset contains the following data:

- the folder "raw" includes 14 raw .csv files with employee attributes in Texas administrations

- "merged_raw_data.csv" is the aggregation of the 14 raw employees tables, and contains the following attributes

- "merged_cleaned_data.csv" is the aggregation of the 14 raw employee tables, after manual cleaning/matching of job titles across data sources.

"merged_cleaned_data.csv" contains the following attributes:

- "Dirty Job Title": the employee raw job title (before manual cleaning)

- "Cleaned Job Title": the employee job title, after manual cleaning/matching across data sources

- "Seniority": the number of years of experience of the employee since its hiring date

- "Gender": a binary variable indicating the employee gender (0 for men, 1 for women)

- "Ethnicity": the employee ethnicity

- "Annual Salary": the employee annual salary, in dollars

- "Database_ID": an integer (between 0 and 13) indicating the Texas administration in which the employee works