커뮤니티
포인트
쿠폰
내 강의실
국비 신청 내역
증명서
계정
로그아웃
학습 질문
개발 일지
나의 활동
답변 완료
FutureWarning
undefined주차
북마크
방*기
댓글
3
추천
0
조회수
6
조회수
6
답변 완료

* 겪고 있는 문제 상황을 최대한 자세하게 작성해주세요.

* 문제 해결을 위해 어떤 시도를 해보았는지 구체적으로 함께 알려주세요.


<ipython-input-46-5620e9d00088>:14: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df_result = df_result.append(doc, ignore_index=True)
   기업명      연봉(남)      연봉(여)    차이(남-여)           평균
0  카카오  217000000  108000000  109000000  109000000.0
'\n\n<ipython-input-44-2c62bab9864d>:14: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n  df_result = df_result.append(doc, ignore_index=True)\n\n\ndf_result = pd.DataFrame()\nfor corp_name in list(df_listed['corp_name'].sample(10)):\n  \n  df = get_salary(corp_name)\n  df_result.append(df)\ndf_result\n\n\n\n



def get_salary(name):
  corp_code = df_listed[df_listed['corp_name'] == name].iloc[0,0]
  data = dart_fss.api.info.emp_sttus(corp_code, '2021', '11011')


  df = pd.DataFrame(data['list'])
  df = df[['corp_name','sexdstn','jan_salary_am']]


  df_result = pd.DataFrame()
  doc = {
      '기업명': '카카오',
      '연봉(남)': df[df['sexdstn'] == '남'].iloc[-1,-1],
      '연봉(여)': df[df['sexdstn'] == '여'].iloc[-1,-1]
  }
  df_result = df_result.append(doc, ignore_index=True)
  df_result['연봉(남)'] = pd.to_numeric(df_result['연봉(남)'].str.replace(',',''))
  df_result['연봉(여)'] = pd.to_numeric(df_result['연봉(여)'].str.replace(',',''))
  df_result['차이(남-여)'] = (df_result['연봉(남)'] - df_result['연봉(여)']).abs()
  df_result['평균'] = (df_result['연봉(남)'] - df_result['연봉(여)']).mean()


  return df_result


df = get_salary('카카오')
print(df)


'''




<ipython-input-44-2c62bab9864d>:14: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df_result = df_result.append(doc, ignore_index=True)



df_result = pd.DataFrame()
for corp_name in list(df_listed['corp_name'].sample(10)):
  
  df = get_salary(corp_name)
  df_result.append(df)
df_result






'''



def get_salary(name):
  corp_code = df_listed[df_listed['corp_name'] == name].iloc[0,0]
  data = dart_fss.api.info.emp_sttus(corp_code, '2021', '11011')


  df = pd.DataFrame(data['list'])
  df = df[['corp_name','sexdstn','jan_salary_am']]


  df_result = pd.DataFrame()
  doc = {
      '기업명': '카카오',
      '연봉(남)': df[df['sexdstn'] == '남'].iloc[-1,-1],
      '연봉(여)': df[df['sexdstn'] == '여'].iloc[-1,-1]
  }
  df_result = df_result.append(doc, ignore_index=True)
  df_result['연봉(남)'] = pd.to_numeric(df_result['연봉(남)'].str.replace(',',''))
  df_result['연봉(여)'] = pd.to_numeric(df_result['연봉(여)'].str.replace(',',''))
  df_result['차이(남-여)'] = (df_result['연봉(남)'] - df_result['연봉(여)']).abs()
  df_result['평균'] = (df_result['연봉(남)'] - df_result['연봉(여)']).mean()


  return df_result


df = get_salary('카카오')
print(df)


'''




<ipython-input-44-2c62bab9864d>:14: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.
  df_result = df_result.append(doc, ignore_index=True)



df_result = pd.DataFrame()
for corp_name in list(df_listed['corp_name'].sample(10)):
  
  df = get_salary(corp_name)
  df_result.append(df)
df_result






'''



취소
 공유
취소
댓글 0
댓글 알림
나의얼굴