Extract second character from string in Python

Question

I have a dataframe with a column that holds certain values where I would like to extract the second string after the hyphen and keep the original.

Data

   type            stat
   SSS-AA-11111    y
   FFF-BB-22222    y

Desired

type            type1 stat
SSS-AA-11111    AA    y
FFF-BB-22222    BB    y

Doing

  df[['type', 'type1']] = df['type'].str.split('-', 1, expand=True)`

I get this error:

ValueError: Columns must be same length as key

I am still researching. Any suggestion is appreciated

Corralien · Accepted Answer · 2022-01-13 17:57:44Z

2

Use str.split and keep the second element with str[1]:

df['type1'] = df['type'].str.split('-').str[1]
print(df)

# Output
           type stat type1
0  SSS-AA-11111    y    AA
1  FFF-BB-22222    y    BB

answered Jan 13, 2022 at 17:57

Corralien

121k8 gold badges43 silver badges68 bronze badges

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

1 Answer 1