ExportWise AI is an AI-Based Export Market Recommendation and Trade Analytics System built as a complete B.Tech final-year project for Vishwajeet Musande. Its intent is to help Indian exporters decide where to sell a chosen agricultural export product — rice, chilli, cotton, spices and similar goods — by combining genuine historical import-export data from UN Comtrade (or another reliable public source) with machine-learning evidence: country recommendations, country-wise market analysis, historical trend graphs, export value prediction, a profit calculator that accounts for shipping, duties and other costs, and downloadable prediction reports.
The audience is twofold. Indian exporters use the analytics to plan an export. Project evaluators — college examiners and reviewers — inspect the machine-learning comparison, the evaluation metrics and the research paper to confirm that results come from unseen test data and that no accuracy figure or research result has been fabricated.
The project is delivered as a working Streamlit application with a Python backend, scikit-learn models saved with joblib, Pandas/NumPy data processing, and Plotly/Matplotlib visualizations. It is written for a beginner: the complete folder structure, requirements.txt, installation commands and local run commands are part of the deliverable, and the build proceeds from a minimum working project to features one by one.
ExportWise AI is a single Streamlit web application with sidebar navigation across seven pages: Home Dashboard, Export Market Recommendation, Country Comparison, Export Demand Prediction, ML Algorithm Comparison, Profit Calculator and About Project. All pages are openly reachable; no sign-in, account or role-based permission is part of the product.
The application is backed by a shared Python service that serves the data and model APIs the Streamlit pages call. Application-owned persistent data (the loaded historical and synthetic datasets, trained model artifacts and their evaluation records) is stored in MariaDB. A LiteLLM gateway, backed by its own PostgreSQL instance, is available to the backend for model-provider calls; it does not add product behavior. The React frontend service in the provisioned inventory is retained as infrastructure but the accepted product surface is the Streamlit application.
Two active human personas use the system: the Indian Exporter, who selects a product and consumes recommendations, comparisons, trends, predictions and profit calculations; and the Project Evaluator, who reviews the ML algorithm comparison, the metrics and the research paper for the final-year demonstration.
Accepted behavior covers: product selection; AI-based country recommendation for Indian exporters; country-wise export market analysis; historical export trends as interactive graphs; ML export value prediction; an export profit calculator with shipping, duties and other costs; downloadable prediction reports; training and comparison of Linear Regression, Decision Tree Regressor and Random Forest Regressor on MAE, RMSE, R² Score and an Actual vs Predicted graph; training and comparison of Logistic Regression, Decision Tree Classifier and Random Forest Classifier predicting High/Medium/Low export opportunity with Accuracy (%), Precision, Recall, F1-score and a Confusion Matrix; a clearly labeled synthetic sample dataset for initial testing only; chronological train-test splitting with all metrics on unseen test data; a documented opportunity-label definition that does not reuse prediction features; and a research paper with Problem Statement, Objectives, System Architecture, Methodology, Dataset Description, Algorithm Comparison, Experimental Results, Conclusion and Future Scope.
Removed from scope
ExportWise AI is delivered as a first-party Streamlit application. Every page is public and anonymous: an exporter or an evaluator opens the app and works immediately, with no account creation, sign-in or session identity. This matches the source, which never asks for accounts, and the accepted access contract, which marks every page none.
The product's data authority is external and read-only. Historical trade figures come from UN Comtrade or another reliable public source and are never invented; a separate, clearly labeled synthetic sample dataset exists only so the project can be tested before real data is loaded. The application owns the derived artifacts — preprocessed tables, trained models saved with joblib, and evaluation records computed on unseen test data — and stores them in MariaDB so the pages read consistent, reproducible results.
The backend is a shared Python service that exposes the data, recommendation, prediction, comparison and report endpoints the Streamlit pages consume. The LiteLLM gateway and its PostgreSQL store are provisioned infrastructure for backend model-provider calls and carry no product requirement. The React frontend service remains in the deployment inventory but is not the accepted product surface.
Everything described in this document is current. No future-horizon capability is claimed as delivered.
The reference directive designates UN Comtrade (or another reliable public source) as an authoritative content_source for genuine historical import-export data. The following factual structure is what the product must carry from that source; no specific numeric values are asserted here because none were supplied, and none may be invented.
FR-1 — Product selection (explicit) As an Indian Exporter, I should select an export product such as rice, chilli, cotton or spices so that every analysis, recommendation and prediction is scoped to that product.
FR-2 — AI-based country recommendation (explicit) As an Indian Exporter, I should receive AI-based country recommendations for my selected product so that I know which destination markets to prioritize.
FR-3 — Country-wise export market analysis (explicit) As an Indian Exporter, I should view country-wise export market analysis so that I understand how each destination market performs for my product.
FR-4 — Historical export trends and interactive graphs (explicit) As an Indian Exporter, I should view historical export trends as interactive graphs so that I can see how demand for my product has moved over time.
FR-5 — Export value prediction with machine learning (explicit) As an Indian Exporter, I should predict export value with machine learning so that I can estimate what a destination market is worth before committing.
FR-6 — Export profit calculator (explicit) As an Indian Exporter, I should calculate export profit with shipping, duties and other costs so that I know whether a shipment is worthwhile.
FR-7 — Downloadable prediction reports (explicit) As an Indian Exporter, I should download a prediction report so that I can keep or share the prediction I generated.
FR-8 — Regression model training and comparison (explicit) As a Project Evaluator, I should see Linear Regression, Decision Tree Regressor and Random Forest Regressor trained and compared on MAE, RMSE and R² Score with an Actual vs Predicted graph so that I can judge which model performs best.
FR-9 — Classification model training and comparison (explicit) As a Project Evaluator, I should see Logistic Regression, Decision Tree Classifier and Random Forest Classifier trained and compared on Accuracy (%), Precision, Recall, F1-score and a Confusion Matrix so that I can judge how well export opportunity is classified.
FR-10 — High/Medium/Low opportunity categories (explicit) As an Indian Exporter, I should see export opportunity classified as High, Medium or Low so that I can read market attractiveness at a glance.
FR-11 — Opportunity label definition (explicit) As a Project Evaluator, I should read how opportunity labels are defined so that I can confirm labels are not created directly from the prediction features.
FR-12 — Real historical data with labeled synthetic sample (explicit) As an Indian Exporter, I should see analyses built on genuine historical export data, with a clearly labeled synthetic sample dataset available only for initial testing, so that I can trust the figures.
FR-13 — Leakage-safe chronological evaluation (explicit) As a Project Evaluator, I should see that a chronological train-test split is used and that all metrics are computed on unseen test data so that I can trust the reported results.
FR-14 — Research paper content (explicit) As a Project Evaluator, I should read the research paper with Problem Statement, Objectives, System Architecture, Methodology, Dataset Description, Algorithm Comparison, Experimental Results, Conclusion and Future Scope so that I can assess the project academically.
FR-15 — Beginner-ready project delivery (explicit)
As a Project Evaluator, I should receive the complete folder structure, requirements.txt, a working Streamlit application, data preprocessing, joblib-saved models, model integration, error handling, input validation and local run commands so that the project can be installed and demonstrated.
requirements.txt; missing models are resolved by running training; each failure message names the missing step.FR-16 — Dataset and model loading prerequisite (required_inference) As an Indian Exporter, I should have the real or labeled synthetic dataset loaded and the models trained and saved with joblib before prediction pages run so that predictions and recommendations are available.
requirements.txt, and load the real UN Comtrade data or the labeled synthetic sample dataset.requirements.txt; missing models are resolved by running training; each failure message names the missing step.The creative direction is authoritative: Trade data made physical, after Refik Anadol. The muse is Refik Anadol; the headline idea is that the export dataset itself becomes the hero image — a luminous particle field on a dark museum ground that gives the ML results weight for a college demonstration.
Mode: dark.
Colour tokens (exact hex, by role)
#0A0B0D — near-black ground covering most of the page.#141619 — data cards and panels.#F2F0EA — ink-white reading text.#F2F0EA — primary text and primary controls.#FF7A2F — hot tangerine, used only on the active product, the top recommended country and the call to action.#8C9096 — secondary labels and metadata.#2A2D31 — 1px hairline on data cards.#2FD3C0 — low opacity in the particle field and data marks.#FFC24A — low opacity in the particle field and data marks.Typography
Shape language: full-bleed dark fields and thin luminous rules. Data cards use sharp corners with a 1px #2A2D31 border. No soft blobs, no glass cards.
Layout: full-bleed generative hero, then a strict 12-column grid below. Sidebar navigation stays dark and narrow. Data rows align like museum wall labels — name, value and rank in tabular numerals with a hairline rule.
Spacing rhythm: generous vertical spacing between sections, each section opened by a thin luminous rule that links to its sidebar item; tight internal spacing inside data rows.
Imagery style: one generative particle field built from the export dataset — product and country points glow and drift. Small schematic diagrams for the model comparison. No playful illustration or mascots.
Accessibility: readable text and controls stay whole at 375px, 768px and 1280px, wrapping or scaling with clamp(...) to fit; no element covers any part of them. The indigo/blue-on-white SaaS template is forbidden.
The public entry — Home Dashboard — opens on a full-bleed black canvas holding a slow particle field of export points, each point a product-country pair from the loaded dataset, glowing in teal #2FD3C0 and amber #FFC24A at low opacity and drifting continuously. Over the field, a nine-column Instrument Serif headline sits left at 40px to 128px: "Find the best market for your export", with the subline "Compare country demand, predict export value and check the profit before you ship." A thin tangerine #FF7A2F rule runs beneath the headline, and the "Open dashboard" call to action sits under the rule in the same accent. The sidebar stays dark and quiet at the left edge.
Below the hero, the strict 12-column grid begins. The active product is marked with the single tangerine accent; the historical trend graph renders as an interactive Plotly chart on a #141619 surface with a #2A2D31 hairline border; the dataset-provenance badge sits as an uppercase Space Grotesk micro-label. Country rows on the recommendation page read as museum labels — name, value and rank in tabular numerals with a hairline rule — and the top recommendation carries the one accent. The concept recomposes only accepted content, states and controls: the product selector, the trend graphs, the provenance badge and the navigation.
Interaction Model: Animated Motion Tempo: cinematic Hero Dimensionality: webgl
Landing Hero Motion Brief
#0A0B0D canvas.prefers-reduced-motion, the particle field renders as a static composed arrangement of the same points, the scroll-linked fade is removed, and the headline, rule and call to action remain fully readable and operable.Landing Hero 3D Scene Brief — DIRECTION-DERIVED
A real-time WebGL scene (React Three Fiber) renders one crafted particle field: each point is a product-country pair from the loaded dataset, positioned by its trade value and period, glowing in teal #2FD3C0 and amber #FFC24A at low opacity against #0A0B0D. The field drifts slowly and continuously; scroll-linked opacity fades it as the data grid below comes forward. The scene shows the product's defining state — the export dataset made physical — and never displays invented figures. Under reduced motion the scene renders a single static frame.
prefers-reduced-motion. Rationale: the creative direction's motion rule.requirements.txt and a documented Streamlit run command.
ExportWise AIUN Comtrade trade field
Compare country demand, predict export value and check the profit before you ship.
02 / Dataset & Trends
Choose an export product to read its year-by-year export value and quantity. Hover a point for its exact figures; click to pin the tooltip.
Synthetic sample dataset — for initial testing only. Not real-world trade statistics.
The products collection is empty. Load the trade dataset — the synthetic sample for initial testing, or real UN Comtrade trade records — so the historical trend can be plotted. The project data store exposes no create endpoint for this collection.
Demand pointsTrade valueAll pages stay public — no sign-in

ExportWise AIUN Comtrade trade field
Compare country demand, predict export value and check the profit before you ship.
02 / Dataset & Trends
Choose an export product to read its year-by-year export value and quantity. Hover a point for its exact figures; click to pin the tooltip.
Synthetic sample dataset — for initial testing only. Not real-world trade statistics.
The products collection is empty. Load the trade dataset — the synthetic sample for initial testing, or real UN Comtrade trade records — so the historical trend can be plotted. The project data store exposes no create endpoint for this collection.
Demand pointsTrade valueAll pages stay public — no sign-in
No comments yet. Be the first!