(
df
.assign(date_time=lambda x: pd.to_datetime(x['date_time']))
.assign(rank=lambda x:x
.groupby('file_name', as_index=False)['date_time']
.rank(method='first', ascending=False)
)
.loc[lambda x: x['rank'] == 1]
.assign(order=lambda x:x
.apply(
lambda x:
{
'table' : 0,
'view' : 1,
'trigger' : 2,
'func' : 3,
'proc' : 4
}.get(x['file_name'].split('_')[0], 10)
, axis=1
)
)
.sort_values(['order', 'file_name'], ascending=[True, True])
.reset_index(drop=True)
.drop(columns=['rank','order'])
)
perl -ne '!m/border|max-width|\{|\}/&&~s|(\d+)px|$1/10 ."rem"|ge;print' < some.css
for i in range(30):
cap.read()