In [9]:

    

import sqlite3


    

In [10]:

    

db = "./npi_data.db"
conn = sqlite3.connect(db)
c = conn.cursor()


    

In [11]:

    

c.execute("DROP table npi_table")


    

    
Out[11]:





<sqlite3.Cursor at 0x451bce0>

In [12]:

    

cmd = "CREATE TABLE npi_table (Name TEXT,\
                               Business_name TEXT,\
                               City TEXT,\
                               State TEXT)"

c.execute(cmd)


    

    
Out[12]:





<sqlite3.Cursor at 0x451bce0>

In [13]:

    

conn.commit()


    

In [14]:

    

conn.close()


    

In [14]: