updating data format for analysis