SWDesk
[Python] 수집된 자료를 정리하는 파이썬 소스 코드
inhae
2021. 8. 22. 14:08
File, Directory, move, rename
파일, 디렉토리, 이동, 복사
import os
import shutil
from cBExcel import cBExcel
from pandas import DataFrame
sourcePath = "I:/Readables"
sourceFoldername = "OnlineShop"
sourceFolderPath = sourcePath+"/"+sourceFoldername
destPath = "I:/Readables/OnlineShop218"
destTitle = "OnlineShop"
excelFilename = "OnlineShop218.xlsx"
stopWord = "y2mate.com - "
fileList = os.listdir(sourcePath+"/"+sourceFoldername)
print(fileList)
os.mkdir(destPath)
excel1 = cBExcel()
count1 = 0
fileList_DF = DataFrame()
for fileName1 in fileList:
count1 += 1
ext1 = os.path.splitext(fileName1)[-1]
fileName2 = fileName1.replace(",", "-")
fileName3 = fileName2.replace(stopWord, "")
destFilename = destTitle+"{0:03d}".format(count1)+ext1
destFilePathname = destPath + "/"+destFilename
shutil.move(sourceFolderPath+"/"+fileName1, destFilePathname)
fileInfo1 = {
'OriginalFilename': fileName3,
'RenamedTo': destFilename
}
print(fileInfo1)
if fileList_DF.empty:
fileList_DF = DataFrame([fileInfo1])
else:
fileList_DF = fileList_DF.append(fileInfo1, ignore_index=True)
if not fileList_DF.empty:
excel1 = cBExcel()
excelPathname = sourcePath+"/"+excelFilename
excel1.SaveData(fileList_DF, excelPathname)
<참조 링크 페이지>
반응형