change header of csv python

Question

hi I am writing data on csv using python my code is something like this

name_keys =['Record_1', 'Record_2', 'Random_Name'] 

header_names =  ['Record 1', 'Record 2', 'Random Name'] 

with open(file_path, 'w', encoding='UTF8', newline='') as f:
    writer = csv.DictWriter(f, fieldnames=name_keys)
    writer.writeheader()
    writer.writerows(data)

issue is my header_names are suppose to be bit diff from name_keys . so how I can achieve this ? And I don't want to use pandas here.

Tim Roberts · Accepted Answer · 2022-02-16 21:58:14Z

1

Instead of

    writer.writeheader()

Fake a row of data:

    writer.writerow(dict(zip(name_keys,header_names)))

answered Feb 16, 2022 at 21:58

Tim Roberts

55.3k4 gold badges28 silver badges41 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

TNN Over a year ago

thanks sir , worked for me

Collectives™ on Stack Overflow

change header of csv python

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related