Changing the Pandas DataFrame structure in Python

Question

I have the dataframe in Python that looks like below:

BatchID | EventTime

Test1   | 2020-03-10 10:22:21

Test1   | 2020-03-10 10:22:27

Test1   | 2020-03-10 10:22:31

Test2   | 2020-03-10 10:36:00

Test2   | 2020-03-10 10:36:02

Test2   | 2020-03-10 10:36:04

I want to restructure it such that it looks like as shown below:

BatchID --> Batch Start --> Batch End

Test1  --> 2020-03-10 10:22:21 --> 2020-03-10 10:22:31
Test2  --> 2020-03-10 10:36:00 --> 2020-03-10 10:36:04

Where for every unique Batch ID, I want to pick the start time and end time and frame it into one row.

Erfan · Accepted Answer · 2020-11-18 01:51:51Z

1

Use groupby with agg and min, max:

df.groupby('BatchID')['EventTime'].agg(['min', 'max']).reset_index()

  BatchID                 min                 max
0   Test1 2020-03-10 10:22:21 2020-03-10 10:22:31
1   Test2 2020-03-10 10:36:00 2020-03-10 10:36:04

answered Nov 18, 2020 at 1:51

Erfan

43.4k10 gold badges75 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Changing the Pandas DataFrame structure in Python

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related