🎉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

Reading data using field name

robinUser: "robin"
New Altair Community Member
Updated by Jocelyn
I am read a file into RM where there is no header row, each field has the name included in the filed value. 

So where a typical CSV file would be:
ice_cream ,chocolate, candy
1,4,5
6,4,2

My files looks like:
"ice_cream"="1","chocolate"="4","candy"="5"
"ice_cream"="6","chocolate"="4","candy"="2"

Various other data mining programs allow for the "retain name" function, how does one deal with this inside of RapidMiner?

The problem that I face is that these files are large, reading them in retaining the field information and replacing it later with an operator uses more than the available system memory. 

Find more posts tagged with

Sort by:
1 - 1 of 11
    jczogallaUser: "jczogalla"
    New Altair Community Member
    Accepted Answer
    Hi @robin!
    If the data is to be big to fit in in one go, you could try to do a more "manual" approach. As I described in this thread, you can use the text extension to split the csv files into lines and the lines into separate values. It should also be possible to then modify each cell value before it is put into an example set.

    Cheers
    Jan