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, Jan 01 '19 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, Jan 02 '19 at 06:47
Possible duplicate of [How to convert column with dtype as object to string in Pandas Dataframe](https://stackoverflow.com/questions/33957720/how-to-convert-column-with-dtype-as-object-to-string-in-pandas-dataframe) — eliasah, May 28 '19 at 08:21

score 3 · Answer 1 · edited Nov 02 '22 at 01:17

3

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

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

edited Nov 02 '22 at 01:17

krasnapolsky

347
1
16

answered Apr 28 '22 at 18:59

darrahts

365
1
10

score 1 · Answer 2 · answered Jan 02 '19 at 06:59

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('/',' ')

No luck still getting AttributeError: 'DataFrame' object has no attribute 'str' — Arjun Mota, Jan 03 '19 at 12:51

Python:Pandas - Object to string type conversion in dataframe

2 Answers2