File size: 13,543 Bytes
01a717a
 
 
 
8617b14
 
 
 
 
4ad817b
82184d1
01a717a
 
 
1ac75ec
 
 
8617b14
 
1ac75ec
 
 
 
8617b14
 
1ac75ec
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
8617b14
 
01a717a
 
4ad817b
3706982
1ac75ec
8617b14
1ac75ec
 
8617b14
 
3706982
1ac75ec
 
 
 
 
01a717a
 
 
1ac75ec
 
 
 
 
 
 
 
 
 
 
 
 
 
3706982
1ac75ec
8617b14
1ac75ec
 
 
 
 
 
 
 
3706982
 
 
1ac75ec
 
3706982
1ac75ec
3706982
 
1ac75ec
82184d1
3706982
1ac75ec
82184d1
3706982
1ac75ec
8617b14
1ac75ec
3706982
1ac75ec
3706982
 
 
 
 
 
8617b14
3706982
 
 
 
 
 
 
 
 
8617b14
 
01a717a
 
 
3706982
01a717a
 
 
 
 
 
 
 
3706982
01a717a
1ac75ec
3706982
1ac75ec
 
 
01a717a
1ac75ec
01a717a
8617b14
01a717a
82184d1
1ac75ec
 
3706982
01a717a
 
8617b14
 
1ac75ec
 
3706982
 
01a717a
3706982
01a717a
3706982
01a717a
3706982
01a717a
3706982
01a717a
d62588e
01a717a
 
 
 
 
 
 
3706982
 
01a717a
 
 
 
 
 
8617b14
 
01a717a
 
 
1ac75ec
3706982
 
 
 
 
1ac75ec
01a717a
1ac75ec
 
3706982
1ac75ec
3706982
1ac75ec
01a717a
 
 
1ac75ec
 
3706982
1ac75ec
 
 
 
3706982
1ac75ec
 
 
 
3706982
 
 
01a717a
 
1ac75ec
 
01a717a
 
 
3706982
 
 
01a717a
 
 
 
 
 
 
 
 
 
 
 
1ac75ec
01a717a
 
 
 
cd1029d
01a717a
 
 
 
cd1029d
01a717a
 
 
 
 
 
cd1029d
01a717a
 
 
1ac75ec
01a717a
 
 
 
 
 
 
 
 
 
 
 
 
 
3706982
 
 
 
 
01a717a
cd1029d
01a717a
 
1ac75ec
01a717a
cd1029d
01a717a
3706982
cd1029d
 
01a717a
 
 
3706982
 
 
 
 
01a717a
 
 
 
 
 
 
 
3706982
 
 
 
 
cd1029d
3706982
 
 
 
01a717a
 
 
 
 
3706982
 
 
01a717a
3706982
 
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
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
# app.py — Mobile-first, HF-iframe-friendly Gradio app
# Paste this into your Hugging Face Space (Gradio). Uses inline CSS to handle iframe constraints.
# Requirements: gradio, networkx, plotly, pandas, numpy

import gradio as gr
import pandas as pd
import networkx as nx
import plotly.graph_objects as go
import numpy as np
from collections import defaultdict

# ---------------------------
# Data (same sample dataset)
# ---------------------------
AMCS = [
    "SBI MF", "ICICI Pru MF", "HDFC MF", "Nippon India MF", "Kotak MF",
    "UTI MF", "Axis MF", "Aditya Birla SL MF", "Mirae MF", "DSP MF"
]

COMPANIES = [
    "HDFC Bank", "ICICI Bank", "Bajaj Finance", "Bajaj Finserv", "Adani Ports",
    "Tata Motors", "Shriram Finance", "HAL", "TCS", "AU Small Finance Bank",
    "Pearl Global", "Hindalco", "Tata Elxsi", "Cummins India", "Vedanta"
]

BUY_MAP = {
    "SBI MF": ["Bajaj Finance", "AU Small Finance Bank"],
    "ICICI Pru MF": ["HDFC Bank"],
    "HDFC MF": ["Tata Elxsi", "TCS"],
    "Nippon India MF": ["Hindalco"],
    "Kotak MF": ["Bajaj Finance"],
    "UTI MF": ["Adani Ports", "Shriram Finance"],
    "Axis MF": ["Tata Motors", "Shriram Finance"],
    "Aditya Birla SL MF": ["AU Small Finance Bank"],
    "Mirae MF": ["Bajaj Finance", "HAL"],
    "DSP MF": ["Tata Motors", "Bajaj Finserv"]
}

SELL_MAP = {
    "SBI MF": ["Tata Motors"],
    "ICICI Pru MF": ["Bajaj Finance", "Adani Ports"],
    "HDFC MF": ["HDFC Bank"],
    "Nippon India MF": ["Hindalco"],
    "Kotak MF": ["AU Small Finance Bank"],
    "UTI MF": ["Hindalco", "TCS"],
    "Axis MF": ["TCS"],
    "Aditya Birla SL MF": ["Adani Ports"],
    "Mirae MF": ["TCS"],
    "DSP MF": ["HAL", "Shriram Finance"]
}

COMPLETE_EXIT = {"DSP MF": ["Shriram Finance"]}
FRESH_BUY = {"HDFC MF": ["Tata Elxsi"], "UTI MF": ["Adani Ports"], "Mirae MF": ["HAL"]}


def sanitize_map(m):
    out = {}
    for k, vals in m.items():
        out[k] = [v for v in vals if v in COMPANIES]
    return out


BUY_MAP = sanitize_map(BUY_MAP)
SELL_MAP = sanitize_map(SELL_MAP)
COMPLETE_EXIT = sanitize_map(COMPLETE_EXIT)
FRESH_BUY = sanitize_map(FRESH_BUY)

# ---------------------------
# Graph construction
# ---------------------------
company_edges = []
for amc, comps in BUY_MAP.items():
    for c in comps:
        company_edges.append((amc, c, {"action": "buy", "weight": 1}))
for amc, comps in SELL_MAP.items():
    for c in comps:
        company_edges.append((amc, c, {"action": "sell", "weight": 1}))
for amc, comps in COMPLETE_EXIT.items():
    for c in comps:
        company_edges.append((amc, c, {"action": "complete_exit", "weight": 3}))
for amc, comps in FRESH_BUY.items():
    for c in comps:
        company_edges.append((amc, c, {"action": "fresh_buy", "weight": 3}))


def infer_amc_transfers(buy_map, sell_map):
    transfers = defaultdict(int)
    company_to_sellers = defaultdict(list)
    company_to_buyers = defaultdict(list)
    for amc, comps in sell_map.items():
        for c in comps:
            company_to_sellers[c].append(amc)
    for amc, comps in buy_map.items():
        for c in comps:
            company_to_buyers[c].append(amc)
    for c in set(company_to_sellers.keys()) | set(company_to_buyers.keys()):
        sellers = company_to_sellers[c]
        buyers = company_to_buyers[c]
        for s in sellers:
            for b in buyers:
                transfers[(s, b)] += 1
    edge_list = []
    for (s, b), w in transfers.items():
        edge_list.append((s, b, {"action": "transfer", "weight": w}))
    return edge_list


transfer_edges = infer_amc_transfers(BUY_MAP, SELL_MAP)


def build_graph(include_transfers=True):
    G = nx.DiGraph()
    for a in AMCS:
        G.add_node(a, type="amc")
    for c in COMPANIES:
        G.add_node(c, type="company")
    for u, v, attr in company_edges:
        if u in G.nodes and v in G.nodes:
            if G.has_edge(u, v):
                G[u][v]["weight"] += attr["weight"]
                G[u][v]["actions"].append(attr["action"])
            else:
                G.add_edge(u, v, weight=attr["weight"], actions=[attr["action"]])
    if include_transfers:
        for s, b, attr in transfer_edges:
            if s in G.nodes and b in G.nodes:
                if G.has_edge(s, b):
                    G[s][b]["weight"] += attr["weight"]
                    G[s][b]["actions"].append("transfer")
                else:
                    G.add_edge(s, b, weight=attr["weight"], actions=["transfer"])
    return G

# ---------------------------
# Plotly drawing helper
# ---------------------------
def graph_to_plotly(
    G,
    node_color_amc="#9EC5FF",
    node_color_company="#FFCF9E",
    edge_color_buy="#2ca02c",
    edge_color_sell="#d62728",
    edge_color_transfer="#888888",
    edge_thickness_base=1.4,
    show_labels=True,
):
    # spring layout - deterministic seed
    pos = nx.spring_layout(G, seed=42, k=1.2)

    node_x, node_y, node_text, node_color, node_size = [], [], [], [], []
    for n, d in G.nodes(data=True):
        x, y = pos[n]
        node_x.append(x); node_y.append(y); node_text.append(n)
        if d["type"] == "amc":
            node_color.append(node_color_amc); node_size.append(36)
        else:
            node_color.append(node_color_company); node_size.append(56)

    node_trace = go.Scatter(
        x=node_x, y=node_y,
        mode="markers+text" if show_labels else "markers",
        marker=dict(color=node_color, size=node_size, line=dict(width=2, color="#222")),
        text=node_text if show_labels else None, textposition="top center", hoverinfo="text"
    )

    edge_traces = []
    for u, v, attrs in G.edges(data=True):
        acts = attrs.get("actions", [])
        weight = attrs.get("weight", 1)
        x0, y0 = pos[u]; x1, y1 = pos[v]
        if "complete_exit" in acts:
            color = edge_color_sell; dash = "solid"; width = edge_thickness_base * 3
        elif "fresh_buy" in acts:
            color = edge_color_buy; dash = "solid"; width = edge_thickness_base * 3
        elif "transfer" in acts:
            color = edge_color_transfer; dash = "dash"; width = edge_thickness_base * (1 + np.log1p(weight))
        elif "sell" in acts:
            color = edge_color_sell; dash = "dot"; width = edge_thickness_base * (1 + np.log1p(weight))
        else:
            color = edge_color_buy; dash = "solid"; width = edge_thickness_base * (1 + np.log1p(weight))

        edge_traces.append(go.Scatter(
            x=[x0, x1, None], y=[y0, y1, None],
            mode="lines", line=dict(color=color, width=width, dash=dash),
            hoverinfo="none"
        ))

    fig = go.Figure(data=edge_traces + [node_trace])
    # use autosize for better responsiveness inside iframe
    fig.update_layout(showlegend=False,
                      autosize=True,
                      margin=dict(l=8, r=8, t=36, b=8),
                      xaxis=dict(visible=False),
                      yaxis=dict(visible=False))
    return fig

# ---------------------------
# Summaries (company/amc)
# ---------------------------
def company_trade_summary(company_name):
    buyers = [a for a, comps in BUY_MAP.items() if company_name in comps]
    sellers = [a for a, comps in SELL_MAP.items() if company_name in comps]
    fresh = [a for a, comps in FRESH_BUY.items() if company_name in comps]
    exits = [a for a, comps in COMPLETE_EXIT.items() if company_name in comps]

    df = pd.DataFrame({
        "Role": ["Buyer"] * len(buyers) + ["Seller"] * len(sellers) + ["Fresh buy"] * len(fresh) + ["Complete exit"] * len(exits),
        "AMC": buyers + sellers + fresh + exits
    })

    if df.empty:
        return None, pd.DataFrame([], columns=["Role", "AMC"])
    counts = df.groupby("Role").size().reset_index(name="Count")
    colors = ["green", "red", "orange", "black"][:len(counts)]
    fig = go.Figure(go.Bar(x=counts["Role"], y=counts["Count"], marker_color=colors))
    fig.update_layout(title_text=f"Trade summary for {company_name}", autosize=True, margin=dict(t=30,b=10))
    return fig, df


def amc_transfer_summary(amc_name):
    sold = SELL_MAP.get(amc_name, [])
    transfers = []
    for s in sold:
        buyers = [a for a, comps in BUY_MAP.items() if s in comps]
        for b in buyers:
            transfers.append({"security": s, "buyer_amc": b})
    df = pd.DataFrame(transfers)
    if df.empty:
        return None, pd.DataFrame([], columns=["security", "buyer_amc"])
    counts = df["buyer_amc"].value_counts().reset_index()
    counts.columns = ["Buyer AMC", "Count"]
    fig = go.Figure(go.Bar(x=counts["Buyer AMC"], y=counts["Count"], marker_color="lightslategray"))
    fig.update_layout(title_text=f"Inferred transfers from {amc_name}", autosize=True, margin=dict(t=30,b=10))
    return fig, df

# ---------------------------
# Initial graph
# ---------------------------
initial_graph = build_graph(include_transfers=True)
initial_fig = graph_to_plotly(initial_graph)

# ---------------------------
# Mobile-first CSS (override HF iframe quirks)
# ---------------------------
responsive_css = """
/* Remove excessive padding inside HF iframe */
.gradio-container { padding: 0 !important; margin: 0 !important; }

/* Make the plot area truly full-width */
.plotly-graph-div, .js-plotly-plot, .output_plot {
    width: 100% !important;
    max-width: 100% !important;
}

/* Ensure plot will shrink on small screens but remain legible */
.js-plotly-plot {
    height: 460px !important;
}

/* Make controls compact and finger-friendly */
.gradio-container .gr-input, .gradio-container .gr-button {
    width: 100% !important;
}

/* Accordion collapsed by default on mobile; larger touch targets */
@media only screen and (max-width: 780px) {
    .js-plotly-plot { height: 420px !important; }
    .gr-accordion { font-size: 15px; }
    .gradio-container { padding: 6px !important; }
}

/* Avoid horizontal scroll and ensure content uses available width */
body, html { overflow-x: hidden !important; }
"""

# ---------------------------
# Gradio UI (Blocks) — accordion closed by default (mobile-first)
# ---------------------------
with gr.Blocks(css=responsive_css, title="MF Churn Explorer (mobile-first)") as demo:
    gr.Markdown("## Mutual Fund Churn Explorer — Mobile Friendly")
    # Full-width network on top
    network_plot = gr.Plot(value=initial_fig, label="Network graph (tap to zoom)")

    # Controls in a collapsed accordion (closed by default to save vertical space)
    with gr.Accordion("Network Customization — expand to edit", open=False):
        node_color_company = gr.ColorPicker("#FFCF9E", label="Company node color")
        node_color_amc = gr.ColorPicker("#9EC5FF", label="AMC node color")
        node_shape_company = gr.Dropdown(["circle", "square", "diamond"], value="circle", label="Company node shape")
        node_shape_amc = gr.Dropdown(["circle", "square", "diamond"], value="circle", label="AMC node shape")
        edge_color_buy = gr.ColorPicker("#2ca02c", label="BUY edge color")
        edge_color_sell = gr.ColorPicker("#d62728", label="SELL edge color")
        edge_color_transfer = gr.ColorPicker("#888888", label="Transfer edge color")
        edge_thickness = gr.Slider(0.5, 6.0, value=1.4, step=0.1, label="Edge thickness base")
        include_transfers = gr.Checkbox(value=True, label="Show AMC→AMC inferred transfers")
        update_button = gr.Button("Update network")

    gr.Markdown("### Quick inspection (mobile)")
    select_company = gr.Dropdown(choices=COMPANIES, label="Select company (buyers / sellers)")
    company_out_plot = gr.Plot(label="Company trade summary")
    company_out_table = gr.DataFrame(label="Company trade table")

    select_amc = gr.Dropdown(choices=AMCS, label="Select AMC (inferred transfers)")
    amc_out_plot = gr.Plot(label="AMC transfer summary")
    amc_out_table = gr.DataFrame(label="AMC transfer table")

    # ---------------------------
    # Callbacks
    # ---------------------------
    def update_network(node_color_company_val, node_color_amc_val,
                       node_shape_company_val, node_shape_amc_val,
                       edge_color_buy_val, edge_color_sell_val, edge_color_transfer_val,
                       edge_thickness_val, include_transfers_val):
        G = build_graph(include_transfers=include_transfers_val)
        fig = graph_to_plotly(G,
                              node_color_amc=node_color_amc_val,
                              node_color_company=node_color_company_val,
                              edge_color_buy=edge_color_buy_val,
                              edge_color_sell=edge_color_sell_val,
                              edge_color_transfer=edge_color_transfer_val,
                              edge_thickness_base=edge_thickness_val,
                              show_labels=True)
        return fig

    def handle_company(company):
        fig, df = company_trade_summary(company)
        return fig, df

    def handle_amc(amc):
        fig, df = amc_transfer_summary(amc)
        return fig, df

    update_button.click(update_network,
                        inputs=[node_color_company, node_color_amc, node_shape_company, node_shape_amc,
                                edge_color_buy, edge_color_sell, edge_color_transfer, edge_thickness, include_transfers],
                        outputs=[network_plot])

    select_company.change(handle_company, select_company, [company_out_plot, company_out_table])
    select_amc.change(handle_amc, select_amc, [amc_out_plot, amc_out_table])

# Launch
if __name__ == "__main__":
    demo.launch()