How to split column values into multiple columns pandas

Question

I have a df

Name Zone                                                    Dummy
A    BARI (BA), BARLETTA (BT), BRINDISI (BR), FOGGIA (FG)     2
B    BARI (BA), FOGGIA (FG)                                   2
C    HDEF (SE), LECCE (LE)                                    3
D    GUVA (PP)                                                3

I need df as

    Name Zone                                             Symbol            Dummy
    A    BARI , BARLETTA , BRINDISI , FOGGIA         (BA),(BT),(BR),(FG)      2
    B    BARI , FOGGIA                               (FG),(BA)                2
    C    HDEF , LECCE                                (LE),(SE)                3
    D    GUVA                                        (PP)                     3

Tried to split the Zone and Symbol using

Series.str.split()

but not working as expected.

Tim Biegeleisen · Accepted Answer · 2022-05-29 10:53:08Z

1

You could use str.replace here:

df["Symbol"] = df["Zone"].str.replace(r'(?:|\s+)[A-Z]+\s+', '')
df["Zone"] = df["Zone"].str.replace(r'\s*\(.*?\)\s*', '')

edited May 29, 2022 at 10:53

answered May 29, 2022 at 10:50

Tim Biegeleisen

526k32 gold badges324 silver badges399 bronze badges

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

4 Comments

Madan Over a year ago

Its not working..

Madan Over a year ago

yes working, how to remove duplicates..! like there is two same symbols..

Tim Biegeleisen Over a year ago

That's not your original question. You should either edit your current question or ask a new one.

Madan Over a year ago

ok thank u, this is sufficient for now..

Collectives™ on Stack Overflow

How to split column values into multiple columns pandas

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related