added pandas data frames handling to macro data analysis