python数据分析用什么数据库

import sqlite3

with sqlite3.connect(":memory:") as con:

    c=con.cursor()  #创建游标

    c.execute('''CREATE TABLE sensors(data text,city text,code text,sensor_id real,temperature real)''') #新建表，text和real分别表示字符串和数值的类型

    for table in c.execute("SELECT name FROM sqlite_master WHERE type='table'"):

        print "Table",table[0]

        c.execute("INSERT INTO sensors VALUES ('2016-11-05','Utrecht','Red',42,15.14)")

        c.execute("SELECT * FROM sensors")

        print c.fetchone()  #输出插入记录

        con.execute("DROP TABLE sensors")  #删除表

        print "# of tables",c.execute("SELECT COUNT(*) FROM sqlite_master WHERE type='table'").fetchone()[0]

c.close()

Table sensors

(u'2016-11-05', u'Utrecht', u'Red', 42.0, 15.14)

# of tables 0