using inputs variables into csv file

Question

iam trying to save user input under the csvcolumns as shown below, but each input is being saved in its own row. Example: if you input John under the name variable, its being saved as j o h n below is the code.

import time
import csv
csvcolumns= [ "NAME", "CAR MAKE", "YEAR OF MANUFACTURE", "IDENTIFICATION     NUMBER", "DATE"]
Name= input("Enter your name: ")
Car_make= input("Enter your car make e.g Toyota probox: ")
YOM= input("Enter the car YOM: ")
ID= input("Enter your identification number details: ")
todays_date= time.strftime("%Y-%m-%d %H:%M:%S")
with open('E:\doo.csv', 'w') as csvFile:
  writer=csv.writer(csvFile, delimiter=',')
  writer.writerow(csvcolumns)
  writer.writerows(zip(Name, Car_make,YOM,ID,todays_date))


print("writing completed")

Seems to be a problem with python interpreting your String Name as an iterable sequence. — René Jahn
– René Jahn, Commented Oct 26, 2018 at 19:46

Slam · Accepted Answer · 2018-10-26 19:40:44Z

2

You're lost somewhere in complex things.

If all this data is single row, write it with

writer.writerow([Name, Car_make, YOM, ID, todays_date])

answered Oct 26, 2018 at 19:40

Slam

8,6621 gold badge40 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

using inputs variables into csv file

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related