Execute the following Python code to generate a random file :
Execute the following Python code to generate a random file :
import randomimport datetime
import csv
def generate_employee_data():
employee_data = []
for i in range(2000):
employee_data.append([
i,
random.choice(['John', 'Jane', 'Mike', 'Mary', 'Susan', 'Peter']),
random.choice(['A', 'B', 'C', 'D', 'E']),
random.choice(['Doe', 'Smith', 'Jones', 'Williams', 'Brown', 'Green']),
random.choice(['Male', 'Female', 'X']),
datetime.date(random.randint(1940, 2023), random.randint(1, 12), random.randint(1, 28)),
random.randint(20, 60),
random.choice(['Business Analyst', 'Human Resources Manager', 'IT Manager', 'Public Relations Manager', 'Senior Accountant', 'City Manager', 'Gardner', 'Cleaner', 'Advisor', 'Attendant', 'Officer']),
random.randint(1, 1000),
random.randint(1, 1000),
random.randint(50000, 200000),
random.randint(3000, 15000),
random.choices([1, 2, 3], weights=[2, 5, 3]),
random.choices([1, 2, 3], weights=[2, 5, 3]),
random.randint(0, 20),
random.randint(0, 10),
random.randint(0, 10),
random.choice(['High School', 'TAFE', 'Undergraduate', 'Post Graduate']),
random.randint(0, 1)
])
return employee_data
def write_employee_data(employee_data):
with open('employee_data.csv', 'w', newline='') as f:
writer = csv.writer(f)
writer.writerow([
'Employee ID Number', 'First Name', 'Middle Name', 'Last Name', 'Gender', 'Date of Birth', 'Age', 'Position Title', 'Position Number', 'Supervisor's Position Number', 'Annual Salary', 'Monthly Salary', 'This Year's Performance Rating', 'Last Year's Performance Rating', 'Years in Current Position', 'Years Since Last Promotion', 'Years With Current Manager', 'Highest Level of Education', 'Attrition Risk'
])
writer.writerows(employee_data)
Based on the dataset generated:
i.Calculate basic statistics (e.g., mean, median, standard deviation) for employee age, years in the current role, and pay information.
ii.Analyse the distribution of performance ratings.
iii.Explore attrition based on gender, education level, years with current manageriv.Develop a simple predictive model to determine factors influencing employee attrition.
v.Provide the dataset you generated as a CSV and develop a report for presentation.When presenting your results, briefly explain the process you took to reach them (e.g. excel formulas, VB Script, SQL, Python, R, etc.) and why you chose to represent the data in the way you have selected.
Scenario two (hypothetical) RestructureCouncil is considering restructuring part of its operations and setting up its Water and Resource Recovery Division as a standalone business, owned wholly by Council. You will need to potentially reference three items to answer this question (all publicly available):
- Industrial Relations Act 2016 (QLD);- Local Government Act 2009 (QLD);- Townsville City Council (Field and Other Employees) Certified Agreement 2012.
Provide hypothetical data, or a description of the data requirements, to inform a Change Impact Statement that Councils leadership will use in discussing this restructure. Structure this ineithera brief reportorpresentation to present to the selection panel you do not need to create the change impact statement itself, just the data that will form the inputs for the change impact statement.
