Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
Error in date format
Contributor II
hi.
i am working with the data containing date and and text processing .
separately these processes are working well. but after joining these i get the error message for the variable "current" in which i am using date_now() to get the system date. but later i took date difference (date-of-post and current) by converting it into date to numerical.
the process is as follows:
THE CSV file consists of :
DateOfPost- polynomial( e.g. 12/10/2006)
sentimentText- text(e.g. "i have bought a new car last week.it is very good")
id- integer(e.g. 1,2,3,4....................)
XML file is as follows:
<code>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="6.3.000">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="6.3.000" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="retrieve" compatibility="6.3.000" expanded="true" height="60" name="Retrieve" width="90" x="45" y="30">
<parameter key="repository_entry" value="c2'07"/>
</operator>
<operator activated="true" class="filter_examples" compatibility="6.3.000" expanded="true" height="94" name="Filter Examples" width="90" x="112" y="120">
<list key="filters_list">
<parameter key="filters_entry_key" value="id.eq.182"/>
<parameter key="filters_entry_key" value="id.eq.319"/>
<parameter key="filters_entry_key" value="id.eq.330"/>
<parameter key="filters_entry_key" value="id.eq.345"/>
<parameter key="filters_entry_key" value="id.eq.582"/>
<parameter key="filters_entry_key" value="id.eq.733"/>
<parameter key="filters_entry_key" value="id.eq.1927"/>
<parameter key="filters_entry_key" value="id.eq.1987"/>
<parameter key="filters_entry_key" value="id.eq.2269"/>
<parameter key="filters_entry_key" value="id.eq.2312"/>
</list>
</operator>
<operator activated="true" class="wordnet:open_wordnet_dictionary" compatibility="5.3.000" expanded="true" height="60" name="Open WordNet Dictionary" width="90" x="179" y="210">
<parameter key="directory" value="/home/sukh/Documents/WordNet-3.0/dict"/>
</operator>
<operator activated="true" class="remember" compatibility="6.3.000" expanded="true" height="60" name="Remember" width="90" x="246" y="255">
<parameter key="name" value="wordnet"/>
<parameter key="io_object" value="WordnetDictionary"/>
</operator>
<operator activated="true" class="subprocess" compatibility="6.3.000" expanded="true" height="76" name="Subprocess" width="90" x="313" y="120">
<process expanded="true">
<portSpacing port="source_in 1" spacing="0"/>
<portSpacing port="source_in 2" spacing="0"/>
<portSpacing port="sink_out 1" spacing="0"/>
<portSpacing port="sink_out 2" spacing="0"/>
</process>
</operator>
<operator activated="true" class="multiply" compatibility="6.3.000" expanded="true" height="94" name="Multiply" width="90" x="45" y="210"/>
<operator activated="true" class="nominal_to_date" compatibility="6.3.000" expanded="true" height="76" name="Nominal to Date" width="90" x="45" y="435">
<parameter key="attribute_name" value="DateOfPost"/>
<parameter key="date_format" value="MM/dd/yyyy"/>
</operator>
<operator activated="true" class="date_to_numerical" compatibility="6.3.000" expanded="true" height="76" name="Date to Numerical (2)" width="90" x="179" y="435">
<parameter key="attribute_name" value="DateOfPost"/>
<parameter key="time_unit" value="day"/>
<parameter key="day_relative_to" value="epoch"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes" width="90" x="179" y="345">
<list key="function_descriptions">
<parameter key="current" value="date_now()"/>
<parameter key="current1" value="date_parse_custom(current,"mm/dd/yyyy"))"/>
</list>
</operator>
<operator activated="true" class="date_to_numerical" compatibility="6.3.000" expanded="true" height="76" name="Date to Numerical" width="90" x="313" y="435">
<parameter key="attribute_name" value="current"/>
<parameter key="time_unit" value="day"/>
<parameter key="day_relative_to" value="epoch"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes (2)" width="90" x="380" y="300">
<list key="function_descriptions">
<parameter key="current" value="current-2034"/>
<parameter key="Dtag" value="current-DateOfPost"/>
</list>
</operator>
<operator activated="true" class="discretize_by_user_specification" compatibility="6.3.000" expanded="true" height="94" name="Discretize (2)" width="90" x="447" y="390">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="Dtag"/>
<list key="classes">
<parameter key="present" value="375.0"/>
<parameter key="past" value="Infinity"/>
</list>
</operator>
<operator activated="true" class="text:process_document_from_data" compatibility="6.1.000" expanded="true" height="76" name="Process Documents from Data" width="90" x="246" y="30">
<parameter key="keep_text" value="true"/>
<list key="specify_weights"/>
<process expanded="true">
<operator activated="true" class="text:tokenize" compatibility="6.1.000" expanded="true" height="60" name="Tokenize" width="90" x="112" y="30"/>
<operator activated="true" class="recall" compatibility="6.3.000" expanded="true" height="60" name="Recall" width="90" x="45" y="120">
<parameter key="name" value="wordnet"/>
<parameter key="io_object" value="WordnetDictionary"/>
<parameter key="remove_from_store" value="false"/>
</operator>
<operator activated="true" class="wordnet:find_sentiment_wordnet" compatibility="5.3.000" expanded="true" height="76" name="Extract Sentiment (English)" width="90" x="246" y="75"/>
<operator activated="true" class="text:stem_dictionary" compatibility="6.1.000" expanded="true" height="76" name="Stem (Dictionary)" width="90" x="450" y="30">
<parameter key="file" value="/home/sukh/Desktop/stemhindi"/>
</operator>
<connect from_port="document" to_op="Tokenize" to_port="document"/>
<connect from_op="Tokenize" from_port="document" to_op="Extract Sentiment (English)" to_port="document"/>
<connect from_op="Recall" from_port="result" to_op="Extract Sentiment (English)" to_port="dictionary"/>
<connect from_op="Extract Sentiment (English)" from_port="document" to_op="Stem (Dictionary)" to_port="document"/>
<connect from_op="Stem (Dictionary)" from_port="document" to_port="document 1"/>
<portSpacing port="source_document" spacing="0"/>
<portSpacing port="sink_document 1" spacing="0"/>
<portSpacing port="sink_document 2" spacing="0"/>
</process>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes (3)" width="90" x="380" y="30">
<list key="function_descriptions">
<parameter key="present" value="(length(text)-length(replaceAll(text,"present","")))/length("present")"/>
<parameter key="past" value="(length(text)-length(replaceAll(text,"past","")))/length("past")"/>
<parameter key="future" value="(length(text)-length(replaceAll(text,"future","")))/length("future")"/>
<parameter key="Ttag" value="if(present==max(present,past,future),"present",if(past==max(present,past,future),"past",if(future==max(present,past,future),"future",0)))"/>
</list>
</operator>
<operator activated="true" class="join" compatibility="6.3.000" expanded="true" height="76" name="Join" width="90" x="514" y="165">
<parameter key="join_type" value="outer"/>
<parameter key="use_id_attribute_as_key" value="false"/>
<list key="key_attributes">
<parameter key="id" value="id"/>
</list>
<parameter key="keep_both_join_attributes" value="true"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes (5)" width="90" x="514" y="30">
<list key="function_descriptions">
<parameter key="new1" value="if(Ttag=="present",if(Dtag=="past","past",if(Dtag=="present","present",0)),"z")"/>
<parameter key="new" value="if(Ttag=="past",if(Dtag=="past","past",if(Dtag=="present","past",0)),new1)"/>
<parameter key="Temptag" value="if(Ttag=="future",if(Dtag=="past","past",if(Dtag=="present","future",0)),new)"/>
</list>
</operator>
<connect from_op="Retrieve" from_port="output" to_op="Filter Examples" to_port="example set input"/>
<connect from_op="Filter Examples" from_port="example set output" to_op="Multiply" to_port="input"/>
<connect from_op="Open WordNet Dictionary" from_port="dictionary" to_op="Remember" to_port="store"/>
<connect from_op="Remember" from_port="stored" to_op="Subprocess" to_port="in 1"/>
<connect from_op="Subprocess" from_port="out 1" to_op="Process Documents from Data" to_port="word list"/>
<connect from_op="Multiply" from_port="output 1" to_op="Process Documents from Data" to_port="example set"/>
<connect from_op="Multiply" from_port="output 2" to_op="Nominal to Date" to_port="example set input"/>
<connect from_op="Nominal to Date" from_port="example set output" to_op="Date to Numerical (2)" to_port="example set input"/>
<connect from_op="Date to Numerical (2)" from_port="example set output" to_op="Generate Attributes" to_port="example set input"/>
<connect from_op="Generate Attributes" from_port="example set output" to_op="Date to Numerical" to_port="example set input"/>
<connect from_op="Date to Numerical" from_port="example set output" to_op="Generate Attributes (2)" to_port="example set input"/>
<connect from_op="Generate Attributes (2)" from_port="example set output" to_op="Discretize (2)" to_port="example set input"/>
<connect from_op="Discretize (2)" from_port="example set output" to_op="Join" to_port="right"/>
<connect from_op="Process Documents from Data" from_port="example set" to_op="Generate Attributes (3)" to_port="example set input"/>
<connect from_op="Generate Attributes (3)" from_port="example set output" to_op="Join" to_port="left"/>
<connect from_op="Join" from_port="join" to_op="Generate Attributes (5)" to_port="example set input"/>
<connect from_op="Generate Attributes (5)" from_port="example set output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
</code>
Kindly help me for the same.
Thanks and Regards:
Sukh
i am working with the data containing date and and text processing .
separately these processes are working well. but after joining these i get the error message for the variable "current" in which i am using date_now() to get the system date. but later i took date difference (date-of-post and current) by converting it into date to numerical.
the process is as follows:
THE CSV file consists of :
DateOfPost- polynomial( e.g. 12/10/2006)
sentimentText- text(e.g. "i have bought a new car last week.it is very good")
id- integer(e.g. 1,2,3,4....................)
XML file is as follows:
<code>
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<process version="6.3.000">
<context>
<input/>
<output/>
<macros/>
</context>
<operator activated="true" class="process" compatibility="6.3.000" expanded="true" name="Process">
<process expanded="true">
<operator activated="true" class="retrieve" compatibility="6.3.000" expanded="true" height="60" name="Retrieve" width="90" x="45" y="30">
<parameter key="repository_entry" value="c2'07"/>
</operator>
<operator activated="true" class="filter_examples" compatibility="6.3.000" expanded="true" height="94" name="Filter Examples" width="90" x="112" y="120">
<list key="filters_list">
<parameter key="filters_entry_key" value="id.eq.182"/>
<parameter key="filters_entry_key" value="id.eq.319"/>
<parameter key="filters_entry_key" value="id.eq.330"/>
<parameter key="filters_entry_key" value="id.eq.345"/>
<parameter key="filters_entry_key" value="id.eq.582"/>
<parameter key="filters_entry_key" value="id.eq.733"/>
<parameter key="filters_entry_key" value="id.eq.1927"/>
<parameter key="filters_entry_key" value="id.eq.1987"/>
<parameter key="filters_entry_key" value="id.eq.2269"/>
<parameter key="filters_entry_key" value="id.eq.2312"/>
</list>
</operator>
<operator activated="true" class="wordnet:open_wordnet_dictionary" compatibility="5.3.000" expanded="true" height="60" name="Open WordNet Dictionary" width="90" x="179" y="210">
<parameter key="directory" value="/home/sukh/Documents/WordNet-3.0/dict"/>
</operator>
<operator activated="true" class="remember" compatibility="6.3.000" expanded="true" height="60" name="Remember" width="90" x="246" y="255">
<parameter key="name" value="wordnet"/>
<parameter key="io_object" value="WordnetDictionary"/>
</operator>
<operator activated="true" class="subprocess" compatibility="6.3.000" expanded="true" height="76" name="Subprocess" width="90" x="313" y="120">
<process expanded="true">
<portSpacing port="source_in 1" spacing="0"/>
<portSpacing port="source_in 2" spacing="0"/>
<portSpacing port="sink_out 1" spacing="0"/>
<portSpacing port="sink_out 2" spacing="0"/>
</process>
</operator>
<operator activated="true" class="multiply" compatibility="6.3.000" expanded="true" height="94" name="Multiply" width="90" x="45" y="210"/>
<operator activated="true" class="nominal_to_date" compatibility="6.3.000" expanded="true" height="76" name="Nominal to Date" width="90" x="45" y="435">
<parameter key="attribute_name" value="DateOfPost"/>
<parameter key="date_format" value="MM/dd/yyyy"/>
</operator>
<operator activated="true" class="date_to_numerical" compatibility="6.3.000" expanded="true" height="76" name="Date to Numerical (2)" width="90" x="179" y="435">
<parameter key="attribute_name" value="DateOfPost"/>
<parameter key="time_unit" value="day"/>
<parameter key="day_relative_to" value="epoch"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes" width="90" x="179" y="345">
<list key="function_descriptions">
<parameter key="current" value="date_now()"/>
<parameter key="current1" value="date_parse_custom(current,"mm/dd/yyyy"))"/>
</list>
</operator>
<operator activated="true" class="date_to_numerical" compatibility="6.3.000" expanded="true" height="76" name="Date to Numerical" width="90" x="313" y="435">
<parameter key="attribute_name" value="current"/>
<parameter key="time_unit" value="day"/>
<parameter key="day_relative_to" value="epoch"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes (2)" width="90" x="380" y="300">
<list key="function_descriptions">
<parameter key="current" value="current-2034"/>
<parameter key="Dtag" value="current-DateOfPost"/>
</list>
</operator>
<operator activated="true" class="discretize_by_user_specification" compatibility="6.3.000" expanded="true" height="94" name="Discretize (2)" width="90" x="447" y="390">
<parameter key="attribute_filter_type" value="single"/>
<parameter key="attribute" value="Dtag"/>
<list key="classes">
<parameter key="present" value="375.0"/>
<parameter key="past" value="Infinity"/>
</list>
</operator>
<operator activated="true" class="text:process_document_from_data" compatibility="6.1.000" expanded="true" height="76" name="Process Documents from Data" width="90" x="246" y="30">
<parameter key="keep_text" value="true"/>
<list key="specify_weights"/>
<process expanded="true">
<operator activated="true" class="text:tokenize" compatibility="6.1.000" expanded="true" height="60" name="Tokenize" width="90" x="112" y="30"/>
<operator activated="true" class="recall" compatibility="6.3.000" expanded="true" height="60" name="Recall" width="90" x="45" y="120">
<parameter key="name" value="wordnet"/>
<parameter key="io_object" value="WordnetDictionary"/>
<parameter key="remove_from_store" value="false"/>
</operator>
<operator activated="true" class="wordnet:find_sentiment_wordnet" compatibility="5.3.000" expanded="true" height="76" name="Extract Sentiment (English)" width="90" x="246" y="75"/>
<operator activated="true" class="text:stem_dictionary" compatibility="6.1.000" expanded="true" height="76" name="Stem (Dictionary)" width="90" x="450" y="30">
<parameter key="file" value="/home/sukh/Desktop/stemhindi"/>
</operator>
<connect from_port="document" to_op="Tokenize" to_port="document"/>
<connect from_op="Tokenize" from_port="document" to_op="Extract Sentiment (English)" to_port="document"/>
<connect from_op="Recall" from_port="result" to_op="Extract Sentiment (English)" to_port="dictionary"/>
<connect from_op="Extract Sentiment (English)" from_port="document" to_op="Stem (Dictionary)" to_port="document"/>
<connect from_op="Stem (Dictionary)" from_port="document" to_port="document 1"/>
<portSpacing port="source_document" spacing="0"/>
<portSpacing port="sink_document 1" spacing="0"/>
<portSpacing port="sink_document 2" spacing="0"/>
</process>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes (3)" width="90" x="380" y="30">
<list key="function_descriptions">
<parameter key="present" value="(length(text)-length(replaceAll(text,"present","")))/length("present")"/>
<parameter key="past" value="(length(text)-length(replaceAll(text,"past","")))/length("past")"/>
<parameter key="future" value="(length(text)-length(replaceAll(text,"future","")))/length("future")"/>
<parameter key="Ttag" value="if(present==max(present,past,future),"present",if(past==max(present,past,future),"past",if(future==max(present,past,future),"future",0)))"/>
</list>
</operator>
<operator activated="true" class="join" compatibility="6.3.000" expanded="true" height="76" name="Join" width="90" x="514" y="165">
<parameter key="join_type" value="outer"/>
<parameter key="use_id_attribute_as_key" value="false"/>
<list key="key_attributes">
<parameter key="id" value="id"/>
</list>
<parameter key="keep_both_join_attributes" value="true"/>
</operator>
<operator activated="true" class="generate_attributes" compatibility="6.3.000" expanded="true" height="76" name="Generate Attributes (5)" width="90" x="514" y="30">
<list key="function_descriptions">
<parameter key="new1" value="if(Ttag=="present",if(Dtag=="past","past",if(Dtag=="present","present",0)),"z")"/>
<parameter key="new" value="if(Ttag=="past",if(Dtag=="past","past",if(Dtag=="present","past",0)),new1)"/>
<parameter key="Temptag" value="if(Ttag=="future",if(Dtag=="past","past",if(Dtag=="present","future",0)),new)"/>
</list>
</operator>
<connect from_op="Retrieve" from_port="output" to_op="Filter Examples" to_port="example set input"/>
<connect from_op="Filter Examples" from_port="example set output" to_op="Multiply" to_port="input"/>
<connect from_op="Open WordNet Dictionary" from_port="dictionary" to_op="Remember" to_port="store"/>
<connect from_op="Remember" from_port="stored" to_op="Subprocess" to_port="in 1"/>
<connect from_op="Subprocess" from_port="out 1" to_op="Process Documents from Data" to_port="word list"/>
<connect from_op="Multiply" from_port="output 1" to_op="Process Documents from Data" to_port="example set"/>
<connect from_op="Multiply" from_port="output 2" to_op="Nominal to Date" to_port="example set input"/>
<connect from_op="Nominal to Date" from_port="example set output" to_op="Date to Numerical (2)" to_port="example set input"/>
<connect from_op="Date to Numerical (2)" from_port="example set output" to_op="Generate Attributes" to_port="example set input"/>
<connect from_op="Generate Attributes" from_port="example set output" to_op="Date to Numerical" to_port="example set input"/>
<connect from_op="Date to Numerical" from_port="example set output" to_op="Generate Attributes (2)" to_port="example set input"/>
<connect from_op="Generate Attributes (2)" from_port="example set output" to_op="Discretize (2)" to_port="example set input"/>
<connect from_op="Discretize (2)" from_port="example set output" to_op="Join" to_port="right"/>
<connect from_op="Process Documents from Data" from_port="example set" to_op="Generate Attributes (3)" to_port="example set input"/>
<connect from_op="Generate Attributes (3)" from_port="example set output" to_op="Join" to_port="left"/>
<connect from_op="Join" from_port="join" to_op="Generate Attributes (5)" to_port="example set input"/>
<connect from_op="Generate Attributes (5)" from_port="example set output" to_port="result 1"/>
<portSpacing port="source_input 1" spacing="0"/>
<portSpacing port="sink_result 1" spacing="0"/>
<portSpacing port="sink_result 2" spacing="0"/>
</process>
</operator>
</process>
</code>
Kindly help me for the same.
Thanks and Regards:
Sukh
Tagged:
0
Answers
The date_now() function returns an object of type "Date time". Using this with the date_parse_custom() function will result in an error because this function is expecting a string containing the date.
regards
Andrew