How to write .csv file in Python?

Question

I am running the following: output.to_csv("hi.csv") where output is a pandas dataframe.

My variables all have values but when I run this in iPython, no file is created. What should I do?

What kind of variable is `output`? I try to reproduce the issue, but when I have `output` as a string, I receive the error message `AttributeError: 'str' object has no attribute 'to_csv'`. — physicalattraction, May 18 '15 at 06:02
possible duplicate http://stackoverflow.com/questions/16923281/pandas-writing-dataframe-to-csv-file — Scott, May 18 '15 at 06:26
Does this answer your question? [Writing a pandas DataFrame to CSV file](https://stackoverflow.com/questions/16923281/writing-a-pandas-dataframe-to-csv-file) — AMC, Jan 23 '20 at 01:14

score 3 · Accepted Answer · answered May 18 '15 at 06:38

3

Better give the complete path for your output csv file. May be that you are checking in a wrong folder.

answered May 18 '15 at 06:38

Kathirmani Sukumar

10,445
5
33
34

i may delete this question since the issue was so banal. Thanks. – Eric Baldwin May 18 '15 at 06:41

score 0 · Answer 2 · answered May 18 '15 at 06:22

0

You have to make sure that your 'to_csv' method of 'output' object has a write-file function implemented.

And there is a lib for csv manipulation in python, so you dont need to handle all the work:

https://docs.python.org/2/library/csv.html

answered May 18 '15 at 06:22

648trindade

689
2
5
21

score 0 · Answer 3 · edited Jun 20 '20 at 09:12

I'm not sure if this will be useful to you, but I write to CSV files frequenly in python. Here is an example generating random vectors (X, V, Z) values and writing them to a CSV, using the CSV module. (The paths are os paths are for OSX but you should get the idea even on a different os.

Working Writing Python to CSV example

import os, csv, random

# Generates random vectors and writes them to a CSV file

WriteFile = True # Write CSV file if true - useful for testing


CSVFileName = "DataOutput.csv"
CSVfile = open(os.path.join('/Users/Si/Desktop/', CSVFileName), 'w')

def genlist():
    # Generates a list of random vectors

    global v, ListLength
    ListLength = 25 #Amount of vectors to be produced

    Max = 100 #Maximum range value

    x = [] #Empty x vector list
    y = [] #Empty y vector list
    z = [] #Empty x vector list

    v = [] #Empty xyz vector list

    for i in xrange (ListLength):
        rnd = random.randrange(0,(Max)) #Generate random number
        x.append(rnd) #Add it to x list

    for i in xrange (ListLength):
        rnd = random.randrange(0,(Max))
        y.append(rnd) #Add it to y list

    for i in xrange (ListLength):
        rnd = random.randrange(0,(Max)) #Generate random number
        z.append(rnd) #Add it to z list

    for i in xrange (ListLength):
        merge = x[i], y[i],z[i] # Merge x[i], y[i], x[i]
        v.append(merge) #Add merged list into v list

def writeCSV():
    # Write Vectors to CSV file

    wr = csv.writer(CSVfile, quoting = csv.QUOTE_MINIMAL, dialect='excel')
    wr.writerow(('Point Number', 'X Vector', 'Y Vector', 'Z Vector'))

    for i in xrange (ListLength):
        wr.writerow((i+1, v[i][0], v[i][1], v[i][2]))

    print "Data written to", CSVfile

genlist()

if WriteFile is True:
   writeCSV()

Hopefully there is something useful in here for you!

How to write .csv file in Python?

3 Answers3

Working Writing Python to CSV example