Hello Hamdi,

The test set is at the tail end of every field. Carefully observing the details in the info section and train data will put you in the right direction.

However, see starter code below in R. Hope it helps

#Convert timestamp to date and time in train, i.e. col timestamp3 below

Wazi <- cbind(Wazi,timestamp3 = strptime(Wazi$timestamp , format = "%Y-%m-%d %H:%M:%S", tz = "GMT"))

#You can seperate field1 to 4 into different dataframes, i.e. 4, by selecting the required columns

#Once you complete the step in the column below apply the code below to get train and test for field 1 to 4

#Get train and test for each field

#Field1

Field1 <- Field1[with(Field1, order(timestamp3)), ]

Field1_train <- Field1[Field1$timestamp3 >= "2019-02-23 00:00:00" & Field1$timestamp3 <= "2019-03-25 23:45:00",]

Field1_test <- Field1[Field1$timestamp3 > "2019-03-25 23:45:00" & Field1$timestamp3 <= "2019-03-29 23:50:00",]

#Field2

Field2 <- Field2[with(Field2, order(timestamp3)), ]

Field2_train <- Field2[Field2$timestamp3 >= "2019-02-23 00:00:00" & Field2$timestamp3 <= "2019-05-25 08:40:00",]

Field2_test <- Field2[Field2$timestamp3 > "2019-05-25 08:40:00" & Field2$timestamp3 <= "2019-05-31 10:15:00",]

#Field3

Field3 <- Field3[with(Field3, order(timestamp3)), ]

Field3_train <- Field3[Field3$timestamp3 >= "2019-02-23 00:00:00" & Field3$timestamp3 <= "2019-04-19 21:10:00",]

Field3_test <- Field3[Field3$timestamp3 > "2019-04-19 21:10:00" & Field3$timestamp3 <= "2019-04-23 21:15:00",]

#Field4

Field4 <- Field4[with(Field4, order(timestamp3)), ]

Field4_train <- Field4[Field4$timestamp3 >= "2019-02-23 00:00:00" & Field4$timestamp3 <= "2019-05-25 08:40:00",]

Field4_test <- Field4[Field4$timestamp3 > "2019-05-25 08:40:00" & Field4$timestamp3 <= "2019-05-31 08:45:00",]

Thanks DrFad, by applying those bounderies I find that the lenghth of all test data is 5775, so there is 7 missing rows ? also how to prapare the sumbmission file for the 4 fields. Any code please ?