Why does pandas DataFrame convert integer to object like this?

Question

I am using value_counts() to get the frequency for sec_id. The output of value_counts() should be integers.

When I build DataFrame with these integers, I found those columns are object dtype. Does anyone know the reason?

Did you check the type of df_pos_0219['sec_id']?

Sheldon
– Sheldon

2021-11-12 02:10:22 +00:00
Commented Nov 12, 2021 at 2:10 — Sheldon
– Sheldon, Commented Nov 12, 2021 at 2:10

Andrew Eckart · Accepted Answer · 2021-11-12 02:11:08Z

3

They are the object dtype because your sec_id column contains string values (e.g. "94114G"). When you call .values on the dataframe created by .reset_index(), you get two arrays which both contain string objects.

More importantly, I think you are doing some unnecessary work. Try this:

>>> sec_count_df = df['sec_id'].value_counts().rename_axis("sec_id").rename("count").reset_index()

answered Nov 12, 2021 at 2:11

Andrew Eckart

1,72612 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Why does pandas DataFrame convert integer to object like this?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related