Python_Colab 3주차

def get_profit(name):

  corp_code = df_listed[df_listed['corp_name'] == name].iloc[0,0]

  data = dart_fss.api.finance.fnltt_singl_acnt(corp_code, '2021', '11011')

  df=pd.DataFrame(data['list'])

  cond=(df['fs_div']=='CFS')&(df['account_nm']=='이익잉여금')

  df=df[cond]

  df['name']=name

  df=df[['name','thstrm_amount','frmtrm_amount']]

  df.columns=['기업명','당기','전기']

  df['당기']=pd.to_numeric(df['당기'].str.replace(',',''))

  df['전기']=pd.to_numeric(df['전기'].str.replace(',',''))

  df['증감']=df['당기']-df['전기']

  df['증감율']=abs(df['증감'])/abs(df['전기'])    #abs( )는 절대값

  

  return df

 

def get_earning(name):

  corp_code = df_non_listed[df_non_listed['corp_name'] == name].iloc[0,0]

  data = dart_fss.api.info.alot_matter(corp_code, '2021', '11011')

  df = pd.DataFrame(data['list'])

  df=df[df['se']=='(연결)당기순이익(백만원)']

  df=df[['corp_name','thstrm','frmtrm','lwfr']]

  df.columns=['기업명','2021','2020','2019']

  df['2021']=pd.to_numeric(df['2021'].str.replace(',','')) #문자열을 숫자로 변경

  df['2020']=pd.to_numeric(df['2020'].str.replace(',',''))

  df['2019']=pd.to_numeric(df['2019'].str.replace(',',''))

  #df.dtypes #int형으로 변경되었는지 확인

  return df