lundi 22 février 2016

SQLite not displaying data in Pycharm

I am using Pycharm to code my python projects and I downloaded some data from quandl and passed it into a pandas DataFrame.

I wrote the below code to put this DataFrame into a SQLite database (It works)

engine = sqlite3.connect(country + ".db")
mydata = Quandl.get('TSE/8703', returns='pandas')
mydata.to_sql(name='TSE/8703', con=engine)

When I use SQLite Browser to view the items in the database, it works and it shows that the data is saved correctly.

My problem is that I cant view the database items from Pycharm directly. When I double click on the database in Pycharm, nothing pops up.. Am I configuring something wrongly? Or? (The database driver that I downloaded is Sqlite (Xerial))

Any tips?

Aucun commentaire:

Enregistrer un commentaire