惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

Attack and Defense Labs
Attack and Defense Labs
The GitHub Blog
The GitHub Blog
C
Check Point Blog
博客园_首页
MongoDB | Blog
MongoDB | Blog
N
Netflix TechBlog - Medium
F
Full Disclosure
Microsoft Security Blog
Microsoft Security Blog
爱范儿
爱范儿
Recent Announcements
Recent Announcements
阮一峰的网络日志
阮一峰的网络日志
G
GRAHAM CLULEY
Cyber Security Advisories - MS-ISAC
Cyber Security Advisories - MS-ISAC
T
Threat Research - Cisco Blogs
C
Cybersecurity and Infrastructure Security Agency CISA
V
Vulnerabilities – Threatpost
K
Kaspersky official blog
博客园 - 司徒正美
S
Schneier on Security
T
The Exploit Database - CXSecurity.com
Project Zero
Project Zero
云风的 BLOG
云风的 BLOG
Cisco Talos Blog
Cisco Talos Blog
Know Your Adversary
Know Your Adversary
雷峰网
雷峰网
V
V2EX - 技术
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
Spread Privacy
Spread Privacy
罗磊的独立博客
K
KPMG report finds enterprise disconnect between AI and its ROI | CIO
S
Security Affairs
SecWiki News
SecWiki News
Schneier on Security
Schneier on Security
O
OpenAI News
Jina AI
Jina AI
PCI Perspectives
PCI Perspectives
Cyberwarzone
Cyberwarzone
Y
Y Combinator Blog
Apple Machine Learning Research
Apple Machine Learning Research
B
Blog RSS Feed
I
InfoQ
D
Docker
P
Palo Alto Networks Blog
Recorded Future
Recorded Future
M
MIT News - Artificial intelligence
博客园 - Franky
B
Blog
Scott Helme
Scott Helme
博客园 - 叶小钗
D
DataBreaches.Net

博客园 - bigdog

安装PyTorch_1 Pandas上的Dataframe求差集 Linux 下安装NLTK的过程 Python函数返回多结果 Pandas下的Dataframe如何实现多条件筛选 将英文缩写扩展成正常英文的方法 如何安装pytorch Selenium 获取Select元素的选中值 安装MxNet Docker 的日常 Ubuntu上安装Docker Ubuntu华为云挂载新硬盘 Python读写大文件-将整行文字根据分号分行 Pandas中的DataFrame读取Mysql的方法 Kettle 7.1 配置连接Oracle、Mysql、SqlServe的DLL文件准备 Nginx开启访问日志记录 Selenium chromeDriver 下载地址 在Linux上部署Nginx,反向代理tornado的WebSite Linux上安装Mysql
Pandas中的DataFrame读取Oracle的方法
bigdog · 2020-02-08 · via 博客园 - bigdog

1.Oracle

需安装的包

cx_Oracle

pandas

 def GetQueryByDF(self,sql):
        conn = cx_Oracle.connect("orcl/orcl@localhost:1521/ORCL")  # 连接数据库
        cur = conn.cursor()
        cur.execute(sql)
        title = [i[0] for i in cur.description]
        res = cur.fetchall()
        cur.close()
        conn.close()
        result = pd.DataFrame(res,columns=title)
        return result

posted @ 2020-02-08 17:55  bigdog  阅读(890)  评论(0)    收藏  举报