Convert String List Of Dict From Csv Into Json Object In Python
I have a csv where for one column values are in list of dict like below [{'10': 'i ve been with what is now comcast since 2001 the company has really grown and improved and delive
Solution 1:
You can use the ast
module
Ex:
import ast
s = """[{'10': 'i ve been with what is now comcast since 2001 the company has really grown and improved and delivers a great service along with great customer service ', 'aspects':['service']},
{'20': 'good service but lack of options to allow it be more affordable allowing individual channel choices would be great ', 'aspects':['lack', 'service']},
{'30': 'it a good service but very expensive', 'aspects':['service']}, {'40': 'good service', 'aspects':['service']},
{'50': 'good service but over priced ', 'aspects':['service']}]"""print(ast.literal_eval(s))
Output:
[{'10': 'i ve been with what is now comcast since 2001 the company has really grown and improved and delivers a great service along with great customer service ', 'aspects': ['service']}, {'aspects': ['lack', 'service'], '20': 'good service but lack of options to allow it be more affordable allowing individual channel choices would be great '}, {'30': 'it a good service but very expensive', 'aspects': ['service']}, {'aspects': ['service'], '40': 'good service'}, {'aspects': ['service'], '50': 'good service but over priced '}]
Solution 2:
To convert to json file:
>>>import json>>>json.dump(obj,open(path + '/txt.json','w+'))
Post a Comment for "Convert String List Of Dict From Csv Into Json Object In Python"