def generate_excel(): #make table based on pgadmin4 import psycopg2 import re import pandas as pd column_names = [] conn = psycopg2.connect("dbname='d8kmt03u16v621' user='ub7ar8om9fr3du' host='ec2-34-255-107-246.eu-west-1.compute.amazonaws.com' port='5432' password='p8fd5edd65c34fc3821be8507673ed326c4f116b7d4e7a6515765dab9fdafd028'") cur = conn.cursor() cur.execute("""select * from (SELECT "label","time_started_utc","code" FROM public.otree_participant ORDER BY id ASC ) tm """) column_names = [desc[0] for desc in cur.description] result = cur.fetchall() df=pd.DataFrame(list(result),columns=column_names) df.to_excel("result_time_utc.xlsx",sheet_name='result') generate_excel()