with open('file.csv','a') as f:
        thewriter=csv.writer(f)

        thewriter.writerow({' name',' adult','child','reference'})
        thewriter.writerow([name,ad,ch,ref])

(Jan-30-2020, 10:36 AM)buran Wrote: obviously that is what the values for ad, ch and ref names are... We cannot tell what is going on without seeing that part of your code

also note that {' name',' adult','child','reference'} is a set, i.e. unordered container. Use a list or a tuple e.g. ['name','adult','child','reference']

in addition - do you really want to repeat the header above each data row?
Also note that when using csv module on Windows, you need to supply newline='' argument to open(). Not doing so result in extra blank line visible after each header/data row

import pickle
import csv

with open('file.csv','a',newline="") as f:
    thewriter=csv.writer(f)

    thewriter.writerow([' name',' adult','child','reference'])
        

ref=-1
av_seats=152

while True:    
    ad=int(input("Enter a  adult "))

    ch=int(input("Enter a  children "))
    name=input("Plese enter your name")

    totoal=ad+ch

    av_seats=av_seats-totoal
    ref=ref+1

    thewriter.writerow([name,ad,ch,ref])



    print("left are ",av_seats)
   
    op=input("press 'n' to terminate or any key to stop ").lower()
    if op=='n':
        break