はてなブックマーク

import pandas as pd from sqlalchemy import create_engine import sqlalchemy as sa import sys import datetime class MySqlPandas(): def __init__(self): self.engine = create_engine('mysql+pymysql://{USER}:{PASSWORD}@{HOST}:{PORT}/{DB NAME}') def sesStoreData(self): sql = ''' SELECT tb.hoge1 , tb.hoge2 , tb.hoge3 FROM table tb ; ''' df = pd.read_sql_query(sql, self.engine) df.to_csv('ses_table_' + str(