PRG-pandas-sqlite-00

install

1122  pip3.7 install --upgrade  --force-reinstall  spyder==5.1 
1128  pip3.7 install --upgrade  pathlib2
1129  pip3.7 install --upgrade  pandas 
1130  pip3.7 install --upgrade  lxml db.py 

pandas のデータを sqlite3 に

import pandas as pd

import os
from pathlib2 import Path

import sqlite3

df2 = pd.read_csv('./d1.txt')

# DBファイル準備
db_name = u'db000.db'
conn = sqlite3.connect(db_name) 
cursor = conn.cursor()

# Master table
listtable=u"list_table"

# GET COLUMS
df00 = pd.read_sql_query(sql=u"SELECT * FROM list_table LIMIT 1", con=conn)
# print( df00.columns )

# GET SELECT sqlite->pandas
# df01 = pd.read_sql_query(sql=u"SELECT * FROM list_table", con=conn)
# print( df01 ) 

# APPEND    ( 'append' is create?? )
df2.to_sql( listtable, conn, if_exists='append', index=None)
# conn.commit()
conn.close()

apend がうまく行かない。。

  その２

#!/usr/bin/env python3
# -*- coding: utf-8 -*-
"""
Created on Mon Dec  7 13:35:13 2020
HTML データを sqlite.DB に保存する

@author: yourdata 
"""
import sqlite3
import pandas as pd
########
url='file:///home/data/DL/0000/201109/5555.html'

dfs = pd.read_html(url)

dfc = pd.DataFrame (    dfs[0]['タイトル']  )
dfs = dfc.rename( columns={'タイトル':0})

print ( dfs ) 
########
file_sq = "./d201207.db"
conn = sqlite3.connect(file_sq)
#
dfs.to_sql('dmmdata',conn,if_exists='append',index=None)
#
conn.close()
########