Skip to content

add new process at add_factor #15

Description

@sn0wfree

def add_factor(self, db_table, factor_names: (list, tuple, str), cik_dt=None, cik_iid=None,

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')

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions