click_pandas_column_names.py

from datetime import datetime
import pandas as pd
from clickhouse_driver import Client

client = Client('localhost')

db_name = "db_name"
tables_list = ["table_1", "table_2"]
db_table_list = ["{db}.{tb}".format(db=db_name, tb=tb) for tb in tables_list]

for tb in db_table_list:
    result = client.execute("SELECT * FROM {tb}".format(tb=tb))
    
    columns = client.execute("DESCRIBE TABLE {tb}".format(tb=tb)) 
    cols = [c[0] for c in columns]
    
    df = pd.DataFrame(result, columns=cols)
    
    df["dt"] = pd.to_datetime(df["dt"], format="%Y-%m-%d")
    df["ts"] = pd.to_datetime(df["ts"], format="%Y-%m-%d %H:%M:%S")