Using regular expression in pandas to select before a certain divider \r\

Question

Hi I'm trying to without succeed to use regular expression to select he string before the \r\ , ideally in majority of the times is a word follow by a coma. But as showed the \r\ and some other obstacles appear .Example below:

    var
Sao Paulo , Brazil \r\n Details Description ....
Rio de Janeiro , Brazil  ... Pending funding.  

  (result)expected
Sao Paulo , Brasil

This is the code I have so far : df['result'] = df['var'].str.extract('/^(.*?)\\r /', expand=True) I get all NaN as a result — Ian_De_Oliveira, Feb 26 '18 at 03:51

YOLO · Answer 1 · 2018-02-26T11:04:08.570

0

How about this ?

# using string function .find()
    a = 'Sao Paulo , Brazil \r\n Details Description ....'
    a[0:a.find('\r')].strip()

   'Sao Paulo , Brazil'

Edit:< br />

Let's say your data frame is df. The name of your column is 'text'. We'll create a new column say 'new_text'. Now, do the following:

library(data.table)
setDT(df) # just in case it's not a data.table
df[,new_text := text[0:text.find('\r')].strip()]

edited Feb 26 '18 at 11:04

answered Feb 26 '18 at 02:55

YOLO

20,181
5
20
40

Hi and tks for such a quick reply. How I would apply to a data set containing 1 million rows? @Manish Saraswat – Ian_De_Oliveira Feb 26 '18 at 03:33
Just added that in the answer. – YOLO Feb 26 '18 at 11:04

score 0 · Answer 2 · answered Feb 26 '18 at 13:15

0

You can use either

df["var"].str.extract("(.*)\\\\r")

or

df["var"].str.extract(r"(.*)\\r")

Notice the r before quotation mark. You can read more at Python regex - r prefix

answered Feb 26 '18 at 13:15

Tai

7,684
3
29
49

Using regular expression in pandas to select before a certain divider \r\

2 Answers2