I am having below issue when I have one dataframe and it is having one column name is attribute and attribute type is

|– attributes: string (nullable = true)

in that column i am having values like below

[
    {'name': 'sfcc.created_by', 'type': 'STRING', 'value': 'DummyUser'},
    {'name': 'shippingLines', 'type': 'JSON', 'value': {'code': 'DUMMYCODE', 'price': '0', 'discountedPrice': '0'}},
    {'name': 'sourceChannel', 'type': 'STRING', 'value': 'dummyOS'},
    {'name': 'leaveAtDoor', 'type': 'BOOLEAN', 'value': False},
    {'name': 'actualCreateDate', 'type': 'STRING', 'value': '2024-01-01T00:00:00.000Z'},
    {'name': 'orderCompleteDate', 'type': 'STRING', 'value': '2024-01-02T00:00:00.000Z'},
    {'name': 'sfcc.order_date', 'type': 'STRING', 'value': '2024-01-01T00:00:00.000Z'},
    {'name': 'orderSuccessfullyCreatedInSAP', 'type': 'BOOLEAN', 'value': True},
    {'name': 'splitPayments', 'type': 'JSON', 'value': [{'price': '100', 'gateway': 'DUMMYGATEWAY', 'paymentGatewayName': 'DUMMY_CARD'}]},
    {'name': 'sfcc.customer_locale', 'type': 'STRING', 'value': 'en_US'},
    {'name': 'customerId', 'type': 'STRING', 'value': '000DummyID0000'},
    {'name': 'financialStatus', 'type': 'STRING', 'value': 'DUMMYSTATUS'},
    {'name': 'addressLine1', 'type': 'STRING', 'value': 'Dummy Street 1'},
    {'name': 'sourceLocation', 'type': 'STRING', 'value': 'DUMMYWEBSITE'},
    {'name': 'addressLine2', 'type': 'STRING', 'value': 'Dummy Street 2'},
    {'name': 'subtotalPrice', 'type': 'STRING', 'value': '100'},
    {'name': 'carrierId', 'type': 'STRING', 'value': 'DummyCarrier'},
    {'name': 'isCancelable', 'type': 'BOOLEAN', 'value': False},
    {'name': 'consignments', 'type': 'JSON', 'value': ['0000-0000-0000-0000']},
    {'name': 'sfcc.shipments', 'type': 'JSON', 'value': {'shipments': [{'items': [{'skuRef': '0000000000', 'quantity': 1}], 'isGift': False, 'shipmentId': '00000000', 'giftMessage': None, 'shippingAddress': {'area': 'Dummy Area', 'city': 'Dummy City', 'name': 'John Doe', 'phone': '+00000000000', 'street': 'Dummy Street', 'country': 'XX', 'lastName': 'Doe', 'postcode': '00000', 'firstName': 'John'}, 'shippingMethodRef': 'XXX000'}]}}
]

I want to get all result in separate columns like

sfcc.created_by  shippingLines
DummyUser        {'code': 'DUMMYCODE', 'price': '0', 'discountedPrice': '0'}