Notes:
-
Problem Solved: Flags salary or hour inconsistencies based on labor laws.
-
Customization Benefits: Adjust rules per region or job role.
-
Further Adoption: Connect to payroll systems or accounting software.
Python Code:
import pandas as pd
df = pd.read_csv("employee_hours.csv") # Columns: employee_id, hours_worked, salary
def check_compliance(row):
hourly_rate = row['salary'] / row['hours_worked']
if hourly_rate < 15: # Example: $15/hr minimum wage
return "Non-Compliant"
return "Compliant"
df['Compliance Status'] = df.apply(check_compliance, axis=1)
print(df[['employee_id', 'Compliance Status']])
No comments:
Post a Comment