I have installed Jupyter Notebook how do i open a terminal or command prompt and type the following command to install Jupyter Notebook:

pip install jupyter

Install Required Libraries

You'll need some additional Python libraries for data manipulation and charting:

$1.$ Pandas:

o Pandas is a powerful data manipulation library.

pip install pandas

$2.$ Matplotlib:

$$ Matplotlib is a comprehensive library for creating static, animated, and interactive visualizations in Python.pip install matplotlib

$3.$ SciPy:

$$ SciPy is a library used for scientific and technical computing.

pip install scipy

Create the SPC charts.

Step$-$by$-$Step Plan:

$1.$ firstly Load the data into a DataFrame.

$2.$ next Calculate the control limits $($UCL$,$ LCL$)$ for each site and the overall data.

$3.$ and Generate the SPC charts using Matplotlib.

Use Phyton extract data and convert to dataframe

import pandas as pd

import numpy as np

import matplotlib.pyplot as plt

# Data extraction

data $=\{$

'Hospital Site': $[\text{'}$Birmingham Heartlands', 'Good Hope', 'Solihull', 'Queen Elizabeth', 'TOTAL'$],$

'Jan$-24\text{'}$: $[24,21,14,28,22],$

'Feb$-24\text{'}$: $[42,23,16,25,27],$

'Mar$-24\text{'}$: $[22,26,7,26,20],$

'Apr$-24\text{'}$: $[24,28,7,28,22],$

'May$-24\text{'}$: $[29,28,15,28,25],$

'Jun$-24\text{'}$: $[31,32,17,29,27],$

'Jul$-24\text{'}$: $[35,31,19,31,29]$

$\}$

# Convert to DataFrame

df $=$ pd$.$DataFrame$($data$)$

# Function to plot SPC chart

def plot$\_$spc$\_$chart$($df$,$ site$)$:

data $=$ df$[$df$[\text{'}$Hospital Site'$]==$ site$].$drop$(\text{'}$Hospital Site', axis$=1).$values.flatten$()$

months $=$ df$.$columns$[1$:$]$

mean $=$ np$.$mean$($data$)$

sigma $=$ np$.$std$($data$)$

UCL $=$ mean $+3*$sigma

LCL $=$ mean $-3*$sigma

plt$.$figure$($figsize$=(12,6))$

plt$.$plot$($months$,$ data, marker$=\text{'}$o$\text{'},$ linestyle$=\text{'}-\text{'},$ color$=\text{'}$b$\text{'},$ label$=$'Data'$)$

plt$.$axhline$($mean$,$ color$=$'green', linestyle$=\text{'}--\text{'},$ label$=$'Mean'$)$

plt$.$axhline$($UCL$,$ color$=$'red', linestyle$=\text{'}--\text{'},$ label$=$'UCL $(3\backslash$sigma $)\text{'})$

plt$.$axhline$($LCL$,$ color$=$'red', linestyle$=\text{'}--\text{'},$ label$=\text{'}$LCL $(3\backslash$sigma $)\text{'})$

plt$.$title$($f$\text{'}$SPC Chart for $\{$site$\}\text{'})$

plt$.$xlabel$(\text{'}$Month$\text{'})$

plt$.$ylabel$(\text{'}$Percentage$\text{'})$

plt$.$legend$()$

plt$.$grid$($True$)$

plt$.$ylim$(0,$ max$($UCL$,$ max$($data$))+10)$

plt$.$show$()$

# Plot SPC chart for overall data

plot$\_$spc$\_$chart$($df$,$ 'TOTAL'$)$

# Plot SPC chart for each site

for site in df$[\text{'}$Hospital Site'$].$unique$()$:

if site $!=$ 'TOTAL':

plot$\_$spc$\_$chart$($df$,$ site$)$