Adding new column with the header containing date at the beginning of CSV file

I was looking on Stackoverflow for this thing but I didn't find exactly what I wanted. I would like to open csv file on Python and add new column with header "Date" and until end of the file add today's date. How can I do it? I was trying to do it with pandas but I only know how to append to the end.

I was trying to do this that way with package csv:

x=open(outfile_name1)
y=csv.reader(x)
z=[]
for row in y:
    z.append(['0'] + row)

Instead of ['0'] I wanted to put today's date. Can I then convert this list to csv with pandas or something? Thanks in advance for help!

Try this:

import pandas as pd
import datetime

df = pd.read_csv("my.csv")
df.insert(0, 'Date', datetime.datetime.today().strftime('%Y-%m-%d'))
df.to_csv("my_withDate.csv", index=False)

PS: Read the docs

Is this what you are looking for?

import pandas as pd
import datetime

df = pd.read_csv("file.csv")
df['Date'] = datetime.datetime.today().strftime('%Y-%m-%d')
df.to_csv("new_file.csv", index=False)

As far as I undestand ultimate goal is to write data to csv. One option to do that is to open first file for reading data, second for writing data then write header row into new file prepending it with column name 'Date,' and then iterate over data rows prepending them with date (requires 3.6 <= Python as uses f-strings):

import datetime

with open('columns.csv', 'r') as out, open('out.csv', 'w') as into:
    headers = 'Date,' + next(out)
    print(headers, end='', file=into)
    for row in out:
        print(f'{datetime.datetime.today().date()}, {row}', end='', file=into)