Extract value from Series

Question

I want to add

I get all values from column:

from collections import Counter
coun_ = set(train_df['time1'].dt.hour)

Then I add new columns to data frame and fill there default values:

for i in coun_:
    train_df['hour'+str(i)] = 0

Now I want to get hour from time1 and set 1 to right column. Forexample, if time1 equals 10 then I put 1 to hour10. I do several ways without success, one of them.

for hour in [train_df]:
    hour['hour' + hour['time1'].dt.hour.to_string()] = 1

The question is how I can extract only value from Series and concat it?

Can you add some data sample, 3 4 values of `train_df['time1']` and expected output? — jezrael, Apr 21 '20 at 06:03
@jezrael `train_df['time1'][:3]` returns session_id 1 2014-02-20 10:02:45 2 2014-02-22 11:19:50 3 2013-12-16 16:40:17 — rnd, Apr 21 '20 at 06:11
Thank you, so my solution working? Or what is expected output? — jezrael, Apr 21 '20 at 06:15
Sorry, could you explain how can I write this values in data frame? — rnd, Apr 21 '20 at 06:18
I ask because first rule in pandas is [dont loop](https://stackoverflow.com/a/55557758/2901002) — jezrael, Apr 21 '20 at 06:20

jezrael · Accepted Answer · 2020-04-21T06:34:59.923

1

Use get_dummies with DataFrame.add_prefix adn append to original by DataFrame.join:

df = df.join(pd.get_dummies(train_df['time1'].dt.hour).add_prefix('hour'))

edited Apr 21 '20 at 06:34

answered Apr 21 '20 at 06:01

jezrael

822,522
95
1,334
1,252

I do this `one_hot = pd.get_dummies(train_df['time1'].dt.hour) train_df = train_df.join(one_hot)` Maybe you know to set custom names for new columns? – rnd Apr 21 '20 at 06:32

Extract value from Series

1 Answers1