Access|Access BQ via pandas in python
Write data
import pandas as pdfor i in range(1,len(nonstd_q)):
id += 1
data2 = pd.DataFrame({"col": dat, "col": dat, "col": dat}, pd.Index(range(1)))
data = https://www.it610.com/article/data2.append(data)data.to_gbq(destination_table="*.*", project_id = '*',if_exists="append")
Read data
query = """
SELECT max(`*`) FROM `*.*.*`
"""
result = pd.read_gbq(query, dialect='standard', project_id='*', use_bqstorage_api=True)id = int(result["f0_"][0])+1
推荐阅读
- Pandas（数据清洗）
- pandas使用
- Pandas批量读取csv文件数据存入到Mysql中
- 用Pandas库实现MySQL数据库的读写
- #|学习笔记 | Ch05 Pandas数据清洗 —— 缺失值、重复值、异常值
- Pandas——Series结构
- has|has private access in INSTANCE
- 后端和服务器|跨域(Access-Control-Allow-Origin)解决方案详解
- Android Accessibility大致解析,通过adb运行纯java代码打开应用的辅助功能
- Pandas常见用法总结