pandas를 활용하여 postgresql 테이블을 csv로 저장하기

pandas를 활용하여 postgresql 테이블을 csv로 저장하기

728x90

- flask에서 postgreSQL 테이블 내용을 csv로 저장하는 함수 작성코드

import psycopg2 as pc import pandas as pd dataReceive = request.get_json() df = get_data(dataReceive) def get_data(req_data): try: conn = pc.connect("dbname=디비이름 user=계정 password=암호") curs = conn.cursor() sql = "Select {0}, date, region_cd, {1} From 테이블이름 where {2} > 0 order by date".format(req_data['name'], fieldstr, req_data['name']) df = pd.read_sql(sql, conn) df.to_csv("/experiment/result.csv", encoding='utf-8', header = True, doublequote = True, sep=',', index=False) print("CSV File has been created") conn.close() except Exception as error: logger.warn("ERROR in get_data function") logger.warn(error) return df

728x90

from http://may9noy.tistory.com/410 by ccl(A) rewrite - 2021-12-22 16:27:05