Как сделать регулярку по списку словарей?
у меня есть данные
data = [{
"Object": "info",
"subobject": "info",
"Name": "nametest.300_Т9Plus",
"Ip": "",
"Status": "info",
"Mac": "info",
"sn": "SN: abc12345651",
"Worker": "info",
"Info_1": "info",
"Info_2": "info",
"Info_3": "info",
"Info_4": "info"
},
{
"Object": "info",
"subobject": "info",
"Name": "info",
"Ip": "",
"Status": "info",
"Mac": "info",
"sn": "SN: DG5678900 test\r",
"Worker": "info",
"Info_1": "info",
"Info_2": "info",
"Info_3": "info",
"Info_4": "info"
},
{
"Object": "info",
"subobject": "info",
"Name": "name.017_S17",
"Ip": "info",
"Status": "info",
"Mac": info,
"sn": "SN: FXD56789312\n",
"Worker": "info",
"Info_1": "info",
"Info_2": "info",
"Info_3": "info",
"Info_4": "info"
}]
Как мне про мощи регулярнее пройтись и поверить значение у ключей "sn" и "name" чтобы в итоге было:
result = [{
"Object": "info",
"subobject": "info",
"Name": "nametest.300_Т9Plus",
"Ip": "info",
"Status": "info",
"Mac": "info",
"sn":"abc12345651",
"Worker": "info",
"Info_1": "info",
"Info_2": "info",
"Info_3": "info",
"Info_4": "info"
"model": "Т9Plus"
},
{
"Object": "info",
"subobject": "info",
"Name": "123z.040_S17",
"Ip": "",
"Status": "info",
"Mac": "info",
"sn": "DG5678900",
"Worker": "info",
"Info_1": "info",
"Info_2": "info",
"Info_3": "info",
"Info_4": "info"
"model": "S17"
},
{
"Object": "info",
"subobject": "info",
"Name": "name.017_S17",
"Ip": "info",
"Status": "info",
"Mac": info,
"sn": "FXD56789312",
"Worker": "info",
"Info_1": "info",
"Info_2": "info",
"Info_3": "info",
"Info_4": "info"
"model": "S17"
}]