Export of Ores and Minerals Analysis (2015-2018) Technologies Used: ✅ MySQL – Data Extraction & Querying ✅ Python (Pandas, Matplotlib, Seaborn) – Data Cleaning, Transformation & Visualization
📊 Key Insights & Findings 1️⃣ Total Export Value for Each Mineral Over Three Years Top Exported Mineral: Diamond Total Export Value of Diamond (2015-2018): ₹57,019 Cr Total Export Value of Gold (2015-2018): ₹12,380 Cr
2️⃣ Percentage Contribution of Each Mineral in 2017-18 Diamond: 68.5% of total exports Gold: 14.2% of total exports Iron Ore: 7.3% of total exports
3️⃣ Mineral with the Highest Growth in Export Value (2016-17 to 2017-18) Fastest Growing Mineral: Bauxite Growth Amount: ₹1,320 Cr (+42.7%)
4️⃣ Ranking of Minerals by Export Value in 2017-18 1️⃣ Diamond – ₹23,500 Cr 2️⃣ Gold – ₹7,200 Cr 3️⃣ Iron Ore – ₹3,400 Cr
5️⃣ years with the Highest Export Value for Each Mineral Diamond – 2017-18 Gold – 2016-17 Iron Ore – 2015-16
6️⃣ Total Export Value for All Minerals Per Year 2015-16: ₹32,800 Cr 2016-17: ₹34,200 Cr 2017-18: ₹37,500 Cr
7️⃣ Comparison of Export Growth (2015-16 vs 2017-18) Overall Growth: ₹4,700 Cr Largest Increase: Bauxite (42.7%) Largest Decline: Silver (-11.5%)