India's official merchandise trade statistics from the Directorate General of Foreign Trade (DGFT). Covers commodity-wise and country-wise export and import data, ITC-HS code level trade flows, and port-wise statistics. Maharashtra is India's top exporting state with major ports (JNPT, Mumbai) and export hubs (Pune, Nashik, Aurangabad). Essential for analyzing Maharashtra's trade competitiveness and export sector.
import pandas as pd
# Download trade data from https://www.dgft.gov.in/CP/?opt=trade-statistics
# Select commodity-wise or country-wise reports
df = pd.read_excel('trade_statistics.xlsx')
print(f"Commodities: {df['Commodity'].nunique()}")
print(df.groupby('Commodity')['Export_Value_USD'].sum().sort_values(ascending=False).head(10))| Field | Type | Description |
|---|---|---|
| hs_code | string | ITC-HS commodity code |
| commodity | string | Commodity description |
| country | string | Trading partner country |
| export_value_usd | float | Export value in USD millions |
| import_value_usd | float | Import value in USD millions |
| period | string | Trade period (month/year) |