作者xy210742 (Sam)
看板Python
标题[问题] SQLite3 将资料存在资料库中
时间Sat Jul 14 19:25:16 2018
各位大大好 小弟非本科系生 目前自学Python3
程式码如下:(Python3.6)
import sqlite3
with sqlite3.connect('c.sqlite') as db:
c.to_sql('c',con=db,self.if_exists='append')
(c这资料是用pandas将台银牌告汇率爬取下来,参考如下网址:
https://www.youtube.com/watch?v=-c5rrzjsN34)
错误:
File "<ipython-input-56-246156207101>", line 3
c.to_sql('c',con=db,self.if_exists='append')
^
SyntaxError: keyword can't be an expression
题目只是单纯将c这资料存在资料库中
另若是把self.拿掉
则出现以下错误:
OperationalError Traceback (most recent call last)
<ipython-input-57-e5a3883ff452> in <module>()
1 import sqlite3
2 with sqlite3.connect('c.sqlite') as db:
----> 3 c.to_sql('c',con=db,if_exists='append')
c:\users\sam\appdata\local\programs\python\python36-32\lib\site-packages\pandas\core\generic.py
in to_sql(self, name, con, schema, if_exists, index, index_label, chunksize,
dtype)
2128 sql.to_sql(self, name, con, schema=schema,
if_exists=if_exists,
2129 index=index, index_label=index_label,
chunksize=chunksize,
-> 2130 dtype=dtype)
2131
2132 def to_pickle(self, path, compression='infer',
c:\users\sam\appdata\local\programs\python\python36-32\lib\site-packages\pandas\io\sql.py
in to_sql(frame, name, con, schema, if_exists, index, index_label, chunksize,
dtype)
448 pandas_sql.to_sql(frame, name, if_exists=if_exists, index=index,
449 index_label=index_label, schema=schema,
--> 450 chunksize=chunksize, dtype=dtype)
451
452
c:\users\sam\appdata\local\programs\python\python36-32\lib\site-packages\pandas\io\sql.py
in to_sql(self, frame, name, if_exists, index, index_label, schema,
chunksize, dtype)
1478 if_exists=if_exists,
index_label=index_label,
1479 dtype=dtype)
-> 1480 table.create()
1481 table.insert(chunksize)
1482
c:\users\sam\appdata\local\programs\python\python36-32\lib\site-packages\pandas\io\sql.py
in create(self)
571 "'{0}' is not valid for
if_exists".format(self.if_exists))
572 else:
--> 573 self._execute_create()
574
575 def insert_statement(self):
c:\users\sam\appdata\local\programs\python\python36-32\lib\site-packages\pandas\io\sql.py
in _execute_create(self)
1249 with self.pd_sql.run_transaction() as conn:
1250 for stmt in self.table:
-> 1251 conn.execute(stmt)
1252
1253 def insert_statement(self):
OperationalError: duplicate column name: Date
希望各位大大可帮小弟解惑一下
谢谢 感恩
--
※ 发信站: 批踢踢实业坊(ptt.cc), 来自: 123.192.84.222
※ 文章网址: https://webptt.com/cn.aspx?n=bbs/Python/M.1531567519.A.0A8.html
1F：→ Raymond0710: 不用self吧 07/14 19:35
※ 编辑: xy210742 (123.192.84.222), 07/14/2018 19:56:16
2F：→ kenduest: 怎麽感觉看到 pandas 语法，是不是整个搞错了 07/15 06:44
3F：→ kenduest: 你的程式码也不完整，建议整个张贴好确认 07/15 06:47
※ 编辑: xy210742 (123.192.81.136), 07/15/2018 16:43:40