위키북스 wikibook
wikibook
/ py-first-step-3-2.py
Created
November 30, 2020 07:52
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| folder = 'C:/myPyExcel/data/ch07/sales_data/' | |
| merged_excel_file = folder + '상반기_제품_판매량_통합.xlsx' |
wikibook
/ py-first-step-3-3.py
Created
November 30, 2020 07:55
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # DataFrame 데이터(total_df)를 생성한 엑셀 객체에 쓰기(옵션 지정) | |
| total_df.to_excel(merged_excel_file, # 엑셀 파일 이름 | |
| sheet_name='상반기_제품_판매량_통합', # 시트 이름 지정 | |
| index=False) # DataFrame 데이터 index는 출력 안함 |
wikibook
/ py-first-step-3-4.py
Created
November 30, 2020 07:57
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| print("생성 파일:", merged_excel_file) # 생성한 엑셀 파일 경로 |
OlderNewer