fork(1) download
copy 
  1. # your code goes here
  2. import pandas as pd 
  3. from dateutil import parser
  4. from datetime import date
  5. from datetime import datetime
  6. today = date.today()
  7. midnight = datetime.combine(today, datetime.min.time())
  8.  
  9.  
  10. df = pd.DataFrame([[1,'1h:2m'],[2,'1h:58m'],[3,'35m'],[4,'2h']],columns=['id','time'])
  11.  
  12.  
  13. df['time'] = df['time'].apply(lambda x: (parser.parse(x, fuzzy=True)) - midnight)
  14.  
  15. print(df)
  16. print(df['time'].mean())
Success #stdin #stdout 0.54s 60640KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
   id     time
0   1 01:02:00
1   2 01:58:00
2   3 00:35:00
3   4 02:00:00
0 days 01:23:45
https://ideone.com/Aze9mR
language:
Python 3 (python  3.12)
created:
4 years ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!