如何将雅典娜创建的拼花面板表读入python

pip install boto3 pandas

import boto3

# 创建与雅典娜服务的连接
athena_client = boto3.client('athena')

# 执行查询
query = 'SELECT * FROM your_table_name'
response = athena_client.start_query_execution(
    QueryString=query,
    QueryExecutionContext={
        'Database': 'your_database_name'
    },
    ResultConfiguration={
        'OutputLocation': 's3://your_bucket_name/athena_results/'
    }
)

# 获取查询结果
query_execution_id = response['QueryExecutionId']
result_response = athena_client.get_query_results(QueryExecutionId=query_execution_id)

# 解析结果
columns = [col['Label'] for col in result_response['ResultSet']['ResultSetMetadata']['ColumnInfo']]
rows = []
for row in result_response['ResultSet']['Rows'][1:]:
    rows.append([data['VarCharValue'] for data in row['Data']])

# 将结果转换为DataFrame
import pandas as pd
df = pd.DataFrame(rows, columns=columns)