Object Type not convertable in string Python

Question

I have a column with text which is stored as a object tpye in a pandas dataframe. The following two codes to not work. The required column is still object type.

TD_Eco_Comb_c['CountryPair'] = TD_Eco_Comb_c['CountryPair'].astype('|S')
TD_Eco_Comb_c['CountryPair'] = TD_Eco_Comb_c['CountryPair'].astype('str')

Any advice?

With the imminent release of 1.0, there will be a dedicated str type: pandas.pydata.org/pandas-docs/version/1.0.0/whatsnew/… — ALollz
– ALollz, Commented Jan 27, 2020 at 16:51

wpercy · Accepted Answer · 2020-01-27 16:42:16Z

1

A string is always going to have dtype == 'object' in a dataframe.

This comes from numpy, which uses purely numerical dtypes. Everything that isn't numerical is classified as an 'object'. Your data is already in the format you need it to be in.

answered Jan 27, 2020 at 16:42

wpercy

10.2k4 gold badges35 silver badges50 bronze badges

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

3 Comments

ShuFFle2207 Over a year ago

Thank you. How is it possible to show this than in a heatmap or visualize it. The problem is I can not plot it.

ShuFFle2207 Over a year ago

ufunc 'isnan' not supported for the input types, and the inputs could not be safely coerced to any supported types according to the casting rule ''safe''

wpercy Over a year ago

I don't think I understand your questions, but they seem like they're better suited for an entirely new question rather than trying to expand on this one, which was "why can't I convert this to a string?"

Collectives™ on Stack Overflow

Object Type not convertable in string Python

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related