enverus-ea / enverus-developer-api

Enverus Developer API Python Client
MIT License
19 stars 16 forks source link

DeveloperAPIv3.ddl() script VS DeveloperAPIv3.to_dataframe() #9

Open TowerRockOG opened 3 years ago

TowerRockOG commented 3 years ago

A call to DeveloperAPIv3.ddl() for the permits table returns a create table script with the 44th column as PermitID.

A subsequent call to DeveloperAPIv3.to_dataframe() for the permits table returns a dataframe without the PermitID column.

Instead, the PermitID column is used as the index, so it is present in the dataframe, but not in the 44th position.

I believe the default behavior of to_dataframe() should return a pandas dataframe with columns that match the response given by ddl().