文档建议反馈控制台
首页
学习
活动
专区
圈层
工具
MCP广场
文章/答案/技术大牛
发布
社区首页 >问答首页 >如何使用熊猫在两个值之间选择行范围？

问如何使用熊猫在两个值之间选择行范围？
EN

Stack Overflow用户
提问于 2016-11-10 21:28:08
回答 1查看 224关注 0票数 0

我想在底部切片样本数据..。

因此，每个会话(从登录到下一次登录前的操作)如下所示：

代码语言：javascript
复制
login,4,2016-11-10 05:28:30.396,hbhimani,11/10/2016
getUserPreferences,179,2016-11-10 05:28:30.575,hbhimani,11/10/2016
getPreference,3,2016-11-10 05:28:55.686,hbhimani,11/10/2016
getPreference,4,2016-11-10 05:28:55.961,hbhimani,11/10/2016
constructFromSession,4,2016-11-10 05:28:56.108,hbhimani,11/10/2016
getUserPreferences,4,2016-11-10 05:28:56.112,hbhimani,11/10/2016
getUserPreferences,3,2016-11-10 05:28:56.116,hbhimani,11/10/2016
setBooleanPreference,4,2016-11-10 05:28:56.238,hbhimani,11/10/2016
setBooleanPreference,4,2016-11-10 05:28:56.513,hbhimani,11/10/2016
getQuickSearchInitInfo,3,2016-11-10 05:28:58.936,hbhimani,11/10/2016
getQuickSearchInitInfo2,4,2016-11-10 05:28:59.315,hbhimani,11/10/2016

我想数一下记录的数量和getPreference动作的发生情况。将显示为如下所示的记录：

代码语言：javascript
复制
day,User,session_duration(min),getPreference_count,total_session_actions
11/10/2016,hbhimani, 180, 2, 11

我的挑战发生在我有不止一次会议的时候。我不知道如何对索引进行动态切片。

样本数据：

代码语言：javascript
复制
Action,Duration,_time,User,day
login,4,2016-11-10 05:28:30.396,hbhimani,11/10/2016
getUserPreferences,179,2016-11-10 05:28:30.575,hbhimani,11/10/2016
getPreference,3,2016-11-10 05:28:55.686,hbhimani,11/10/2016
getPreference,4,2016-11-10 05:28:55.961,hbhimani,11/10/2016
constructFromSession,4,2016-11-10 05:28:56.108,hbhimani,11/10/2016
getUserPreferences,4,2016-11-10 05:28:56.112,hbhimani,11/10/2016
getUserPreferences,3,2016-11-10 05:28:56.116,hbhimani,11/10/2016
setBooleanPreference,4,2016-11-10 05:28:56.238,hbhimani,11/10/2016
setBooleanPreference,4,2016-11-10 05:28:56.513,hbhimani,11/10/2016
getQuickSearchInitInfo,3,2016-11-10 05:28:58.936,hbhimani,11/10/2016
getQuickSearchInitInfo2,4,2016-11-10 05:28:59.315,hbhimani,11/10/2016
login,3,2016-11-10 05:29:29.202,hbhimani,11/10/2016
getSummary,4042,2016-11-10 05:29:33.246,hbhimani,11/10/2016
getEnclosures,457,2016-11-10 05:29:34.372,hbhimani,11/10/2016
getAuditTrail,1061,2016-11-10 05:29:36.034,hbhimani,11/10/2016
getRelatedDefects,5,2016-11-10 05:29:36.586,hbhimani,11/10/2016
getServiceRequests,5,2016-11-10 05:29:36.864,hbhimani,11/10/2016
getForeignBugs,270,2016-11-10 05:29:37.408,hbhimani,11/10/2016
getEnclosures,455,2016-11-10 05:29:50.087,hbhimani,11/10/2016
getSummary,5505,2016-11-10 05:32:26.584,hbhimani,11/10/2016
getEnclosures,459,2016-11-10 05:32:27.940,hbhimani,11/10/2016
login,997,2016-11-10 05:32:29.480,anshanno,11/10/2016
getRelatedDefects,5,2016-11-10 05:32:30.027,anshanno,11/10/2016
getServiceRequests,5,2016-11-10 05:32:30.306,anshanno,11/10/2016
getForeignBugs,6,2016-11-10 05:32:30.585,anshanno,11/10/2016
group-by
python
pandas
dataframe
EN

回答 1

Stack Overflow用户

回答已采纳

发布于 2016-11-11 12:27:50

你可以将你的数据分组如下：

原始DF：

代码语言：javascript
复制
In [62]: df
Out[62]:
                     Action  Duration                   _time      User        day
0                     login         4 2016-11-10 05:28:30.396  hbhimani 2016-11-10
1        getUserPreferences       179 2016-11-10 05:28:30.575  hbhimani 2016-11-10
2             getPreference         3 2016-11-10 05:28:55.686  hbhimani 2016-11-10
3             getPreference         4 2016-11-10 05:28:55.961  hbhimani 2016-11-10
4      constructFromSession         4 2016-11-10 05:28:56.108  hbhimani 2016-11-10
5        getUserPreferences         4 2016-11-10 05:28:56.112  hbhimani 2016-11-10
6        getUserPreferences         3 2016-11-10 05:28:56.116  hbhimani 2016-11-10
7      setBooleanPreference         4 2016-11-10 05:28:56.238  hbhimani 2016-11-10
8      setBooleanPreference         4 2016-11-10 05:28:56.513  hbhimani 2016-11-10
9    getQuickSearchInitInfo         3 2016-11-10 05:28:58.936  hbhimani 2016-11-10
10  getQuickSearchInitInfo2         4 2016-11-10 05:28:59.315  hbhimani 2016-11-10
11                    login         3 2016-11-10 05:29:29.202  hbhimani 2016-11-10
12               getSummary      4042 2016-11-10 05:29:33.246  hbhimani 2016-11-10
13            getEnclosures       457 2016-11-10 05:29:34.372  hbhimani 2016-11-10
14            getAuditTrail      1061 2016-11-10 05:29:36.034  hbhimani 2016-11-10
15        getRelatedDefects         5 2016-11-10 05:29:36.586  hbhimani 2016-11-10
16       getServiceRequests         5 2016-11-10 05:29:36.864  hbhimani 2016-11-10
17           getForeignBugs       270 2016-11-10 05:29:37.408  hbhimani 2016-11-10
18            getEnclosures       455 2016-11-10 05:29:50.087  hbhimani 2016-11-10
19               getSummary      5505 2016-11-10 05:32:26.584  hbhimani 2016-11-10
20            getEnclosures       459 2016-11-10 05:32:27.940  hbhimani 2016-11-10
21                    login       997 2016-11-10 05:32:29.480  anshanno 2016-11-10
22        getRelatedDefects         5 2016-11-10 05:32:30.027  anshanno 2016-11-10
23       getServiceRequests         5 2016-11-10 05:32:30.306  anshanno 2016-11-10
24           getForeignBugs         6 2016-11-10 05:32:30.585  anshanno 2016-11-10

分组：

代码语言：javascript
复制
In [63]: grp = df.groupby(['User', df.Action.eq('login').cumsum()])

打印所有组：

代码语言：javascript
复制
In [64]: for g, x in grp:
    ...:     print(x)
    ...:
                Action  Duration                   _time      User        day
21               login       997 2016-11-10 05:32:29.480  anshanno 2016-11-10
22   getRelatedDefects         5 2016-11-10 05:32:30.027  anshanno 2016-11-10
23  getServiceRequests         5 2016-11-10 05:32:30.306  anshanno 2016-11-10
24      getForeignBugs         6 2016-11-10 05:32:30.585  anshanno 2016-11-10
                     Action  Duration                   _time      User        day
0                     login         4 2016-11-10 05:28:30.396  hbhimani 2016-11-10
1        getUserPreferences       179 2016-11-10 05:28:30.575  hbhimani 2016-11-10
2             getPreference         3 2016-11-10 05:28:55.686  hbhimani 2016-11-10
3             getPreference         4 2016-11-10 05:28:55.961  hbhimani 2016-11-10
4      constructFromSession         4 2016-11-10 05:28:56.108  hbhimani 2016-11-10
5        getUserPreferences         4 2016-11-10 05:28:56.112  hbhimani 2016-11-10
6        getUserPreferences         3 2016-11-10 05:28:56.116  hbhimani 2016-11-10
7      setBooleanPreference         4 2016-11-10 05:28:56.238  hbhimani 2016-11-10
8      setBooleanPreference         4 2016-11-10 05:28:56.513  hbhimani 2016-11-10
9    getQuickSearchInitInfo         3 2016-11-10 05:28:58.936  hbhimani 2016-11-10
10  getQuickSearchInitInfo2         4 2016-11-10 05:28:59.315  hbhimani 2016-11-10
                Action  Duration                   _time      User        day
11               login         3 2016-11-10 05:29:29.202  hbhimani 2016-11-10
12          getSummary      4042 2016-11-10 05:29:33.246  hbhimani 2016-11-10
13       getEnclosures       457 2016-11-10 05:29:34.372  hbhimani 2016-11-10
14       getAuditTrail      1061 2016-11-10 05:29:36.034  hbhimani 2016-11-10
15   getRelatedDefects         5 2016-11-10 05:29:36.586  hbhimani 2016-11-10
16  getServiceRequests         5 2016-11-10 05:29:36.864  hbhimani 2016-11-10
17      getForeignBugs       270 2016-11-10 05:29:37.408  hbhimani 2016-11-10
18       getEnclosures       455 2016-11-10 05:29:50.087  hbhimani 2016-11-10
19          getSummary      5505 2016-11-10 05:32:26.584  hbhimani 2016-11-10
20       getEnclosures       459 2016-11-10 05:32:27.940  hbhimani 2016-11-10

解释：

代码语言：javascript
复制
In [71]: df['grp_id'] = df.Action.eq('login').cumsum()

In [72]: df[['Action','User','grp_id']]
Out[72]:
                     Action      User  grp_id
0                     login  hbhimani       1
1        getUserPreferences  hbhimani       1
2             getPreference  hbhimani       1
3             getPreference  hbhimani       1
4      constructFromSession  hbhimani       1
5        getUserPreferences  hbhimani       1
6        getUserPreferences  hbhimani       1
7      setBooleanPreference  hbhimani       1
8      setBooleanPreference  hbhimani       1
9    getQuickSearchInitInfo  hbhimani       1
10  getQuickSearchInitInfo2  hbhimani       1
11                    login  hbhimani       2
12               getSummary  hbhimani       2
13            getEnclosures  hbhimani       2
14            getAuditTrail  hbhimani       2
15        getRelatedDefects  hbhimani       2
16       getServiceRequests  hbhimani       2
17           getForeignBugs  hbhimani       2
18            getEnclosures  hbhimani       2
19               getSummary  hbhimani       2
20            getEnclosures  hbhimani       2
21                    login  anshanno       3
22        getRelatedDefects  anshanno       3
23       getServiceRequests  anshanno       3
24           getForeignBugs  anshanno       3
票数 2
EN
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：

https://stackoverflow.com/questions/40537308

复制
相关文章

相似问题

领券

腾讯云开发者

扫码关注腾讯云开发者

扫码关注腾讯云开发者

领取腾讯云代金券

热门产品

热门推荐

更多推荐

Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有 

深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 粤公网安备44030502008569号

腾讯云计算（北京）有限责任公司 京ICP证150476号 |  京ICP备11018762号

问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档