多个数据表在python 3.6中读取

import pandas as pd

# 读取CSV文件
df_csv = pd.read_csv('data.csv')

# 读取Excel文件
df_excel = pd.read_excel('data.xlsx')

# 读取SQL数据库中的数据表
import sqlite3
conn = sqlite3.connect('database.db')
df_sql = pd.read_sql('SELECT * FROM table_name', conn)

from sqlalchemy import create_engine

# 创建数据库连接
engine = create_engine('sqlite:///database.db')

# 执行SQL查询语句
result = engine.execute('SELECT * FROM table_name')

# 获取查询结果
for row in result:
    print(row)

import sqlite3

# 创建数据库连接
conn = sqlite3.connect('database.db')

# 创建游标对象
cursor = conn.cursor()

# 执行SQL查询语句
cursor.execute('SELECT * FROM table_name')

# 获取查询结果
result = cursor.fetchall()
for row in result:
    print(row)

# 关闭游标和数据库连接
cursor.close()
conn.close()