3584 lines
167 KiB
Python
3584 lines
167 KiB
Python
#! python3
|
|
#convert_csv_xlsx.py
|
|
#A tool to change CSVs to XLSX
|
|
#Licence: GPL-3.0-or-later
|
|
#Written by Stuart Griffiths, stuart.griffiths@birminghamscouts.org.uk
|
|
#Started 02/07/2022
|
|
#Version:0.4
|
|
#Released: 02/10/2022
|
|
#Status: Working
|
|
#Inputs: CSVs
|
|
#Outputs: XLSXs, zip files, folder
|
|
#Additional modules: openpyxl, pyminizip
|
|
#Next Steps:
|
|
#Issues:
|
|
#Background IP:
|
|
|
|
#Libraries
|
|
import os #Enables file IO
|
|
from pathlib import Path #to work out current working directory
|
|
import csv #required to handle csv files
|
|
import pandas as pd #required to convert CSV to XLSX
|
|
import shutil #required for shell functions
|
|
import datetime #required for getting today's date
|
|
import pyminizip #required to zip a file up with password
|
|
|
|
def convert_csv_xlsx():
|
|
#for every file ending in .csv
|
|
#for files in os.walk(Path.cwd()):
|
|
# for file_path in files:
|
|
# extensions = ('.csv')
|
|
# ext = os.path.splitext(file_path)[1]
|
|
# if ext in extensions:
|
|
# file_name = os.path.splitext(file_path)[0]
|
|
# print(file_name)
|
|
#read_file = pd.read_csv(file)
|
|
# read_file.to_excel(file + '.xlsx')
|
|
|
|
#1 - make working folder
|
|
#get today's date
|
|
today1 = str(datetime.date.today())
|
|
today = datetime.datetime.strptime(today1, "%Y-%m-%d") #dodgy work around comparing datetime to date object error
|
|
working_folder = str(Path.cwd()) + '/' + str(today)
|
|
os.makedirs(working_folder)
|
|
#make district folders
|
|
county_folder = working_folder + '/' + 'county'
|
|
os.makedirs(county_folder)
|
|
CVS_folder = working_folder + '/' + 'CVS'
|
|
os.makedirs(CVS_folder)
|
|
rea_folder = working_folder + '/' + 'rea'
|
|
os.makedirs(rea_folder)
|
|
SCE_folder = working_folder + '/' + 'SCE'
|
|
os.makedirs(SCE_folder)
|
|
SCW_folder = working_folder + '/' + 'SCW'
|
|
os.makedirs(SCW_folder)
|
|
spitfire_folder = working_folder + '/' + 'spitfire'
|
|
os.makedirs(spitfire_folder)
|
|
tame_folder = working_folder + '/' + 'tame'
|
|
os.makedirs(tame_folder)
|
|
csv_folder = working_folder + '/' + '_csv'
|
|
os.makedirs(csv_folder)
|
|
|
|
#2 - GDPR
|
|
#get paths and file name
|
|
file_title = 'county_GDPR'
|
|
folder_name = county_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'CVS_GDPR'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'rea_GDPR'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCE_GDPR'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCW_GDPR'
|
|
folder_name = SCW_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'spitfire_GDPR'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'tame_GDPR'
|
|
folder_name = tame_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#3 - Due Mandatory Training
|
|
#get paths and file name
|
|
file_title = 'county_due_mandatory_training'
|
|
folder_name = county_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'CVS_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'rea_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCE_due_mandatory_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCW_due_mandatory_training'
|
|
folder_name = SCW_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'spitfire_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'tame_due_mandatory_training'
|
|
folder_name = tame_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#4 - Late Mandatory Training
|
|
#get paths and file name
|
|
file_title = 'county_late_mandatory_training'
|
|
folder_name = county_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'CVS_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'rea_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCE_late_mandatory_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCW_late_mandatory_training'
|
|
folder_name = SCW_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'spitfire_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'tame_late_mandatory_training'
|
|
folder_name = tame_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#5 - GDPR
|
|
#get paths and file name
|
|
file_title = 'county_missing_training'
|
|
folder_name = county_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'CVS_missing_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'rea_missing_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCE_missing_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCW_missing_training'
|
|
folder_name = SCW_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'spitfire_missing_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'tame_missing_training'
|
|
folder_name = tame_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#6 - Woodbadge Reports
|
|
#get paths and file name
|
|
file_title = 'county_woodbadge_training'
|
|
folder_name = county_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'CVS_woodbadge_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'rea_woodbadge_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCE_woodbadge_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'SCW_woodbadge_training'
|
|
folder_name = SCW_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'spitfire_woodbadge_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = 'tame_woodbadge_training'
|
|
folder_name = tame_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#7 - General
|
|
file_title = 'due_mandatory_training'
|
|
folder_name = working_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
file_title = 'missing_training'
|
|
folder_name = working_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
file_title = 'GDPR_training'
|
|
folder_name = working_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
file_title = 'late_mandatory_training'
|
|
folder_name = working_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
file_title = 'woodbadge_report'
|
|
folder_name = working_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#CVS group reports
|
|
|
|
#get paths and file name
|
|
file_title = '81_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '81_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '96_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '96_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '192_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '192_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '24_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '24_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '254_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '254_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '89_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '89_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '220_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '220_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '260_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '260_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '100_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '100_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '219_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '219_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '198_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '198_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '232_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '232_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '258_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '258_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '29_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '29_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '279_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '279_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '304_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '304_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '148_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '148_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '325_late_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '325_due_mandatory_training'
|
|
folder_name = CVS_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#Rea
|
|
|
|
#get paths and file name
|
|
file_title = '74_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '74_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '191_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '191_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '145_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '145_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '108_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '108_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '169_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '169_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '293_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '293_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '281_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '281_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '277_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '277_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '195_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '195_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '238_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '238_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '206_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '206_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '283_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '283_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '42_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '42_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '95_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '95_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '303_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '303_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '113_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '113_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '218_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '218_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '332_late_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '332_due_mandatory_training'
|
|
folder_name = rea_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#Spitfire
|
|
|
|
#get paths and file name
|
|
file_title = '298_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '298_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '144_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '144_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '34_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '34_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '234_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '234_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
#get paths and file name
|
|
file_title = '237_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '237_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '126_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '126_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '87_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '87_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '261_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '261_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '118_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '118_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '184_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '184_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '155_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '155_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '211_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '211_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '309_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '309_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '141_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '141_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '305_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '305_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '330_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '330_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '331_late_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '331_due_mandatory_training'
|
|
folder_name = spitfire_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#SCE
|
|
|
|
#get paths and file name
|
|
file_title = '143_late_mandatory_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '143_due_mandatory_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '21_late_mandatory_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|
|
|
#get paths and file name
|
|
file_title = '21_due_mandatory_training'
|
|
folder_name = SCE_folder
|
|
file_name = str(Path.cwd()) + '/' + str(file_title + '.csv')
|
|
#convert to xlsx
|
|
read_file = pd.read_csv(file_name)
|
|
file_name_xlsx = file_title + '.xlsx'
|
|
read_file.to_excel(file_name_xlsx, index = None, header = True)
|
|
#move file to the right place
|
|
file_name_destination = folder_name + '/' + file_name_xlsx
|
|
shutil.move(file_name_xlsx, file_name_destination)
|
|
#move the CSV to the right place
|
|
csv_destination = csv_folder + '/' + str(file_title + '.csv')
|
|
shutil.move(file_name, csv_destination)
|
|