so i found the error pythonanywhere was trying to find the csv file in the folder where the mysite folder is located in

it basically created the csv file there and stored data it that file rather than saving it in the original file which is located inside the mysite folder

i simply deleted the the original one that i created and just added the headings to the csv file that pythonanywhere created