estate_data
columns = ['price', 'year', 'dong', 'apartname', 'month', 'day', 'space', 'address', 'addresscode', 'floor']
df = pd.DataFrame(estate_data, columns=columns)
from sqlalchemy import create_engine
db.close() ### 이전 DB 커넥션을 끊어주세요
engine = create_engine("mysql+pymysql://davelee:"+"korea356"+"@funcoding-db.ca1fydhpobsc.ap-northeast-2.rds.amazonaws.com:3306/estate_db?charset=utf8", encoding='utf-8')
conn = engine.connect()
df
df.to_sql(name='estate_new', con=engine, if_exists='append', index=False)
conn.close()
import pymysql
import pandas as pd
host_name = "funcoding-db.ca1fydhpobsc.ap-northeast-2.rds.amazonaws.com"
username = ""
password = ""
database_name = "estate_db" # 데이터베이스 이름을 sakila 로 바꿔줘야 합니다.
db = pymysql.connect(
host=host_name, # DATABASE_HOST
port=3306,
user=username, # DATABASE_USERNAME
passwd=password, # DATABASE_PASSWORD
db=database_name, # DATABASE_NAME
charset='utf8'
)
SQL = "SELECT * FROM estate_new LIMIT 1"
df = pd.read_sql(SQL, db)
df
SQL = "DESC estate_new"
df = pd.read_sql(SQL, db)
df
SQL = "SELECT COUNT(*) FROM estate_new"
df = pd.read_sql(SQL, db)
df
db.close() ### 이전 DB 커넥션을 끊어주세요