equinor/tagreader-python

Reading non-numeric tags is NaN

Opened this issue · 3 comments

When reading tags that are not of numeric type, the tag is converted to a NaN value. This is due to line 489 of webhandlers.py and can be resolved by just removing the line. The line attempts to convert the tag to a numeric value, but it really should first check that the tag is numeric in the first place or allow the user to specify which tags are numeric.

# Ensure non-numericals like "1.#QNAN" are returned as NaN
df["Value"] = pd.to_numeric(df.Value, errors="coerce")

https://github.com/equinor/tagreader-python/blob/master/tagreader/web_handlers.py

This seems good, has this been patched?

Any update?

The only way I was able to overcome this is by using SQL extract.
c = tagreader.IMSClient()
df = c.query_sql(query=f"SELECT * FROM {table};",parse=False)

Using the experimental query_sql returns categorical values. Then use c.read() for numeric values. Not a solution, rather a workaround.