python + elasticsearch

from elasticsearch import Elasticsearch
from elasticsearch_dsl import Search
import openpyxl
import json


class ProjIndex:

    def __init__(self):
        self.esnode = Elasticsearch(hosts="192.168.2.10")
        self.category = ["TU", "MC", "CH", "ET", "FO", "KE", "KM"]

    def searchIndx(self):
        with open("./index_list.json", "r", encoding="utf-8") as f:
            jdoc = json.loads(f.read())
            for c in self.category:
                for v in dict(jdoc[c]).keys():
                    print ("{cat} #[{indx_name}] => {indx_cnt}".format(
                        cat = c,
                        indx_name =  v,
                        indx_cnt = Search(using=self.esnode).index(jdoc[c][v]).count()))

def main():
    pnode = ProjIndex()
    pnode.searchIndx()

if __name__ == "__main__":
    main()