GIVE ME THE PYTHON CODE WHICH SOLVES STEP $1$ OF MY ASSIGNMENT WHICH IS DESCRIBED BELOW:

Step $1$: Assignment$4.$py

In Assignment$4.$py implement a class called Records. This class will represent the

entire record dataset you$$re working with, credit card transactions and consumer

complaints. The class must have the attribute record$\_$dict.

This class should implement the following methods:

$\_\_$init$\_\_$ Constructor that takes the a file$\_$name and file$\_$title as an argument.

The method should create a record$\_$dict attribute and makes a call to the

load$\_$data method.

$$ record$\_$dict: dictionary that will create a key$-$value pair using file$\_$title as the

key and another defaultdict as the value, and this nested defaultdict will have an empty list as a value by default. You must use a defaultdict and

lambda function for this behavior

load$\_$data $$ Method takes file$\_$name and file$\_$title as arguments, and loads the

data from the file and makes a call to the $\_$create$\_$container method described

below. Using the Entry namedtuple container created, use it to create an Entry

namedtuple for each line in the file. Finally append it to the record$\_$dict using

file$\_$title as the key for the top layer defaultdict and data as the key for the

nested defaultdict. You should end up with a list of namedtuples associated with

the keys file$\_$title and data. Please refer to the structure of record$\_$dict given

above.

This method must be able to handle a file not found error, and should ask the

user to input a valid file name until they entered a valid file name or quit if the

user enters $$q$.$ The exception handling must also make use of an $$else$$ clause

to print to the console that the file was loaded successfully.

Note: to extract the first line of the file you can use the method next$().$

$\_$create$\_$container $$ Method takes the first line of the file, which contains the

names of the columns, as an argument. It must make a call to

$\_$standardize$\_$col$\_$names method described below.

You must then unpack the column names to create a namedtuple called Entry

that will have the column names as the names of the attributes. Return the Entry

namedtuple

$\_$standardize$\_$col$\_$names $-$ Method takes list of column names and replaces

$\_,-$ and blank spaces with an empty string, you can use str$.$replace method

to do this. After standardizing the column names, check that all column names

are alpha$-$numeric $($meaning it$$s only letters and numbers$).$ If the column names

are not alpha$-$numeric, you must raise a custom exception called

InvalidColumnNames described below in Step $2.$ You must pass the column

names to the exception and your $$except$$ statement should print the msg

attribute of the InvalidColumnNames exception class and ask the user to input

the names of the columns by hand. Return the standardized columns list.

$$ record$\_$stats $-$ Method takes the file$\_$title, a column name you wish to process

and a lambda function, as arguments. You will need to retrieve the values for the

given column in the appropriate data list using the lambda function that was

passed in and the map method. Once you have extracted the values use a

Counter object to summarize the number of instances in that column, this

should give you a Counter object that pairs the value in the column with the

number of times that value appeared in your data. Store the result inside of the

appropriate file$\_$title dictionary using $$stats$\_$column$\_$name$$ as the key $($this

should also be done dynamically$).$

$$ extract$\_$top$\_$n $-$ Method takes an integer, file$\_$title and a stats$\_$column$\_$name as

arguments. It must return the top n most frequent values for the Counter object

created by the record$\_$stats method for the given column, where n is the integer

that was passed into the function. If the stats$\_$column$\_$name doesn$$t exist, you

must raise a custom NoRecordStatsFound exception described below. You

must pass the stats$\_$column$\_$name to the exception and your $$except$$

statement should print the msg attribute of the NoRecordStatsFound exception

class and have a return statement to exit the method

SO THERE ARE TWO CSVS INVOLVED

COLUMNS $($total of $15$ columns$)$OF credit card csv are as follows

Series$\_$reference $,$Period $,$Data$\_$value $,$Suppressed, STATUS $,$UNITS, Magnitude, Subject, Group,Series$\_$title$\_1,$Series$\_$title$\_2,$Series$\_$title$\_3,$ Series$\_$title$\_4,$ Series$\_$title$\_5$

where $,$Series$\_$title$\_3,$ Series$\_$title$\_4,$ Series$\_$title$\_5$

have no entries

FOR customer$\_$complaints column names $($total of $18)$ are :

Date received $,$Product $,$Sub$-$product, Issue, Sub$-$issue $,$Consumer complaint narrative, Company public response $,$Company $,$State $,$ZIP code, Tags $,$Consumer consent provided?, Submitted via, Date sent to company $,$Company response to consumer $,$Timely response?, Consumer disputed?, Complaint ID

please make a note that all the rows columns must not contain entries there may be or there might not be