CODEWITHSUNDEEP
pythonarraysdictionary
Aditi Pathak
Aditi Pathak

Reputation: 1

How to convert 1D array containing dictionaries as its values into a 2D array

I want to change the below 1D array having dictionaries as its value into 2D array. I don't want to use numpy or pandas.

array = [{"id": "123", 'name-code': 'user-1666935009', 'r.no.': '1', 'start_time': '1666955702', 'state_msg': 'Finished', 'state_details': '', 'setup_time': '2371'}]

I am expecting the output as

array = [['id','name-code','r.no.','start_time','state_msg','state_details','setup_time'],['123','user-1666935009', '1','1666955702','Finished','','2371']]

Upvotes: 0

Views: 221

Answers (3)

0xRyN
0xRyN

Reputation: 872

Here is an easy to understand way of doing this:

array = [{"id": "123", 'name-code': 'user-1666935009', 'r.no.': '1', 'start_time': '1666955702',
          'state_msg': 'Finished', 'state_details': '', 'setup_time': '2371'}]

res = []
for i in range(len(array)):
    keys = list(array[i].keys())
    values = list(array[i].values())
    res.append(keys)
    res.append(values)

print(res)

Upvotes: 0

Andrej Kesely
Andrej Kesely

Reputation: 195553

Try:

array = [
    {
        "id": "123",
        "name-code": "user-1666935009",
        "r.no.": "1",
        "start_time": "1666955702",
        "state_msg": "Finished",
        "state_details": "",
        "setup_time": "2371",
    }
]

array = [list(array[0]), list(array[0].values())]
print(array)

Prints:

[
    [
        "id",
        "name-code",
        "r.no.",
        "start_time",
        "state_msg",
        "state_details",
        "setup_time",
    ],
    ["123", "user-1666935009", "1", "1666955702", "Finished", "", "2371"],
]

If you have more dictionaries in your list:

array = [[k for d in array for k in d], [v for d in array for v in d.values()]]
print(array)

Upvotes: 1

scotscotmcc
scotscotmcc

Reputation: 3123

Create a new list that contains the two empty lists you want, then loop through original dictionary (which is the initial item in the original list, so subscript 0), and append the keys and values to the new one.

array2 = [[],[]]
for key,value in array[0].items():
    array2[0].append(key)
    array2[1].append(value)

Upvotes: 0

Related Questions