Converting string to list of dictionaries using Python

Question

I have code as follows:

try:
    relations = open(file_name, "wb")      
    ftp.retrbinary('RETR {0}'.format(file_name), test)         
    relations.close()  # Closes the local file        
    ftp.quit()  # Closes the ftp connection
    print("FTP Connection quited.")        
except Exception as e:
    print("Error: File {0} could not be downloaded. {1}".format(file_name, str(e)))

And the test function is as follows:

def test(data):
    data_n = json.dumps(data.decode('utf-8'))

    pdb.set_trace()
    pass

I want to download the file from ftp server using python and read it without writing it locally.

In this case in test function in data_n i get:

'"CODE;MATCHCODE;\\r\\nK902154;VANHOVEGARAGES;;;;;;;;;;;;;;;;;;;;;;;;;;;;;\\r\\nK902191;CARAVENUESTAR;;;;;;;;;;;;;;;;;;;;;;;;;;;;;\\r\\nK902192;CARAVENUESTAR;;;;;;;;;;;;;;;;;;;;;;;;;;;;;"'

How can I convert it to the list of dictionaries as follows:

result = [
    {
        "CODE": "K902154",
        "MATCHCODE": "VANHOVEGARAGES"
    },
    {
        "CODE": "K902191",
        "MATCHCODE": "CARAVENUESTAR"
    },
    {
        "CODE": "K902192",
        "MATCHCODE": "CARAVENUESTAR"
    }
]

It looks like you’re getting actual backslashes in that string, instead of newlines — is that correct? — Tom Zych
– Tom Zych, Commented May 13, 2019 at 10:15

Rakesh · Accepted Answer · 2019-05-13 10:32:11Z

1

Using str.split and a simple iteration.

Ex:

s = '"CODE;MATCHCODE;\\r\\nK902154;VANHOVEGARAGES;;;;;;;;;;;;;;;;;;;;;;;;;;;;;\\r\\nK902191;CARAVENUESTAR;;;;;;;;;;;;;;;;;;;;;;;;;;;;;\\r\\nK902192;CARAVENUESTAR;;;;;;;;;;;;;;;;;;;;;;;;;;;;;"'
result = []
for i, v in enumerate(s.split(r"\r\n")):
    if i == 0:
        keys = v.strip().strip(';"').split(";")    #Get Keys
    else:
        result.append(dict(zip(keys, v.strip().strip(';"').split(";"))))     #Form dict. 

print(result)

Output:

[{'CODE': 'K902154', 'MATCHCODE': 'VANHOVEGARAGES'},
 {'CODE': 'K902191', 'MATCHCODE': 'CARAVENUESTAR'},
 {'CODE': 'K902192', 'MATCHCODE': 'CARAVENUESTAR'}]

edited May 13, 2019 at 10:32

answered May 13, 2019 at 10:18

Rakesh

82.9k17 gold badges86 silver badges122 bronze badges

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

1 Comment

Rakesh Over a year ago

Updated snippet. Can you try this?

Collectives™ on Stack Overflow

Converting string to list of dictionaries using Python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related