将Teradata查询读入Pandas [英] Read Teradata query into Pandas

问题描述

有人找到一种将Teradata查询读入Pandas数据框的方法吗?看起来SQLAlchemy没有Teradata方言.

Has anyone found a way to read a Teradata query into a Pandas dataframe? It looks like SQLAlchemy does not have a Teradata dialect.

http://docs.sqlalchemy.org/en/latest/dialects/

http://pandas.pydata.org/pandas- docs/stable/generated/pandas.read_sql.html

推荐答案

我使用read_sql做到了.在ID下方的代码段为:

I did it using read_sql . Below id the code snip :

def dqm() :
    conn_rw = create_connection()
    dataframes = []
    srcfile = open('srcqueries.sql', 'rU').read()
    querylist = srcfile.split(';')
    querylist.pop()
    for query in querylist :
        dataframes.append(pd.read_sql(query, conn_rw))
    close_connection(conn_rw)
    return dataframes,querylist

您可以如下创建连接:

    def create_connection():
        conn = pyodbc.connect("DRIVER=Teradata;DBCNAME=tddb;UID=uid;PWD=pwd;QUIETMODE=YES", autocommit=True,unicode_results=True)
        return conn

您可以在此处检查完整的代码:GitHub链接 让我知道这是否回答了您的查询.

You can check complete code here : GitHub Link Let me know if this answers your query .

这篇关于将Teradata查询读入Pandas的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！