How to Move Files from One Folder to Another by reading CSV (Python Code) ?

You can use excel file information to move files from one folder to another using python script. The script is below

import csv
import shutil
import os

path='E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num'

i=0
with open('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/calc_case_description_train_set.csv', 'r') as csvFile:
    reader = csv.reader(csvFile)
    for row in reader:
        if i==0:
            i=i+1
            continue
        i=i+1
        if not os.path.exists('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm'):
            continue
       
        if row[10]=='MALIGNANT' and row[3]=='RIGHT' and row[4]=='CC':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Malignant/Calc/RCC/')
       
        elif row[10]=='MALIGNANT' and row[3]=='LEFT' and row[4]=='CC':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Malignant/Calc/LCC/')
       
        elif row[10]=='MALIGNANT' and row[3]=='RIGHT' and row[4]=='MLO':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Malignant/Calc/RMLO/')
     
        elif row[10]=='MALIGNANT' and row[3]=='LEFT' and row[4]=='MLO':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Malignant/Calc/LMLO/')
     
 
   
        elif row[10]=='BENIGN' and row[3]=='LEFT' and row[4]=='CC':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign/Calc/LCC/')
       
        elif row[10]=='BENIGN' and row[3]=='RIGHT' and row[4]=='MLO':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign/Calc/RMLO/')
     
        elif row[10]=='BENIGN' and row[3]=='LEFT' and row[4]=='MLO':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign/Calc/LMLO/')
 
        elif row[10]=='BENIGN' and row[3]=='RIGHT' and row[4]=='CC':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign/Calc/RCC/')

   
   
        elif row[10]=='BENIGN_WITHOUT_CALLBACK' and row[3]=='LEFT' and row[4]=='CC':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign_w_cb/Calc/LCC/')
       
        elif row[10]=='BENIGN_WITHOUT_CALLBACK' and row[3]=='RIGHT' and row[4]=='MLO':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign_w_cb/Calc/RMLO/')
     
        elif row[10]=='BENIGN_WITHOUT_CALLBACK' and row[3]=='LEFT' and row[4]=='MLO':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign_w_cb/Calc/LMLO/')
 
        elif row[10]=='BENIGN_WITHOUT_CALLBACK' and row[3]=='RIGHT' and row[4]=='CC':
            shutil.move('E:/Projects/Final_Datasets/CBIS_Orignal_ROI/Calc_num/'+row[0]+'.dcm', 'E:/Projects/Final_Datasets/Multiview_Malig_Ben/Benign_w_cb/Calc/RCC/')

           
     
        print(str(i))

csvFile.close()