Writing series to a text file

Question

I have a long matrix (say A) with 10,000 rows and 2 columns in an excel file.

I need to copy each column in separate text files (say A0.txt, A1.txt);

I did the following

A0 = open("A0.txt", "w+")
A1 = open("A1.txt", "w+")
A0.write(A.iloc[:,0])
A1.write(A.iloc[:,1])

but the error is

TypeError: write() argument must be str, not Series

then, how can I write the series?

Take a look t this post https://stackoverflow.com/questions/22231592/pandas-change-data-type-of-series-to-string . — Azhy, Sep 09 '18 at 14:21
alternatively, you can try numpy np.savetxt('A0.txt', a.iloc[:,0].values, delimiter=',') — Anant Gupta, Sep 09 '18 at 14:22

score 3 · Accepted Answer · answered Sep 09 '18 at 14:32

3

You could do something like:

for col in A.columns:
    A[col].to_csv('A_'+col+'.txt', index=False, header=False)

and you will end up with one txt file per column.

answered Sep 09 '18 at 14:32

Mateo Torres

1 Answers1