====AQLQuery::Execute_DF====

This function is part of the [[AQLQuery|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 [[AQLQuery_Execute|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.