Writing array to csv python (one column)

Question

I'm trying to write the values of an array to a .csv file in python. But when I open the file in excel, the data is shown in one row. I want to have one column where each member of the array is a row.

The array "testLabels" is of the form:

array(['deer', 'airplane', 'dog', ..., 'frog', 'cat', 'truck'], 
  dtype='<S10')

And the code I use to write to the csv is:

import csv
resultFile = open("/filepath",'wb')
wr = csv.writer(resultFile)
wr.writerows([testLabels])

Any help would be greatly appreciated.

The question has long been answered with suggestions on python side. However, using a function in MS Excel would have been easier: Simply use the text-to-columns function. — MERose
– MERose, Commented Feb 17, 2015 at 13:41

deostroll · Accepted Answer · 2014-01-30 19:43:34Z

13

Try this:

wtr = csv.writer(open ('out.csv', 'w'), delimiter=',', lineterminator='\n')
for x in arr : wtr.writerow ([x])

answered Jan 30, 2014 at 19:43

deostroll

12k22 gold badges94 silver badges168 bronze badges

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

Comments

MatthieuBizien · Accepted Answer · 2014-01-30 19:24:09Z

6

You should change the delimiter. CSV is Comma Separated Value, but Excel understands that a comma is ";" (yeah weird). So you have to add the option delimiter=";", like

csv.writer(myfile, delimiter=";")

edited Jan 30, 2014 at 19:24

answered Jan 30, 2014 at 19:12

MatthieuBizien

1,7251 gold badge10 silver badges19 bronze badges

1 Comment

deostroll Over a year ago

The delimiter excel uses is configurable...but its not through excel though: howtogeek.com/howto/21456/…

Carlos Hanson · Accepted Answer · 2014-01-30 19:25:08Z

1

You need to write each item of list to a row in the CSV file to get them into one column.

for label in testLabels:
    wr.writerows([label])

answered Jan 30, 2014 at 19:25

Carlos Hanson

986 bronze badges

Comments

Pratyush Tripathy · Accepted Answer · 2018-11-30 06:09:18Z

1

Try this:

import csv
import numpy as np
yourArray = ['deer', 'airplane', 'dog', ..., 'frog', 'cat', 'truck']
yourArray = np.array(yourArray)

with open('outputFile.csv', 'w', newline='') as csvfile:
    writer = csv.writer(csvfile, delimiter=',')
    for row in range(0,yourArray.shape[0]):
        myList = []
        myList.append(yourArray[row])
        writer.writerow(myList)

answered Nov 30, 2018 at 6:09

Pratyush Tripathy

1412 silver badges4 bronze badges

Comments

Altan · Accepted Answer · 2019-03-29 17:48:39Z

0

Try this:

    for i in range(len(testLabels)):
        result_file = open('filePath.csv', 'a')
        result_file.write("{}{}".format(testLabels[i], '\n'))

answered Mar 29, 2019 at 17:48

Altan

11 bronze badge

Collectives™ on Stack Overflow

Writing array to csv python (one column)

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

1 Comment

Comments

Comments

Comments

Linked

Related