python csv add column name

Question

Can you help me please. how to add column name to csv file with python.

dirname = os.path.dirname(os.path.abspath(__file__))
csvfilename = os.path.join(dirname, 'csvfile.csv')
file_exists = os.path.isfile(csvfilename)
f = open(csvfilename,'a')
f.write(list[0] + ';' + '\r\n')
f.close()

By column name, do you mean you want a header in the first line of the file? What is list[0]? Is it a list containing multiple column names? — tdelaney
– tdelaney, Commented May 12, 2020 at 18:45
Does this answer your question? Pythonically add header to a csv file — Gahan
– Gahan, Commented May 12, 2020 at 18:46
Do you have an example CSV file? Just a few lines would do. Is there an existing header? Is this a semicolon separated file? — tdelaney
– tdelaney, Commented May 12, 2020 at 18:56

fsrfyama · Accepted Answer · 2020-05-12 19:09:35Z

3

may be you can add a header like this?

with open(csvfilename, 'wt', newline ='') as file:
    write_header = csv.writer(file, delimiter=',')
    write_header.writerow(i for i in list[0])

edited May 12, 2020 at 19:09

answered May 12, 2020 at 19:00

fsrfyama

3252 silver badges15 bronze badges

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

Comments

tdelaney · Accepted Answer · 2020-05-12 19:04:23Z

Since you just want to modify a single line of the file there isn't a need to run this all through a CSV processor. Its generally best not to read and write to the same file. You can create a temporary file and make the changes to the top of the file before copying the bulk.

import shutil

dirname = os.path.dirname(os.path.abspath(__file__))
csvfilename = os.path.join(dirname, 'csvfile.csv')
tmpfilename = os.path.join(dirname, 'csvfile.csv.tmp')
file_exists = os.path.isfile(csvfilename)

with open(csvfilename, 'rb') as f_in, open(tmpfilename, 'wb') as f_out:
    # discard current header
    next(f_in)
    # write new header
    f_out.write("colname\r\n".encode())
    # copy the rest of the file
    shutil.copyfileobj(f_in, f_out)
# replace original csv with fixed
shutil.move(tmpfilename, csvfilename)

Collectives™ on Stack Overflow

python csv add column name

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related