Open
Description
ClickSQL/ClickSQL/factor_table/__init__.py
Line 251 in 42906c3
add_factor function could be to add factor via factortable(self), table of database, dataframe or SQL,
such as:
add factor via database table
[completed]
ft = FactorTable(conn,cik_dt='dt',cik_iid='code',strict_cik=False)
ft.add_factor('test.test',['test1'],cik_dt='dt',cik_iid='iid')
add factor via factortable(self)
ft = FactorTable(conn,cik_dt='dt',cik_iid='code',strict_cik=False)
ft.add_factor('test.test',['test1'],cik_dt='dt',cik_iid='iid')
ft2 = FactorTable(conn2,cik_dt='dt',cik_iid='code',strict_cik=False)
ft2.add_factor(ft,['test1'],cik_dt='dt',cik_iid='iid')
add factor via SQL
sql = 'select dt,code,test3,test4 from test.test2'
ft3= FactorTable(conn,cik_dt='dt',cik_iid='code',strict_cik=False)
ft3.add_factor(sql ,['test3','test4],cik_dt='dt',cik_iid='code')
add factor via pd.DataFrame
data=pd.DataFrame(data,columns=['test3','test4','dt','code'])
ft3= FactorTable(conn,cik_dt='dt',cik_iid='code',strict_cik=False)
ft3.add_factor(data,['test3','test4],cik_dt='dt',cik_iid='code')