Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
pd.options - deeper tear sheet - algo analysis - changes to research
Umar Hasan
edited Feb 9, 2017
API Getting Started Show Q Q Updates Research

Hi - spend quite a bit of time building out a "deeper" tear sheet then is currently available (attached) since wanted more granular data however very recent changes in accessing various research options has caused it to essentially stop running.

Trying to avoid getting frustrated but do I have any choice other then to re-build (if I bother putting in that many hours again that is).

SecurityViolation: 0002 Security Violation(s): Accessing pd.options raised an AttributeError. Did you mean to access pd.tools instead?
SecurityViolation: 0002 Security Violation(s): Accessing pf.capacity raised an AttributeError. No attributes with a similar name were found.

2 responses
Dan Dunn
Feb 9, 2017

Hello Umar,

I'm very sorry that you've had this problem. We recently identified a potential security hole and we tightened up several of the modules that are available on pandas. That is what stopped your notebook from running.

I'm afraid I don't have an easy resolution for you. It will need to be re-worked with other modules.

We're very sorry about this. It's the right thing to do, security-wise, but it has a very unfortunate impact on your notebook.

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.

Paul Harrison
Nov 27, 2019

Hey Umar & Dan
So the solution I found was fairly simple, just use a 'join' on your dataframe. In this example:
dataframe1 is called results
dataframe2 is called final_prices
and I want to add a column from final_prices to results so : 

results_with_final_prices = results.join(final_prices['Final_Prices'], on='Stocks')
About Quantopian
Careers
Community
Events
Documentation
Academia
Lectures
Status
Facebook
Twitter
LinkedIn
YouTube
Terms of Use
Privacy Policy

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.