import pandas as pd
import datetime
import os, shutil
import xlsxwriter

INPUT = "."
EXCEL_PATH = "."
FOLDER_NAME = "backup"

cols = ["", "SUBJECT", "Sign", "Count",
   "Place", "teacher", "mode",
   "type", "count-2", "sub",
   "amount", "sub-2", "amount3",
   "place-2", "Amount5", "school-join",
   "close", "amount4", "head1",
   "serial", "amount8", "serial-5", "amount-9", "GROUP1", "GROUP2", "GROUP3"]
int_cols = ['amount', 'amount3', 'Amount5', 'amount4', 'amount8', 'amount-9']
extra_XY_cols = ['Value', 'amount', 'amount3', 'amount4', '', 'amount5', 'count']

extra_Z_cols = ['Class', 'subject', '', 'Amo unt', 'amount3', 'AMOUNT4', 'AMOUNT5']

X12 = pd.DataFrame([cols])
Y14 = pd.DataFrame([cols])
Z14 = pd.DataFrame([cols])

INFO_FILE = "data-for-infosheet.txt"

files = [f for f in os.listdir(INPUT) if not os.path.isdir(f)]

def write_to_excel(X12, Y14, Z14, output_path):
excel_path = os.path.join(EXCEL_PATH, output_path)
writer = pd.ExcelWriter(excel_path)

X12.columns = cols
Y14.columns = cols
Z14.columns = cols

X12 = X12.drop(X12.index[[0]], axis=0)
Y14 = Y14.drop(Y14.index[[0]], axis=0)
Z14 = Z14.drop(Z14.index[[0]], axis=0)

for col in int_cols:
   X12[col] = X12[col].str.replace(';', '.')
   Y14[col] = Y14[col].str.replace(';', '.')
   Z14[col] = Z14[col].str.replace(';', '.')

X12[int_cols] = X12[int_cols].astype('float')
Y14[int_cols] = Y14[int_cols].astype('float')
Z14[int_cols] = Z14[int_cols].astype('float')

2. Sorting Numbers in Python 3 (40 points) Write an application i...