After real test, WMS is faster than WMTS using openlayer 6

 To run the following code you have to import the required js and css files 

HTML

Python grouping

 import numpy as np

import pandas as pd

from pandas import Series, DataFrame

import seaborn as sn

address = 'mtcars.csv'

cars = pd.read_csv(address)

cars.columns = ['car_names', 'mpg', 'cyl', 'disp', 'hp', 'drat', 'wt', 'qsec', 'vs', 'am', 'gear', 'carb']

cars.head()

address = 'mtcars.csv'

cars = pd.read_csv(address)

cars.columns = ['car_names', 'mpg', 'cyl', 'disp', 'hp', 'drat', 'wt', 'qsec', 'vs',

                'am', 'gear', 'carb']

cars.head()

cars_groups = cars.groupby(cars['cyl'])

#cars_groups.mean()

sn.barplot(x='cyl', y = 'disp', data = cars)

cars['cyl'].value_counts().plot.bar();

cars['gear'].value_counts().plot.bar();

cars_groups = cars.groupby(cars['gear'])

cars_groups.mean()

cars_groups = cars.groupby(cars['gear'])

cars_groups.count()

Python read json data from API

import pandas as pd

import requests

d = requests.get("https://www.yourwebsite.com/controller?ApiKey=value").json()

df = pd.DataFrame.from_dict(d['records'])

df.shape