replace multispaces into a single space from a series in a dataframe and return it back to the series

Question

I have multi-column dataframe of Flickr tags with 41,000 rows. I want to remove multiple white spaces element in a column, leaving the other columns intact.

so, this is how my column looks like:

column1                            column2                                              column3
<a href="www.asia.com>Breda</a>    result    thisIs    Somany     multiplespace   s     25,000

and this is how I want my column2 looks like after I remove multiple white spaces in it:

column1                            column2                                 column3
<a href="www.asia.com>Breda</a>    result thisIs Somany multiplespace s    25,000

PV8 · Accepted Answer · 2020-01-16T14:27:19.187

0

df['column2'] = df['column2'].replace('\s+', ' ', regex=True)

will do your job, s\+ stands for more then one whitspace.

You can use this question to get another idea of it how it works, the command replace works with it.

edited Jan 16 '20 at 14:27

answered Jan 16 '20 at 14:20

PV8

5,799
7
43
87

it works. thanks. but I also found another way. thanks by the way @PV8 – Jack Zaki Zakiul Fahmi Jailani Jan 16 '20 at 15:31
1

works like a charm in only some seconds for 41,000 rows compare to for loops. thanks @PV8 – Jack Zaki Zakiul Fahmi Jailani Jan 21 '20 at 13:05

score 0 · Answer 2 · answered Jan 16 '20 at 15:32

0

it also works using function like this code below. it is a good functino to use to different columns.

 def replaceWhiteSpace(text):
    res = []
    for i in text:
        res = text.str.split()
    res = res.str.join(' ')
    return res

df['column2'] = replaceWhiteSpace(df['column2'])

answered Jan 16 '20 at 15:32

Jack Zaki Zakiul Fahmi Jailani

309
2
15

to be honest this is a `loop`solution, you should avoid that! a vectorized approach is better (python preferred solotion) :) but good one also – PV8 Jan 17 '20 at 07:19
what do you mean by a vectorized approach? is it like your answer? – Jack Zaki Zakiul Fahmi Jailani Jan 17 '20 at 07:58
excally, the moment you don't see a `for`, `while` it is vectorized most of the time – PV8 Jan 17 '20 at 08:00

replace multispaces into a single space from a series in a dataframe and return it back to the series

2 Answers2