Regex on Dataframe Values

Question

def Clean_Data(df):
   df.replace({ r'\A\s+|\s+\Z': '', '\n' : ' ', '\w\s+\w|\w\n\w': '\w\s\w'}, regex=True, inplace=True)
   return df

I would like to clean my dataframe before I work on it. I need to get rid of:

double whitespace

whitespace + linebreak

-> and replace it with a single whitespace.

As well I want to check if there is more than one whitespace between two words (letters or numbers) and reduce it to a single whitespace.

And at least Check if there ae whitespaces between words and signs (, or .) and replace with ''.

But I have literally no idea of regex and getting already an error for bad escape \w

Srikar Manthatti · Accepted Answer · 2020-02-25 12:14:27Z

4

Try this df.replace({' +':' ', '\n':' ','->':' '}, regex=True, inplace=True)

First one checks for more than one whitespaces and replaces with only one whitespace.
Second one checks for new line and replaces with white space
Third is the pattern -> and replaces with white space

answered Feb 25, 2020 at 12:14

Srikar Manthatti

5042 silver badges16 bronze badges

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

Collectives™ on Stack Overflow

Regex on Dataframe Values

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