How to create a formatted array from the timestamp column in a pandas dataframe

Question

I have the following pandas dataframe called df_time_series

Now I would like to create a formatted array from the pandas dataframe column timestamp sucht that this additional array contains only the corresponding hours of the day. This means that e.g for the four columns with timestamp [00:00:00, 00:15:00, 00:30:00, 00:45:00] a 0 should be in this additinal array. For all columns with timestamp [01:00:00, 01:15:00, 01:30:00, 01:45:00] a 1 should be in this additional array and so on.

I tried the following suggestion from here Pandas timestamp on array

import pandas as pd

timeDataArray = pd.to_datetime(df_time_series, unit='h').values

But this yields an error "ValueError: to assemble mappings requires at least that [year, month, day] be specified: [day,month,year] is missing". Any suggestions why this error occurs and what to do to create this formatted additional array?

jezrael · Accepted Answer · 2022-07-19 10:26:09Z

1

IIUC get hours from DatetimeIndex by DatetimeIndex.hour:

timeDataArray = pd.to_datetime(df_time_series.index).hour.to_numpy()

edited Jul 19, 2022 at 10:26

answered Jul 19, 2022 at 9:32

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

vkh · Accepted Answer · 2022-07-19 10:10:33Z

0

df['date_col'].dt.strftime('%H:%M:%S')

See Pandas docs for details.

answered Jul 19, 2022 at 10:10

vkh

11 silver badge1 bronze badge

Collectives™ on Stack Overflow

How to create a formatted array from the timestamp column in a pandas dataframe

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related