Python:Pandas - Object to string type conversion in dataframe

Question

I'm trying to convert object to string in my dataframe using pandas. Having following data:

particulars
NWCLG 545627 ASDASD KJKJKJ ASDASD
TGS/ASDWWR42045645010009 2897/SDFSDFGHGWEWER
dtype:object

while trying to convert particulars column from object to string using astype()[with str, |S, |S32, |S80] types, or directly using str functions it is not converting in string (remain object) and for str methods[replacing '/' with ' '] it says AttributeError: 'DataFrame' object has no attribute 'str'

using pandas 0.23.4

Also refereed: https://github.com/pandas-dev/pandas/issues/18796

Can you show us a sample of the raw data and the command you're using to convert it to a pandas dataframe? — ParvBanks
– ParvBanks, Commented Jan 1, 2019 at 10:53
@ParvBanks Actually I'm reading that data from excel sheet but can't put sample here as it's confidential — Arjun Mota
– Arjun Mota, Commented Jan 2, 2019 at 6:47
Possible duplicate of How to convert column with dtype as object to string in Pandas Dataframe — eliasah
– eliasah, Commented May 28, 2019 at 8:21

krasnapolsky · Accepted Answer · 2022-11-02 01:17:46Z

5

Use astype('string') instead of astype(str) :

df['column'] = df['column'].astype('string')

edited Nov 2, 2022 at 1:17

krasnapolsky

3571 silver badge17 bronze badges

answered Apr 28, 2022 at 18:59

darrahts

4134 silver badges11 bronze badges

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

Comments

ParvBanks · Accepted Answer · 2019-01-02 06:59:58Z

1

You could read the excel specifying the dtype as str:

df = pd.read_excel("Excelfile.xlsx", dtype=str)

then use string replace in particulars column as below:

df['particulars'] = df[df['particulars'].str.replace('/','')]

Notice that the df assignment is also a dataframe in '[]' brackets.

When you're using the below command in your program, it returns a string which you're trying to assign to a dataframe column. Hence the error.

df['particulars'] = df['particulars'].str.replace('/',' ')

answered Jan 2, 2019 at 6:59

ParvBanks

1,4361 gold badge14 silver badges15 bronze badges

1 Comment

Arjun Mota Over a year ago

No luck still getting AttributeError: 'DataFrame' object has no attribute 'str'

Collectives™ on Stack Overflow

Python:Pandas - Object to string type conversion in dataframe

2 Answers 2

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related