Python - Parse a list of string formatted list of strings

Question

I am having problem in parsing list of strings in the below format. This is actually a pandas dataframe:

def parse_text_to_list(row):
    print(row) # eval is not working as inner strings are missing the quotes
    return row

df.apply(parse_text_to_list)

output

# printed only one row to simplify the question
['[[str1, str2], [str1, a long text], ..., [strn, strx]]']

But Want to convert it to a pure python list like:

[["str1", "str2"], ["str1", "a long text"], ... ["strn", "strx"]]

@Negative markers - let me know the reason

If you can add few rows of input dataframe to your Q as text, sure I can try to help — Sreeram TP
– Sreeram TP, Commented Feb 23, 2021 at 14:41

Epsi95 · Accepted Answer · 2021-02-23 14:44:38Z

2

You can try regular expression with literal_eval to get the list

import re
import ast

l = ['[[str1, str2], [str1, a long text], [strn, strx]]']

output = ast.literal_eval(re.sub(r'([^\[\],\s][^\[\],]+[^\[\],\s])', r'"\1"', l[0]))

print(output)

[['str1', 'str2'], ['str1', 'a long text'], ['strn', 'strx']]

answered Feb 23, 2021 at 14:44

Epsi95

9,1071 gold badge19 silver badges37 bronze badges

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

2 Comments

Laxmikant Over a year ago

Perfect, Thanks very much. It worked like charm. but wondering whats happening in the regex part. Can you please explain a bit.

Epsi95 Over a year ago

It is checking if anything starting with anything except [ ] space , then in between anything except [ ] , more than one times and ending with anything except [ ] space ,

Ariel Catala Valencia · Accepted Answer · 2021-02-23 14:45:54Z

0

If you want print each row as a list you can use:


def parse_text_to_list(row):
    print(row.tolist())
    return row

But if you want convert each row to List,you can use directly:

df.values.tolist()

This questions is already resolved here

edited Feb 23, 2021 at 14:45

answered Feb 23, 2021 at 14:42

Ariel Catala Valencia

1121 silver badge10 bronze badges

1 Comment

Laxmikant Over a year ago

No, it does not answer my question

Collectives™ on Stack Overflow

Python - Parse a list of string formatted list of strings

2 Answers 2

2 Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related