how to create a new CSV file

Asked May 13 '16 at 10:21

Active May 13 '16 at 10:43

Viewed 755 times

I'm not sure how to create csv file, I then also want to learn how to save data on it. I have variables I want to enter in python, and I want to transfer them to excel. I would be very grateful if someone could help me with this problem!

import csv


def nasif():
    myfile= open("MARIA.csv","wb")
    wr=csv.writer(myfile,quoting=csv.QUOTE_ALL)
    mylist=["Name","address","telephone"]
    wr.writerow(mylist)



def maria():
    c = csv.writer(open("MARIA.csv","rb"))

    c.writerow(["Name","address","telephone"])

edited May 13 '16 at 10:43

wolendranh

4,202
1
28
37

asked May 13 '16 at 10:21

Maria Kanellopoulos

Possible duplicate of [Writing a Python list of lists to a csv file](http://stackoverflow.com/questions/14037540/writing-a-python-list-of-lists-to-a-csv-file) – shivsn May 13 '16 at 10:26
2

Don't forget to close your file and check your open modes, but what's your problem exactly ? – polku May 13 '16 at 10:27
use python `xlrd` module for excel format. – Tanu May 13 '16 at 10:31
Unclear to me. Are you aware the 'r' in "rb" stands for *read*? – Jongware May 13 '16 at 10:44

how to create a new CSV file

0 Answers0