User Input and CSV File

[Davy_Jones_XIV]

Hey peeps,

How do you take user input and populate a .csv file?

I know Python reads top to bottom, so I was thinking I needed to create the headers first and then create blank writer lines to fill in, but I know that isn't the correct flow. What happens when there are 10,000 user input lines, this would be a mess. Table, Drink, Count, Cost, Tab act as headers and all user input is supposed to follow underneath.

As always, any suggestions are much appreciated!

Below is a truncated example of the project I am working on:

import csv

def bar():

file = open ('Bar_March.csv', 'w')    

writer = csv.writer(file)    

writer.writerow(['Table', 'Drink', 'Count', 'Cost', 'Tab'])    

writer.writerow([''])    

writer.writerow([''])    

table = input('Bar or Table? ')

print(table)    

Drink = input('Refreshment? ')

print(Drink)

[buran]

you don't need to create blank lines. take all the user inputs necessary for one row, construct a list and pass this list to writerow() method. i.e. you need to write the whole line at once.

[Davy_Jones_XIV]

I think I understand what mean. I have figured some out, but it still is not coming out correctly. I'll keep at it.

you don't need to create blank lines. take all the user inputs necessary for one row, construct a list and pass this list to writerow() method. i.e. you need to write the whole line at once.