Read excel file in Django views using pandas module

Question

I'm trying to read an excel file using pandas in a views method.

But the server stopped with:

File "/Users/ronsair/anaconda3/lib/python3.6/site-packages/py/_error.py", line 44, in __getattr__
    raise AttributeError(name)    
AttributeError: __name__

Code:

import pandas as pd

def extract(request):
  df = pd.read_excel('update.xlsx')
  return render(request, "work/index.html")

Can you help please?

Can you share the full stack trace? Also can you make sure the excel file is within reach of the server (check your relative path)? — Vivek Kalyanarangan
– Vivek Kalyanarangan, Commented Nov 2, 2019 at 10:45
Here is the trace: github.com/ronscoder/Store/blob/master/error_pandas_django — ron
– ron, Commented Nov 2, 2019 at 12:53

ron · Accepted Answer · 2019-11-02 13:18:20Z

1

This was fixed after updating Pandas package from 0.22.0 to 0.25.3.

answered Nov 2, 2019 at 13:18

ron

1251 silver badge10 bronze badges

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

Collectives™ on Stack Overflow

Read excel file in Django views using pandas module

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related