如果没有钉钉这种打卡软件可以帮你统计考勤数据,而且考勤机导出的数据只有员工打卡时间时,可以利用python编写一个自动统计的脚本,加快办公效率
实现的几个功能:
1、按月统计出勤,早退,迟到等常见指标
2、对源数据进行了清洗加工,尤其对一天内重复打卡的情况进行处理
3、抽取出异常记录(忘记打卡),便于排查异常原因
附带完整源码~
# -*- coding: utf-8 -*-
"""
Created on Wed Aug 25 16:10:46 2021
@author: Administrator
"""
import pandas as pd
import datetime
import os
import time
# %%
def get_week_day(date):
week_day = {
0: '一',
1: '二',
2: '三',
3: '四',
4: '五',
5: '六',
6: '日'
}
day = date.weekday()
return week_day[day]
def get_monringORafternoon(date):
current_time = date.hour
if current_time <= 12:
return '上午'
else:
return '下午'
def lateForWork(df):
return (df['AMPM'] == '上午') & (df['Time'].apply(lambda x: datetime.time.strftime(x, "%H:%M:%S")) > '09:00:00')
def leaveEarly(df):
return (df['AMPM'] == '下午') & (df['Time'].apply(lambda