AttributeError: 'DataFrame' object has no attribute 'as_matrix' in Python

Dung Do Tien Jul 03 2022 239

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.
  • J

    Juckke G Jul 03 2022

    To solve this issue please don't use as_matrix() method. You can use values 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.

Related Q&A May You Like

  1. TypeError: cannot unpack non-iterable NoneType object in Python
  2. AttributeError: 'set' object has no attribute 'extend' in Python
  3. ModuleNotFoundError: No module named 'click' in Python
  4. ImportError: cannot import name 'get_config' from 'tensorflow.python.eager.context'
  5. Error: pg_config executable not found in Python 3.10
  6. ValueError: Can only compare identically-labeled DataFrame objects in Python
  7. ValueError: I/O operation on closed file in Python 3
  8. AttributeError: 'dict' object has no attribute 'has_key' in Python
  9. AttributeError: type object 'datetime.datetime' has no attribute 'timedelta' in Python
  10. AttributeError: 'DataFrame' object has no attribute 'price' in Python
  11. SyntaxError: non-default argument follows default argument in Python
  12. Error: BrokenPipeError: [Errno 32] Broken pipe in Python 3
  13. Throw ImportError: No module named boto3 in Python 3
  14. AttributeError: 'str' object has no attribute 'decode' in Python
  15. TypeError: 'dict_values' object is not subscriptable in Python
Leave An Answer
* NOTE: You need Login before leave an answer

* Type maximum 2000 characters.

* All comments have to wait approved before display.

* Please polite comment and respect questions and answers of others.

Most Quizs Popular

Start Test

Javascript - Functions
Start Test

Asp.Net Core - Exam test 01
Start Test

Asp.Net Core - Exam test 02
Start Test

C# - Level Beginner

Popular Tips

This site uses cookies so that we can remember you and understand how you interact with our website. This allows us to improve and customize your browsing experience. See our Cookies Policy.
X Close