RapidMiner

csv file does not show correctly after sampling with windows powershell

SOLVED
video icon RapidMiner now offering a full suite of online training videos - free! Check it out
Highlighted
Learner I marcschw
Learner I

csv file does not show correctly after sampling with windows powershell

Hello,

I am working with a very large csv file which I cannot directly import into rapidminer. Therefore, I try to sample it down with windows powershell. However, after the sampling rapidminer does not import the file correctly. The appended file "test_sample.csv" works perfectly in rapidminer. The file "first100.csv" contains the first 100 lines of the other file but I have problems with the import.

2 REPLIES
Moderator Moderator
Moderator
Solution

Re: csv file does not show correctly after sampling with windows powershell

Hi @marcschw,

 

I have no problem to import your file first100.csv by selecting

Regular Expression (,\s*|;\s*) at the step 2 / 4 of the Data import wizard : 

Import_csv_RM.png

 

I hope it helps,

 

Regards,

 

Lionel

 

 

 

Learner I marcschw
Learner I
Solution

Re: csv file does not show correctly after sampling with windows powershell

Now I could import the file so thank you for that. But i can't get it to recognize the date. It is clearly in the format

yyyy-MM-dd HH:mm:ss. But when I select this format it does not parseit correctly.