Error 1000 RPackage library exception Unable to convert DataSet into R DataFrame train file of kaggle BIMBO

Marcos de Souza 21 Reputation points
2022-01-28T02:55:07.177+00:00

Olá , Estou tentando alterar os valores de algumas colunas no desafio Kaggle BIMBO e sempre após 9 minutos de execução o job pára com este erro. Como poderia resolver esta situação?
subtrair a devolução atual, da semana anterior garantindo ser do mesmo produto.
como esse código iria levar 211 dias para ser executado, levei para o azure

str (train)

'data.frame': 60886401 obs. of 9 variables:
$ Semana : int 3 7 8 3 7 8 3 4 5 6 ...
$ Agencia_ID : int 2061 2061 2061 2061 2061 2061 2061 2061 2061 2061 ...
$ Canal_ID : int 2 2 2 2 2 2 2 2 2 2 ...
$ Ruta_SAK : int 7212 7212 7212 7212 7212 7212 7212 7212 7212 7212 ...
$ Cliente_ID : int 26 26 26 26 26 26 26 26 26 26 ...
$ Producto_ID : int 1182 1182 1182 4767 4767 4767 31393 31393 31393 31393 ...
$ Venta_uni_hoy : int 39 35 42 84 42 42 20 16 15 15 ...
$ Dev_uni_proxima : num 0 42 42 0 0 0 0 0 0 0 ...
$ Demanda_uni_equil: int 39 0 0 42 42 42 20 16 15 15 ...

Blockquote

   train <- maml.mapInputPort(1) # class: data.frame
    train <- arrange(train, Cliente_ID , Agencia_ID, Producto_ID , Semana )
    for (i in 1:nrow(train))
    { 
      if (train[i,1] > 3)
      {  
         if (train[i,6] == train[i-1,6])
         {  
            train[i-1,7] <- train[i-1,7] - train[i,8]
            train[i-1,9] <- train[i-1,7]
            train[i,9]   <- train[i,7] 
            if (train[i-1,7] < 0)
            {
               train[i-1,9] <- 0
               train[i-1,7] <- 0
            }
         }    
         else
         {
           train[i,9] <- train[i,7] 
           train[i,8] <- 0
         }enter code here
      }
    }
    maml.mapOutputPort("train");

Blockquote

Error:
START TIME 1/27/2022 11:08:30 PM
END TIME 1/27/2022 11:17:15 PM
ELAPSED TIME 0:08:44.943
STATUS CODE
Failed
STATUS DETAILS
requestId = 70bc3c1c636044ea98d4ab4663a41846 errorComponent=Module. taskStatusCode=400. {"Exception":{"ErrorId":"LibraryException","ErrorCode":"1000","ExceptionType":"ModuleException","Message":"Error 1000: RPackage library exception: Unable to convert DataSet into R DataFrame","Exception":{"Library":"RPackage","ErrorId":"DataTableToDataFrame","ErrorCode":"18","ExceptionType":"LibraryException","Message":"Unable to convert DataSet into R DataFrame","Exception":{"ExceptionType":"Exception","Message":"Array dimensions exceeded supported range."}}}}Error: Error 1000: RPackage library exception: Unable to convert DataSet into R DataFrame Process exited with error code -2

Azure SQL Database
0 comments No comments
{count} votes

Accepted answer
  1. Obaid Farooqi MSFT 511 Reputation points Microsoft Employee
    2022-01-28T08:37:42.287+00:00

    Hi @Marcos de Souza
    The tag Openspecs-questions is dedicated to supporting open specifications. You can find open specifications here https://learn.microsoft.com/en-us/openspecs/. Your inquiry is not related to open specifications. I have removed the openspecs-questions and have added azure-sq-databases for a better chance for you to obtain an answer.

    Regards,
    Obaid Farooqi - MSFT


0 additional answers

Sort by: Most helpful