add logic to update the pday column based on hourly obs