import pandas as pd
from collections import Counter
import os
df = pd.read_csv(r'/lss/research/itrns-iwz/camera_images/cameramap.csv')
df = df.dropna()

#Declarations
#This gives the old folder names like 33905, 33906
subfolder_old = df.iloc[:, 0]
#This gives the olde folder names along with path like /lss/research/itrns-iwz/camera_images/33905
subfolpath_old = []
df_old = df['Old Folder']
df_new = df['New Folder']
df_newsubURL = df['New Subfolder']

camFolder = '/lss/research/itrns-iwz/camera_images/'

for sub in subfolder_old:
    subfolpath_old.append(camFolder + str(sub))
    #print(sub)
# mypath = camFolder + subfolder_old
# list_subfolders_with_paths = [f.name for f in os.scandir(mypath) if f.is_dir()]

list_subfolders_with_paths = []
i = 0
for subfol in subfolpath_old:
    list_subfolders_with_paths.clear()
    list_subfolders_with_paths = [f.name for f in os.scandir(subfol) if f.is_dir()]
    df_newsub = df_newsubURL[i].split('/')[-1].replace('.jpg','')
    for subfolders in list_subfolders_with_paths:
        #print("sub: ", subfolders, "df_new: ", df_new[i], "df_newsub: ", df_newsub)
        print("mv "+subfol+"/"+subfolders+"/* /lss/research/itrns-iwz/camera_images/"+df_new[i]+"/"+subfolders+"/"+df_newsub+"/")
    print("=======================================")
    i=i+1