We are an internet startup company with a website that recommends products to our users based on the preferences. They give us their preferences on different facets of items by using a series of sliders. An example would be for laptops, how important is long battery life to you? The user could move the slider anywhere from a 1 (not important) to 10 (critical).

This data is then stored as JSON objects in our SQL database. The field ends up looking like {\"38\":1,\"36\":6,\"37\":8} which reads as "This user rated facet 38 a 1 in importance, facet 36 a 6, and facet 37 an 8". There can be up to 100 facet/rating pairs per field.

What we need is someone to use a programmatic approach and write a script to transform this field into something usable. Ideally the outcome would resemble survey data, where each facet has its corresponding rating for each user.

This would be a one-time project. We would send you all the necessary tables from our SQL server and ask you to solve this in the m...