How to conditionally recode variables in Pipeline() ?

Quantopian's community platform is shutting down. Please read this post for more information and download your code.

Back to Community

How to conditionally recode variables in Pipeline() ?

edited Aug 24, 2018

Seeking Help Getting Started Sentiment Tools and Tips Pipeline

Hi all,

Although new to Quantopian, I am now well underway to make my first real contest entry. I am however stuck on one specific point codewise: How to recode a variable in the pipeline, with the new values based on certain conditions. Below I have attached a simple notebook to clarify the problem:

If the number of positive stocktwits messages is more than 0 I want the 'score' variable to reflect the number of messages, whereas if the number of messages equals to 0 I want the 'score' variable for that stock to have a different value (in this case i picked 2 as an example).

I have tried to accomplish this by using an if statement, however this does not seem to work (as can be seen in the head() output in the notebook, the score still shows zeros). Is there a way to make the if statement functional, or alternatively is there another way I can achieve this?

Thanks!

You've successfully submitted a support ticket.

Our support team will be in touch soon.

Need help? Contact support.

The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by Quantopian.

In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances.

About Quantopian

The material on this website is provided for informational purposes only and does not constitute an offer to sell, a solicitation to buy, or a recommendation or endorsement for any security or strategy, nor does it constitute an offer to provide investment advisory services by Quantopian.

In addition, the material offers no opinion with respect to the suitability of any security or specific investment. No information contained herein should be regarded as a suggestion to engage in or refrain from any investment-related course of action as none of Quantopian nor any of its affiliates is undertaking to provide investment advice, act as an adviser to any plan or entity subject to the Employee Retirement Income Security Act of 1974, as amended, individual retirement account or individual retirement annuity, or give advice in a fiduciary capacity with respect to the materials presented herein. If you are an individual retirement or other investor, contact your financial advisor or other fiduciary unrelated to Quantopian about whether any given investment idea, strategy, product or service described herein may be appropriate for your circumstances. All investments involve risk, including loss of principal. Quantopian makes no guarantees as to the accuracy or completeness of the views expressed in the website. The views are subject to change, and may have become unreliable for various reasons, including changes in market conditions or economic circumstances.