Hi
I am scrapping a website graph and getting back a string whcih to me looks like a nested dictionary, however, I cannot seem to work out how to convert it to a nested dictionary that Python will understand.
'{"values":[{"data":[{"x":1634594400000,"y":88.443,"name":"DA 2021-10-19"},{"x":1634680800000,"y":85.523,"name":"DA 2021-10-20"},{"x":1634767200000,"y":91.224,"name":"DA 2021-10-21"},{"x":1634853600000,"y":86.035,"name":"DA 2021-10-22"},{"x":1634940000000,"y":86.42,"name":"WE 2021-10-23\\/24"},{"x":1635026400000,"y":86.42,"name":"WE 2021-10-23\\/24"},{"x":1635112800000,"y":86.854,"name":"DA 2021-10-25"},{"x":1635199200000,"y":88.999,"name":"DA 2021-10-26"},{"x":1635285600000,"y":87.604,"name":"DA 2021-10-27"},{"x":1635372000000,"y":85.434,"name":"DA 2021-10-28"},{"x":1635458400000,"y":75.037,"name":"DA 2021-10-29"},{"x":1635544800000,"y":62.555,"name":"WE 2021-10-30\\/31"},{"x":1635631200000,"y":62.555,"name":"WE 2021-10-30\\/31"},{"x":1635721200000,"y":62.479,"name":"DA 2021-11-01"},{"x":1635807600000,"y":64.1,"name":"DA 2021-11-02"},{"x":1635894000000,"y":68.19,"name":"DA 2021-11-03"},{"x":1635980400000,"y":77.484,"name":"DA 2021-11-04"},{"x":1636066800000,"y":71.698,"name":"DA 2021-11-05"},{"x":1636153200000,"y":73.138,"name":"WE 2021-11-06\\/07"},{"x":1636239600000,"y":73.138,"name":"WE 2021-11-06\\/07"},{"x":1636326000000,"y":73.225,"name":"DA 2021-11-08"},{"x":1636412400000,"y":77.932,"name":"DA 2021-11-09"},{"x":1636498800000,"y":72.372,"name":"DA 2021-11-10"},{"x":1636585200000,"y":70.271,"name":"DA 2021-11-11"},{"x":1636671600000,"y":73.99,"name":"DA 2021-11-12"},{"x":1636758000000,"y":73.479,"name":"WE 2021-11-13\\/14"},{"x":1636844400000,"y":73.479,"name":"WE 2021-11-13\\/14"},{"x":1636930800000,"y":73.994,"name":"DA 2021-11-15"},{"x":1637017200000,"y":79.68,"name":"DA 2021-11-16"},{"x":1637103600000,"y":93.825,"name":"DA 2021-11-17"},{"x":1637190000000,"y":94.014,"name":"DA 2021-11-18"},{"x":1637276400000,"y":93.261,"name":"DA 2021-11-19"},{"x":1637362800000,"y":86.906,"name":"WE 2021-11-20\\/21"},{"x":1637449200000,"y":86.906,"name":"WE 2021-11-20\\/21"},{"x":1637535600000,"y":87.392,"name":"DA 2021-11-22"},{"x":1637622000000,"y":84.204,"name":"DA 2021-11-23"},{"x":1637708400000,"y":91.352,"name":"DA 2021-11-24"},{"x":1637794800000,"y":94.053,"name":"DA 2021-11-25"},{"x":1637881200000,"y":92.802,"name":"DA 2021-11-26"},{"x":1637967600000,"y":87.756,"name":"WE 2021-11-27\\/28"},{"x":1638054000000,"y":87.756,"name":"WE 2021-11-27\\/28"},{"x":1638140400000,"y":88.082,"name":"DA 2021-11-29"},{"x":1638226800000,"y":93.359,"name":"DA 2021-11-30"},{"x":1638313200000,"y":91.586,"name":"DA 2021-12-01"},{"x":1638399600000,"y":97.103,"name":"DA 2021-12-02"},{"x":1638486000000,"y":94.284,"name":"DA 2021-12-03"}]}],"unit":"\\u20ac\\/MWh"}'
Thanks
Ed
What I have tried:
df = json.loads(data)