Convert list of Dictionaries to comma separated string python

Question

i'm trying to convert list of dictionaries to comma separated string , but some extra fields of dictionary are coming

data = [{'groupid': '28', 'name': 'TEST 2', 'internal': '0', 'flags': '0'}, {'groupid':'27', 'name': 'CUSTOMER/TEST 1', 'internal': '0', 'flags': '0'}]

expected output = TEST2,CUSTOMER/TEST 1

my script: s = [','.join(map(str,i.values())) for i in data]

output i'm getting : ['28,TEST 2,0,0', '27,CUSTOMER/TEST 1,0,0']

Why is the expected output ```TEST2,CUSTOMER/TEST 1``` when you're printing all the key values from your dictionary? — Omar AlSuwaidi, Mar 18 '21 at 12:58

score 4 · Accepted Answer · answered Mar 18 '21 at 12:57

4

Try this:

data = [{'groupid': '28', 'name': 'TEST 2', 'internal': '0', 'flags': '0'}, {'groupid':'27', 'name': 'CUSTOMER/TEST 1', 'internal': '0', 'flags': '0'}]
print([d["name"] for d in data])

Output:

['TEST 2', 'CUSTOMER/TEST 1']

answered Mar 18 '21 at 12:57

baduker

15,071
9
26
44

Krishna Chaurasia · Answer 2 · 2021-03-18T13:08:12.830

2

For the expected out, you simply need to get the value corresponding to the key name:

s = ','.join(i['name'] for i in data)

edited Mar 18 '21 at 13:08

answered Mar 18 '21 at 13:00

Krishna Chaurasia

8,130
6
18
31

You can drop the square brackets if you're using `.join()`. -> `','.join(i['name'] for i in data)` – baduker Mar 18 '21 at 13:02
thanks for the feedback, btw do you know if there is any difference wrt efficiency between the two? – Krishna Chaurasia Mar 18 '21 at 13:04
1

Correct me if I'm wrong, but for large objects generator expressions are going to be more memory efficient. – baduker Mar 18 '21 at 13:07

dtc348 · Answer 3 · 2021-04-09T09:09:36.483

1

Data is defined as dictionary object. Apply elt for filter.


data = [{'groupid': '28', 'name': 'TEST 2', 'internal': '0', 'flags': '0'}, 
      {'groupid':'27', 'name': 'CUSTOMER/TEST 1', 'internal': '0', 'flags': '0'}]

expected output = [elt["name"] for elt in data]
print(expected output)
output = ['TEST 2', 'CUSTOMER/TEST 1']

edited Apr 09 '21 at 09:09

answered Mar 18 '21 at 13:04

dtc348

616
6
16

Convert list of Dictionaries to comma separated string python

3 Answers3

Linked