Bigquery Python API -编写dataframe order by column

pip install google-cloud-bigquery pandas

from google.cloud import bigquery
import pandas as pd

# 设置你的Google Cloud项目ID
project_id = 'your-project-id'

# 创建BigQuery客户端
client = bigquery.Client(project=project_id)

# 编写SQL查询，按特定列排序
query = """
    SELECT column1, column2, column3
    FROM `your-dataset.your-table`
    ORDER BY column1
"""

# 执行查询并将结果加载到Pandas DataFrame中
query_job = client.query(query)
df = query_job.to_dataframe()

# 打印DataFrame
print(df)

   column1 column2 column3
0        1       B       Y
1        2       C       Z
2        3       A       X