Convert pandas series into numpy array

Question

I am new to pandas and python. My input data is like

category   text
1   hello iam fine. how are you
1   iam good. how are you doing.

inputData= pd.read_csv(Input', sep='\t', names=['category','text'])
X = inputData["text"]
Y = inputData["category"]

here Y is the panda series object, which i want to convert into numpy array. so i tried .as_matrix

YArray= Y.as_matrix(columns=None)
print YArray

But i got the output as [1,1] (which is wrong since i have only one column category and two rows). I want the result as 2x1 matrix.

`.values` wil be shunned in favour of two new methods starting v0.24.0. See [this answer.](https://stackoverflow.com/a/54324513/4909087) — cs95, Jan 23 '19 at 10:09

score 82 · Answer 1 · answered May 29 '17 at 09:20

82

To get numpy array, you need

Y.values

answered May 29 '17 at 09:20

gzc

7,200
6
34
60

when i do Y.values(), it throws, TypeError: 'numpy.ndarray' object is not callable – vishnu May 29 '17 at 09:28
4

@vishnu It's a property, not a method. – gzc May 29 '17 at 09:29
thanks. but reshape worked for me! – vishnu May 29 '17 at 10:01
@vishnu Not sure the original post is updated based on your comment, but the way is to do Y.values, not Y.values(). – Err Dec 25 '21 at 19:53

score 15 · Accepted Answer · answered May 29 '17 at 09:48

15

Try this:
after applying the .as_matrix on your series object

Y.reshape((2,1))

Since .as_matrix() only returns a numpy-array NOT a numpy-matrix. Link here

answered May 29 '17 at 09:48

chetan reddy

310
1
11

2

reshape is deprecated use Y.values.reshape(2,1) instead. – Arpit Sisodia Dec 17 '18 at 16:09

score 13 · Answer 3 · answered Jan 07 '19 at 13:14

13

If df is your dataframe, then a column of the dataframe is a series and to convert it into an array,

df = pd.DataFrame()
x = df.values
print(x.type)

The following prints,

<class 'numpy.ndarray'>

successfully converting it to an array.

answered Jan 07 '19 at 13:14

Akshaya Natarajan

1,605
13
16

Convert pandas series into numpy array

3 Answers3