AQLQuery::Execute_DF
This function is part of the AQLQuery class.
Execute_DF is used to run an AQL query on the ARDI server and convert the historical information returned into a Pandas dataframe.
Python does a considerable amount of processing on the data to give you a Complete Dataframe.
If the data doesn't contain historical information (ie. the query doesn't use the GETHISTORY function), we suggest using Execute.
Parameters
| Name | Description | Default |
|---|---|---|
| Query | The AQL query to run | |
| namemap | A map used to rename the channels of data from ARDI | None |
| serverzone | The timezone of the server | |
| localzone | The 'local' timezone you want the results in | |
| mapbad | Used to replace specific data values with N/A | None |
| mapna | A dictionary linking column names to the value you want to replace any 'bad' data with. | None |
| autofill | Fill missing values | True |
| pad | Pad the results with missing times | True |
Return Value
This function returns a Pandas Complete Dataframe with all of the data from your query.
If no timezones are given, your resulting data will usually be in UTC.