India Trade Analysis

Project Overview

The India Trade Analysis project offers a detailed examination of India's trade activities, focusing on imports and exports. This analysis considers various dimensions such as country, commodity, section, year, region, GDP, growth, month, port, and trade intensity. Through data preprocessing, visualization, and advanced analytics, the project aims to reveal key patterns and trends in India's trade. The findings will be valuable for policymakers, businesses, and researchers. Additionally, the project includes a responsive web dashboard developed with React, featuring interactive insights, a detailed project description, Python code, and Jira integration for project management.

Python Screenshot

There is a significant difference of mu between the values of the import and export.here in import and export data have significantly less changes in average value

Python Screenshot

correlation of population(GDP/PCI) and GDP is 0.9647

Python Screenshot

export data is not normally distributed here we use q-q plot to visualize the data is not normally distributed

Python Screenshot

import data also not normally distributed formally test whether data follows a normal distribution using statistical tests (e.g., Shapiro-Wilk test, Anderson-Darling test, or visual inspection of histograms and Q-Q plots).When your data is not normally distributed, it means that the distribution of your data points does not follow a typical bell-shaped curve (like the normal distribution). Instead, the data might exhibit skewness (a longer tail on one side) or other non-symmetrical patterns.

Python Screenshot

The median is not equal across all groups Unequal medians suggest that the distribution of values within each group differs. It could mean that one group tends to have higher or lower values than the others.

Python Screenshot

correlation of all fields in gdp data here GDP and per capita income net_export_percetage_of_GDP and net_export_contribution_to_PCI_percentage are perfect correlated

PowerBI

Power BI is a business analytics service provided by Microsoft that enables users to visualize and share insights from their data. It provides interactive visualizations and business intelligence capabilities with an interface that is simple enough for end users to create their own reports and dashboards.

Sections
I Animal Products
II Vegetable Products.
III Animal or Vegetable Fats and Oils and their cleavage products; Prepared Edible Fats; animal or vegetble waxes.
IV Prepared Foodstuffs, Beverages, Spirits and Vinegar, Tobacco and Manufactured Tobacco Substitutes.
V Mineral Products.
VI Product of the chemicals or allied Industries.
VII Plastics and articles thereof, Rubber and articles thereof.
IX Wood and articles of wood, Wood charcoal, Cork and articles of cork, Manufacturers of straw, of Esparto or of other Plaiting Materials, Basketwork and Wickerwork.
X Pulp of wood or of other Fibrous Cellulosic Material, Recovered ( Waste and scrap ) paper or paperboard, paper and paperboard and articles thereof.
XI Textile and Textile articles.
XII Footwear, Headgear, Umbrellas, Sun Umbrellas, Walking-sticks, seat-sticks, whips, riding-crops and parts thereof, Prepared feathers and articles made therewith, Artificial flowers, Articles of human hair.
XIII Articles of stone, plaster, cement, asbestos, mica, or similar materials, ceramic products, glass and glassware.
XIV Natural or cultured pearls, Precious or semi-precious stones, precious metals, Metal clad with precious metal, and articles thereof, Imitation Jewellery, Coins.
XV Base Metals and articles of Base Metal.
XVI Machinery and mechanical appliances, electrical equipment, parts thereof, sound recorders and reproducers, television image and souch recorders and reproducers, and Parts and Accessories of such article.
XVII Vehicles, Aircraft, Vessels and Associated Transport Equipment.
XVIII Optical, Photographic, Cinematographic, measuring, checking, precision, medical or surgical instruments and apparatus, clocks and watches, musical instruments, parts and accessories thereof.
XIX Arms and ammunition, parts and accessories thereof.
XX Arms and ammunition, parts and accessories thereof.
XXI Works of art, Collectors’ Pieces and antiques.
TOTAL Others