"Execute R code gives missing data for date values"
User50676
New Altair Community Member
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"?>
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"?>
0
Best Answer
-
That looks like a date format in in type long.
https://community.rapidminer.com/discussion/46641/rapidminer-operator-to-convert-into-date
1
Answers
-
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/54579/execute-r-date-missing-in-output
Thanks1 -
Many thanks for your response, I had seen this thread. However i am new to RapidMiner and i do not understand this solution.0
-
Please post your dataset and process. You can import process from rapidminer and attach it here (File --> Import process).1
-
Many thanks, please find attached the dataset and the process.
Regards,
Chris
0 -
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.
0 -
That looks like a date format in in type long.
https://community.rapidminer.com/discussion/46641/rapidminer-operator-to-convert-into-date
1 -
0
-
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×tamp=292278994&Submit=++++++Convert+to+Date++++++1
