Read data from the Wikipedia article on electricity generation in Alberta and create a pie chart

electricity-generation-in-alberta.py

import pandas as pd
import plotly.express as px
df = pd.read_html('https://en.wikipedia.org/wiki/List_of_generating_stations_in_Alberta')
categories = ['coal','natural gas','dual fuel','biomass','geothermal','hydroelectric','wind','solar']
values = []
for i, c in enumerate(categories):
  total = int(pd.to_numeric(df[i+1]['Capacity (MW)'], errors='coerce').sum())
  values.append(total)
px.pie(names=categories, values=values)