Convert only values from list of dictionary to list of list without changing order using Python

Question

I have list of dict from which I need to convert all the dict values into list of list without changing the order.

I used empty list and tried to append dict values using for loop but its not in order.

For example:

    result = [{'Project': 'ABC','Employee': 'MNK','Project': 'ABC','Project': 'ABC'}]

I want in below format:

    answer = [['ABC'],['MNK'],['ABC'],['ABC']]

I used below code:

    answer =[]
    for i,j in enumerate(result):
        answer .append(result[i].values())

What I got is

    answer = [['MNK'],['ABC'],['ABC'],['ABC']]

Expected answer is

    answer = [['ABC'],['MNK'],['ABC'],['ABC']]

Note: I am looking for code which gives expected answer, I checked other questions, none of them related to this. Right suggestions and codes are accepted. Thanks.

Why do you have duplicate keys? A dict cannot have dup keys! — DirtyBit, Apr 17 '19 at 11:09
To expand upon DirtyBit's comment: Your `result` data as illustrated is equivalent to `[{'Project': 'ABC', 'Employee': 'MNK'}]` – there's no way to get the result you want in Python. — AKX, Apr 17 '19 at 11:10

DirtyBit · Answer 1 · 2019-04-17T11:44:33.123

2

Based on your comment with the new list:

Using map():

result = [{'T_Project': 'ABC','T_Employee': 'MNK','T_Project1': 'ABC','T_Project2': 'ABC'}]

print(list(map(lambda x: x.values(), result)))

Using list-comprehension:

print(list(x.values() for x in result))

OUTPUT:

[dict_values(['ABC', 'MNK', 'ABC', 'ABC'])]

pyFiddle

EDIT:

Python 2.x:

from collections import OrderedDict

d = OrderedDict()
d['T_Project'] = 'ABC'
d['T_Employee'] = 'MNK'
d['T_Project1'] = 'ABC'
d['T_Project2'] = 'ABC'

print(d)
print(list(d.values()))

OUTPUT:

OrderedDict([('T_Project', 'ABC'), ('T_Employee', 'MNK'), ('T_Project1', 'ABC'), ('T_Project2', 'ABC')])
['ABC', 'MNK', 'ABC', 'ABC']

pyFiddle 2.x

edited Apr 17 '19 at 11:44

answered Apr 17 '19 at 11:33

DirtyBit

16,613
4
34
55

I got some thing like this [['ABC', 'ABC', 'MNK', 'ABC']] – Karthik Gowda Apr 17 '19 at 11:36
@KarthikGowda I have a feeling you're on Python 2.x. – DirtyBit Apr 17 '19 at 11:37
I am using Python 2.7 – Karthik Gowda Apr 17 '19 at 11:38
@KarthikGowda https://stackoverflow.com/questions/46360509/does-dict-values-returns-in-an-ordered-sequence – DirtyBit Apr 17 '19 at 11:41
@KarthikGowda provided a way out for Python 2.x in my edit. – DirtyBit Apr 17 '19 at 11:44
Ok if I change result to just list ['T_Dept.ABC', 'T_EMP.NAME', 'T_PRO.ABC', 'T_Mastert.ABC'] and how to extract text which is after period in list values? example ['ABC','NAME','ABC','ABC'] – Karthik Gowda Apr 17 '19 at 11:51
2

@KarthikGowda That is a different question but still `print([x.split(".")[1] for x in r])` should do it. – DirtyBit Apr 17 '19 at 11:54

score 0 · Answer 2 · answered Apr 17 '19 at 11:13

0

I will assume that you've written your question input dictionary wrong and I will assume it looks like this:

result = [
    {'Project': 'ABC'},
    {'Employee': 'MNK'},
    {'Project': 'ABC'},
    {'Project': 'ABC'}
]

x = [list(d.values()) for d in result]

print(x)

Which will yield what you want [['ABC'], ['MNK'], ['ABC'], ['ABC']]

answered Apr 17 '19 at 11:13

andreihondrari

5,743
5
30
59

You're altering the original list provided in the question. – DirtyBit Apr 17 '19 at 11:14
@DirtyBit I'm pretty sure he wrote it wrong. forgot a few brackets, hence the assumption in my answer. – andreihondrari Apr 17 '19 at 11:15

Convert only values from list of dictionary to list of list without changing order using Python

2 Answers2