Code Editor for app.py

import streamlit as st
import pandas as pd
import altair as alt

st.title('E-commerce Orders Visualizer')

# Sample data generation
orders_data = {
    'Order ID': range(1, 101),
    'Product': [f'Product {i % 10}' for i in range(1, 101)],
    'Quantity': [i % 5 + 1 for i in range(1, 101)],
    'Price': [round(i % 20 + 5.0, 2) for i in range(1, 101)],
    'Order Date': pd.date_range(start='2023-01-01', periods=100)
}

orders_df = pd.DataFrame(orders_data)

# Display orders data
st.subheader('Orders Data')
st.write(orders_df)

# Visualize total revenue per product
revenue_df = orders_df.groupby('Product').agg({'Quantity': 'sum', 'Price': 'mean'}).reset_index()
revenue_df['Total Revenue'] = revenue_df['Quantity'] * revenue_df['Price']

st.subheader('Total Revenue per Product')
chart = alt.Chart(revenue_df).mark_bar().encode(
    x='Product:N',
    y='Total Revenue:Q'
).properties(
    width=600,
    height=400,
)
st.altair_chart(chart)