"Execute R code gives missing data for date values"

User50676

I have the following code in R Studio:



This gives the following results:

I have put the code in Execute R which is as follows:


This gives the following results set:



The dates have missing values?
Is it something to do with date formats in R and Rapid Miner?  Please assist.

My XML code is as follows:


<?xml version="1.0" encoding="UTF-8"?>

hughesfleming68

That looks like a date format in in type long.

https://community.rapidminer.com/discussion/19269/rapidminer-operator-to-convert-into-date

varunm1

Hi @User50676

There is a similar discussion below with an accepted answer. Please go through below thread and see if it is helpful.

https://community.rapidminer.com/discussion/55070/execute-r-date-missing-in-output

Thanks

User50676

Many thanks for your response, I had seen this thread.  However i am new to RapidMiner and i do not understand this solution.

varunm1

Please post your dataset and process. You can import process from rapidminer and attach it here (File --> Import process).

User50676

Many thanks, please find attached the dataset and the process.

Regards,

Chris

varunm1

Hi,

I checked your issue. I see that the R script is returning improper date format (you can see the year is some illogical year)  which you can see below. As this output is a part of AdhereR package I am trying to understand why this is happening.

varunm1

@hughesfleming68, I am wondering why the year is in this format as we can see month and day.

hughesfleming68

I am not sure @varunm1 but it is not the first time that I have seen dates that look like that. I will take a look later. There might be something else going on. I used this site to convert the time stamp and it does not look right even though it has the correct number of digits.

https://www.timestampconvert.com/?go2=true&offset=-2&timestamp=292278994&Submit=++++++Convert+to+Date++++++