Replace cells in a dataframe with a range of values

Question

I have a large dataframe that has certain cells which have values like: <25-27>. Is there a simple way to convert these into something like:25|26|27 ?

Source data frame:

import pandas as pd
import numpy as np

f = {'function':['2','<25-27>','200'],'CP':['<31-33>','210','4001']}
filter = pd.DataFrame(data=f)
filter

Output Required

output = {'function':['2','25|26|27','200'],'CP':['31|32|33','210','4001']}
op = pd.DataFrame(data=output)
op

thanks a lot !

Tom Ron · Accepted Answer · 2020-05-22 08:34:18Z

2

import re
def convert_range(x):
    m = re.match("<([0-9]+)+\-([0-9]+)>", x)
    if m is None:
       return x
    s1, s2 = m.groups()
    return "|".join([str(s) for s in range(int(s1), int(s2)+1)])
op = filter.applymap(convert_range)

answered May 22, 2020 at 8:34

Tom Ron

6,2413 gold badges28 silver badges43 bronze badges

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

Collectives™ on Stack Overflow

Replace cells in a dataframe with a range of 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