import
pandas as pd
import
numpy as np
dataset
=
{
'Group'
: [
'G-2'
,
'G-3'
,
'G-3'
,
'G-2'
,
'G-2'
,
'G-2'
,
'G-3'
,
'G-1'
,
'G-1'
,
'G-2'
],
'Date'
: [
'2019-11-04'
,
'2020-05-17'
,
'2020-12-12'
,
'2019-10-15'
,
'2019-01-31'
,
'2019-02-13'
,
'2020-12-25'
,
'2018-06-01'
,
'2018-07-15'
,
'2019-09-14'
]}
dataset
=
pd.DataFrame(dataset, columns
=
[
'Group'
,
'Date'
])
df
=
dataset.groupby([
'Group'
])
df2
=
df.agg(Minimum_Date
=
(
'Date'
, np.
min
), Maximum_Date
=
(
'Date'
, np.
max
))
display(df2)