Attribute returns data as floats about piconnect

[Hugovdberg]

This should work:

list(zip(data.index, data))

See this StackOverflow question: https://stackoverflow.com/a/38468711/4398595

[Hugovdberg]

The recorded_values method returns a pandas.Series of the data, where the timestamps of the events are the index of the series.

The way you retrieve values from the series returns only the data at that location, but not its index. More information on getting subsets of pandas objects can be found on this page: Indexing and selecting data. If you would like to see the first 10 items of the data you could do this:

with PI.PIAFDatabase(server=servers[0],
                     database="Test") as database:
    element = database.descendant(
        r'Europe\A\B')
    attribute = element.attributes['DD']
    print(type(attribute))
    data = attribute.recorded_values('*-5mo', '*')
    print(data.head(10))

This is therefore not a bug in PIconnect, and I will close the issue. Feel free to comment if you think the way PIconnect returns the data is actually wrong.

[vadtam]

subset = data.head(10) is of type <class 'PIconnect.PIData.PISeries'>
cmd_output is as follows:
2017-01-12 15:04:47+01:00 204.395
2017-01-13 15:04:48+01:00 204.395
Name: Rate, dtype: object

How to convert them to (datetime, float) pairs? I tried several solutions from the internet, but it fails.