The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.

csv file does not show correctly after sampling with windows powershell

marcschwmarcschw Member Posts: 4 Contributor I
edited November 2018 in Help


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.

Best Answers

  • Options
    lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,195 Unicorn
    Solution Accepted

    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 : 



    I hope it helps,








  • Options
    marcschwmarcschw Member Posts: 4 Contributor I
    Solution Accepted

    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.

Sign In or Register to comment.