python - 正确重新采样开始和结束员工假期表-6ren

python - 正确重新采样开始和结束员工假期表

转载作者：行者123 更新时间：2023-12-03 18:44:00

我有以下数据框。

df = pd.DataFrame(
    {'name' : ['Khan','Khan','Khan','Dean','Dean','Dean'],
     'start_date' : ['01-01-2020','04-02-2020','02-03-2020','09-04-2020','06-08-2020','12-12-2020'],
     'end_date' : ['03-01-2020', '09-02-2020','02-03-2020','15-05-2020','19-08-2020','31-12-2020'],
     'holiday_type' : ['holiday','holiday','sick leave','holiday','holiday','sick leave']

    } )

df[['start_date','end_date']] = df[['start_date','end_date']].apply(pd.to_datetime,format='%d-%m-%Y')

打印(df)

   name start_date   end_date holiday_type
0  Khan 2020-01-01 2020-01-03      holiday
1  Khan 2020-02-04 2020-02-09      holiday
2  Khan 2020-03-02 2020-03-02   sick leave
3  Dean 2020-04-09 2020-05-15      holiday
4  Dean 2020-08-06 2020-08-19      holiday
5  Dean 2020-12-12 2020-12-31   sick leave

我试图在不重叠的情况下按开始和结束日期重新采样数据，即我不想要从 2020-01-02 开始的可汗表并结束于 2020-03-02
我自己尝试融化、索引和使用 groupby.resample但是我不确定如何只按每个开始和结束日期分组，累计计数？但它似乎也不是很有效。

理想输出:

    name date_range holiday_type
0   Khan 2020-01-01      holiday
1   Khan 2020-02-01      holiday
2   Khan 2020-03-01      holiday # < end of holiday 1
3   Khan 2020-04-02      holiday 
4   Khan 2020-05-02      holiday
5   Khan 2020-06-02      holiday
6   Khan 2020-07-02      holiday
7   Khan 2020-08-02      holiday
8   Khan 2020-09-02      holiday # end of holiday 2
9   Khan 2020-02-03   sick leave # one day sick leave, can also have one day holiday.
10  Dean 2020-09-04      holiday
11  Dean 2020-10-04      holiday
12  Dean 2020-11-04      holiday
13  Dean 2020-12-04      holiday
14  Dean 2020-04-13      holiday
15  Dean 2020-04-14      holiday
16  Dean 2020-04-15      holiday
17  Dean 2020-06-08      holiday
18  Dean 2020-07-08      holiday
19  Dean 2020-08-08      holiday
20  Dean 2020-09-08      holiday
21  Dean 2020-10-08      holiday
22  Dean 2020-11-08      holiday
23  Dean 2020-12-08      holiday
24  Dean 2020-08-13      holiday
25  Dean 2020-08-14      holiday
26  Dean 2020-08-15      holiday
27  Dean 2020-08-16      holiday
28  Dean 2020-08-17      holiday
29  Dean 2020-08-18      holiday
30  Dean 2020-08-19      holiday
31  Dean 2020-12-12   sick leave
32  Dean 2020-12-13   sick leave
33  Dean 2020-12-14   sick leave
34  Dean 2020-12-15   sick leave
35  Dean 2020-12-16   sick leave
36  Dean 2020-12-17   sick leave
37  Dean 2020-12-18   sick leave
38  Dean 2020-12-19   sick leave
39  Dean 2020-12-20   sick leave
40  Dean 2020-12-21   sick leave
41  Dean 2020-12-22   sick leave
42  Dean 2020-12-23   sick leave
43  Dean 2020-12-24   sick leave
44  Dean 2020-12-25   sick leave
45  Dean 2020-12-26   sick leave
46  Dean 2020-12-27   sick leave
47  Dean 2020-12-28   sick leave
48  Dean 2020-12-29   sick leave
49  Dean 2020-12-30   sick leave
50  Dean 2020-12-31   sick leave

作为字典的理想输出。

{'name': {0: 'Khan', 1: 'Khan', 2: 'Khan', 3: 'Khan', 4: 'Khan', 5: 'Khan', 6: 'Khan', 7: 'Khan', 8: 'Khan', 9: 'Khan', 10: 'Dean', 11: 'Dean', 12: 'Dean', 13: 'Dean', 14: 'Dean', 15: 'Dean', 16: 'Dean', 17: 'Dean', 18: 'Dean', 19: 'Dean', 20: 'Dean', 21: 'Dean', 22: 'Dean', 23: 'Dean', 24: 'Dean', 25: 'Dean', 26: 'Dean', 27: 'Dean', 28: 'Dean', 29: 'Dean', 30: 'Dean', 31: 'Dean', 32: 'Dean', 33: 'Dean', 34: 'Dean', 35: 'Dean', 36: 'Dean', 37: 'Dean', 38: 'Dean', 39: 'Dean', 40: 'Dean', 41: 'Dean', 42: 'Dean', 43: 'Dean', 44: 'Dean', 45: 'Dean', 46: 'Dean', 47: 'Dean', 48: 'Dean', 49: 'Dean', 50: 'Dean'}, 'date_range': {0: Timestamp('2020-01-01 00:00:00'), 1: Timestamp('2020-02-01 00:00:00'), 2: Timestamp('2020-03-01 00:00:00'), 3: Timestamp('2020-04-02 00:00:00'), 4: Timestamp('2020-05-02 00:00:00'), 5: Timestamp('2020-06-02 00:00:00'), 6: Timestamp('2020-07-02 00:00:00'), 7: Timestamp('2020-08-02 00:00:00'), 8: Timestamp('2020-09-02 00:00:00'), 9: Timestamp('2020-02-03 00:00:00'), 10: Timestamp('2020-09-04 00:00:00'), 11: Timestamp('2020-10-04 00:00:00'), 12: Timestamp('2020-11-04 00:00:00'), 13: Timestamp('2020-12-04 00:00:00'), 14: Timestamp('2020-04-13 00:00:00'), 15: Timestamp('2020-04-14 00:00:00'), 16: Timestamp('2020-04-15 00:00:00'), 17: Timestamp('2020-06-08 00:00:00'), 18: Timestamp('2020-07-08 00:00:00'), 19: Timestamp('2020-08-08 00:00:00'), 20: Timestamp('2020-09-08 00:00:00'), 21: Timestamp('2020-10-08 00:00:00'), 22: Timestamp('2020-11-08 00:00:00'), 23: Timestamp('2020-12-08 00:00:00'), 24: Timestamp('2020-08-13 00:00:00'), 25: Timestamp('2020-08-14 00:00:00'), 26: Timestamp('2020-08-15 00:00:00'), 27: Timestamp('2020-08-16 00:00:00'), 28: Timestamp('2020-08-17 00:00:00'), 29: Timestamp('2020-08-18 00:00:00'), 30: Timestamp('2020-08-19 00:00:00'), 31: Timestamp('2020-12-12 00:00:00'), 32: Timestamp('2020-12-13 00:00:00'), 33: Timestamp('2020-12-14 00:00:00'), 34: Timestamp('2020-12-15 00:00:00'), 35: Timestamp('2020-12-16 00:00:00'), 36: Timestamp('2020-12-17 00:00:00'), 37: Timestamp('2020-12-18 00:00:00'), 38: Timestamp('2020-12-19 00:00:00'), 39: Timestamp('2020-12-20 00:00:00'), 40: Timestamp('2020-12-21 00:00:00'), 41: Timestamp('2020-12-22 00:00:00'), 42: Timestamp('2020-12-23 00:00:00'), 43: Timestamp('2020-12-24 00:00:00'), 44: Timestamp('2020-12-25 00:00:00'), 45: Timestamp('2020-12-26 00:00:00'), 46: Timestamp('2020-12-27 00:00:00'), 47: Timestamp('2020-12-28 00:00:00'), 48: Timestamp('2020-12-29 00:00:00'), 49: Timestamp('2020-12-30 00:00:00'), 50: Timestamp('2020-12-31 00:00:00')}, 'holiday_type': {0: 'holiday', 1: 'holiday', 2: 'holiday', 3: 'holiday', 4: 'holiday', 5: 'holiday', 6: 'holiday', 7: 'holiday', 8: 'holiday', 9: 'sick leave', 10: 'holiday', 11: 'holiday', 12: 'holiday', 13: 'holiday', 14: 'holiday', 15: 'holiday', 16: 'holiday', 17: 'holiday', 18: 'holiday', 19: 'holiday', 20: 'holiday', 21: 'holiday', 22: 'holiday', 23: 'holiday', 24: 'holiday', 25: 'holiday', 26: 'holiday', 27: 'holiday', 28: 'holiday', 29: 'holiday', 30: 'holiday', 31: 'sick leave', 32: 'sick leave', 33: 'sick leave', 34: 'sick leave', 35: 'sick leave', 36: 'sick leave', 37: 'sick leave', 38: 'sick leave', 39: 'sick leave', 40: 'sick leave', 41: 'sick leave', 42: 'sick leave', 43: 'sick leave', 44: 'sick leave', 45: 'sick leave', 46: 'sick leave', 47: 'sick leave', 48: 'sick leave', 49: 'sick leave', 50: 'sick leave'}}

最佳答案

国际大学联盟，

df_out = (df.set_index(['name','holiday_type'])
            .apply(lambda x: pd.date_range(x['start_date'], x['end_date']), axis=1)
            .explode().rename('date').reset_index())

输出:

    name holiday_type       date
0   Khan      holiday 2020-01-01
1   Khan      holiday 2020-01-02
2   Khan      holiday 2020-01-03
3   Khan      holiday 2020-02-04
4   Khan      holiday 2020-02-05
..   ...          ...        ...
76  Dean   sick leave 2020-12-27
77  Dean   sick leave 2020-12-28
78  Dean   sick leave 2020-12-29
79  Dean   sick leave 2020-12-30
80  Dean   sick leave 2020-12-31

[81 rows x 3 columns]

字典输出:

df_out.to_dict()

输出:

{'name': {0: 'Khan',
  1: 'Khan',
  2: 'Khan',
  3: 'Khan',
  4: 'Khan',
  5: 'Khan',
  6: 'Khan',
  7: 'Khan',
  8: 'Khan',
  9: 'Khan',
  10: 'Dean',
  11: 'Dean',
  12: 'Dean',
  13: 'Dean',
  14: 'Dean',
  15: 'Dean',
  16: 'Dean',
  17: 'Dean',
  18: 'Dean',
  19: 'Dean',
  20: 'Dean',
  21: 'Dean',
  22: 'Dean',
  23: 'Dean',
  24: 'Dean',
  25: 'Dean',
  26: 'Dean',
  27: 'Dean',
  28: 'Dean',
  29: 'Dean',
  30: 'Dean',
  31: 'Dean',
  32: 'Dean',
  33: 'Dean',
  34: 'Dean',
  35: 'Dean',
  36: 'Dean',
  37: 'Dean',
  38: 'Dean',
  39: 'Dean',
  40: 'Dean',
  41: 'Dean',
  42: 'Dean',
  43: 'Dean',
  44: 'Dean',
  45: 'Dean',
  46: 'Dean',
  47: 'Dean',
  48: 'Dean',
  49: 'Dean',
  50: 'Dean',
  51: 'Dean',
  52: 'Dean',
  53: 'Dean',
  54: 'Dean',
  55: 'Dean',
  56: 'Dean',
  57: 'Dean',
  58: 'Dean',
  59: 'Dean',
  60: 'Dean',
  61: 'Dean',
  62: 'Dean',
  63: 'Dean',
  64: 'Dean',
  65: 'Dean',
  66: 'Dean',
  67: 'Dean',
  68: 'Dean',
  69: 'Dean',
  70: 'Dean',
  71: 'Dean',
  72: 'Dean',
  73: 'Dean',
  74: 'Dean',
  75: 'Dean',
  76: 'Dean',
  77: 'Dean',
  78: 'Dean',
  79: 'Dean',
  80: 'Dean'},
 'holiday_type': {0: 'holiday',
  1: 'holiday',
  2: 'holiday',
  3: 'holiday',
  4: 'holiday',
  5: 'holiday',
  6: 'holiday',
  7: 'holiday',
  8: 'holiday',
  9: 'sick leave',
  10: 'holiday',
  11: 'holiday',
  12: 'holiday',
  13: 'holiday',
  14: 'holiday',
  15: 'holiday',
  16: 'holiday',
  17: 'holiday',
  18: 'holiday',
  19: 'holiday',
  20: 'holiday',
  21: 'holiday',
  22: 'holiday',
  23: 'holiday',
  24: 'holiday',
  25: 'holiday',
  26: 'holiday',
  27: 'holiday',
  28: 'holiday',
  29: 'holiday',
  30: 'holiday',
  31: 'holiday',
  32: 'holiday',
  33: 'holiday',
  34: 'holiday',
  35: 'holiday',
  36: 'holiday',
  37: 'holiday',
  38: 'holiday',
  39: 'holiday',
  40: 'holiday',
  41: 'holiday',
  42: 'holiday',
  43: 'holiday',
  44: 'holiday',
  45: 'holiday',
  46: 'holiday',
  47: 'holiday',
  48: 'holiday',
  49: 'holiday',
  50: 'holiday',
  51: 'holiday',
  52: 'holiday',
  53: 'holiday',
  54: 'holiday',
  55: 'holiday',
  56: 'holiday',
  57: 'holiday',
  58: 'holiday',
  59: 'holiday',
  60: 'holiday',
  61: 'sick leave',
  62: 'sick leave',
  63: 'sick leave',
  64: 'sick leave',
  65: 'sick leave',
  66: 'sick leave',
  67: 'sick leave',
  68: 'sick leave',
  69: 'sick leave',
  70: 'sick leave',
  71: 'sick leave',
  72: 'sick leave',
  73: 'sick leave',
  74: 'sick leave',
  75: 'sick leave',
  76: 'sick leave',
  77: 'sick leave',
  78: 'sick leave',
  79: 'sick leave',
  80: 'sick leave'},
 'date': {0: Timestamp('2020-01-01 00:00:00'),
  1: Timestamp('2020-01-02 00:00:00'),
  2: Timestamp('2020-01-03 00:00:00'),
  3: Timestamp('2020-02-04 00:00:00'),
  4: Timestamp('2020-02-05 00:00:00'),
  5: Timestamp('2020-02-06 00:00:00'),
  6: Timestamp('2020-02-07 00:00:00'),
  7: Timestamp('2020-02-08 00:00:00'),
  8: Timestamp('2020-02-09 00:00:00'),
  9: Timestamp('2020-03-02 00:00:00'),
  10: Timestamp('2020-04-09 00:00:00'),
  11: Timestamp('2020-04-10 00:00:00'),
  12: Timestamp('2020-04-11 00:00:00'),
  13: Timestamp('2020-04-12 00:00:00'),
  14: Timestamp('2020-04-13 00:00:00'),
  15: Timestamp('2020-04-14 00:00:00'),
  16: Timestamp('2020-04-15 00:00:00'),
  17: Timestamp('2020-04-16 00:00:00'),
  18: Timestamp('2020-04-17 00:00:00'),
  19: Timestamp('2020-04-18 00:00:00'),
  20: Timestamp('2020-04-19 00:00:00'),
  21: Timestamp('2020-04-20 00:00:00'),
  22: Timestamp('2020-04-21 00:00:00'),
  23: Timestamp('2020-04-22 00:00:00'),
  24: Timestamp('2020-04-23 00:00:00'),
  25: Timestamp('2020-04-24 00:00:00'),
  26: Timestamp('2020-04-25 00:00:00'),
  27: Timestamp('2020-04-26 00:00:00'),
  28: Timestamp('2020-04-27 00:00:00'),
  29: Timestamp('2020-04-28 00:00:00'),
  30: Timestamp('2020-04-29 00:00:00'),
  31: Timestamp('2020-04-30 00:00:00'),
  32: Timestamp('2020-05-01 00:00:00'),
  33: Timestamp('2020-05-02 00:00:00'),
  34: Timestamp('2020-05-03 00:00:00'),
  35: Timestamp('2020-05-04 00:00:00'),
  36: Timestamp('2020-05-05 00:00:00'),
  37: Timestamp('2020-05-06 00:00:00'),
  38: Timestamp('2020-05-07 00:00:00'),
  39: Timestamp('2020-05-08 00:00:00'),
  40: Timestamp('2020-05-09 00:00:00'),
  41: Timestamp('2020-05-10 00:00:00'),
  42: Timestamp('2020-05-11 00:00:00'),
  43: Timestamp('2020-05-12 00:00:00'),
  44: Timestamp('2020-05-13 00:00:00'),
  45: Timestamp('2020-05-14 00:00:00'),
  46: Timestamp('2020-05-15 00:00:00'),
  47: Timestamp('2020-08-06 00:00:00'),
  48: Timestamp('2020-08-07 00:00:00'),
  49: Timestamp('2020-08-08 00:00:00'),
  50: Timestamp('2020-08-09 00:00:00'),
  51: Timestamp('2020-08-10 00:00:00'),
  52: Timestamp('2020-08-11 00:00:00'),
  53: Timestamp('2020-08-12 00:00:00'),
  54: Timestamp('2020-08-13 00:00:00'),
  55: Timestamp('2020-08-14 00:00:00'),
  56: Timestamp('2020-08-15 00:00:00'),
  57: Timestamp('2020-08-16 00:00:00'),
  58: Timestamp('2020-08-17 00:00:00'),
  59: Timestamp('2020-08-18 00:00:00'),
  60: Timestamp('2020-08-19 00:00:00'),
  61: Timestamp('2020-12-12 00:00:00'),
  62: Timestamp('2020-12-13 00:00:00'),
  63: Timestamp('2020-12-14 00:00:00'),
  64: Timestamp('2020-12-15 00:00:00'),
  65: Timestamp('2020-12-16 00:00:00'),
  66: Timestamp('2020-12-17 00:00:00'),
  67: Timestamp('2020-12-18 00:00:00'),
  68: Timestamp('2020-12-19 00:00:00'),
  69: Timestamp('2020-12-20 00:00:00'),
  70: Timestamp('2020-12-21 00:00:00'),
  71: Timestamp('2020-12-22 00:00:00'),
  72: Timestamp('2020-12-23 00:00:00'),
  73: Timestamp('2020-12-24 00:00:00'),
  74: Timestamp('2020-12-25 00:00:00'),
  75: Timestamp('2020-12-26 00:00:00'),
  76: Timestamp('2020-12-27 00:00:00'),
  77: Timestamp('2020-12-28 00:00:00'),
  78: Timestamp('2020-12-29 00:00:00'),
  79: Timestamp('2020-12-30 00:00:00'),
  80: Timestamp('2020-12-31 00:00:00')}}

关于python - 正确重新采样开始和结束员工假期表，我们在Stack Overflow上找到一个类似的问题： https://stackoverflow.com/questions/62178394/

文章推荐： delphi - 开发通过ADO与Oracle服务器通信的Windows服务的准则

workday-api - 如何获取 Workday 员工/员工 Web 个人资料 URL？
我希望通过 Workday API 检索 Workday 工作人员(又名员工)Web 配置文件 URL。用例是我正在构建一个聊天机器人来检索用户信息，并且我希望能够深度链接到工作人员(员工)网络配置文
sql - 员工 ID 自动生成带前缀
我很困惑我希望员工 ID 是自动生成的前缀格式我知道在 sql server 中触发之前是可能的我正在关注帖子 http://www.aspdotnet-suresh.com/2012/04/set-
c - 结构员工 {} 比较结构 {} 员工
我读了一个教程，其中有这个结构: struct { char Name[25]; int Age; float SkillRating; } Employee; defines
mysql - MySQL中如何确定缺席者(员工)列表和在场人员列表以及主员工列表？
我有两个表 employee(name,id) ，其中包含所有员工和另一个表 reader(id,date) ，它给出了日期和哪个员工在场。我如何找到一定范围内的缺席者列表日期？对于特定日期，我能够
c# - 员工 ID 的标准正则表达式
我需要员工 ID 的标准正则表达式，例如 EMP015 015EMP EMP_015 E_015 EMP-015 EMP.VIS EMP/056 基本上它应该允许 . 或 _ 或 - 或 / 在字母数
javascript - 类(class)员工
我是 Angular 的新手，正在使用 Angular 编写代码，我正在观看视频教程。我注意到我的代码中有一些东西，但我无法理解它是如何工作的。我想知道这段代码是什么意思组件上的“员工:员工 []”
一个员工的离职成本有多高，很恐怖，员工、管理者、老板都要慎重
下面从HR角度，来分析员工离职成本，欢迎大家留言讨论。一个员工离职后留下的坑，并不是再找一个人填上就万事大吉了。一般来说，核心人才的流失，至少有1-2个月的招聘期、3个月的适应期，6个月的融入期；
SQL 查询以获取主管层次结构的列表。员工 --> 主管 --> 主管
我有两个表 Employee 和 Department 此图像显示每个员工的经理。我想编写一个 SQL 查询，为我提供所有主管(经理、经理的经理......)的列表。我只想要一个列，在给定特定员工时
database - 将三元关系映射到关系模型(员工、客户、项目)
我想将 ER 图的这一部分转换为关系模型。我们有一个三元关系，它说的是以下内容: 1 位客户将 1 个项目提供给 -> 多个开发人员 1 位客户分配给 1 位开发人员 -> 多个项目 1 个开发人员被
c++ - Axis2C 非官方 vs. Axis2C 员工
我将要开发一个应用程序，该应用程序将使用一些基于 SOAP 的 Web 服务框架。我做了一些研究，我有点喜欢 Axis2C 框架，但在某些主题中，我发现原来的 Axis2C 实现存在内存泄漏问题，并且
php - 公司 vs 员工 ID 困境
我的 SQL 数据库中有两个表: 公司: ID(自增) 姓名地址 ... 员工: ID(自增) 公司编号 internal_id 姓名姓氏问题是我想要一个与他们所属的公司相关的员工 ID (in
c++ - 类(class)(员工)存放在哪个内存段(代码/数据段)？
我试图在堆栈溢出和谷歌上找到这个问题的答案，但没有找到。如果有问题需要更正或重复问题，请告诉我。当我计算员工对象 (emp_obj) 和员工类的大小时，在这两种情况下我都得到了 4 个字节。但是我不
javascript - 如何在 Angular 员工 component.html 上返回 EmployeeCode？
问题如何在 Angular 员工 component.html 上返回 EmployeeCode ？示例数据引用表 Code tableName FieldName LabelText
java - org.hibernate.MappingException : java. lang.ClassNotFoundException:员工
我是 hibernate 新手，正在使用 hibernate 版本 4.3.4 JAR 文件。我正在尝试使用 intelliJ 社区版中的 mySQL 服务器执行简单的 Hibernate 程序。以下
javascript - Yajra 员工 :140 Uncaught TypeError: $(. ..).DataTable 不是函数
我正在使用 laravel 5.4 和 Yajra Datatable，但我无法使其工作..我遇到了“Uncaught TypeError: $(...).DataTable is not a fun
android - 三星 Nexus Prime 和读取 RFID 员工 ID
我想创建一个小型示例应用程序，它可以读取我的员工徽章并将其显示在屏幕上(或者如果我可以复制它就更好了，这样我们就可以使用我们的手机徽章而不是我们的塑料身份证) 几个问题1. 这在技术上可行吗？如果是这
silverlight - 在 Silverlight 中将对象(即任何对象，如人、员工)转换为 byte[]
我有一个 person 对象，需要将它存储为 byte[] 并再次检索该 byte[] 并转换为 person 对象并且 BinaryFormatter 在 Silverlight 中不可用最佳答
sql - SELECT * FROM Employees WHERE NULL IS NULL; SELECT * FROM 员工 WHERE NULL = NULL;
最近开始学习oracle和sql。在学习的过程中，我遇到了几个问题，我的 friend 在接受采访时被问到这些问题。 SELECT * FROM Employees WHERE NULL IS N
mysql - 执行 : mysqlfabric sharding add_table 1 employees. 员工 emp_no 时出错
当我执行以下命令来创建分片时: mysqlfabric sharding add_table 1 employees.employees emp_no 我收到以下错误: DatabaseError:
php - 使用 JOIN 的 Mysql 查询(LINK 票证、员工、猫、评论)
这是我的表格门票 tic_id, tic_cat tic_priority tic_cus tic_date tic_title tic_

行者123

个人简介

我是一名优秀的程序员,十分优秀！

作者热门文章

滴滴打车优惠券免费领取

全站热门文章

首页

博学

6Ren·AI

商城

python - 正确重新采样开始和结束员工假期表