Python AttributeError: module 'pandas' has no attribute 'Dataframe'

Question

I'm very new to python and pandas and I'm working a project for a distance matrix. I got an API that gets distance data from two points and I 'd like to export to excel or csv.

I'm getting a module "pandas" has no attribute "Dataframe"

import requests
import json
import pandas as pd



origin="Centro Hospitalar Universitário de São João, E. P. E"
destination="Braga"
api="api"

response=requests.get("https://api.distancematrix.ai/maps/api/distancematrix/json?        origins="+origin+"&destinations="+destination+"&key="+api+"")

print(response.status_code)
print(response.json())


df=pd.Dataframe.from_dict(response.json())
df.to_excel("filepath")

I tried capitalizing Dataframe and made sure that I don't have any pd variable or pandas.py file name

svfat · Accepted Answer · 2022-11-03 16:53:39Z

1

It is DataFrame, python is case-sensitive, so use it like this:

df = pd.DataFrame.from_dict(response.json())

answered Nov 3, 2022 at 16:53

svfat

3,3931 gold badge18 silver badges34 bronze badges

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

Collectives™ on Stack Overflow

Python AttributeError: module 'pandas' has no attribute 'Dataframe'

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