import datetime as dt
today = dt.datetime.today().strftime('%m%d%Y')
output_file = 'filename_{}.csv'.format(today)
import pandas as pd
today = dt.datetime.today().strftime('%m%d%Y') # to set the date in the csv filename
df.to_csv('csv_name_{}.csv'.format(today))