How to import from excel into a 2d numpy array?

Question

I'm trying to import the below data (excel file) into a 2D numpy array

My Python code:

spreadsheet = 'zone.xlsx'
data = pd.read_excel(spreadsheet)
x = data['x1'].values
y = data['x2'].values

x_train = np.concatenate((x,y))

The problem is that the output for x_train is [12, 34, 43, 34, 56, 89, 10, 11] and I would like to get the following output:

[[12, 56], [34, 56], [43,10], [34,11]]

Yes. When I check the .shape, the result is (8,). I want to get (4, 2,2) as .shape — Viorel
– Viorel, Commented Nov 30, 2020 at 14:12

ombk · Accepted Answer · 2020-11-30 14:14:00Z

1

x = np.array([1,2,3]).reshape(-1,1)
y= np.array([2,3,4]).reshape(-1,1)
np.concatenate([x,y],axis=1)

#output

array([[1, 2],
       [2, 3],
       [3, 4]])

np.concatenate([x,y],axis=1).tolist()
[[1, 2], [2, 3], [3, 4]]

answered Nov 30, 2020 at 14:14

ombk

2,1091 gold badge6 silver badges16 bronze badges

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

3 Comments

Viorel Over a year ago

It worked, first I transformed my Python label into a numpy array, then the reshape method worked. Thank you

ombk Over a year ago

@Viorel great ^_^

ombk Over a year ago

@Viorel accept answer to remove it from unanswered questions queue! thanks!

Collectives™ on Stack Overflow

How to import from excel into a 2d numpy array?

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related