Trying to get counts/sum/percentages from pandas similar to pivot table

[cubangt]

I understand that, its provided as example of how im creating the json.
Im looking for the output to be like my example in the first line that has my values.

The point of adding the sample code was to show that the output json file does not have this portion

data = '[

It outputs starting like this

{"

So im trying to get it so that the json output wraps the data starting with data = '[{ }]';