In Python create a hash of a hash using given CSV data.

It will take a string array which is the output of your function my$\_$data$\_$transform, it will return a json string of hash of hash following this format: $\{$COLUMN: $\{$Value$1$: nbr$\_$of$\_$occurence$\_$of$\_$value$\_1,$ Value$2$: nbr$\_$of$\_$occurence$\_$of$\_$value$\_2,...\},...\}$ Order of Column will be the order they are in the header of the CSV $($Gender first then Email, etc$)$ Order of the Value will be the order they appear in each line from top left. Use STRINGS as keys $(=>$ Do not use any symbol or any fancy things. It doesn't translate well in json. $($no :Age $=>$ "Age"$))$

So far I have this:

Expected Return Value $\{"$Gender$"$:$\{"$Male$"$:$3,$"Female":$2\},$"Email":$\{"$yahoo$.$com":$2,$"hotmail.com":$3\},$"Age":$\{"21->40"$:$2,"66->99"$:$2,"41->65"$:$1\},$"City":$\{"$Seattle$"$:$2,$"Detroit":$1,$"Las Vegas":$1,$"Chicago":$1\},$"Device":$\{"$Safari iPhone":$1,$"Chrome Android":$2,$"Chrome":$2\},$"Order At$"$:$\{"$afternoon$"$:$4,$"morning":$1\}\}$

Return Value $"\{\backslash "$Gender$\backslash "$: $\{\backslash "$Male$\backslash "$: $3,\backslash "$Female$\backslash "$: $2\},\backslash "$Email$\backslash "$: $\{\backslash "$yahoo$.$com$\backslash "$: $2,\backslash "$hotmail$.$com$\backslash "$: $3\},\backslash "$Age$\backslash "$: $\{\backslash "21->40\backslash "$: $2,\backslash "66->99\backslash "$: $2,\backslash "41->65\backslash "$: $1\},\backslash "$City$\backslash "$: $\{\backslash "$Seattle$\backslash "$: $2,\backslash "$Detroit$\backslash "$: $1,\backslash "$Las Vegas$\backslash "$: $1,\backslash "$Chicago$\backslash "$: $1\},\backslash "$Device$\backslash "$: $\{\backslash "$Safari iPhone$\backslash "$: $1,\backslash "$Chrome Android$\backslash "$: $2,\backslash "$Chrome$\backslash "$: $2\},\backslash "$Order At$\backslash "$: $\{\backslash "$afternoon$\backslash "$: $4,\backslash "$morning$\backslash "$: $1\}\}"$

$---------$ code snip $--------------$

import json

$"""$

:type $$input: $\{$String$[]\}$

:rtype: string

$"""$

def my$\_$data$\_$process$($input$)$:

$$ headers $=$ input$[0].$split$(",")$

$$ data $=[$line$.$split$(",")$ for line in input$[1$:$]]$

$$ # Filter headers

$$ required$\_$headers $=["$Gender$",$ "Email", "Age", "City", "Device", "Order At$"]$

$$ required$\_$indices $=[$i for i$,$ header in enumerate$($headers$)$ if header in required$\_$headers$]$

$$ # Dictionary to count occurrences of each key value

$$ counts $=\{$header: $\{\}$ for header in required$\_$headers$\}$

$$ # Process each row

$$ for row in data:

$$ for index in required$\_$indices:

$$ header $=$ headers$[$index$]$

$$ value $=$ row$[$index$].$strip$()$

$$ if value in counts$[$header$]$:

$$ counts$[$header$][$value$]+=1$

$$ else:

$$ counts$[$header$][$value$]=1$

$$ counts

$$ return json.dumps$($counts$)$