search

enverus-ea / enverus-developer-api

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

v3.to_dataframe() error #20

Open CPESevans opened 1 year ago

CPESevans commented 1 year ago

I tried the to_dataframe example at the bottom of the README file and got the error KeyError: 'VARCHAR(32)'.

On line 366 there is a map of all the possible datatypes, but I was thinking it's missing VARCHAR(32) and that's what's throwing the issues.

dtypes_mapping = { "TEXT": "object", "NUMERIC": "float64", "REAL": "float64", "DOUBLE": "float64", "DATETIME": "object", "SMALLINT": "Int64", "INT": "Int64", "INTEGER": "Int64", "BIGINT": "Int64", "VARCHAR": "object", "DATE": "object" }

Perhaps adding "VARCHAR(32)":"object" to the dictionary would fix it?

joseramosenverus commented 1 year ago

@CPESevans Cant reproduce issue. Can you provide the following?

OS name and version

Python version

full log of program launch in debug mode