create new columns derived from existing columns pandas

Question

I need to split 1 column value into 3 columns.

df['Campaign name']
0     US_FEMALE_20to30
1        US_MIX_35to45
2     US_FEMALE_20to30
3        US_MIX_35to45
4       US_MALE_30to35
5        US_MIX_35to45

so in the end, it will look like that

   region   gender   age
0   US      FEMALE   20to30
1   US      MIX      35to45
2   US      FEMALE   20to30
3   US      MIX      35to45
4   US      MALE     30to35
5   US      MIX      35to45

thanks a lot

use: out=df['Campaign name'].str.split('_',expand=True) after that rename columns out.columns=['region','gender','age'] now if you print out you will get your output see the documentation of str.split — Anurag Dabas
– Anurag Dabas, Commented Aug 1, 2021 at 7:10

Sonia Samipillai · Accepted Answer · 2021-08-01 07:39:38Z

1

Use the str.split function.

In str.split, you use

specify the delimiter in quotes
the 'n' parameter to specify how many times you want to split
Use 'expand' parameter to expand the columns into new columns

Then you create those columns in df as shown below

# new data frame with split value columns
new = df["Campaign_name"].str.split("_", n = 2, expand = True)
  
# making separate columns from new data frame
df["region"]= new[0]
df["gender"]= new[1]
df["age"]= new[2]

Output using df.head()

    Campaign_name     region    gender   age
0   US_FEMALE_20to30    US      FEMALE   20to30
1   US_MIX_35to45       US      MIX      35to45
2   US_FEMALE_20to30    US      FEMALE   20to30
3   US_MIX_35to45       US      MIX      35to45
4   US_MALE_30to35      US      MALE     30to35

answered Aug 1, 2021 at 7:39

Sonia Samipillai

6206 silver badges15 bronze badges

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

Comments

mozway · Accepted Answer · 2021-08-01 08:27:45Z

0

pandas.Series.str.extract with named groups is also a nice alternative:

df['Campaign name'].str.extract('(?P<region>.*)_(?P<gender>.*)_(?P<age>.*)')

output:

  region  gender     age
0     US  FEMALE  20to30
1     US     MIX  35to45
2     US  FEMALE  20to30
3     US     MIX  35to45
4     US    MALE  30to35
5     US     MIX  35to45

answered Aug 1, 2021 at 8:27

mozway

267k13 gold badges56 silver badges106 bronze badges

Collectives™ on Stack Overflow

create new columns derived from existing columns pandas

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related