Code Editor for app.py

import streamlit as st
import pandas as pd

# Sample wide dataframe with many datetime columns
columns = [f'date_col_{i}' for i in range(1, 20)]

# Generating a DataFrame with datetime columns
data = {col: pd.date_range(start='2024-01-01', periods=5, freq='D') for col in columns}
df = pd.DataFrame(data)

# Formatting datetime columns to just display the date in 'YYYY/MM/DD' format
def format_datetime_columns(df):
    for col in df.columns:
        if pd.api.types.is_datetime64_any_dtype(df[col]):
            df[col] = df[col].dt.strftime('%Y/%m/%d')
    return df

# Apply formatting
formatted_df = format_datetime_columns(df)

st.title('Formatted Date Columns')
st.dataframe(formatted_df)