import pandas as pd import sys import json df = pd.read_json("/var/lib/zabbix/output/apache2_user_agent_metrics-2.json") norm_user_agent_list = [] for norm_user_agent in df.norm_user_agent: norm_user_agent_list.append( {"{#NORM_USER_AGENT}":norm_user_agent} ) print( json.dumps(norm_user_agent_list) )