convert Dataframe to 2d Array

Question

I have a data-frame of size (140000,22) dimensions.

i have to create 2d array of equal dimensions to pass it into convolution neural network .

Can you please guide how to transform on this dataframe

Possible duplicate of [Convert pandas dataframe to NumPy array](https://stackoverflow.com/questions/13187778/convert-pandas-dataframe-to-numpy-array) — FChm, Feb 06 '19 at 08:29

score 15 · Answer 1 · answered Feb 06 '19 at 10:16

15

You just need to call .values on the DataFrame.

If for example your dataframe is called df, then you can pass df.values to your convolutional neural network.

answered Feb 06 '19 at 10:16

markuscosinus

Hi but the .values would give us a single array of whole dataframe right – KURUVILLA ABRAHAM Feb 06 '19 at 11:10
Yes, you are right. Sorry I didn't see that you asked for equal dimensions. What dimensions do you want the array to have? – markuscosinus Feb 06 '19 at 11:14
1

it should be 2D array of Equal dimensions so that i can fit it for a neural network – KURUVILLA ABRAHAM Feb 06 '19 at 15:50

score 1 · Answer 2 · answered Mar 01 '21 at 00:10

Use arr = df.to_numpy()

It will create a 2d array where each row is the inner array.

[[row1],
 [row2],
 [row3]...
 [row n]]

To turn it into a 2d array where each column is the inner array, use transpose:

arr = np.transpose(arr)

[[all_data_in_col_1],
 [all_data_in_col_2],...
 [all_data_in_col_n]]

2 Answers2