Convert a single string inside list into multiple string inside that same list in pandas

Question

I have a dataframe which consists of a column having tags as

tags
------------
['tag1' 'tag2']
['tag1']
['tag5' 'tag3' 'tag6']

How to get the dataframe in following format?

    tags
    ------------
    ['tag1','tag2']
    ['tag1']
    ['tag5','tag3','tag6']

While viewing the single row:

print(df['tags'][0][0])
>>> "'tag1' 'tag2'"
print(df['tags'][0][0][0]
>>> "'"

I tried the following method:

def Convert(string): 
    li = list(string.split(" ")) 
    return li 
str1 = Convert(df1['tags'][0][0])
print(str1)
>>> ["'tag1'", "'tag2'"]

Method2 This also didn't work to me.

import ast
ast.literal_eval(df['tags'][0][0])
>>>'tag1tag2'

Question2 I want to count the total occurrence of tags and df['tags'].value_counts() doesn't work. It either takes the whole list as count their occurrence or if i modify the list then it will take the character count.

Your objective is not clear to me. Do you want to split strings of the form " \'tag1\' \'tag2\' "? — Jan Alexander
– Jan Alexander, Commented Feb 28, 2021 at 8:09
Does this answer your question? pandas - convert string into list of strings — Kipkurui
– Kipkurui, Commented Feb 28, 2021 at 8:12
@JanAlexander I have a list say list1 = ['tag1' 'tag2'] and i want to access the list item tag1 and tag2. But the list is actually in form list1 = ["'tag1' 'tag2"'] . By accessing the list item, i mean in the format list1 = ['tag1','tag2'] — najuspy
– najuspy, Commented Feb 28, 2021 at 8:36

Jan Alexander · Accepted Answer · 2021-02-28 09:16:47Z

2

Is this what you are looking for?

list1 = ["'tag1' 'tag2'"]
result = [w.strip("'") for w in list1[0].split(' ')]
print(f'converted\n{list1}\nto\n{result}')

answered Feb 28, 2021 at 9:16

Jan Alexander

1658 bronze badges

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

Collectives™ on Stack Overflow

Convert a single string inside list into multiple string inside that same list in pandas

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related