Dataframe pandas split str

Question

I got a dataframe that contains columns with numbers where some are a single number (1234) and others contains multiple numbers(12340-567-8900) I found a way to split the multiple numbers, but if my columns contains single numbers my code fails.

Can anyone point me in the right direction?

    `lens = df['EPDNr'].str.split('-').map(len)
     res = pd.DataFrame({'Title':np.repeat(df['Title'],lens),
                'Kundenummer':np.repeat(df['Kundenummer'],lens),
                'Avvikstype':np.repeat(df['Avvikstype'],lens),
                'Ordrenummer':np.repeat(df['Ordrenummer'],lens),
                'EPDNr':chainer(df['EPDNr']),
               'Antall':chainer(df['Antall'])})

I want my output to look like Column header: EPDNR Cell a1 1234 Cell a2 12340 Cell a3 567 cell a4 8900 ect..

Can you provide more complete sample dataset and expected outputs from that data set? — Scott Boston
– Scott Boston, Commented Jun 11, 2019 at 18:13

Andy Hayden · Accepted Answer · 2019-06-11 18:51:10Z

2

You can use expand=True:

In [11]: s = pd.Series(["1234-567-8900", "12"])

In [12]: s.str.split("-", expand=True)
Out[12]:
      0     1     2
0  1234   567  8900
1    12  None  None

answered Jun 11, 2019 at 18:51

Andy Hayden

378k110 gold badges640 silver badges546 bronze badges

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

Collectives™ on Stack Overflow

Dataframe pandas split str

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