'SUM' ]) # for cnt in range(len(code_df)): for cnt in range(5): item_name = code_df.loc[cnt, 'name'] code = code_df.loc[cnt, 'code'] try: fs = FS(code) except KeyError: continue cnt += 1 value_df.loc[cnt, ['종목']] = item_name value_df.loc[cnt, ['ROA']] = 1 if fs.get_ROA() > 0 else 0 value_df.loc[cnt, ['CFO']] = 1 if fs.get_CFO() > 0 else 0 value_df.loc[cnt, ['ROA_DIFF']] = 1 if fs.get_ROA_DIFF() > 0 else 0 value_df.loc[cnt, ['ACCRUAL']] = 1 if fs.get_CFO() > fs.get_ROA() else 0 value_df.loc[cnt, ['LIQUID']] = 1 if fs.get_LIQUID_cur( ) - fs.get_LIQUID_past() > 0 else 0 value_df.loc[cnt, ['MARGIN']] = 1 if fs.get_MARGIN_cur( ) - fs.get_MARGIN_past() > 0 else 0 value_df.loc[ cnt, ['TURN']] = 1 if fs.get_TURN_cur() - fs.get_TURN_past() > 0 else 0 value_df['SUM'] = value_df[[ 'ROA', 'CFO', 'ROA_DIFF', 'ACCRUAL', 'LIQUID', 'TURN' ]].sum(axis=1) value_df = value_df.sort_values(by=["SUM"], ascending=[False]) print(tabulate(value_df, headers='keys', tablefmt='psql')) # print(len(value_df)) # value_df.to_csv('./Q.csv')
code = code_df.loc[cnt, 'code'] try: fs = FS(code) if fs.get_SC() < 10000: continue print(item_name) cnt += 1 value_df.loc[cnt, ['종목']] = item_name value_df.loc[cnt, ['code']] = code value_df.loc[cnt, ['ROA']] = 1 if fs.get_ROA() > 0 else 0 value_df.loc[cnt, ['CFO']] = 1 if fs.get_CFO() > 0 else 0 value_df.loc[cnt, ['ROA_DIFF']] = 1 if fs.get_ROA_DIFF() > 0 else 0 value_df.loc[cnt, ['ACCRUAL']] = 1 if fs.get_CFO() > fs.get_ROA() else 0 value_df.loc[cnt, ['LIQUID']] = 1 if fs.get_LIQUID_cur() - fs.get_LIQUID_past() > 0 else 0 value_df.loc[cnt, ['MARGIN']] = 1 if fs.get_MARGIN_cur() - fs.get_MARGIN_past() > 0 else 0 value_df.loc[cnt, ['TURN']] = 1 if fs.get_TURN_cur() - fs.get_TURN_past() > 0 else 0 except: pass value_df['SUM'] = value_df[['ROA', 'CFO', 'ROA_DIFF', 'ACCRUAL', 'LIQUID', 'MARGIN', 'TURN']].sum(axis=1) value_df = value_df.sort_values(by=["SUM"], ascending=[False]) value_df.to_json('Value.json', orient='table') value_df = value_df[['종목', 'code', 'SUM']] df_records = value_df.to_dict('records') print(df_records)