Adding Keys to Dictionary from a List Python

Question

I have queried snowflake using python to extract 3 Columns.

The result looks like this:

[('123','',datetime.date(9999,12,31)), ('321', '981', datetime.date(9999,12,31))]

What I want is to get a JSON with the column names. so the final output would look like this:

[{
"Number": "123",
"ExternalNumber": "",
"effective_date": "9999,12,31"
},
{
"Number": "321",
"ExternalNumber":"981",
"effective_date": "9999,12,31"
}]

The column names in Snowflake are Number, ExternalNumber and effective date.

what you have tried?

Sharim09
– Sharim09

2022-08-22 18:56:36 +00:00
Commented Aug 22, 2022 at 18:56 — Sharim09
– Sharim09, Commented Aug 22, 2022 at 18:56

funnydman · Accepted Answer · 2022-08-22 19:01:06Z

5

Use list comprehensions:

import datetime

alist = [('123', '', datetime.date(9999, 12, 31)), ('321', '981', datetime.date(9999, 12, 31))]


result = [
    {
        "Number": number,
        "ExternalNumber": external_number,
        "effective_date": str(effective_date).replace('-', ',')
    } for number, external_number, effective_date in alist
]

print(result)

Output:

[
    {'Number': '123', 'ExternalNumber': '', 'effective_date': '9999,12,31'}, 
    {'Number': '321', 'ExternalNumber': '981', 'effective_date': '9999,12,31'}
]

answered Aug 22, 2022 at 19:01

funnydman

11.8k4 gold badges51 silver badges67 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Haribk · Accepted Answer · 2023-05-06 08:34:29Z

2

If what you are looking for is a simple python function:

import datetime
def convert_function(list_of_tuple):
    list_of_dict = []
    for i in list_of_tuple:
        list_of_dict.append({
            "Number": i[0],
            "ExternalNumber": i[1],
            "effective_date": str(i[2]).replace('-', ',')
        })
    return list_of_dict

edited May 6, 2023 at 8:34

answered Aug 22, 2022 at 19:09

Haribk

3193 silver badges8 bronze badges

Collectives™ on Stack Overflow

Adding Keys to Dictionary from a List Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related