regex replace using function python

Question

I'm trying to print a table of my database using :

pd.read_sql_query("SELECT name,duration FROM activity where (strftime('%W', date) = strftime('%W', 'now'))", conn))

and it work it prints :

                   name  duration
 0        programmation       150
 1              lecture        40
 2                  ctf        90
 3                  ceh        90
 4        deep learning       133
 5  vm capture the flag       100

but I would like to use my function minuteToStr who translate the duration to string likes "1h30" on the duraton colowns. I tried this code but it does'nt work :

tableau = str(pd.read_sql_query("SELECT name,duration FROM activity\
                 where (strftime('%W', date) = strftime('%W', 'now'))", conn))  
tableau = re.sub("([0-9]{2,})",   minuteToStr(int("\\1")), tableau)
print(tableau)

Thanks

Can you add your function?

jezrael
– jezrael

2017-11-05 08:44:49 +00:00
Commented Nov 5, 2017 at 8:44 — jezrael
– jezrael, Commented Nov 5, 2017 at 8:44

cs95 · Accepted Answer · 2017-11-05 08:45:57Z

3

Make this easy, just use a little mathemagic and string formatting.

h = df.duration // 60
m = df.duration % 60

df['duration'] = h.astype(str) + 'h' + m.astype(str) + 'm'
df

                  name duration
0        programmation    2h30m
1              lecture    0h40m
2                  ctf    1h30m
3                  ceh    1h30m
4        deep learning    2h13m
5  vm capture the flag    1h40m

answered Nov 5, 2017 at 8:45

cs95

406k106 gold badges745 silver badges798 bronze badges

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

4 Comments

Bharath M Shetty Over a year ago

This is certainly the easiest way of doing it.

cs95 Over a year ago

@Bharath Passed you an upvote too, and the answer you linked ;-)

Bharath M Shetty Over a year ago

Thank you.My solution might help future users who has duration like 120 mins or so.

cs95 Over a year ago

@Neolex Just letting you know that apply is much slower.

DeepSpace · Accepted Answer · 2017-11-05 08:44:32Z

2

re.sub doesn't work this way. It expects a string, not a DataFrame.

Given that minuteToStr accepts an integer, you can simply use apply:

tableau['duration'] = tableau['duration'].apply(minuteToStr)

answered Nov 5, 2017 at 8:44

DeepSpace

82.2k12 gold badges119 silver badges166 bronze badges

1 Comment

Neolex Over a year ago

Thanks for the help :) I'll use this solution .

Bharath M Shetty · Accepted Answer · 2017-11-05 09:12:51Z

2

Similar to using a function inside re.sub in pandas we can use str.replace . Similar type is used here i.e

If duration column is of integer type then

tableau['duration'].astype(str).str.replace("([0-9]{2,})", minuteToStr)

Else:

tableau['duration'].str.replace("([0-9]{2,})", minuteToStr)

To illustrate using function inside replace (I prefer you go with @colspeed's solution)

def minuteToStr(x):
    h = int(x.group(1)) // 60
    m = int(x.group(1)) % 60
    return str(h) + 'h' + str(m)


df['duration'].astype(str).str.replace("([0-9]{2,})",minuteToStr)

            name duration
0     programmation     2h30
1           lecture     0h40
2               ctf     1h30
3               ceh     1h30
4      deeplearning     2h13
5  vmcapturetheflag     1h40

edited Nov 5, 2017 at 9:12

answered Nov 5, 2017 at 8:56

Bharath M Shetty

30.6k6 gold badges65 silver badges111 bronze badges

3 Comments

Neolex Over a year ago

Thank's for your help, but it doesnt work ... I got : ` name duration 0 programmation NaN 1 lecture NaN 2 ctf NaN 3 ceh NaN 4 deep learning NaN 5 vm capture the flag NaN 6 programmation NaN `

Bharath M Shetty Over a year ago

Its better you provide the function minuteToStr in the question.

Bharath M Shetty Over a year ago

@Neolex check the update this is how you should use function inside replace. Hope it helps.

Collectives™ on Stack Overflow

regex replace using function python

3 Answers 3

4 Comments

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related