Vizualize three values to a 3d point rapidminer

New Altair Community Member
Updated by Jocelyn
Each line in the attached file correspond to 240 values of which they are supposed to be in tripple pairs, where each tripple of values correspond to one point in the x,y,z plane, how do i plot the first row in rapidminer, so I have 80 dots in the x,y,z plane
Find more posts tagged with
Sort by:
1 - 8 of
81
Hi, im so sorry i attached the right file now, namned data!
The data is structured as x,y,z,x,y,z and so on for 240 columns
And each row represent a new movement or position, i would just like to be able to visualize, one row with 240 attributes which will be 80 dots in 3d-space
The data is structured as x,y,z,x,y,z and so on for 240 columns
And each row represent a new movement or position, i would just like to be able to visualize, one row with 240 attributes which will be 80 dots in 3d-space
Hi,
Something like this? (there is probably a way easier way to do this)

Something like this? (there is probably a way easier way to do this)
<?xml version="1.0" encoding="UTF-8"?><process version="10.1.002"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="10.1.002" expanded="true" name="Process" origin="GENERATED_TUTORIAL"> <parameter key="logverbosity" value="init"/> <parameter key="random_seed" value="2001"/> <parameter key="send_mail" value="never"/> <parameter key="notification_email" value=""/> <parameter key="process_duration_for_mail" value="30"/> <parameter key="encoding" value="SYSTEM"/> <process expanded="true"> <operator activated="true" class="read_csv" compatibility="10.1.002" expanded="true" height="68" name="Read CSV" width="90" x="45" y="34"> <parameter key="csv_file" value="https://us.v-cdn.net/6030995/uploads/editor/p5/vgkjyxg5z8uk.csv"/> <parameter key="column_separators" value=";"/> <parameter key="trim_lines" value="false"/> <parameter key="use_quotes" value="true"/> <parameter key="quotes_character" value="""/> <parameter key="escape_character" value="\"/> <parameter key="skip_comments" value="false"/> <parameter key="comment_characters" value="#"/> <parameter key="starting_row" value="1"/> <parameter key="parse_numbers" value="true"/> <parameter key="decimal_character" value="."/> <parameter key="grouped_digits" value="false"/> <parameter key="grouping_character" value=","/> <parameter key="infinity_representation" value=""/> <parameter key="date_format" value=""/> <parameter key="first_row_as_names" value="false"/> <list key="annotations"/> <parameter key="time_zone" value="SYSTEM"/> <parameter key="locale" value="English (United States)"/> <parameter key="encoding" value="UTF-8"/> <parameter key="read_all_values_as_polynominal" value="false"/> <list key="data_set_meta_data_information"/> <parameter key="read_not_matching_values_as_missings" value="true"/> </operator> <operator activated="true" class="filter_example_range" compatibility="10.1.002" expanded="true" height="82" name="Filter Example Range" width="90" x="179" y="34"> <parameter key="first_example" value="1"/> <parameter key="last_example" value="1"/> <parameter key="invert_filter" value="false"/> </operator> <operator activated="true" class="rename_by_replacing" compatibility="10.1.002" expanded="true" height="82" name="Rename by Replacing" width="90" x="313" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="attribute_value"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="time"/> <parameter key="block_type" value="attribute_block"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="value_matrix_row_start"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="replace_what" value="att"/> </operator> <operator activated="true" class="concurrency:loop_attributes" compatibility="10.1.002" expanded="true" height="103" name="Loop Attributes" width="90" x="447" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="attribute_value"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="time"/> <parameter key="block_type" value="attribute_block"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="value_matrix_row_start"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="attribute_name_macro" value="loop"/> <parameter key="reuse_results" value="true"/> <parameter key="enable_parallel_execution" value="false"/> <process expanded="true"> <operator activated="true" class="multiply" compatibility="10.1.002" expanded="true" height="103" name="Multiply" width="90" x="45" y="34"/> <operator activated="true" class="blending:select_attributes" compatibility="10.1.002" expanded="true" height="82" name="Select Attributes" width="90" x="112" y="340"> <parameter key="type" value="include attributes"/> <parameter key="attribute_filter_type" value="one attribute"/> <parameter key="select_attribute" value="%{loop}"/> <parameter key="select_subset" value=""/> <parameter key="also_apply_to_special_attributes_(id,_label..)" value="false"/> </operator> <operator activated="true" class="generate_macro" compatibility="10.1.002" expanded="true" height="82" name="Generate Macro" width="90" x="246" y="340"> <list key="function_descriptions"> <parameter key="attribute" value="concat("tripplet_", str(floor((round(parse(%{loop}))-1)/3)))"/> </list> </operator> <operator activated="true" class="generate_empty_attribute" compatibility="10.1.002" expanded="true" height="82" name="Generate Empty Attribute" width="90" x="380" y="340"> <parameter key="name" value="%{attribute}"/> <parameter key="value_type" value="integer"/> </operator> <operator activated="true" class="operator_toolbox:merge" compatibility="2.14.000" expanded="true" height="103" name="Merge Attributes (2)" width="90" x="514" y="85"> <parameter key="handling_of_duplicate_attributes" value="keep_only_first"/> <parameter key="handling_of_special_attributes" value="keep_only_first"/> <parameter key="handling_of_duplicate_annotations" value="keep_only_first"/> </operator> <operator activated="true" class="blending:generate_columns" compatibility="10.1.002" expanded="true" height="82" name="Generate Attributes" width="90" x="715" y="85"> <list key="function_descriptions"> <parameter key="%{attribute}" value="if(missing(cell_value(%{attribute}, 1, NOMINAL)), cell_value(%{loop}, 1, NOMINAL), concat(cell_value(%{attribute} , 1, NOMINAL), " ", cell_value(%{loop},1, NOMINAL)))"/> </list> <parameter key="keep_all_columns" value="true"/> </operator> <operator activated="true" class="blending:select_attributes" compatibility="10.1.002" expanded="true" height="82" name="Select Attributes (2)" width="90" x="849" y="85"> <parameter key="type" value="exclude attributes"/> <parameter key="attribute_filter_type" value="one attribute"/> <parameter key="select_attribute" value="%{loop}"/> <parameter key="select_subset" value=""/> <parameter key="also_apply_to_special_attributes_(id,_label..)" value="false"/> </operator> <connect from_port="input 1" to_op="Multiply" to_port="input"/> <connect from_port="input 2" to_op="Merge Attributes (2)" to_port="example set 1"/> <connect from_op="Multiply" from_port="output 1" to_port="output 1"/> <connect from_op="Multiply" from_port="output 2" to_op="Select Attributes" to_port="example set input"/> <connect from_op="Select Attributes" from_port="example set output" to_op="Generate Macro" to_port="through 1"/> <connect from_op="Generate Macro" from_port="through 1" to_op="Generate Empty Attribute" to_port="example set input"/> <connect from_op="Generate Empty Attribute" from_port="example set output" to_op="Merge Attributes (2)" to_port="example set 2"/> <connect from_op="Merge Attributes (2)" from_port="merged set" to_op="Generate Attributes" to_port="table input"/> <connect from_op="Generate Attributes" from_port="table output" to_op="Select Attributes (2)" to_port="example set input"/> <connect from_op="Select Attributes (2)" from_port="example set output" to_port="output 2"/> <portSpacing port="source_input 1" spacing="0"/> <portSpacing port="source_input 2" spacing="0"/> <portSpacing port="source_input 3" spacing="0"/> <portSpacing port="sink_output 1" spacing="0"/> <portSpacing port="sink_output 2" spacing="0"/> <portSpacing port="sink_output 3" spacing="0"/> </process> </operator> <operator activated="true" class="transpose" compatibility="10.1.002" expanded="true" height="82" name="Transpose" width="90" x="581" y="34"/> <operator activated="true" class="split" compatibility="10.1.002" expanded="true" height="82" name="Split" width="90" x="715" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="nominal"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="file_path"/> <parameter key="block_type" value="single_value"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="single_value"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="split_pattern" value="\s"/> <parameter key="split_mode" value="ordered_split"/> </operator> <operator activated="true" class="guess_types" compatibility="10.1.002" expanded="true" height="82" name="Guess Types" width="90" x="849" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="attribute_value"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="time"/> <parameter key="block_type" value="attribute_block"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="value_matrix_row_start"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="decimal_point_character" value="."/> </operator> <connect from_op="Read CSV" from_port="output" to_op="Filter Example Range" to_port="example set input"/> <connect from_op="Filter Example Range" from_port="example set output" to_op="Rename by Replacing" to_port="example set input"/> <connect from_op="Rename by Replacing" from_port="example set output" to_op="Loop Attributes" to_port="input 1"/> <connect from_op="Loop Attributes" from_port="output 2" to_op="Transpose" to_port="example set input"/> <connect from_op="Transpose" from_port="example set output" to_op="Split" to_port="example set input"/> <connect from_op="Split" from_port="example set output" to_op="Guess Types" to_port="example set input"/> <connect from_op="Guess Types" 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>


New Altair Community Member
OPUpdated by Talefjanten
Omg this is exacly what I want, i made it work in python, so the picture is right, but when i load the process it does'nt work?
I have some dummy process in loop attributes,
When i load the process you wrote, it gives dummy operator, etc, but I can see it works correct for you
I have some dummy process in loop attributes,
When i load the process you wrote, it gives dummy operator, etc, but I can see it works correct for you

New Altair Community Member
OPUpdated by Talefjanten
I have here attached the real original file, without my interference, its an csv file with one cell and hundreds of rows, i know how to read in the file and remove unwanted attributes on the last two rows, but the process you sent up there gave you the right vizual effect, but did'nt work at all for me, so maybe there is something corrupt with the file i sent before, or do you have any idea as why it did'nt work for me and gave me dummy attributes etc
It has some holes in the data that I will fix with the replace missing values operator
It has some holes in the data that I will fix with the replace missing values operator
Hi,
i accidently used an non-core operator from the Operator Toolbox extension, you can install it via the Marketplace.
https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_operator_toolbox
Greetings,
Jonas
i accidently used an non-core operator from the Operator Toolbox extension, you can install it via the Marketplace.
https://marketplace.rapidminer.com/UpdateServer/faces/product_details.xhtml?productId=rmx_operator_toolbox
Greetings,
Jonas
Sort by:
1 - 1 of
11
Hi,
Something like this? (there is probably a way easier way to do this)

Something like this? (there is probably a way easier way to do this)
<?xml version="1.0" encoding="UTF-8"?><process version="10.1.002"> <context> <input/> <output/> <macros/> </context> <operator activated="true" class="process" compatibility="10.1.002" expanded="true" name="Process" origin="GENERATED_TUTORIAL"> <parameter key="logverbosity" value="init"/> <parameter key="random_seed" value="2001"/> <parameter key="send_mail" value="never"/> <parameter key="notification_email" value=""/> <parameter key="process_duration_for_mail" value="30"/> <parameter key="encoding" value="SYSTEM"/> <process expanded="true"> <operator activated="true" class="read_csv" compatibility="10.1.002" expanded="true" height="68" name="Read CSV" width="90" x="45" y="34"> <parameter key="csv_file" value="https://us.v-cdn.net/6030995/uploads/editor/p5/vgkjyxg5z8uk.csv"/> <parameter key="column_separators" value=";"/> <parameter key="trim_lines" value="false"/> <parameter key="use_quotes" value="true"/> <parameter key="quotes_character" value="""/> <parameter key="escape_character" value="\"/> <parameter key="skip_comments" value="false"/> <parameter key="comment_characters" value="#"/> <parameter key="starting_row" value="1"/> <parameter key="parse_numbers" value="true"/> <parameter key="decimal_character" value="."/> <parameter key="grouped_digits" value="false"/> <parameter key="grouping_character" value=","/> <parameter key="infinity_representation" value=""/> <parameter key="date_format" value=""/> <parameter key="first_row_as_names" value="false"/> <list key="annotations"/> <parameter key="time_zone" value="SYSTEM"/> <parameter key="locale" value="English (United States)"/> <parameter key="encoding" value="UTF-8"/> <parameter key="read_all_values_as_polynominal" value="false"/> <list key="data_set_meta_data_information"/> <parameter key="read_not_matching_values_as_missings" value="true"/> </operator> <operator activated="true" class="filter_example_range" compatibility="10.1.002" expanded="true" height="82" name="Filter Example Range" width="90" x="179" y="34"> <parameter key="first_example" value="1"/> <parameter key="last_example" value="1"/> <parameter key="invert_filter" value="false"/> </operator> <operator activated="true" class="rename_by_replacing" compatibility="10.1.002" expanded="true" height="82" name="Rename by Replacing" width="90" x="313" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="attribute_value"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="time"/> <parameter key="block_type" value="attribute_block"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="value_matrix_row_start"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="replace_what" value="att"/> </operator> <operator activated="true" class="concurrency:loop_attributes" compatibility="10.1.002" expanded="true" height="103" name="Loop Attributes" width="90" x="447" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="attribute_value"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="time"/> <parameter key="block_type" value="attribute_block"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="value_matrix_row_start"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="attribute_name_macro" value="loop"/> <parameter key="reuse_results" value="true"/> <parameter key="enable_parallel_execution" value="false"/> <process expanded="true"> <operator activated="true" class="multiply" compatibility="10.1.002" expanded="true" height="103" name="Multiply" width="90" x="45" y="34"/> <operator activated="true" class="blending:select_attributes" compatibility="10.1.002" expanded="true" height="82" name="Select Attributes" width="90" x="112" y="340"> <parameter key="type" value="include attributes"/> <parameter key="attribute_filter_type" value="one attribute"/> <parameter key="select_attribute" value="%{loop}"/> <parameter key="select_subset" value=""/> <parameter key="also_apply_to_special_attributes_(id,_label..)" value="false"/> </operator> <operator activated="true" class="generate_macro" compatibility="10.1.002" expanded="true" height="82" name="Generate Macro" width="90" x="246" y="340"> <list key="function_descriptions"> <parameter key="attribute" value="concat("tripplet_", str(floor((round(parse(%{loop}))-1)/3)))"/> </list> </operator> <operator activated="true" class="generate_empty_attribute" compatibility="10.1.002" expanded="true" height="82" name="Generate Empty Attribute" width="90" x="380" y="340"> <parameter key="name" value="%{attribute}"/> <parameter key="value_type" value="integer"/> </operator> <operator activated="true" class="operator_toolbox:merge" compatibility="2.14.000" expanded="true" height="103" name="Merge Attributes (2)" width="90" x="514" y="85"> <parameter key="handling_of_duplicate_attributes" value="keep_only_first"/> <parameter key="handling_of_special_attributes" value="keep_only_first"/> <parameter key="handling_of_duplicate_annotations" value="keep_only_first"/> </operator> <operator activated="true" class="blending:generate_columns" compatibility="10.1.002" expanded="true" height="82" name="Generate Attributes" width="90" x="715" y="85"> <list key="function_descriptions"> <parameter key="%{attribute}" value="if(missing(cell_value(%{attribute}, 1, NOMINAL)), cell_value(%{loop}, 1, NOMINAL), concat(cell_value(%{attribute} , 1, NOMINAL), " ", cell_value(%{loop},1, NOMINAL)))"/> </list> <parameter key="keep_all_columns" value="true"/> </operator> <operator activated="true" class="blending:select_attributes" compatibility="10.1.002" expanded="true" height="82" name="Select Attributes (2)" width="90" x="849" y="85"> <parameter key="type" value="exclude attributes"/> <parameter key="attribute_filter_type" value="one attribute"/> <parameter key="select_attribute" value="%{loop}"/> <parameter key="select_subset" value=""/> <parameter key="also_apply_to_special_attributes_(id,_label..)" value="false"/> </operator> <connect from_port="input 1" to_op="Multiply" to_port="input"/> <connect from_port="input 2" to_op="Merge Attributes (2)" to_port="example set 1"/> <connect from_op="Multiply" from_port="output 1" to_port="output 1"/> <connect from_op="Multiply" from_port="output 2" to_op="Select Attributes" to_port="example set input"/> <connect from_op="Select Attributes" from_port="example set output" to_op="Generate Macro" to_port="through 1"/> <connect from_op="Generate Macro" from_port="through 1" to_op="Generate Empty Attribute" to_port="example set input"/> <connect from_op="Generate Empty Attribute" from_port="example set output" to_op="Merge Attributes (2)" to_port="example set 2"/> <connect from_op="Merge Attributes (2)" from_port="merged set" to_op="Generate Attributes" to_port="table input"/> <connect from_op="Generate Attributes" from_port="table output" to_op="Select Attributes (2)" to_port="example set input"/> <connect from_op="Select Attributes (2)" from_port="example set output" to_port="output 2"/> <portSpacing port="source_input 1" spacing="0"/> <portSpacing port="source_input 2" spacing="0"/> <portSpacing port="source_input 3" spacing="0"/> <portSpacing port="sink_output 1" spacing="0"/> <portSpacing port="sink_output 2" spacing="0"/> <portSpacing port="sink_output 3" spacing="0"/> </process> </operator> <operator activated="true" class="transpose" compatibility="10.1.002" expanded="true" height="82" name="Transpose" width="90" x="581" y="34"/> <operator activated="true" class="split" compatibility="10.1.002" expanded="true" height="82" name="Split" width="90" x="715" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="nominal"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="file_path"/> <parameter key="block_type" value="single_value"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="single_value"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="split_pattern" value="\s"/> <parameter key="split_mode" value="ordered_split"/> </operator> <operator activated="true" class="guess_types" compatibility="10.1.002" expanded="true" height="82" name="Guess Types" width="90" x="849" y="34"> <parameter key="attribute_filter_type" value="all"/> <parameter key="attribute" value=""/> <parameter key="attributes" value=""/> <parameter key="use_except_expression" value="false"/> <parameter key="value_type" value="attribute_value"/> <parameter key="use_value_type_exception" value="false"/> <parameter key="except_value_type" value="time"/> <parameter key="block_type" value="attribute_block"/> <parameter key="use_block_type_exception" value="false"/> <parameter key="except_block_type" value="value_matrix_row_start"/> <parameter key="invert_selection" value="false"/> <parameter key="include_special_attributes" value="false"/> <parameter key="decimal_point_character" value="."/> </operator> <connect from_op="Read CSV" from_port="output" to_op="Filter Example Range" to_port="example set input"/> <connect from_op="Filter Example Range" from_port="example set output" to_op="Rename by Replacing" to_port="example set input"/> <connect from_op="Rename by Replacing" from_port="example set output" to_op="Loop Attributes" to_port="input 1"/> <connect from_op="Loop Attributes" from_port="output 2" to_op="Transpose" to_port="example set input"/> <connect from_op="Transpose" from_port="example set output" to_op="Split" to_port="example set input"/> <connect from_op="Split" from_port="example set output" to_op="Guess Types" to_port="example set input"/> <connect from_op="Guess Types" 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>

the attached excel file appears to be empty.
Does the file suppose to look like this?
x
y
z
x
y
z
Greetings,
Jonas