Question $9-$ Reading Malformed $.$csv Files Note:

The only kinds of issues you need your function to handle are comma and quote misplacements; don't try and find any other issues with the CSV$.$

With that said, you should assume that data$/$malformed$.$csv is a sample of a larger file that has the same sorts of errors, but potentially in different lines. For example,

data$/$malformed$.$csv has an unnecessary quote $"$ in line $4,$ but your function may be called on another CSV that has a perfectly fine line $4$ but an unnecessary quote

on some other line.

So$,$ don't implement parse$\_$malformed assuming that the commas and quotes are mispositioned on specific lines; rather, implement parse$\_$malformed such that it

can handle these issues on every single line they appear in$.$

A good way to proceed is to open data$/$malformed$.$csv and look carefully at the comma and quote placements.

The first few rows of parse$\_$malformed$(\text{'}$data$/$malformed$.$csv$\text{'})$ should be: fp $=$ Path$(\text{'}$data$\text{'})/$ 'malformed.csv$\text{'}$

cols $=[\text{'}$first$\text{'},$ 'last', 'weight', 'height', 'geo'$]$

df $=$ parse$\_$malformed$($fp$)$

dg $=$ pd$.$read$\_$csv$($fp$,$ nrows$=4,$ skiprows$=10,$ names$=$cols$)$

data$/$malformed$.$csv is a file of comma$-$separated values, containing the following fields:

Unfortunately, the entries contains errors with the placement of commas $(,)$ and quotes that cause pandas $\text{'}$ read$\_$csv function to fail parsing the file with the

default settings. Don't believe us$?$ Try using pd$.$read$\_$csv on data$/$malformed$.$csv and look at what happens.

As a result, instead of using pd$.$read$\_$csv$,$ you must read in the file manually using Python's built$-$in open function.

Complete the implementation of the function parse$\_$malformed, which takes in a file path $(fp)$ and returns a parsed, properly$-$typed DataFrame with the information in

the corresponding file. For example, fp may be 'data$/$malformed$.$csv$\text{'}.$ The DataFrame should contain the columns described in the data description table above $($with

the specified types$).$