Quantopian's community platform is shutting down. Please read this post for more information and download your code.
Back to Community
Does anyone knows if to_cvs from pandas works?

Im trying to use the pandas function "to_cvs" to export some data.
Does anyone knows if it works?

import pandas as pd  
def initialize(context):  
    stocks = {24: sid(24),  
            466131: sid(46631)  
            }  
    pass


def handle_data(context, data):  
    datapanel = history(200, '1d', 'close_price')  
    #location = C:\Users\Jose\Desktop\exportacion.txt  
    pd.to_cvs(datapanel)  
5 responses

Doesn't look like it works. I get the following error: Cannot import attribute within module to_csv. Third party data vendors don't want you exporting the data.

There is a bug in pandas where they have a conflict with TZ UTC

I managed to serialize with to_hdf others didnt work either.

Hi all,

Unfortunately, we don't allow you to export data so any to_csv() method won't work.

Happy to answer any questions you might have,

Seong

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.

I figured the software wouldn't allow csv exports, but what about a way to output a longer log line than 1024 characters? I have a program that builds a huge array of codes and situations, and I'm having trouble outputting the whole array for debugging. Any ways around this?

Have you tried the debugger? You can place a breakpoint by clicking on a line number. Then you'll have a REPL to explore in-memory objects. There's still some restrictions on the amount of data you can print in the REPL, but the interactivity makes debugging much easier than just logging.

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.