i have a python app, but i want the plots to be more orgranized. I want to move the plots to cover more of the window and have more space for other plot and reports, any help is really appreciated please:

import streamlit as st

from sqlalchemy import create$\_$engine

import pandas as pd

import plotly.express as px

# Function to create a database connection using SQLAlchemy

def create$\_$db$\_$connection$()$:

db$\_$url $="$mysql$+$mysqlconnector:$//$root:peter@localhost$/$main$\_$items"

engine $=$ create$\_$engine$($db$\_$url$)$

return engine

# $---$ Fetch data from the database $---$

def load$\_$data$()$:

engine $=$ create$\_$db$\_$connection$()$

query $=$ "SELECT $*$ FROM items$\_$table"

data $=$ pd$.$read$\_$sql$($query$,$ engine$)$

return data

# $---$ plot the data in a scatter plot $---$

def plot$\_$scatter$\_$chart$($data$)$:

# Convert 'Bundles$\_$Boxes' to numeric, setting errors to 'NaN'

data$[\text{'}$Bundles$\_$Boxes'$]=$ pd$.$to$\_$numeric$($data$[\text{'}$Bundles$\_$Boxes'$],$ errors$=$'coerce'$)$

# Replace NaN values with a default size, e$.$g$.,0$ or the mean size

data$[\text{'}$Bundles$\_$Boxes'$].$fillna$(0,$ inplace$=$True$)$

# Calculate total and percentage

total$\_$bundles $=$ data$[\text{'}$Bundles$\_$Boxes'$].$sum$()$

data$[\text{'}$Percentage$\text{'}]=($data$[\text{'}$Bundles$\_$Boxes'$]/$ total$\_$bundles$)*100$

# Create the scatter plot

fig $=$ px$.$scatter$($

data$\_$frame$=$data,

x$=$'Description',

y$=$'Percentage',

size$=$'Bundles$\_$Boxes', # The size argument represents the size of each dot.

hover$\_$data$=[\text{'}$Bundles$\_$Boxes'$],$ # Display bundles$/$boxes info on hover

labels$=\{\text{'}$Description$\text{'}$: 'Item Description', 'Percentage': 'Percentage of Total Inventory'$\},$

title$=$'Percentage of Inventory by Item'

$)$

# Update layout to adjust margins

fig.update$\_$layout$($

margin$=$dict$($l$=20,$ r$=20,$ t$=20,$ b$=20),$ # $\text{'}$l$\text{'}$ adjusts the left margin

xaxis$\_$tickangle$=-45$

$)$

return fig

# $---$ plot data in a pie chart to display total inventory usage per Bundles$/$Boxes $---$

def plot$\_$pie$\_$chart$($data$)$:

# Calculate total bundles for percentage calculation

total$\_$bundles $=$ data$[\text{'}$Bundles$\_$Boxes'$].$sum$()$

# Add a percentage column to the dataframe

data$[\text{'}$Inventory$\_$Percentage'$]=($data$[\text{'}$Bundles$\_$Boxes'$]/$ total$\_$bundles$)*100$

# Create a pie chart with Plotly

fig $=$ px$.$pie$($

data$\_$frame$=$data,

names$=$'Description',

values$=$'Inventory$\_$Percentage',

title$=$'Percentage of Inventory by Bundles$/$Boxes per Item'

$)$

return fig

# $---$ plot data into a bar chart $---$

def plot$\_$bar$\_$chart$($data$)$:

fig $=$ px$.$bar$($data$\_$frame$=$data, x$=$'Description', y$=$'Units$\_$Pieces$\_$Each', title$=$'Item Description'$)$

fig.update$\_$layout$($xaxis$\_$tickangle$=-45)$

return fig

# Define the Streamlit page

def main$()$:

st$.$title$("$Inventory Dashboard"$)$

# Load the data

data $=$ load$\_$data$().$copy$()$

# Define the layout for charts

col$1,$ col$2=$ st$.$columns$([5,6])$ # Adjust the ratio based on your requirement

with col$1$:

# Plotting the scatter chart

scatter$\_$chart $=$ plot$\_$scatter$\_$chart$($data$)$

st$.$plotly$\_$chart$($scatter$\_$chart, use$\_$container$\_$width$=$True$)$

with col$2$:

# Plotting the pie chart

pie$\_$chart $=$ plot$\_$pie$\_$chart$($data$)$

st$.$plotly$\_$chart$($pie$\_$chart, use$\_$container$\_$width$=$True$)$

# Plotting the bar chart below the scatter and pie charts

st$.$write$(\text{'}$Item Description'$)$

bar$\_$chart $=$ plot$\_$bar$\_$chart$($data$)$

st$.$plotly$\_$chart$($bar$\_$chart, use$\_$container$\_$width$=$True$)$

# Run the main function when the script is executed

if $\_\_$name$\_\_=="\_\_$main$\_\_"$:

main$()$