I take a 12 mile 15 minute commute, about 10 miles of which is motorway. Using the trip computer, as there's no other way, the average fuel figure goes down steadily until around the half way stage where it sits until I'm nearly at work whereupon it goes up slowly until it's around the same level as it started. Given a longer motorway run I'm certain it would have ended up higher than it started.
On the other hand, Mrs. Beard's Alfa 156 doesn't have a trip computer but on filling the tank brim-ful and working out the fuel mileage it returns around 30mpg, which doesn't sound great, but bear in mind it is a 2-litre 150 bhp petrol version and is 10 years old. Her daily commute is only around 3 miles each way. On a longer motorway journey it gives 35mpg.
The Panda gives 55 to 58mpg. But in winter, in other words now, it struggles to best 50.
Personally, for local commutes I'd go for the small petrol. You shouldn't need to rev the engine above 2000 - 2500 revs even in a 1.2 or 1.4 petrol which should give you pretty good fuel returns.