如何使用Rest API以csv或Excel格式从Databricks DBFS读取数据？

import requests
import pandas as pd

# 步骤1：获取访问令牌
auth_endpoint = "https://<databricks-instance>/token/auth"
payload = {
    "username": "<your-username>",
    "password": "<your-password>"
}
response = requests.post(auth_endpoint, json=payload)
access_token = response.json()["access_token"]

# 步骤2：构建REST API请求
dbfs_file_path = "/mnt/<dbfs-mount-point>/<file-path>"
api_endpoint = f"https://<databricks-instance>/api/2.0/dbfs/read?path={dbfs_file_path}"
headers = {
    "Authorization": f"Bearer {access_token}"
}

# 步骤3：发送请求并处理响应
response = requests.get(api_endpoint, headers=headers)
data = response.json()

# 步骤4：将数据转换为csv或Excel格式
df = pd.DataFrame(data)  # 假设数据是一个列表字典形式
df.to_csv("<output-file-path>.csv", index=False)  # 将数据保存为csv文件
df.to_excel("<output-file-path>.xlsx", index=False)  # 将数据保存为Excel文件