Changing pandas column values into another format

Question

The labels column in my test['labels'] dataframe, looks like:

0                                      ['Edit Distance']
1                                   ['Island Perimeter']
2      ['Longest Substring with At Most K Distinct Ch...
3                                  ['Valid Parentheses']
4                      ['Intersection of Two Arrays II']
5                                           ['N-Queens']

For each value in the column, which is a string representation of list ("['Edit Distance']"), I want to apply the function below to convert it into an actual list.

ast.literal_eval(VALUE HERE)

What is a straightforward way to do this?

Use `test['labels'].apply(ast.literal_eval)`. – Space Impact Jun 21 '19 at 06:33 — Space Impact, Jun 21 '19 at 06:33

jezrael · Answer 1 · 2019-06-21T06:55:15.057

4

Use:

import ast
test['labels'] = test['labels'].apply(ast.literal_eval)
print (test)
                                           labels
0                                 [Edit Distance]
1                              [Island Perimeter]
2  [Longest Substring with At Most K Distinct Ch]
3                             [Valid Parentheses]
4                 [Intersection of Two Arrays II]
5                                      [N-Queens]

edited Jun 21 '19 at 06:55

answered Jun 21 '19 at 06:35

jezrael

822,522
95
1,334
1,252

1

could you explain how `pd.io.json.loads` works here? or any resource link? – Mohamed Thasin ah Jun 21 '19 at 06:41
1

@MohamedThasinah - it should working here, beacuse list is valid json, but after testing not. so removed. – jezrael Jun 21 '19 at 06:55

Changing pandas column values into another format

1 Answers1