How convert an int64 to minutes ? Python Pandas

Question

I would like to transform this column (format int64) to a minutes format to do calculation

Duration(min)
10
30
5
15
5

I tried this:

df['Duration(min)'] = pd.to_datetime(df['Duration(min)'], format='%H%M')

But I have ValueError: time data '5' does not match format '%H%M' (match)

These values are very small to create datetime. There should be at least 2 digits — Mehdi Golzadeh
– Mehdi Golzadeh, Commented Oct 31, 2020 at 18:36
Can you detail your use case a little more? Why do you need a date format? — JAV
– JAV, Commented Oct 31, 2020 at 18:38

Ch3steR · Accepted Answer · 2020-10-31 18:37:54Z

3

You need to use pd.to_timedelta here.

pd.to_timedelta(df['Duration(min)'], unit='min')

0   0 days 00:10:00
1   0 days 00:30:00
2   0 days 00:05:00
3   0 days 00:15:00
4   0 days 00:05:00
Name: Duration(min), dtype: timedelta64[ns]

unit -> ‘m’ / ‘minute’ / ‘min’ / ‘minutes’ / ‘T’ all are shorthand for minutes.

answered Oct 31, 2020 at 18:37

Ch3steR

20.8k4 gold badges34 silver badges66 bronze badges

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

Comments

Shradha · Accepted Answer · 2020-10-31 18:42:01Z

3

Using pd.to_datetime with strftime -

pd.to_datetime(df.Duration(min), unit='m').dt.strftime('%H:%M')

Output-

0    00:10
1    00:30
2    00:05
3    00:15
4    00:05
dtype: object

answered Oct 31, 2020 at 18:42

Shradha

2,4721 gold badge16 silver badges27 bronze badges

Comments

Mike Elkins · Accepted Answer · 2020-10-31 18:38:56Z

0

Why %H%M when all you have is minutes? Try format='%M'.

answered Oct 31, 2020 at 18:38

Mike Elkins

1,4381 gold badge11 silver badges13 bronze badges

Collectives™ on Stack Overflow

How convert an int64 to minutes ? Python Pandas

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related