Scottish Exports from 2002 to 2018: What Python Analysis Reveals About Scotland’s Strengths in a Post-Brexit UK

Scotland’s export economy reflects resilience and sector based strength. Python analysis of 2002–2018 data highlights growth driven by manufacturing, energy and chemical related industries, food and drink beverages, financial services, and advanced technology innovations.

Scotland’s export economy tells an important story about resilience, adaptation, and competitive strength. Using Python to analyse the Scottish Exports dataset from 2002 to 2018, clear patterns emerge in where Scotland is strongest, which sectors have grown most consistently, and what these trends suggest for Scotland’s position in a post-Brexit UK. The dataset captures export values by year, industry sector, and destination, allowing a structured view of how Scottish trade evolved over time.

The first major finding is that Scotland’s exports grew strongly over the full period, despite episodes of political and economic disruption. Your analysis identified a very strong positive relationship between year and average export value, with a Pearson correlation coefficient of 0.988, showing that export values rose steadily across the long run. This matters because it suggests that, even with shocks such as the 2008 financial crisis, the 2014 independence referendum, and the 2016 Brexit vote, Scotland’s broader export base remained upward-trending rather than structurally declining.

A Python-based approach makes this especially useful because trends can be grouped, filtered, and compared quickly across destinations and sectors. By cleaning the data, standardising labels, grouping by year and destination, and aggregating sector totals, the analysis showed that Scotland’s export performance is not evenly distributed. Instead, a small number of sectors dominate overall value and give Scotland its strongest trade advantages. The dataset was cleaned with checks for missing values and duplicates, and text fields were standardised before analysis, improving consistency and reliability.

One of the clearest conclusions is that the European Union remained a major source of export growth during the later part of the dataset. Exports to the EU rose from £36.01 billion in 2014 to £39.58 billion in 2016 and then to £47.26 billion in 2018. That is a substantial increase over a short period and is especially notable because it includes the period surrounding the Brexit referendum. Rather than collapsing immediately, Scottish exports to the EU continued to expand, suggesting that established demand, supply-chain linkages, and sector competitiveness were strong enough to withstand early Brexit uncertainty. Working With Data Scottish Expo… Working With Data Scottish Expo…

At sector level, manufacturing stands out as one of Scotland’s greatest export strengths. Across EU exports, Total Manufacturing was the most valuable sector, contributing around £130.56 billion over the period analysed. Internationally as well, Total Manufacturing was dominant, with around £251.96 billion in export value, making it the backbone of Scotland’s non-UK trade profile. This indicates that Scotland’s export economy is still heavily supported by tradable goods industries with scale, productive capacity, and overseas demand.

However, manufacturing is not the only strength. Services were consistently one of the largest contributors across the dataset and were especially dominant in trade with the rest of the UK. The report shows that Total Services were the most valuable export category to the rest of the UK at approximately £413.94 billion, far ahead of most other sectors. This is an important point for a post-Brexit interpretation: while international trade often gets the most attention, Scotland’s economic strength also depends heavily on deep internal UK trade relationships, particularly in services. That means Scotland’s future competitiveness is tied not only to global exports, but also to maintaining strength in domestic inter-UK exchange.

The 2017 to 2018 comparison reinforces this two-speed strength in manufacturing and services. The three biggest exporting sectors in both years were Total Services, Total Manufacturing, and Financial and Insurance activities. Between 2017 and 2018, Total Services increased by 1.02%, Total Manufacturing by 4.46%, and Financial and Insurance by 8.2%. This suggests that Scotland was not relying on a single export engine. Instead, it had a diversified high-value mix, with traditional industrial output and high-value service exports growing side by side.

Financial and Insurance activities are particularly significant when thinking about the post-Brexit UK. In the data, this sector showed some of the strongest recent momentum, and it also emerged as one of the fastest-growing areas of export activity to the EU. That points to a broader lesson: Scotland’s export strengths are not limited to physical goods. Knowledge-intensive and professional sectors are increasingly important, and in a post-Brexit environment they may offer an advantage because they are scalable, high-margin, and less dependent on some of the physical trade frictions that affect goods exports.

The data also highlights that not all markets behaved the same way. Non-EU exports were positive overall but more volatile. For example, non-EU exports rose from £29.27 billion in 2007 to £37.56 billion in 2012 and £38.53 billion in 2015, but the growth was less consistent than EU trade. The basic pharmaceuticals example is especially useful here: average exports to non-EU markets were around £122.35 million, but yearly performance fluctuated sharply, including a 94.12% rise in one period and a 46.35% decline in another. This suggests that while non-EU markets offer opportunity, they may also involve greater uncertainty, regulatory friction, or market concentration risk.

Python analysis helps make this distinction clearer because it allows both total values and year-on-year percentage changes to be examined together. Looking only at totals might suggest steady strength, but adding trend calculations reveals whether a sector is stable, accelerating, or vulnerable to volatility. In Scotland’s case, the analysis suggests that manufacturing and services are not just large; they are also more dependable foundations for long-term export performance than some smaller, more erratic sectors.

Another important lesson from the data is that Scotland’s export strengths are concentrated in a mix of advanced manufacturing, food and drink-related production, financial services, and selected knowledge-based sectors such as professional, scientific, and technical services and computer/electronic products. For example, Computer, Electronic and Optical Products recovered strongly after a decline in 2014 and rose to their highest value in 2018. That pattern suggests Scotland has real capability in higher-value industrial and technical production, not just in legacy industries.

So what can be learned from this going into a post-Brexit UK? First, Scotland’s core export strengths are clear: manufacturing remains the leading external trade engine, services dominate within the UK market, and financial and knowledge-intensive sectors are increasingly important growth areas. Second, the EU still appears highly significant in the final years of the dataset, meaning Scotland’s competitive position has historically been strongest where it could access large nearby markets with established demand. Third, non-EU trade has potential, but the data suggests it should not be treated as a simple replacement for European trade because volatility is higher and growth is less even.

The strategic takeaway is that Scotland’s strongest post-Brexit export model is likely to be a balanced one. It should continue backing advanced manufacturing, protect and expand high-value services, and invest further in sectors that combine export value with scalability, such as financial services, professional services, and specialist technology production. The evidence from the data does not suggest that Scotland succeeds by abandoning existing trade strengths. Instead, it suggests that Scotland performs best when it builds on what already works: high-value manufacturing, resilient service capacity, and diversified sectoral strengths across both UK and international markets.

Conclusion

Overall, the Python analysis shows that Scotland entered the post-Brexit era with several genuine export advantages. Manufacturing was the strongest external-facing sector, services were the strongest within the UK, and finance and other knowledge-intensive sectors were gaining momentum. EU exports remained robust up to 2018, while non-EU markets offered opportunity but with greater volatility. The main lesson is that Scotland’s export future should be built around reinforcing its proven strengths rather than chasing uncertain diversification for its own sake. A competitive post-Brexit Scotland is therefore most likely to be one that doubles down on advanced manufacturing, services, and high-value specialist sectors that already show evidence of resilience and growth in the data.