'DataFrame' object has no attribute 'as_matrix

Question

import pandas as pd

from sklearn.model_selection import train_test_split

import pandas as pd

from sklearn.model_selection import train_test_split

from sklearn import ensemble

from sklearn.metrics import mean_absolute_error

from joblib import *

df = pd.read_csv('~/Downloads/Melbourne_housing_FULL.csv')

df.head(n=5)
del df['Address']
del df['Method']
del df['SellerG']
del df['Date']
del df['Postcode']
del df['Lattitude']
del df['Longtitude']
del df['Regionname']
del df['Propertycount']
df.dropna(axis=0, how='any', thresh=None, subset=None, inplace=True)
features_df = pd.get_dummies(df, columns=['Suburb', 'CouncilArea', 'Type'])
X = features_df.as_matrix()
y = df['Price'].as_matrix()

Can anyone please help me I am facing a error as soon as I put X = features_df.as_matrix() y = df['Price'].as_matrix() and I am learning Machine Learning with a book called Machine Learning with python by oliver... Any Help is highly appreciated Thankyou

`df.as_matrix()` is deprecated, see [this answer](https://stackoverflow.com/questions/53309250/pandas-as-matrix-to-values-keep-column-order). TL;DR try using `df.values`. — jfaccioni, Apr 08 '20 at 13:53

score 73 · Answer 1 · edited Jul 06 '21 at 17:19

73

df.as_matrix() was deprecated after version 0.23.0. Use df.values instead.

Follow this link for additional information.

edited Jul 06 '21 at 17:19

Alex Metsai

1,837
5
12
24

answered Aug 07 '20 at 01:05

TUSHAR

863
6
9

29

df.values --> no parantheses – Arash Vahabpour Sep 15 '20 at 07:04

score 17 · Answer 2 · answered Aug 21 '20 at 21:12

17

Dataframe depricated a lot of attributes such as .ix

Here you need this command:

y = df['Price'].values

answered Aug 21 '20 at 21:12

Code42

2,292
1
17
22

score 14 · Answer 3 · answered Mar 11 '21 at 08:57

14

Replacing .as_matrix() with .values() also resulted in an error, but replacing it with .to_numpy() worked perfectly

Convert the DataFrame to a NumPy array.

New in version 0.24.0.

answered Mar 11 '21 at 08:57

Valdas

198
1
7

2

`.values()` wouldn't have worked because it is not a method. Use `.values` instead. – Tom Cupis Apr 30 '22 at 21:27

score 5 · Answer 4 · answered May 19 '21 at 09:28

5

As of Pandas 1.0 use .to_numpy() other ways are deprecated according to the docs

answered May 19 '21 at 09:28

juan Isaza

3,646
3
31
37

'DataFrame' object has no attribute 'as_matrix

4 Answers4

Linked