python to_csv

import pyodbc
import pandas as pd # 引用套件並縮寫為 pd

cnxn = pyodbc.connect("DRIVER={MySQL ODBC 8.0 Unicode Driver}; SERVER=localhost; PORT=3306;DATABASE=my_db; UID=root; PASSWORD=xxxxx;OPTION=3;CHARSET=UTF8;")
SQL = "SELECT * FROM expense where PAY_DATE > '2020/1/1' order by PAY_DATE desc"
df = pd.read_sql(SQL, cnxn)
cnxn.close()
df.to_csv('Result.csv')

###############################

import pandas as pd

df = pd.read_csv("C:/data/data.csv")

df.to_csv("C:/data/data_output.csv")