xl2nlu_md.py

import pandas as pd

input_file_name = 'Tamil_NLU_Collation.xls'
# update it based on your xl file.
sheets = ['Generic NLU', 'Generic FAQs', 'Collection_Response+FAQ Intent']

output_file = open('result/nlu.md',"w")
list_intents = open('result/list_intent.txt',"w")

for sheet in sheets:
    df = pd.read_excel(input_file_name, sheet_name=sheet)
    output_file.write(f"# {sheet}\n\n")
    print(sheet)
    # print(df.columns)
    new_l = []

    for i in df.columns:
        if "Unnamed" in i:
            pass
        else:
            new_l.append(i)
            list_intents.write(f"- {i}\n")

    for intent in new_l:
        output_file.write(f"\n## {intent}\n")
        for i in df[intent]:
        # print(type(i))
            if isinstance(i,float):
                pass
            else:
                output_file.write(f"- {i}\n")
    
    output_file.write("\n\n")