Sep-27-2018, 10:37 AM
Hello everybody,
I read data from an MySQL server and it gives me the info as a list dictionaries:
The dictionary looks like this:
I read data from an MySQL server and it gives me the info as a list dictionaries:
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:
{'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:
new_dict={ 'Station1':1, 'Station2':5, 'Station3':3, 'Station4':9, 'Station5':2, }Can somebody help me please