复制链接
克隆策略
In [58]:
# m4.data.read()
In [57]:
# df = m4.data.read()
# len(df[df.fs_eps_yoy_0.isnull()])
In [56]:
# df2 = m9.data.read()
# len(df[df2.fs_eps_yoy_0.isnull()])
In [55]:
# df[df2.fs_eps_yoy_0.isnull()]

    {"description":"实验创建于2022/11/19","graph":{"edges":[{"to_node_id":"-73:instruments","from_node_id":"-60:data"},{"to_node_id":"-73:features","from_node_id":"-68:data"},{"to_node_id":"-80:features","from_node_id":"-68:data"},{"to_node_id":"-80:input_data","from_node_id":"-73:data"},{"to_node_id":"-155:input_1","from_node_id":"-80:data"},{"to_node_id":"-181:input_ds","from_node_id":"-80:data"},{"to_node_id":"-187:input_ds","from_node_id":"-80:data"},{"to_node_id":"-105:input_data","from_node_id":"-155:data"},{"to_node_id":"-192:input_1","from_node_id":"-181:data"},{"to_node_id":"-227:input_1","from_node_id":"-187:data"},{"to_node_id":"-174:data1","from_node_id":"-192:data_1"},{"to_node_id":"-174:data2","from_node_id":"-227:data_1"}],"nodes":[{"node_id":"-60","module_id":"BigQuantSpace.instruments.instruments-v2","parameters":[{"name":"start_date","value":"2019-01-01","type":"Literal","bound_global_parameter":null},{"name":"end_date","value":"2019-03-01","type":"Literal","bound_global_parameter":null},{"name":"market","value":"CN_STOCK_A","type":"Literal","bound_global_parameter":null},{"name":"instrument_list","value":"","type":"Literal","bound_global_parameter":null},{"name":"max_count","value":0,"type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"rolling_conf","node_id":"-60"}],"output_ports":[{"name":"data","node_id":"-60"}],"cacheable":true,"seq_num":1,"comment":"","comment_collapsed":true},{"node_id":"-68","module_id":"BigQuantSpace.input_features.input_features-v1","parameters":[{"name":"features","value":"\n# #号开始的表示注释，注释需单独一行\n# 多个特征，每行一个，可以包含基础特征和衍生特征，特征须为本平台特征\nfs_eps_yoy_0\nps_ttm_0\nindustry_sw_level1_0\nvolume_0\n","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"features_ds","node_id":"-68"}],"output_ports":[{"name":"data","node_id":"-68"}],"cacheable":true,"seq_num":2,"comment":"","comment_collapsed":true},{"node_id":"-73","module_id":"BigQuantSpace.general_feature_extractor.general_feature_extractor-v7","parameters":[{"name":"start_date","value":"","type":"Literal","bound_global_parameter":null},{"name":"end_date","value":"","type":"Literal","bound_global_parameter":null},{"name":"before_start_days","value":90,"type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"instruments","node_id":"-73"},{"name":"features","node_id":"-73"}],"output_ports":[{"name":"data","node_id":"-73"}],"cacheable":true,"seq_num":3,"comment":"","comment_collapsed":true},{"node_id":"-80","module_id":"BigQuantSpace.derived_feature_extractor.derived_feature_extractor-v3","parameters":[{"name":"date_col","value":"date","type":"Literal","bound_global_parameter":null},{"name":"instrument_col","value":"instrument","type":"Literal","bound_global_parameter":null},{"name":"drop_na","value":"False","type":"Literal","bound_global_parameter":null},{"name":"remove_extra_columns","value":"False","type":"Literal","bound_global_parameter":null},{"name":"user_functions","value":"{}","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"input_data","node_id":"-80"},{"name":"features","node_id":"-80"}],"output_ports":[{"name":"data","node_id":"-80"}],"cacheable":true,"seq_num":4,"comment":"","comment_collapsed":true},{"node_id":"-105","module_id":"BigQuantSpace.filter.filter-v3","parameters":[{"name":"expr","value":"industry_sw_level1_0!=0","type":"Literal","bound_global_parameter":null},{"name":"output_left_data","value":"False","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"input_data","node_id":"-105"}],"output_ports":[{"name":"data","node_id":"-105"},{"name":"left_data","node_id":"-105"}],"cacheable":true,"seq_num":8,"comment":"","comment_collapsed":true},{"node_id":"-155","module_id":"BigQuantSpace.fill_nan.fill_nan-v8","parameters":[{"name":"columns_input","value":"['fs_eps_yoy_0']","type":"Literal","bound_global_parameter":null},{"name":"group_key","value":"['date','industry_sw_level1_0']","type":"Literal","bound_global_parameter":null},{"name":"method","value":"使用中位数填充","type":"Literal","bound_global_parameter":null},{"name":"fillnum","value":"0.0","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"input_1","node_id":"-155"},{"name":"input_2","node_id":"-155"}],"output_ports":[{"name":"data","node_id":"-155"}],"cacheable":true,"seq_num":9,"comment":"","comment_collapsed":true},{"node_id":"-174","module_id":"BigQuantSpace.join.join-v3","parameters":[{"name":"on","value":"date,instrument","type":"Literal","bound_global_parameter":null},{"name":"how","value":"inner","type":"Literal","bound_global_parameter":null},{"name":"sort","value":"False","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"data1","node_id":"-174"},{"name":"data2","node_id":"-174"}],"output_ports":[{"name":"data","node_id":"-174"}],"cacheable":true,"seq_num":11,"comment":"","comment_collapsed":true},{"node_id":"-181","module_id":"BigQuantSpace.select_columns.select_columns-v3","parameters":[{"name":"columns","value":"date,instrument,volume_0","type":"Literal","bound_global_parameter":null},{"name":"reverse_select","value":"False","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"input_ds","node_id":"-181"},{"name":"columns_ds","node_id":"-181"}],"output_ports":[{"name":"data","node_id":"-181"}],"cacheable":true,"seq_num":6,"comment":"","comment_collapsed":true},{"node_id":"-187","module_id":"BigQuantSpace.select_columns.select_columns-v3","parameters":[{"name":"columns","value":"date,instrument,fs_eps_yoy_0","type":"Literal","bound_global_parameter":null},{"name":"reverse_select","value":"False","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"input_ds","node_id":"-187"},{"name":"columns_ds","node_id":"-187"}],"output_ports":[{"name":"data","node_id":"-187"}],"cacheable":true,"seq_num":12,"comment":"","comment_collapsed":true},{"node_id":"-192","module_id":"BigQuantSpace.period_resample.period_resample-v1","parameters":[{"name":"resample_period","value":"M","type":"Literal","bound_global_parameter":null},{"name":"how_key","value":"sum","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"input_1","node_id":"-192"}],"output_ports":[{"name":"data_1","node_id":"-192"}],"cacheable":true,"seq_num":7,"comment":"","comment_collapsed":true},{"node_id":"-227","module_id":"BigQuantSpace.period_resample.period_resample-v1","parameters":[{"name":"resample_period","value":"M","type":"Literal","bound_global_parameter":null},{"name":"how_key","value":"last","type":"Literal","bound_global_parameter":null}],"input_ports":[{"name":"input_1","node_id":"-227"}],"output_ports":[{"name":"data_1","node_id":"-227"}],"cacheable":true,"seq_num":13,"comment":"","comment_collapsed":true}],"node_layout":"<node_postions><node_position Node='-60' Position='101,86,200,200'/><node_position Node='-68' Position='403,91,200,200'/><node_position Node='-73' Position='246,182,200,200'/><node_position Node='-80' Position='241,254.65655517578125,200,200'/><node_position Node='-105' Position='61.47248840332031,471.3927917480469,200,200'/><node_position Node='-155' Position='63.3795166015625,359.3007507324219,200,200'/><node_position Node='-174' Position='599.0816040039062,583.7678833007812,200,200'/><node_position Node='-181' Position='397.5123291015625,360.4073486328125,200,200'/><node_position Node='-187' Position='736.798828125,359.98419189453125,200,200'/><node_position Node='-192' Position='401.144287109375,482.0752258300781,200,200'/><node_position Node='-227' Position='742.2466430664062,472.5724182128906,200,200'/></node_postions>"},"nodes_readonly":false,"studio_version":"v2"}
    In [54]:
    # 本代码由可视化策略环境自动生成 2022年11月21日 16:15
# 本代码单元只能在可视化模式下编辑。您也可以拷贝代码，粘贴到新建的代码单元或者策略，然后修改。


m1 = M.instruments.v2(
    start_date='2019-01-01',
    end_date='2019-03-01',
    market='CN_STOCK_A',
    instrument_list='',
    max_count=0
)

m2 = M.input_features.v1(
    features="""
# #号开始的表示注释，注释需单独一行
# 多个特征，每行一个，可以包含基础特征和衍生特征，特征须为本平台特征
fs_eps_yoy_0
ps_ttm_0
industry_sw_level1_0
volume_0
"""
)

m3 = M.general_feature_extractor.v7(
    instruments=m1.data,
    features=m2.data,
    start_date='',
    end_date='',
    before_start_days=90
)

m4 = M.derived_feature_extractor.v3(
    input_data=m3.data,
    features=m2.data,
    date_col='date',
    instrument_col='instrument',
    drop_na=False,
    remove_extra_columns=False,
    user_functions={}
)

m9 = M.fill_nan.v8(
    input_1=m4.data,
    columns_input=['fs_eps_yoy_0'],
    group_key=['date','industry_sw_level1_0'],
    method='使用中位数填充',
    fillnum=0.0
)

m8 = M.filter.v3(
    input_data=m9.data,
    expr='industry_sw_level1_0!=0',
    output_left_data=False
)

m6 = M.select_columns.v3(
    input_ds=m4.data,
    columns='date,instrument,volume_0',
    reverse_select=False
)

m7 = M.period_resample.v1(
    input_1=m6.data,
    resample_period='M',
    how_key='sum'
)

m12 = M.select_columns.v3(
    input_ds=m4.data,
    columns='date,instrument,fs_eps_yoy_0',
    reverse_select=False
)

m13 = M.period_resample.v1(
    input_1=m12.data,
    resample_period='M',
    how_key='last'
)

m11 = M.join.v3(
    data1=m7.data_1,
    data2=m13.data_1,
    on='date,instrument',
    how='inner',
    sort=False
)

    ---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
TypeError: resample() got an unexpected keyword argument 'how'

During handling of the above exception, another exception occurred:

TypeError                                 Traceback (most recent call last)
<ipython-input-54-61b75698876b> in <module>
     46 )
     47 
---> 48 m7 = M.period_resample.v1(
     49     input_1=m6.data,
     50     resample_period='M',

TypeError: resample() got an unexpected keyword argument 'how'