python - Pandas 数据框进入数据库，类型错误: Required argument 'database' (pos 1) not found

Question

我想使用 sqlite3 和 Python3 将 pd 数据帧插入数据库

df = pd.DataFrame(maindatatable)
print (df)

con = sqlite3.connect(host="localhost",user="milenko",passwd="******",db="dbase")
sql.write_frame(df, con=con, name='table_name_for_df', if_exists='replace', flavor='mysql')

It doesn't work
  File "b23.py", line 36, in <module>
    con = sqlite3.connect(host="localhost",user="milenko",passwd="*******",db="dbase")
TypeError: Required argument 'database' (pos 1) not found

如果我回到MySQL

show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ap1                |
| classicmodels      |
| dbase              |
| mysql              |
| performance_schema |
| sys                |
+--------------------+

数据库就在这里，那么有什么问题吗？

如果我改为

con = sqlite3.connect("dbase")

然后

AttributeError: module 'pandas.io.sql' has no attribute 'write_frame'

Answer 1

sqlite3.connect("dbase")

只需使用这一行，您不需要所有这些