AttributeError: 'DataFrame' object has no attribute 'as_matrix' in Python
Dung Do Tien
Jul 03 2022
355
I try to create a Python application that will help me import and process a CSV file. My code is like this:
main.py
import pandas as pd
df = pd.read_csv('courses.csv')
arr = df.as_matrix() #convert the DataFrame to a NumPy array
print(arr)
And here is the format data of courses.csv
file:
name,time,price
Connect Skills,30,£90.09
Management Time,25,£80.10
LeaderShip,40,£10.19
Friend and family,£24.01
My code will load & read that CSV file, and use as_matrix()
method to help convert the DataFrame to a Numpy array. But it didn't work and throw an exception AttributeError: 'DataFrame' object has no attribute 'as_matrix'. You can see detailed exceptions here:
Traceback (most recent call last):
File "main.py", line 4, in <module>
arr = df.as_matrix() #convert the DataFrame to a NumPy array
File "/usr/lib/python3.8/site-packages/pandas/core/generic.py", line 5130, in __getattr__
return object.__getattribute__(self, name)
AttributeError: 'DataFrame' object has no attribute 'as_matrix'
** Process exited - Return Code: 1 **
Press Enter to exit terminal
I used Python 3.10. Anyone can explain and solve the issue to help me?
Thanks in advance.
Have 1 answer(s) found.
-
J0
Juckke G Jul 03 2022
To solve this issue please don't use
as_matrix()
method. You can usevalues
property to do. See an example below:import pandas as pd df = pd.read_csv('courses.csv') arr = df.values print(arr)
#Output
[['Connect Skills' '30' '£90.09'] ['Management Time' '25' '£80.10'] ['LeaderShip' '40' '£10.19'] ['Friend and family' '£24.01' nan]]
I hope this answer is useful to you.
* Type maximum 2000 characters.
* All comments have to wait approved before display.
* Please polite comment and respect questions and answers of others.