File size: 5,928 Bytes
7f8521c c1c9edf 7f8521c 4e0feff 7f8521c 4e0feff 7f8521c 44dfbf5 7f8521c 44dfbf5 7f8521c c1c9edf b628f1b c1c9edf b628f1b c1c9edf |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 |
import pandas as pd
import numpy as np
import datetime
import traceback
# ============================================================
# NUMBER FORMATTING HELPERS
# ============================================================
def format_number(num):
if num is None:
return "-"
try:
return f"{float(num):,.2f}".rstrip("0").rstrip(".")
except:
return str(num)
def format_large_number(num):
if num is None:
return "-"
try:
n = float(num)
if abs(n) >= 1_00_00_000: # Crore
return f"{n/1_00_00_000:.2f} Cr"
elif abs(n) >= 1_00_000: # Lakh
return f"{n/1_00_000:.2f} L"
elif abs(n) >= 1_000: # Thousand
return f"{n/1_000:.2f} K"
else:
return format_number(n)
except:
return str(num)
# ============================================================
# HTML UI HELPERS
# ============================================================
def html_card(title, content):
return f"""
<div style="
background:#fff;
border-radius:12px;
padding:18px;
margin:15px 0;
box-shadow:0 2px 8px rgba(0,0,0,0.1);
border-left:6px solid #0077cc;
">
<h2 style="margin-top:0;color:#0077cc;">{title}</h2>
<div>{content}</div>
</div>
"""
def html_section(title, content):
return f"""
<div style="margin:20px 0;">
<h3 style="color:#444;margin-bottom:8px;">{title}</h3>
{content}
</div>
"""
def html_error(msg):
return f"""
<div style="
padding:15px;
margin:15px 0;
background:#ffe6e6;
border-left:6px solid #d9534f;
border-radius:8px;
color:#b30000;
">
<b>Error:</b> {msg}
</div>
"""
# ============================================================
# DATAFRAME CLEANING
# ============================================================
def clean_df(df):
if isinstance(df.index, pd.DatetimeIndex):
df.index = df.index.strftime("%Y-%m-%d")
df.replace([np.inf, -np.inf], np.nan, inplace=True)
df.fillna("-", inplace=True)
return df
# ============================================================
# TABLE STYLING
# ============================================================
def make_table(df):
try:
df = df.copy()
df = clean_df(df)
html = df.to_html(classes="styled-table", escape=False, border=0)
return f"""
<style>
.styled-table {{
width:100%;
border-collapse:collapse;
font-size:14px;
}}
.styled-table th {{
background:#0077cc;
color:white;
padding:8px;
text-align:left;
}}
.styled-table td {{
padding:8px;
border-bottom:1px solid #ddd;
}}
.styled-table tr:nth-child(even) {{
background:#f3f7ff;
}}
.styled-table tr:hover {{
background:#e7f1ff;
}}
</style>
{html}
"""
except Exception as e:
return html_error(f"Table render failed: {e}<br><pre>{traceback.format_exc()}</pre>")
# ============================================================
# UNIVERSAL PLOT WRAPPER
# ============================================================
def wrap_plotly_html(html_chart, table_html=None):
extra = f"<div style='margin-top:20px'>{table_html}</div>" if table_html else ""
return f"""
<div style="width:98%;margin:auto;">
{html_card("Chart", html_chart)}
{extra}
</div>
"""
# ============================================================
# INDICATOR SAFE EXTRACTION HELPER
# ============================================================
def safe_get(df, key, default_val="-"):
try:
return df.get(key, default_val)
except:
return default_val
def format_timestamp_to_date(timestamp):
if not isinstance(timestamp, (int, float)) or timestamp <= 0:
return "N/A"
try:
return datetime.datetime.fromtimestamp(timestamp).strftime('%Y-%m-%d')
except:
return "Invalid Date"
# ============================================================
# HTML WRAPPER
# ============================================================
STYLE_BLOCK = """
<style>
.styled-table {border-collapse: collapse; margin: 10px 0; font-size: 0.9em; font-family: sans-serif; width: 100%; box-shadow: 0 0 10px rgba(0,0,0,0.1);}
.styled-table th, .styled-table td {padding: 8px 10px; border: 1px solid #ddd;}
.styled-table tbody tr:nth-child(even) {background-color: #f9f9f9;}
.card {display: block; width: 95%; margin: 10px auto; padding: 15px; border: 1px solid #ddd; border-radius: 8px; box-shadow: 0 2px 5px rgba(0,0,0,0.1); background: #fafafa;}
.card-category-title {font-size: 1.1em; color: #222; margin: 0 0 8px; border-bottom: 1px solid #eee; padding-bottom: 5px;}
.card-content-grid {display: flex; flex-wrap: wrap; gap: 15px;}
.key-value-pair {flex: 1 1 calc(20% - 15px); box-sizing: border-box; min-width: 150px; background: #fff; padding: 10px; border: 1px solid #e0e0e0; border-radius: 5px; box-shadow: 0 1px 3px rgba(0,0,0,0.05);}
.key-value-pair h3 {font-size: 0.95em; color: #444; margin: 0 0 5px 0;}
.key-value-pair p {font-size: 0.9em; color: #555; margin: 0; font-weight: bold;}
.big-box {width:95%; margin:20px auto; padding:20px; border:1px solid #ccc; border-radius:8px; background:#fff; box-shadow:0 2px 8px rgba(0,0,0,0.1); font-size:0.95em; line-height:1.4em; max-height:400px; overflow-y:auto;}
</style>
"""
def wrap_html(content, title="Stock Data"):
return f"""
<!DOCTYPE html>
<html>
<head>
<title>{title}</title>
{STYLE_BLOCK}
</head>
<body>
{content}
</body>
</html>
"""
|