파이썬 판다스 엑셀 날짜 출력 질문입니다 채택완료

import pandas as pd</p>

<p>from operator import index</p>

<p>import numpy as np</p>

<p>from datetime import datetime</p>

<p> </p>

<p>df= pd.read_excel('C:/Users/user/Desktop/2022년 매출.매입 현황_TEST.xlsx',</p>

<p>                  sheet_name='22-01',usecols='AE,D,C,U,Y',header=6)</p>

<p>df=df.iloc[0:67]</p>

<p>df=df.rename(columns={'인력':'성명','Unnamed: 20':'금액(Free)', 'Unnamed: 24':'금액(사업자)','Unnamed: 30':'지급일'})</p>

<p> </p>

<p>df['용역비지급']=' '</p>

<p>df=df[['지급일','용역비지급','소속','성명','금액(Free)','금액(사업자)']]</p>

<p> </p>

<p>df=df.sort_values(by='소속')</p>

<p>df=df.iloc[0:31]</p>

<p>df['금액(Free)']=df['금액(Free)'].apply(lambda x : "{:,}".format(x))</p>

<p>df['금액(사업자)']=df['금액(사업자)'].apply(lambda x : "{:,}".format(x))</p>

<p>df['금액(Free)']= np.where(df['금액(Free)']=='0',df['금액(사업자)'],df['금액(Free)'])</p>

<p> </p>

<p>df=df.drop(['금액(사업자)'],axis=1)</p>

<p>df=df.rename(columns={'금액(Free)':'금액'})</p>

<p> </p>

<p>df=df.replace(15,'22-02-15')</p>

<p>df=df.replace(10,'22-02-10')</p>

<p>df=df.replace(30,'22-02-28')</p>

<p>df=df.replace('말일','22-02-28')</p>

<p>df=df.replace(20,'22-02-18')</p>

<p>df=df.replace(31,'22-02-28')</p>

<p> </p>

<p>df=df.set_index("지급일")</p>

<p> </p>

<p>df=df.sort_values(by=['지급일','소속','성명'])</p>

<p> </p>

<p>df.to_excel('C:/Users/user/Desktop/출금.xlsx')