Question $2$: generate$\_$descriptors$()$

Write a function called generate$\_$descriptors$($df$)$ which takes in the DataFrame you loaded from Question$1$ and returns a dataframe of all unique ticket descriptions and how frequent they are $($e$.$g$.$ it will tell you how many "HANDICAP" or $"$NO PERMITS U$/$M$"$ tickets have been issued$)$ for each of the following three time periods: morning $(3$ am to $11$:$59$ am$),$ afternoon $(12$ pm $-5$:$59$ pm$),$ and evening $(6$ pm $-2$:$59$ am$).$

Make sure you drop na values of input df$.$

The DataFrame which generate$\_$descriptors$($df$)$ returns should have $3$ rows and $51$ columns.

Index should be labelled as Morning, Afternoon, and Evening.

Column names should be unique values of df$["$Description$"].$

Need help with question $2$

here is my code:

def generate$\_$descriptors$($df$)$:

import xlrd

import pandas as pd

import numpy as np

import re

# Filter all warnings. If you would like to see the warnings, please comment the two lines below.

import warnings

warnings.filterwarnings$(\text{'}$ignore$\text{'})$

# YOUR CODE HERE

# Preprocess the data by dropping NA values

df $=$ df$.$dropna$()$

df$[\text{'}$Time$\text{'}]=$ pd$.$to$\_$datetime$($df$[\text{'}$Time$\text{'}])$

df$[\text{'}$Period$\text{'}]=$ pd$.$cut$($df$[\text{'}$Time$\text{'}].$dt$.$hour, bins$=[0,3,12,18,24],$ labels$=[\text{'}$Evening$\text{'},$ 'Morning', 'Afternoon', 'Evening'$],$ include$\_$lowest$=$True$)$

df$\_$grouped $=$ df$.$groupby$([\text{'}$Period$\text{'},$ 'Description'$]).$size$().$unstack$().$fillna$(0)$

df$\_$grouped $=$ df$\_$grouped.loc$[[\text{'}$Morning$\text{'},$ 'Afternoon', 'Evening'$]]$

return df

im getting an error.

Important to refer to question $1$:

Question $1$: load$\_$ticket$\_$data$()$

First, write the code to create a single DataFrame object in a function called load$\_$ticket$\_$data$().$ This function should return the full dataframe and take no parameters $($you can assume the ticket files are in the same directory as your assignment notebook$).$ Column labels should be as follows:

$[\text{'}$Ticket #$\text{'},$ 'Badge', 'Issue Date $\text{'},$ 'IssueTime', 'Plate', 'State', 'Make', 'Model', 'Violation', $\text{'}$ Description', 'Location', 'Meter', $\text{'}$ Fine $\text{'},$ 'Penalty'$]$

Here are some hints.

Be sure to scroll through every single sheet to make sure what rows should be dropped.

Make sure to exclude unnecessary footers and headers from the datafile.

Check if your header labels are correct.

here is the answer:

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

import xlrd

import pandas as pd

import numpy as np

import re

# Filter all warnings. If you would like to see the warnings, please comment the two lines below.

import warnings

warnings.filterwarnings$(\text{'}$ignore$\text{'})$

# YOUR CODE HERE

# List of column labels

column$\_$labels $=[$

"Ticket #$",$

"Badge",

"Issue Date $",$

"IssueTime",

"Plate",

"State",

"Make",

"Model",

"Violation",

"Description",

"Location",

"Meter",

"Fine",

"Penalty",

$]$

# Prepare a list

# reading all excel files

excel$\_$files $=[$

$\{$

"name": "AnnArbor$-$TicketViolation$2015.$xls$",$ # EXCEL FILE $01$

"sheets": $[$

$\{"$name$"$: "Sheet$1",$ "skip$\_$rows": $2,$ "skip$\_$footer": $0\},$ # SHEET $1$ INFO

$\{"$name$"$: "Sheet$2",$ "skip$\_$rows": $1,$ "skip$\_$footer": $0\},$ # SHEET $2$ INFO

$\{"$name$"$: "Sheet$3",$ "skip$\_$rows": $1,$ "skip$\_$footer": $1\},$ # SHEET $3$ INFO

$],$

$\},$

$\{$

"name": "AnnArbor$-$TicketViolation$2016.$xls$",$ # EXCEL FILE $02$

"sheets": $[$

$\{"$name$"$: "Sheet$1",$ "skip$\_$rows": $2,$ "skip$\_$footer": $0\},$ # SHEET $1$ INFO

$\{"$name$"$: "Sheet$2",$ "skip$\_$rows": $1,$ "skip$\_$footer": $0\},$ # SHEET $2$ INFO

$\{"$name$"$: "Sheet$3",$ "skip$\_$rows": $1,$ "skip$\_$footer": $1\},$ # SHEET $3$ INFO

$],$

$\},$

$\{$

"name": "AnnArbor$-$TicketViolation$2017.$xls$",$ # EXCEL FILE $03$

"sheets": $[$

$\{"$name$"$: "Sheet$1",$ "skip$\_$rows": $2,$ "skip$\_$footer": $0\},$ # SHEET $1$ INFO

$\{"$name$"$: "Sheet$2",$ "skip$\_$rows": $1,$ "skip$\_$footer": $0\},$ # SHEET $2$ INFO

$\{"$name$"$: "Sheet$3",$ "skip$\_$rows": $1,$ "skip$\_$footer": $1\},$ # SHEET $3$ INFO

$],$

$\},$

$\{$

"name": "AnnArbor$-$TicketViolation$2018.$xls$",$ # EXCEL FILE $04$

"sheets": $[$

$\{"$name$"$: "Sheet$1",$ "skip$\_$rows": $2,$ "skip$\_$footer": $0\},$ # SHEET $1$ INFO

$\{"$name$"$: "Sheet$2",$ "skip$\_$rows": $1,$ "skip$\_$footer": $0\},$ # SHEET $2$ INFO

$\{"$name$"$: "Sheet$3",$ "skip$\_$rows": $1,$ "skip$\_$footer": $1\},$ # SHEET $3$ INFO

$],$

$\},$

$\{$

"name": "AnnArbor$-$TicketViolation$2019.$xls$",$ # EXCEL FILE $05$

"sheets": $[$

$\{"$name$"$: "Sheet$1",$ "skip$\_$rows": $2,$ "skip$\_$footer": $0\},$ # SHEET $1$ INFO

$\{"$name$"$: "Sheet$2",$ "skip$\_$rows": $1,$ "skip$\_$footer": $0\},$ # SHEET $2$ INFO

$\{"$name$"$: "Sheet$3",$ "skip$\_$rows": $1,$ "skip$\_$footer": $1\},$ # SHEET $3$ INFO

$],$

$\},$

$\{$

"name": "AnnArbor$-$TicketViolation$-$jan$2020.$xls$",$ # EXCEL FILE $06$

$"$