🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.

Join and Win

importing multiple date or time attributes with different formats

GreySpike

Hi,

I'm just starting with RapidMiner and really struggling with importing a csv file with multiple date and time columns.

RM does not seem to identify any of the columns correctly, and the wizard is stalling because I have a UTF-16 input file (is that a bug?).

I have externally converted to UTF-8 so at least the wizard is showing something other than Chinese script, but I can't find a way to set the date format differently on each attribute.

Stripped down example

RUNTIME,START DATE,START TIME,START TIMESTAMP
00:01:59,20160301,210042,20160301210042.1

HH:mm:ss,yyyyMMdd,HHmmss,yyyyMMddHHmmss.SSS

time, date, time, date-time

I'm aware that I don't need both the timestamp and the start date and start time, but at the moment I'm trying to learn how to make RM work.

Thanks for any suggestions.

Find more posts tagged with

AI Studio

Accepted answers

All comments

MartinLiebig

Hi,

you can read this all in as polynominal and then use various Nominal to Date operators to parse your dates individually.

~Martin