Python Forum
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
User Input and CSV File
#1
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)
Reply
#2
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.
If you can't explain it to a six year old, you don't understand it yourself, Albert Einstein
How to Ask Questions The Smart Way: link and another link
Create MCV example
Debug small programs

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

(Mar-24-2020, 05:57 AM)buran Wrote: 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.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  WHILE LOOP NOT RETURNING USER INPUT AFTER ZerroDivisionError! HELP! ayodele_martins1 7 990 Oct-01-2023, 07:36 PM
Last Post: ayodele_martins1
  restrict user input to numerical values MCL169 2 869 Apr-08-2023, 05:40 PM
Last Post: MCL169
  user input values into list of lists tauros73 3 1,025 Dec-29-2022, 05:54 PM
Last Post: deanhystad
Information How to take url in telegram bot user input and put it as an argument in a function? askfriends 0 1,033 Dec-25-2022, 03:00 PM
Last Post: askfriends
Question Take user input and split files using 7z in python askfriends 2 1,030 Dec-11-2022, 07:39 PM
Last Post: snippsat
Sad how to validate user input from database johnconar 3 1,837 Sep-11-2022, 12:36 PM
Last Post: ndc85430
  How to split the input taken from user into a single character? mHosseinDS86 3 1,137 Aug-17-2022, 12:43 PM
Last Post: Pedroski55
  Use pexpect to send user input alisha17 0 1,827 May-10-2022, 02:44 AM
Last Post: alisha17
  WHILE Loop - constant variables NOT working with user input boundaries C0D3R 4 1,434 Apr-05-2022, 06:18 AM
Last Post: C0D3R
  Reading an Input File DaveG 1 1,213 Mar-27-2022, 02:08 AM
Last Post: deanhystad

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020