dictionaries

[brecht83]

Hello everybody,

I read data from an MySQL server and it gives me the info as a list dictionaries:

1 2 3 4 5 6

db_ewon =  con.cursor(dictionary=True) db_ewon.execute("SELECT Name,Id FROM esync_stations") df_ewon = db_ewon.fetchall()   for x in df_ewon[0:5]:     print (x)

The result:

1 2 3 4 5

{'Name': 'Station1', 'Id':1} {'Name': 'Station2', 'Id':5} {'Name': 'Station3', 'Id':3} {'Name': 'Station4', 'Id':9} {'Name': 'Station5', 'Id':2}

I want to put all this data in 1 dictionary with the heads: 'Name' and 'Id'
The dictionary looks like this:

1 2 3 4 5 6 7

new_dict={     'Station1':1,     'Station2':5,     'Station3':3,     'Station4':9,     'Station5':2, }

Can somebody help me please

[buran]

dict comprehension:

1	new_dict = {item['Name']:item['Id'] for item in df_ewon[0:5]}

note you can also iterate over cursor as iterator - https://dev.mysql.com/doc/connector-pyth...chone.html
example from the docs

1 2 3 4

# Using the cursor as iterator cursor.execute("SELECT * FROM employees") for row in cursor:   print(row)

[gruntfutuk]

As you know the key names, you can use a simple dictionary comprehension with a for loop to step through the list.

For example,

1 2 3 4 5 6 7 8

list_ = [{'Name': 'Station1', 'Id':1}, {'Name': 'Station2', 'Id':5}, {'Name': 'Station3', 'Id':3}, {'Name': 'Station4', 'Id':9}, {'Name': 'Station5', 'Id':2}]   new_dict = {dict_['Name']: dict_['Id'] for dict_ in list_} print(new_dict)