import csv

import sys

from datetime import datetime

def read$\_$ssn$\_$eid$\_$mapping$($file$\_$path$)$:

ssn$\_$eid$\_$map $=\{\}$

with open$($file$\_$path, mode$=\text{'}$r$\text{'})$ as file:

reader $=$ csv$.$reader$($file$)$

for row in reader:

ssn$,$ eid $=$ row

ssn$\_$eid$\_$map$[$ssn$[-4$:$]]=$ eid

return ssn$\_$eid$\_$map

def process$\_$sdf$($file$\_$path, ssn$\_$eid$\_$map, pp$\_$end$\_$dates$)$:

pp$\_$data $=[]$

bw$\_$data $=[]$

with open$($file$\_$path, mode$=\text{'}$r$\text{'})$ as file:

for line in file:

if line.startswith$(\text{'}!\text{'})$:

continue

if line.startswith$(\text{'}$X$\text{'})$ or line.startswith$(\text{'}$W$\text{'})$:

employee$\_$type $=\text{'}$PP$\text{'}$ if line.startswith$(\text{'}$X$\text{'})$ else $\text{'}$BW$\text{'}$

ssn $=$ line$[2$:$11].$strip$()$

if $\text{'}611$EMS' in line and ssn$[-4$:$]$ in ssn$\_$eid$\_$map:

eid $=$ ssn$\_$eid$\_$map$[$ssn$[-4$:$]]$

columns $=[$float$($x$)$ for x in line$[11$:$].$split$()]$

if employee$\_$type $==\text{'}$PP$\text{'}$:

pp$\_$data.append$([$

eid, pp$\_$end$\_$dates$[1],$ 'Performances', sum$($columns$[1$:$3])$

$])$

else:

bw$\_$data.extend$([$

$[$eid$,$ pp$\_$end$\_$dates$[1],$ 'Vacation Used Info', columns$[8]],$

$[$eid$,$ pp$\_$end$\_$dates$[0],$ 'Shift Pay City', columns$[0]],$

$[$eid$,$ pp$\_$end$\_$dates$[1],$ 'Shift Pay City', columns$[4]],$

$[$eid$,$ pp$\_$end$\_$dates$[0],\text{'}$ST Overtime', columns$[2]+$ columns$[3]],$

$[$eid$,$ pp$\_$end$\_$dates$[1],\text{'}$ST Overtime', columns$[5]+$ columns$[6]],$

$[$eid$,$ pp$\_$end$\_$dates$[1],$ 'Docked Pay', columns$[7]],$

$[$eid$,$ pp$\_$end$\_$dates$[1],$ 'Medical Used Info', columns$[14]],$

$[$eid$,$ pp$\_$end$\_$dates$[1],$ 'Sick Used Info', columns$[9]]$

$])$

return pp$\_$data, bw$\_$data

def write$\_$csv$($file$\_$name, data$)$:

with open$($file$\_$name, mode$=\text{'}$w$\text{'},$ newline$=\text{'}\text{'})$ as file:

writer $=$ csv$.$writer$($file$)$

writer.writerow$([\text{'}$Employee ID$\text{'},$ 'End Date', 'Category', 'Hours'$])$

for row in data:

row$[3]=$ f$"\{$row$[3]$:$\mathrm{.}2$f$\}"$

writer.writerow$($row$)$

def main$()$:

# Prompt for input values

sdf$\_$file $=$ input$("$Enter the path to the SDF file: $")$

ems$\_$file $=$ input$("$Enter the path to the EMS file: $")$

pp$\_$end$\_$date$1=$ input$("$Enter the first PP end date $($YYYY$-$MM$-$DD$)$: $")$

pp$\_$end$\_$date$2=$ input$("$Enter the second PP end date $($YYYY$-$MM$-$DD$)$: $")$

pp$\_$end$\_$dates $=[$pp$\_$end$\_$date$1,$ pp$\_$end$\_$date$2]$

# Read SSN to EID mapping

ssn$\_$eid$\_$map $=$ read$\_$ssn$\_$eid$\_$mapping$($ems$\_$file$)$

# Process the SDF file

pp$\_$data, bw$\_$data $=$ process$\_$sdf$($sdf$\_$file, ssn$\_$eid$\_$map, pp$\_$end$\_$dates$)$

# Write output files

pp$\_$file$\_$name $=$ f$"611-$EMS$-$PP$-\{$pp$\_$end$\_$dates$[1]\}.$csv$"$

bw$\_$file$\_$name $=$ f$"611-$EMS$-$BW$-\{$pp$\_$end$\_$dates$[1]\}.$csv$"$

write$\_$csv$($pp$\_$file$\_$name, pp$\_$data$)$

write$\_$csv$($bw$\_$file$\_$name, bw$\_$data$)$

if $\_\_$name$\_\_=="\_\_$main$\_\_"$:

main$()$

Input information:

Enter the path to the SDF file: F:$\backslash$SDF$\_$Translation$\backslash$DP$611.$SDF

Enter the path to the EMS file: F:$\backslash$SDF$\_$Translation$\backslash$Dept$611$EMS$\backslash$EMS$\_$Person$\_$Number$\_$To$\_$Last$5.$csv

Enter the first PP end date $($YYYY$-$MM$-$DD$)$: $2024-05-25$

Enter the second PP end date $($YYYY$-$MM$-$DD$)$: $2024-06-01$

The Python script provided aims to automate the translation of data from an input file format $($SDF$)$ to specific output formats for per$-$performance $($PP$)$ and regular employees $($BW$).$ The script follows detailed instructions regarding data extraction, transformation, and output formatting.

Need to amend the script with a print output folder results in the following format as dated "Outputfloder$\_($YYYY$-$MM$-$DD$)$ and must print the containing the two produced files titled

$(611-$EMS$-$PP$)=$PER$-$PERF$-$EMPLOYEES

$(611-$EMS$-$bw$)=$REGULAR$-$EMPLOYEES