Road freight transport and big data

Print Friendly

Recovery is on the way. Maybe we should say it’s on the road, again. Never before I had dealt with 121,189 rows times 93 columns for the mind boggling figure of 11,270,577 numbers. Browsing the catalogue on the European Union Open Data Portal I stumbled – actually this happened not so randomly  - on quarterly cross-trade road freight transport statistics (see and get data here).

The chart below – with the latest data available - shows how cross-trade transport changed year-on-year between Q4 in 2012 and the same quarter in the preceding year. On y-axis are transport statistics in two different measure units (thousands of tonnes and millions of tonnes per kilometer), on x-axis the same the year before and the red line is the diagonal cutting in two halves all the values in the chart. The blue line above the red diagonal is a smoothing statistics showing that on average freight transport on asphalt improved year on year in Q4-2012. While notable exceptions are easily recognizable (the Czech Republic, CZ, for example) the underlying and general pattern shows an improvement in freight road transport.

Road freight transport

The different colors represent all countries surveyed by Eurostat – see their codes in the guides on the right – and, though one can hardly tell the difference in their shades, it’s easy to see that countries have significantly different road trade transport patterns. In the chart below country plots have been “trellised” to highlight these differences (see Poland, PL, for example).

Road freight transport country pattern

On average, overall freight transport increased by 8% year-on-year through Q4 in 2012 in the European Union, though differing country patterns can hide counter trends in the data one can rule out coincidence comparing Q4-2011 and Q4-2012 statistics [§]. It’s interesting to have a look at the cross-trade road cargo patterns measured by carried tonnes in 1000T, ‘hire and own’ carriages in the heat map below: the largest EU countries tend to dominate (top right in the heat map) road cross-trade transportation.

Road heat map

Truck drivers may be happy to read the news, not so much environmentalists perhaps. Another question remains unanswered: how is freight road transport correlated with financial markets? Asset managers will surely keep their eyes on the road.

[§]Welch Two Sample t-test
data:  road.h$X2011Q4 and road.h$X2012Q4
t = -2.3556, df = 54530.05, p-value = 0.0185
alternative hypothesis: true difference in means is not equal to 0
95 percent confidence interval:
 -16.069196  -1.472942
sample estimates:
mean of x mean of y 
 104.8799  113.6510
Share Button
Posted in Economics, R-stats
Tags: , , , ,

Leave a Reply

Your email address will not be published. Required fields are marked *


20 + = 27

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>