python怎么获取数据库表项的名字,如何在python中获取用于SQL查询的表列名称/标题...

I have the data in pandas dataframe which I am storing in SQLITE database using Python. When I am trying to query the tables inside it, I am able to get the results but without the column names. Can someone please guide me.

sql_query = """Select date(report_date), insertion_order_id, sum(impressions), sum(clicks), (sum(clicks)+0.0)/sum(impressions)*100 as CTR

from RawDailySummaries

Group By report_date, insertion_order_id

Having report_date like '2014-08-12%' """

cursor.execute(sql_query)

query1 = cursor.fetchall()

for i in query1:

print i

Below is the output that I get

(u'2014-08-12', 10187, 2024, 8, 0.3952569169960474)

(u'2014-08-12', 12419, 15054, 176, 1.1691244851866613)

What do I need to do to display the results in a tabular form with column names

解决方案

In DB-API 2.0 compliant clients, cursor.description is a sequence of 7-item sequences of the form (, , , , , , ), one for each column, as described here. Note description will be None if the result of the execute statement is empty.

If you want to create a list of the column names, you can use list comprehension like this: column_names = [i[0] for i in cursor.description] then do with them whatever you'd like.

Alternatively, you can set the row_factory parameter of the connection object to something that provides column names with the results. An example of a dictionary-based row factory for SQLite is found here, and you can see a discussion of the sqlite3.Row type below that.