Hi all,
After i had issues with my submissions i implemented an extrem logging (submission number: #119545).
Without changing anything on the x_raw i implemented following lines:
get length x_raw:
print(paste("raw: ",length(x_raw$year)))
and compare it with the length of unqiue id_policy - year combinations.
x_raw$id_policy_year = paste(x_raw$id_policy, x_raw$year, sep = “-”)
print(paste("unique pol_year: ",length(unique(x_raw$id_policy_year))))
As generally stated it should not happen, that a policy exist more often than once in a year.
However when looking into the log file of my submission i see following:
[1] “raw: 2000”
[1] “unique pol_year: 1999”
Meaning there is a policy_id - year combination which exists twice in the x_raw file which destroys my code.
Can you please have a look and let me know if this is a bug?
Thanks a lot and best regards.