How to add comma in between strings inside square brackets in pandas

Question

I have a pandas dataframe as:-

categories
['business $ finance'\n 'business $currency']
['entertainment $movies' 'entertainment &music']
['sports& volleyball' 'sports& football'\n 'sports$ baseball']
...............

All I want to convert these strings inside brackets into proper list format. Expected output as:-

categories
['business $ finance','business $currency']
['entertainment $movies','entertainment &music']
['sports&volleyball','sports& football','sports$ baseball']
....................

what I have tried so far:-

array_cat=[]
for i in df['categories']:
      s=i[0].split()
      array_cat.append(s)

Edit

df['categories'][0] is something like:-

"['business finance#mergers & acquisitions' 'business#industries#telecom'\n 'diseases#kidney' 'gaming #offline #console#xbox'\n 'gaming #offline #playstation' 'lifestyle#shopping' 'movies#genres#drama'\n 'music#genres#hiphop/rap' 'personal finance#tools' 'technology#trending'\n 'theme#historicalsites']"

jezrael · Accepted Answer · 2018-08-16T11:23:37.510

1

Use str.findall by all values between '':

df['categories'] = df['categories'].str.findall('\'(.*?)\'')
print (df)
                                          categories
0  [business finance#mergers & acquisitions, busi...
1        [entertainment$movies, entertainment&music]
2  [sports&volleyball, sports&football, sports$ba...

edited Aug 16 '18 at 11:23

answered Aug 16 '18 at 10:57

jezrael

822,522
95
1,334
1,252

@Mavrick - What return `print (df['categories'].iloc[1:5].to_dict())` ? Please change `1` or `5` for catch values with `\n` – jezrael Aug 16 '18 at 11:05
@Mavrick - Can you check now? – jezrael Aug 16 '18 at 11:24
1

@Mavrick - Super, your string `df['categories'][0]` help me a lot ;) – jezrael Aug 16 '18 at 11:31
Can I just ask your help on this `https://stackoverflow.com/questions/51864822/matching-elements-of-pandas-column-with-column-of-another-pandas-dataframe/51869865#51869865`? It would be my pleasure. – Learner Aug 16 '18 at 11:31
1

@Mavrick - Not easy question, but I can try. – jezrael Aug 16 '18 at 11:32
Yeah sure, Thanks :) – Learner Aug 16 '18 at 12:05

How to add comma in between strings inside square brackets in pandas

Edit

1 Answers1