Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Help with pipeline output index

So, I am copying some of the code from the "Fundamental Factor Models" and I am trying to pull all unique assets in the index by using the code asset_list = results.index.levels[1].unique() and it returns a list of the assets, but when I try to subset the pipeline output by some of the assets in that list, it returns an empty data frame. I tested this to see what was happening and I took the len(result.index.levels[1].unique()) and compared it to the len(results.index.levels[1]) and they both result in the same length.

Maybe this test doesn't actually tell me anything, but point is the formula is returning equity names that are not actually in my pipeline output. If I try to subset my output by certain assets in that asset_list it returns nothing. I attached the notebook so you can see what I mean. Can someone tell me why it is doing this?

2 responses

Common question. It's a quirk with pandas multi-indexes. The simple answer/solution is to use get_level_values instead index.levels. Check out this post for a more in depth answer https://www.quantopian.com/posts/strange-issue-with-pipeline-screen-equals-universe-not-working.

Disclaimer

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.

Dan, you're the man, thank you so much