file = 'file.txt'

header_names = {'t1':'Test1', 't2': 'Test2','t3':'Test3'}


with open(file, 'w', newline='') as f:
    w = csv.DictWriter(f, fieldnames=header_names.keys(), restval='', extrasaction='ignore')
    w.writerow(header_names)
    for doc in res['test']['test']:
        my_dict = doc['test']



        w.writerow(my_dict)

Test1,Test2,Test3
Bob,john,Male
Cat,Long,female
Dog,Short,Male
Case,Fast,Male
Nice,who,Male

{header}
Filename:file.txt
date:current date so 20190321
delimited by: ,
generated: python

{data}
Test1,Test2,Test3
Bob,john,Male
Cat,Long,female
Dog,Short,Male
Case,Fast,Male
Nice,who,Male

{Footer}
this file was generated by using python.