如何使用xlrd分隔excel表格中的唯一名称
如何使用xlrd分隔excel表格中的唯一名称
提问于 2015-08-21 10:45:23
Engineer DC Competency Date Effort
Engineer-1 Center-1 Electronics 17-Aug-15 6
Engineer-2 Center-1 Software 13-Aug-15 5
Engineer-3 Center-1 Mechanical 17-Aug-15 6
Engineer-4 Center-1 Testing 17-Aug-15 7
Engineer-5 Center-1 Firmware 17-Aug-15 5
Engineer-4 Center-2 Testing 18-Aug-15 6
Engineer-5 Center-2 Firmware 13-Aug-15 7
Engineer-2 Center-3 Software 18-Aug-15 7
Engineer-3 Center-3 Mechanical 19-Aug-15 6
Engineer-4 Center-3 Testing 19-Aug-15 5
Engineer-2 Center-4 Software 13-Aug-15 4
Engineer-3 Center-4 Mechanical 20-Aug-15 7
Engineer-4 Center-4 Testing 20-Aug-15 6
Engineer-1 Center-5 Electronics 20-Aug-15 5这是excel表格中的数据，如何区分唯一的工程师姓名以及每个工程师的工作量和每个工程师的总工作量
expected output like this-------
total effort(effort of each engineer in current week)
Engineer-1 11
Engineer-2 16
Engineer-3 18
Engineer-4 18
Engineer-5 12 我应该使用python代码使用xlrd编写代码，在这里，工程师1在哪里，工程师2在哪里，应该像这样为每个工程师分开，他们的努力是我们在第34周花费的总小时数。
回答 1
Stack Overflow用户
发布于 2015-08-21 10:59:16
您可以像这样使用excel数据透视表。Link
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/32131585
复制相关文章
相似问题
腾讯云开发者
