Convert unicode String to Dictionary in python

Question

I have a variable which holds the table name and columns as a string. Below is the sample:

[(u'USER_SSO_PROPERTIES', u'[\n  "FULL_NAME",\n  "NAME"\n]'), (u'USERS', u'[\n  "EMAIL",\n  "NAME"\n]'), (u'PITCH_RECIPIENTS', u'[\n  "EMAIL",\n  "ID"\n]'), (u'USER_CLOUD_SERVICES', u'[\n  "EMAIL"\n]')]

I am trying to convert into a dictionary in python as below.

{'USER_SSO_PROPERTIES': ['FULL_NAME','NAME'],
 'PITCH_RECIPIENTS':['USER_CLOUD_SERVICES','EMAIL']}

How can I remove the \n and u and also convert it into the above format. I searched on SO and those solutions did not work for me.

which version of python are you using?

bigbounty
– bigbounty

2020-07-24 02:01:10 +00:00
Commented Jul 24, 2020 at 2:01 — bigbounty
– bigbounty, Commented Jul 24, 2020 at 2:01
I am using python 3

Kumar
– Kumar

2020-07-24 02:05:44 +00:00
Commented Jul 24, 2020 at 2:05 — Kumar
– Kumar, Commented Jul 24, 2020 at 2:05

Jeongmin · Accepted Answer · 2020-07-24 02:21:12Z

1

Use eval() to quickly convert literals to actual Python values.

This code can convert your example.

string = r'''[(u'USER_SSO_PROPERTIES', u'[\n  "FULL_NAME",\n  "NAME"\n]'), (u'USERS', u'[\n  "EMAIL",\n  "NAME"\n]'), (u'PITCH_RECIPIENTS', u'[\n  "EMAIL",\n  "ID"\n]'), (u'USER_CLOUD_SERVICES', u'[\n  "EMAIL"\n]')]'''

result_dict = {}
for table_name, columns_string in eval(string):
    result_dict[table_name] = eval(columns_string)

print(result_dict)

Try to run this code with other strings here.

https://www.pythonpad.co/pads/ri8adgokb5our8v1/

answered Jul 24, 2020 at 2:21

Jeongmin

1663 bronze badges

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

Comments

Kevin Mayo · Accepted Answer · 2020-07-24 02:13:02Z

0

You could use ast.literal_eval and list-comprehension to achieve that:

import ast

t = [(u'USER_SSO_PROPERTIES', u'[\n  "FULL_NAME",\n  "NAME"\n]'), (u'USERS', u'[\n  "EMAIL",\n  "NAME"\n]'),
     (u'PITCH_RECIPIENTS', u'[\n  "EMAIL",\n  "ID"\n]'), (u'USER_CLOUD_SERVICES', u'[\n  "EMAIL"\n]')]
result = {k: ast.literal_eval(v) for k, v in t}
# {'USER_SSO_PROPERTIES': ['FULL_NAME', 'NAME'], 'USERS': ['EMAIL', 'NAME'], 'PITCH_RECIPIENTS': ['EMAIL', 'ID'], 'USER_CLOUD_SERVICES': ['EMAIL']}

answered Jul 24, 2020 at 2:13

Kevin Mayo

1,1591 gold badge8 silver badges19 bronze badges

Comments

Yaakov Bressler · Accepted Answer · 2020-07-24 02:24:12Z

0

Simple 1 liner using eval:

my_data = {k:eval(v) for k,v in text}

answered Jul 24, 2020 at 2:24

Yaakov Bressler

12.7k5 gold badges66 silver badges96 bronze badges

Collectives™ on Stack Overflow

Convert unicode String to Dictionary in python

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related