import pandas as pd import sys import json df = pd.read_json("/var/lib/zabbix/output/db_metrics.json") table_list = [] for table_name in df.table_name: table_list.append({"{#TABLENAME}":table_name}) print(json.dumps(table_list))