如何在Python数据框架中同时将行分组

Question

我正在研究包含时间列(HH：MM：SS.ZZZ(的数据框'。

Answer 1

而无需发布您的 DataFrame，您的问题很难回答，但是这可能是您所追求的：

import pandas as pd
import re
df = pd.DataFrame([['ID1','01:22:52.134'],['ID2','03:21:31.123'],['ID3','21:12:52.544'],['ID4','23:12:31.216'],['ID5','10:22:02.134'],['ID6','06:52:46.184']], columns=["ID's",'Time'])
pattern = re.compile(r':(d{2}).')
dfout = df["ID's"].groupby(df['Time'].str.extract(pattern, expand=False))
for name, group in dfout:
    print('Group Name: ' + name)
    print(group)

屈服：

Group Name: 02
4    ID5
Name: ID's, dtype: object
Group Name: 31
1    ID2
3    ID4
Name: ID's, dtype: object
Group Name: 46
5    ID6
Name: ID's, dtype: object
Group Name: 52
0    ID1
2    ID3
Name: ID's, dtype: object