How to increase columns in pandas if a certain condition is satisfied?

Question

I have a dataframe for example:

ID      Description 

1       Long lasting glasses,Fire resistant,Polarizer

I want every description column just containing the maximum length of 10 characters, if it exceeds new columns should be formed. Example:

ID   Description   Description2   Description3  Description4   Description5

1    Long Lasti     ng glasses    ,Fire resi     stant,Pola    rizer

@Ch3steR, I'm totally disagree! Do you know a regular expression that splits on length??? — Corralien, May 13 '21 at 05:06

Shubham Sharma · Accepted Answer · 2021-05-13T05:23:38.997

3

We can extract the all the occurrences of capturing group in the regex pattern, then unstack to reshape

df['Description'].str.extractall(r'(.{10}|.+$)')[0].unstack()

match           0           1           2           3      4
0      Long lasti  ng glasses  ,Fire resi  stant,Pola  rizer

Regex Details:

(.{10}|.+$) : First capturing group
- .{10} : Match any character exactly 10 times (First alternative)
- .+ : Match any character one or more times (Second alternative)

edited May 13 '21 at 05:23

answered May 13 '21 at 05:15

Shubham Sharma

Thanks @Ch3steR yeah squeeze would also work nicely. – Shubham Sharma May 13 '21 at 05:24
the column names are also important, any ideas for it – Atom Store May 13 '21 at 05:39
1

@AtomStore We can `add` a prefix to the column names. Please check `df['Description'].str.extractall(r'(.{10}|.+$)')[0].unstack().add_prefix('Description')` – Shubham Sharma May 13 '21 at 05:40

1 Answers1