import pandas as pd

def load$\_$ticket$\_$data$()$:

file$\_$paths

'AnnArbor$-$TicketViolation$2017.$xIs',

'AnnArbor$-$TicketViolation$-$jan$2020.$xIs',

'AnnArbor$-$TicketViolation$2019.$xIs',

'AnnArbor$-$TicketViolation$2015.$xIs',

'AnnArbor$-$TicketViolation$2018.$xIs',

'AnnArbor$-$TicketViolation$2016.$xIs'

$]$

df$\_$list $=[]$

total$\_$rows $=0$

for file$\_$path in file$\_$paths:

if $\text{'}2020\text{'}$ in file$\_$path:

df $=$ pd$.$read$\_$csv$($file$\_$path, header$=2,$ skipfooter$=1)$ # Skip $1$ footer row for $2020$

else:

xls $=|pd.$ ExcelFile$($file$\_$path$)$

sheets$\_$names$=$xls$.$sheet$\_$names

df$=$pd$.$DataFrame$()$

for sheet$\_$name in sheet$\_$names:

sheet$\_$df$=$pd$.$read$\_$excel$($file$\_$path, sheet$\_$name$=$sheet$\_$name, header$=$None, skipfooter$=0)$

if sheet$\_$name in $[\text{'}$Sheet$2\text{'},$ 'Sheet$3\text{'}]$ and sheet$\_$df$.$columns$[0]==\text{'}2080017363\text{'}$: sheet$\_$df $=$ sheet$\_$df$.$iloc$[1$:$]$ # Skip the first row for sheet$2$ and sheet$3$ of $2015-2019df=$ pd$.$concat$([$df$,$ sheet$\_$df$],$ ignore$\_$index$=$True$)$

total$\_$rows $+=$ len$($df$)$

if $\text{'}2020\text{'}$ in file$\_$path:

df$.$rename$($columns$=\{"$ Fine $"$: "Fine"$\},$ inplace$=$True$)$

else:

df$.$columns

'Ticket #$\text{'},$ 'Badge', 'Issue Date', 'IssueTime', 'Plate', 'State',

'Make', 'Model', 'Violation', 'Description', 'Location', 'Meter',

'Fine', 'Penalty'

$]$

df$\_$list.append$($df$)$

full$\_$df $=$ pd$.$concat$($df$\_$list, ignore$\_$index$=$True$)$

if total$\_$rows $!=$ len$($full$\_$df$)$:

print$("$Total rows do not match the number of rows in the concatenated DataFrame."$)$

return full$\_$df

# Testing the function

df$\_1\_$test $=$ load$\_$ticket$\_$data$()$

print$("$Total number of rows in all files:", len$($df$\_1\_$test$))$

Cannot get correct answer