Datatable generated by Execute Python bad displayed

lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn
edited December 2018 inProduct Feedback - Resolved

Hi all,

Once again, it's to report a weird behaviour in RapidMiner :

I'm following a tutorial on time series which use RapidMiner.

For that, I'm using the libraryQuandlof Python (viaExecute Pythonoperator) to retrieve from the web

the stock prices that serve as entry dataset.

However, the first column (date-time column) contain only missing values "?" :

Time_series_quandl_1.png

Here the process :







<操作符activated="true" class="process" compatibility="8.1.000" expanded="true" name="Process">

<操作符activated="true" class="python_scripting:execute_python" compatibility="7.4.000" expanded="true" height="82" name="Execute Python" width="90" x="246" y="85">


<操作符activated="true" class="set_role" compatibility="8.1.000" expanded="true" height="82" name="Set Role" width="90" x="380" y="85">












I decided to execute the Python code in a Notebook and here it works perfectly fine (the datatable is good displayed) :

Time_series_quandl_2.png

Can you help me to determine what's going on ?

Thanks you for your answers,

Best regards,

Lionel

Tagged:
0
0 votes

Fixed and Released·Last Updated

SCRIPT-58

Comments

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,761Unicorn

    I think this question came up before in the Community. I seem to remember it was related to formating the data-time.

  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn

    Hi all,

    After research in the communauty, it seems there is not solution to this problem.

    Concretely what is done to solve this problem ?

    Thanks you for your answers,

    Best regars,

    Lionel

  • SGolbertSGolbert RapidMiner Certified Analyst, MemberPosts:344Unicorn
    Solution Accepted

    I have found a temporary solution:







    <操作符activated="true" class="process" compatibility="8.1.000" expanded="true" name="Process">

    <操作符activated="true" class="python_scripting:execute_python" compatibility="7.4.000" expanded="true" height="82" name="Execute Python" width="90" x="112" y="85">


    <操作符activated="true" class="nominal_to_date" compatibility="8.1.000" expanded="true" height="82" name="Nominal to Date" width="90" x="313" y="85">



    <操作符activated="true" class="set_role" compatibility="8.1.000" expanded="true" height="82" name="Set Role" width="90" x="514" y="85">













    Basically it consists of converting the dates to string in Python and then parsing them in RapidMiner Studio.

    Should RM be able to convert from pandas' dates automatically?

  • Thomas_OttThomas_Ott RapidMiner Certified Analyst, RapidMiner Certified Expert, MemberPosts:1,761Unicorn

    @SGolbertI think it should do that automatically because the Python Script operator translates the RM exampleset to the Pandas dataframe. I think this needs to be investigated by the RM Dev team.

  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn

    Hi,

    Thanks you@SGolbert．这个解决方案很有效,帮助我很多。

    Best regards,

    Lionel

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager

    moving to Product Feedback.

    Scott

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager
  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, MemberPosts:1,195Unicorn

    Dear all,

    I agree with Thomas. Some tasks that cannot be performed by RM, can be performed with Python scripts.

    It's frustrating not to be able to display the associated results in RM.

    Regards,

    Lionel

  • sgenzersgenzer Administrator, Moderator, Employee, RapidMiner Certified Analyst, Community Manager, Member, University Professor, PM ModeratorPosts:2,959Community Manager

    tagging@bhupendra_patil:)

  • phellingerphellinger Employee, MemberPosts:103RM Engineering
    Hi All,

    Date values no longer become missing values when using Execute Python starting from Python Scripting Extension version 9.3.1.

    Thanks for reporting this problem and for coming up with workarounds.

    Best,
    Peter
Sign InorRegisterto comment.