How to apply text_wrapper on dataframe column

Question

I have dataframe

In [1]: import pandas as pd
In [2]: data = {'A': [" tell me more about your issue please", "OKEY WILL DO", "IT DOESNT WORK HELP ME PLEASE"], 'B': [4, 5, 6], 'C': [7, 8, 9]}
In [3]: df = pd.DataFrame(data)
In [4]: df

And I want to apply to get in new column split text with max 8 characters

import textwrap
lines = textwrap.wrap(text, 8, break_long_words=False)

I tried something like

df['Split'] = df['A'].map(textwrap.wrap(df['A'],8, break_long_words = False))
 and .apply

Not only I think it is totally nonsense what I have in code, it also returns error

AttributeError: 'Series' object has no attribute 'expandtabs'

But I am total dumbass and I dont know how to get it running. Please could you help me?

Thanks!

jezrael · Accepted Answer · 2022-10-11 11:51:38Z

1

Use lambda function:

df['Split'] = df['A'].map(lambda x: textwrap.wrap(x,8, break_long_words = False))

Or:

df['Split'] = df['A'].apply(lambda x: textwrap.wrap(x,8, break_long_words = False))

answered Oct 11, 2022 at 11:51

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

1 Comment

HeadOverFeet Over a year ago

amazing!!! i used lambda incorrectly.... now it makes sense! Thanks soo much, I was in vicious circle of my mind on this...

Collectives™ on Stack Overflow

How to apply text_wrapper on dataframe column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related