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

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/

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

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']}

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

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Related