df_from_tb.py

# loads the result of a query on Tinybird to a Pandas DataFrame

import pandas as pd
import urllib.parse


def build_tinybird_query_url(query: str, token: str) -> str:
    url = f"https://api.tinybird.co/v0/sql?q={urllib.parse.quote(query + ' FORMAT CSVWithNames')}&token={token}"
    return url
  
  
 def df_from_tb(query: str, token: str) -> pd.DataFrame:
    url = build_tinybird_query_url(query=query, token=token)
    df = pd.read_csv(url, na_values=r'\N')
    return df