Saving a matrix with columns' header in python

Question

I have the following code. When i save it. The headers of columns don't save. Could u please guide me?

import numpy as np
import pandas as pd

A = np.random.randint(0, 10, size=36).reshape(6, 6)

df = pd.DataFrame(A,  columns=['one', 'two', 'three','four','five','six'])
np.savetxt("/home/dataset/test.csv",df, delimiter=",")

`savetxt` takes a `header` parameter. Format your column names as a string and use that. — hpaulj, Nov 14 '15 at 17:21

score 1 · Accepted Answer · answered Nov 14 '15 at 16:03

1

Use the built-in pandas function for this:

df.to_csv("your_file_path_here")

answered Nov 14 '15 at 16:03

Chris McDonald

176
7

Saving a matrix with columns' header in python

1 Answers1