Convert python pandas dataframe rows or columns into numpy array

Question

I have a data frame like this. [from csv file]

       l1  p1 p2 p3 ... p10
    0   ↑  ←---- rows ----→
    1   |  ←---- rows ----→
    2   c  ←---- rows ----→
    3   o  ←---- rows ----→
    .   l  ←---- rows ----→
    .   |  ←---- rows ----→
    9   ↓  ←---- rows ----→

I want to convert l1 column into numpy array like this
[ ←, -, c, o, l, -, →] size : 10
and all the remaining columns into another numpy array like this\

[[ ← - r o w s - →],
 [ ← - r o w s - →],
 [ ← - r o w s - →]]    size: (10, 10)

Also

columns in the data frame are images so how can I further divide my data frame like this

           l1   p1 p2 .... p784
    0       ↑  ←---- rows ----→
    1       |  ←---- rows ----→
    2       c  ←---- rows ----→
    3       o  ←---- rows ----→
    .       l  ←---- rows ----→
    .       |  ←---- rows ----→
    27455   ↓  ←---- rows ----→

After getting the rows array on this data frame I will have numpy array of size(27455, 784) How to further split this array into size(27455, 28, 28)

how to do this !!
any other way will also be appreciated !!

BENY · Accepted Answer · 2020-06-28 14:49:10Z

2

Try

col=df.l1.to_numpy()

ary=df.drop('l1',axis=1).to_numpy()

answered Jun 28, 2020 at 14:49

BENY

324k22 gold badges176 silver badges250 bronze badges

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

3 Comments

luckyCasualGuy Over a year ago

I was about to accept your answer than system said to wait for 7 min !! Than I was editing the question and here I am ...

BENY Over a year ago

@Manan df.drop('l1',axis=1).to_numpy().reshape(len(df),-1,28).shape for you update question

luckyCasualGuy Over a year ago

(o_ _)ﾉ彡☆ Nice !!

Collectives™ on Stack Overflow

Convert python pandas dataframe rows or columns into 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