在Python-Pandas、SQLAchemy或SQL中，将两列的值作为键值返回给列表或字典？

import pandas as pd

data = {'column1': [value1, value2, ...], 'column2': [value1, value2, ...]}
df = pd.DataFrame(data)

result_list = df.to_dict(orient='list')

result_dict = df.to_dict(orient='dict')

from sqlalchemy import create_engine, select, Table, Column, Integer, String, MetaData

engine = create_engine('数据库连接字符串')

metadata = MetaData()
table = Table('table_name', metadata,
              Column('column1', Integer),
              Column('column2', String))

with engine.connect() as conn:
    query = select([table.c.column1, table.c.column2])
    result = conn.execute(query).fetchall()
    result_list = [{'column1': row.column1, 'column2': row.column2} for row in result]
    result_dict = {row.column1: row.column2 for row in result}

import MySQLdb

conn = MySQLdb.connect(host='数据库主机名', user='用户名', passwd='密码', db='数据库名')

cursor = conn.cursor()

query = "SELECT column1, column2 FROM table_name"
cursor.execute(query)
result = cursor.fetchall()
result_list = [{'column1': row[0], 'column2': row[1]} for row in result]
result_dict = {row[0]: row[1] for row in result}