You can extract one or more values from within a column of values can turn data into meaningful data. This section describes how to extract object elements by the following transformation.
For example, suppose your restaurant dataset includes a set of characteristics in the
restFeatures column in the following JSON format, from which you are interested in the total number of seats in the restaurant.
After converting into separate columns, you can perform a simple sum of the
CounterSeats columns to determine the total number of seats in the restaurant.
The final table looks like the following: