do_vm_query.py

import pandas as pd
import requests

def do_vm_query(queryText: str, http: requests.sessions) -> pd.DataFrame:
    params = {
        'query': queryText
    }
    response = http.get(
        'http://test-victoria-metric-server:8428/api/v1/query',
        params=params
    )
    response.raise_for_status()
    results = response.json()['data']['result']
    df = pd.DataFrame()
    data = []
    for result_line in results:
        name = result_line['metric']['__name__']
        dict = {}
        for key in result_line['metric']:
            if key != '__name__':
                dict[key] = result_line['metric'][key]
        dict[name] = result_line['value'][1]
        data.append(dict)
    df = df.from_records(data)
    return df