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