René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"requesting API with multiple columns","articleBody":"Hi Team Glassnode,\r\n\r\nWhen retrieving API with multiple columns, the column name is 'o' not 'v'.\r\n\r\n(e.g : https://api.glassnode.com/v1/metrics/supply/hodl_waves)\r\n\r\nAnd it cannot be retrieved properly with current API connector.\r\n\r\nI have added below code to fix the problem, but the iterator make the whole process quite slow... \r\n\r\n\u003e     \r\n    try:\r\n        df = pd.DataFrame(json.loads(r.text))\r\n        df = df.set_index('t')\r\n        df.index = pd.to_datetime(df.index, unit='s')\r\n        df = df.sort_index()\r\n        s = pd.DataFrame()\r\n        for r, c in df.iterrows():\r\n            for k, v in c['o'].items():\r\n                s.loc[r, k] = v\r\n        return s\r\n\r\n    except Exception as e:\r\n        print(e)\r\n\r\n\r\n","author":{"url":"https://github.com/TurtleJelly","@type":"Person","name":"TurtleJelly"},"datePublished":"2021-02-01T03:06:38.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/5/glassnode-api-python-client/issues/5"}