error when writing numpy into csv file

Question

I want to save a numpy array into a CSV file. My code gives me an error:

import os
import pandas as pd
import numpy as np

path ='/Users/mas/Documents/workspace/Avito/input/'                          # path to testing file

sample = pd.read_csv(path + 'sampleSubmission.csv')

index = sample.ID.values - 1

test =  np.array(pd.read_csv(path + 'dataset5test.csv'))

#print new[0:10,:]

new = test[index,:]

np.savetxt(path + 'testSearchStream9.csv', new, delimiter=",")

os.system('say "Done"')

This is the error that I get:

    np.savetxt(path + 'testSearchStream9.csv', new, delimiter=",")
  File "/System/Library/Frameworks/Python.framework/Versions/2.7/Extras/lib/python/numpy/lib/npyio.py", line 1061, in savetxt
    fh.write(asbytes(format % tuple(row) + newline))
TypeError: float argument required, not str

Roman Luštrik · Accepted Answer · 2015-07-14 12:27:05Z

3

You have to specify the form of data that you are going to save .By default it takes float as format

np.savetxt(path + 'testSearchStream9.csv', new, delimiter=",", fmt="%s")

See section on savetxt function of SciPy documentation.

edited Jul 14, 2015 at 12:27

Roman Luštrik

70.9k25 gold badges160 silver badges203 bronze badges

answered Jul 14, 2015 at 11:06

The6thSense

8,3559 gold badges38 silver badges67 bronze badges

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

Collectives™ on Stack Overflow

error when writing numpy 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