Numpy 2D array to Table

Question

I've got an 18x18 2d numpy array (it's a confusion matrix)...and I need/would like to display it as a table in an ipython notebook.

When I simply print it out, it displays with overlap--the rows are so long they take up two lines.

Is there a library that will allow me to print this array in a sort of spreadsheet format?

you could try to load it into a pandas dataframe. that should look much better. — Cleb
– Cleb, Commented Feb 28, 2016 at 15:39

Konstantinos Michael · Accepted Answer · 2016-02-28 15:38:46Z

21

You can use Pandas for that.

import pandas as pd
print pd.DataFrame(yourArray)

answered Feb 28, 2016 at 15:38

3913 silver badges7 bronze badges

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

Comments

Adam · Accepted Answer · 2023-09-13 01:55:43Z

1

A job for matrepr:

from matrepr import mdisplay

mat = np.random.random((18, 18))

mdisplay(mat, floatfmt=".2f", max_rows=18, max_cols=18)

answered Aug 29, 2023 at 5:06

Adam

17.5k8 gold badges55 silver badges103 bronze badges

guyomd · Accepted Answer · 2018-08-22 14:41:09Z

-1

Note: Konstantinos proposal holds only for 1-D and 2-D arrays!

You can use numpy.array2string():

from pprint import pprint
import numpy as np

array = np.array([[1,2,3], [4,5,6]])
print(np.array2string(array).replace('[[',' [').replace(']]',']'))

Output:

 [1 2 3]
 [4 5 6]

See also: Printing Lists as Tabular Data

answered Aug 22, 2018 at 13:47

guyomd

324 bronze badges