[PYTHON] 5. MySQL to csv file

Convert DB data to csv file

Use pandas

import pandas as pd

class Conver_csv:
    def db_csv(self):
        curs = db.cursor(pymysql.cursors.DictCursor)
        sql = 'select * from lotto_numbers'
        curs.execute(sql)
        
        data = pd.read_sql_query(sql, db)
        data.to_csv(path_or_buf = 'C:\lotto_crawl\crawl_practice\lotto_numbers.csv',
                    index       = False,
                    header      = True)
		db.close

• pymysql.cursors.DictCursor을 사용하여 value를 dictionary 형태로 리턴하여 column명을 명시