(0)

Hi, I am having trouble with the first part of this question below:

I know how to plot the heatmap, I just don't know how to create a new df for violators that obtained 3 business licenses or more under the same dba name.

Here is how I created the original data frame:

Any help on how to create a new df to filter for these results would be greatly appreciated!

Also, I think I have to answer this question using the format below, this is an example of another problem I solved:

Plot on the Heatmap those frequent violators who have obtained 3 business licenses or more under the same DBA Name through out the liftime of their business. You can answer this question from data already queried or you can do a new Elasticsearch query. In [153]: df1 = df_top_frequent_violators.groupby('DBA Name') In [154]: violations_count =df1[ [Inspection ID'].,count () licenses_count =df1[ 'License # ].nunique( ) In [156]: df_final = pd.DataFrame( { 'Violations': violations_count, 'Licenses \#': licenses_count }) In [157]: df_final.head(10) Out [157] : Violations Licenses DBA Name \begin{tabular}{rll} \hline A CHILD'S WORLD EARLY LEARNING CENTER & 7 & 2 \\ ADA S MCKINLEY MAGGIE DRUMMON & 5 & 2 \\ AMAZING GRACE DAYCARE CENTER & 7 & 2 \\ ANGELS & 5 & 2 \\ BOTTLES TO BOOKS LEARNING CENTER & 8 & 2 \\ BUSY BUMBLE BEE ACADEMY DAYCARE & 9 & 3 \\ COMMONWEALTH DAYCARE CENTER & 6 & 1 \\ DISCOVERY LEARNING ACADEMY, INC. & 6 & 2 \\ EARLY CHILDHOOD EDUCARE CENTER & 6 & 3 \end{tabular}