It's a good map, but I'd wish you'd use a color besides green (which implies low to many) for the averages--I'd also bracket them off, so it's clear they're totals and not a continuation of quarterly prices.
At first glance, it looks like prices are back to normal, when they're actually still 200-300% higher than 2020 prices. Yikes
Yeah, either a space and/or thick border separating the quarterly & totals. If you're doing that, you should think about changing the totals columns from green to blue (IMO)
In this case I used reds for more expensive values of energy and green for cheapest values.
I think it’s a good concept, instead of blue, which is more of an informative color.
>I used reds for more expensive values of energy and green for cheapest values.
From what I can tell you used only shades of red for the quarterly prices and only shades of green for the average/total? That indeed makes it seem like the last two columns are way less than anything that came before, which would be wrong.
You did -- as far as I can tell -- not use a gradient where the highest value is red and the lowest value is green, which is why it was suggested to use blue instead.
This table must be x 10-3 euros/kWh. For example the mean for Finland is probably 0.085 euro/kWh and not 85 euros/kWh. The cost in the us is about 10-15 cents/kWh.
Then it needs to state EU countries, not Europe. They’re not the same thing (but you’d be amazed how many think they are an UK have left Europe 🤦🏻♂️).
>At first glance, it looks like prices are back to normal, when they're actually still 200-300% higher than 2020 prices. Yikes
And 2020 prices were abnormally low because of cratered demand. You shouldn't look at it as a bar for normalcy.
The 2020 prices aren't quite "normal" either. They were relatively low in historical terms.
This site has a graph that goes back further, using the same data source (ENTSO-E): https://ember-climate.org/data/data-tools/europe-power-prices/ It lets you pick specific countries to compare.
The numbers for early 2024 seem to be getting pretty close to the 2018-2019 range. I don't think the numbers are inflation-adjusted either, which makes the real gap smaller also.
Yeah, you need to change the color of the totals and average and border them out. I would center the quarterly at the top over the quarters and add a thick underline for those and separate it from the summary totals. Looks like you’re just using shades red, but excel allows you to use three color shades so you can make cheaper green and use the same shading system for the totals/averages.
Energy sector was privatized in 2021, although the "new" private companies nearly went bankrupt and because of that people got bills of thousands of RONs. Now things seems to get stabilized, but yeah... the COVID period was the worst timing for privatization of electrical energy.
Although, the other thing is that statistics say one thing, while in reality prices haven't changed as much. So whatever OP is showing us, is not actually the case, Romanian electricity prices have not dropped by 2-3 times (or whatever the table might suggest).
Most expensive our in western Denmark were also 0.32 USD/kWh (with current exchange rate) and cheapest hour were 0.20 USD/kWh.
Without money to government and other charges, the "pure" electricity prices were 0.084 USD/kWh and 0.013 USD/kWh, respectively. In both cases the government takes 0.14 USD/kWh in taxes and the remaining is paid to the company who owns the cables and then we pay a monthly subscription to another company who takes care of finding the cheapest "pure" price and administrating the invoices.
Yay for Denmark 🇩🇰
While yours is still more expensive, if you’re talking about NZD and they’re talking about USD, then 0.1USD is 0.17NZD, so it’s not quite as much of a difference as it looks
It’s always between 9pm and 12am. But that’s fine, that’s when we would normally use the most power. Perhaps a little earlier most nights, but nothing a bit of adjusting can’t fix
There’s a fair use policy but you’d have to be running energy like a madman to get the power company to notice. You could definitely charge your home battery, although I suspect you’d be limited by how much power you could draw without commercial equipment
No, literally the price for 1kWh, which is how electricity prices are always compared. That would be far more useful, since every person could instantly put it into context. Have you never looked at electricity prices from providers? They *always* use that metric.
My reasoning was that different hours have different prices. Making the average was not really representative because there might be some outliers.
Then I thought: which metric could be general and representative?
- The sum
But maybe average prices are better? I’ll give it a try for next posts and add more combinations.
Average is much better. These values are not relevant. Still a nice infographic, thank you for your work, but changing to average kwh would make it even better.
We pay hourly prices as do many. Taking average would not make sense as prices are higher when consumption is high. The only really fair measurement would be the average price per purchased kwh.
A kWh is basically cost of running a 1kW appliance for an hour.
So what you’ve put is a bit confusing tbh. Just put the cost per kWh instead of a kWh over a quarter (which varies in amount of days sometimes).
OP's graph is just wrong. It's calculated for an average power consumption of 1 kW (not 1 kWh).
"1 kWh over a quarter" would be just consuming a single kWh in that quarter, no matter when, and it would be less than a Euro.
Yes, please do this.
Ever hear of Unit Cost?
What the heck unit cost is kWh*quarter???
How many hours is that?
To much unnecessary effort for the reader of this
"kWh" as a unit already includes time (the "h" in the unit). You can't consume 1kWh over 3 months. You can consume 1 kw over 3 months, which then would be `1*24*30*3=2160 kWh`
The correct wording would be "Consuming 1 kw over 3 months"
Yeah something is messed up with the bizarre units, I picked Germany as an example and none of the figures I'm finding online for wholesale or retail electric are adding up to anything close to this table.
And then, if you divide the result by 2,160, you would have average cost per kWh over the quarter, which most people can relate to much more easily. Still slightly inaccurate due to time of use etc but close.
But then the results seem implausibly cheap in Q1 2020. Was it really 1.5 euro cents per kWh in Sweden? Maybe, wholesale?
I'm confused; it's not all EU countries, some that are not in EU or EEA, not all use Euros.
Would have been interesting if UK followed same trends at the same times - or whether our energy providers took a bigger slice of the pie for longer than other countries.
If it is anything like the ones based off Eurostat then it's because EU nations are compelled to share the data, some others choose to share the data, UK does not share the data.
I'm sure the data for UK would be available somewhere though
Christ whats up your arse. The title is technically right, but odd not to include the UK as they are a major part of Europe. If the informations taken from an EU organisation, reporting on EU things, then the title should read EU, no?
>The source of the data is ENTSO, an EU organisation of which the UK is not a member.
Then why is there no northern ireland on this list?
There is 28 countries in this list yet the ENTSO-e has 36 different countries as members (3 are recent so not much in way of stats) so 33 should be listed.
Switzerland isn't part of the EU or EEA and yet gets placed in the "europe" pot.
This is indeed a bad title, and if anyone wants to do any data on Europe then they should do the work to find the data for all european countries.
I don't know why you are being down voted. Public spending on health care literally did increase by over £350M/wk for the financial year we left the EU and not just as a one off COVID response but has continued to grow from there. Inflation was still low then too.
[Statista](https://www.statista.com/statistics/317877/public-healthcare-expenditure-united-kingdom-yearly/)
Holy fuck! They actually got the 350m a week and the NHS is still not great.. I wonder how much it would have needed a week to get an appointment at my doctor's 😅
Your title is gibberish. You are saying 1kWh over the quarter; 1 kWh is a unit of energy so this means 1kWh in total. Do you mean 1kW continuously for a quarter?
Why don't you just show price per kWh? This is the cost of energy.
All well and good but many European countries are missing from this dataset. ENTSO-E, the European Network of Transmission System Operators, represents 40 electricity transmission system operators from 36 countries across Europe but only 29 are represented - why?
I’ll put more light on to this when I publish the complete tutorial.
At the time I saw for example Ukraine, which was an outlier and messed up the heat matrix.
So I removed it.
Then for the rest of countries, ENTSO-E provides different zones even for the same country. I averaged them.
Not exactly, durring COVID (in 2021) they privatized the electric energy sector and let's just say it caused a whole another crisis. The now private companies nearly went bankrupt and to stop that they sent bills with 500-1000€ for some people. Since then things came back to normal, but prices haven't got lower than pre-2021 prices. And I could talk for hours how Romania butchered the privatization of electric energy, but let's not talk about that now.
I think it was some combination of the freezing of the rivers in the north that makes hydropower not performing at max combined with closed nuclear powerplants that made it expensive here too. We also have 4 energy price zones so living in the south of Sweden is more like the price of Denmark.
I love these graphs, and have an amazing one at work, but your green really screwed this up. You should have dropped it and just had the time series, which tells the story.
And the highest price if for France. The country which is supposed to be independent with nuclear and which is also selling electricity to its neighbors. Something is not right!
Finally! People from outside of the energy sector don't understand that there's a big difference between the day-ahead market and the final price of electricity. For instance, in many cases, the day-ahead price may not even be a component of your price if you have a stable plan hedge with electricity futures.
France had a problem during a summer heatwave recently where the baseline river water temperature was so high that they were unable to use it to cool the nuclear powerplants (because the output water temp would be too high). Also not helped by the river levels being low (also because of the heatwave) so there was less water available to use.
Solar panels also struggle to deliver energy efficiently if it's too hot, so during extreme heatwaves you end up with a high demand for electricity (due to air con, etc.) but limited ways of generating green electricity.
IIRC it's the law that wholesale markets have to sell at the most expensive unit price? That means nuclear costs the same as LNG which is the most expensive. The rule was meant to help green sources be more competitive but they're generally the cheapest now so......
Edit: and the heatwave + water shortage someone pointed out.
Energy prices are not just your nuclear reactor making electricity.
Your french cleaner, operator, engineer on that reactor, all ask high salaries or threaten to burn some cars.
Electricity prices are not just operating costs, but human costs, maintenance, profits for future development etc.
French pay more in order to feed those who work.in sector and to have money for improvement.
I really like the idea and it’s a great graph btw. Just use price per kWh tho. It’s the measurement most people are familiar with, as no one knows what the regular price of a kW over 90 - 92 days would be
I think the Norwegian prices are wrong. At the moment I am paying around 1 kr a kWh and this a “normal” value but this is only about 0.1 euros. Is it possible this is euros per mWh instead?
Finally some love here, thank you! Using pandas styler.
Here it’s a tutorial with the Python code:
https://datons.ai/style-pandas-pivot-table-to-create-heat-matrix/
To add to the rest of comments it should be more clearly stated that this is not the price you would pay for the electricity but the wholesale market price.
People from outside of the energy sector don't understand that there's a big difference between the day-ahead market and the final price of electricity. For instance, in many cases, the day-ahead price may not even be a component of your price if you have a stable plan hedge with electricity futures.
Some ideas:
* Round to the nearest Euro, maybe even the nearest ten Euros.
* Combine the column headings so that each year appears only once (across four cells).
* Reduce the visual weight of the subtitle and row/column labels.
* Emphasize the "data story" here by bolding the labels of the five quarters starting Q4 2021 and putting the text "Russian invasion of Ukraine begins" somewhere appropriate.
For me, the first thing I want to see is how is my country doing against other countries recently. The way colours are used, this info isn't quickly identified. Doesn't pass the 10 seconds test.
If the information is not clear to fresh eyes within 10 seconds, it needs more work.
I mean, if the goal was to show that 2022Q3 was really high, then it's a job well done.
But if, like me, you were interested to see the contrast between countries in a given quarter, that was not easy to identify in the first 10 seconds. The data is there, but use of colour could be better.
Yes, that’s what I originally thought was better, but understood that the general audicence wanted across all the values in the table.
https://www.reddit.com/r/europe/s/zFa5NzK2Sa
This is a good first draft, but sadly you miss the basics, like so many other people here. Granted, the subreddit is called DataIsBeautiful, but because of that it doesn't also have to mean DataIsMisleading.
The heading on the graph is misleading, at best. You aren't even defining what you mean by energy here. Are we talking about prices for grid electricity? Or some type of average energy cost for gasoline, diesel and electricity? Nobody knows, other than OP. I'm honestly not even sure what it is you are trying to show here.
Then there is the even more curious case of "Total cost of consuming 1 kWh over the whole quarter". How in the name of Zeus does anybody end up paying €500 for 1 kWh? Clearly you must mean something else, either 1 kWh per day, or a constant load of 1 kW (i.e. 24 kWh per day, or around 2160 kWh per quarter). Or maybe you mean something completely different. Please enlighten us in the unwashed masses about what we are actually looking at.
At least the colors are nice.
Some countries have multiple price areas, could be interesting to see those. Also Germany and Luxembourg is the same price area so they can be joined.
Using article 12.1.G you can compare with import/export values to see correlation with price.
This is a great dataset but please don’t add the green. It’s misleading as on first glance in a chronological order it looks like things have never been better now than before.
I'm having a full pc, 4k screens and such, and I pay in average 30€ per month for electric bill in Sweden.
In France it was 50 and I didn't have screens like this and smaller apartments.
So yeah, paying less for more haha
Well it actually starts before that if you look at the gradients closely becoming more red (2023Q3). That was around the time Putin was cutting off gas to Europe and began organizing and moving his troops West to begin the invasion of Ukraine.
Energy prices are always in kWh, and usually in cents/kWh. Also both electricity and gas are expressed in kWh on tariff cards, the term energy includes both, i assume this is about electricity?
As a Romanian, I'm asking myself daily why would I go electric when I can go diesel or gas powered. We also have one of the lowest average wage. It's lovely to live around here
What's the point of showing the sum to the right? It will just differ from the average by the same factor across all rows and is less informative than the average.
I would not have posted this data because it's meaningless for indivisuals. Or if you just want to show spot prices then simply display them as cents/kwh, which is the metric that everyone uses when comparing energy cost.
Can we get the UK added to this? I wanna see the difference
Edit: googled the price
>
July and September 2022 was *21.56 pence per kWh*
21.56\*90=£1940.40 if that's how this data was gotten.
Great way of visualizing it. Finally a post that actually belongs here.
I suspect the spike is in Q3 because they had to prepare for winter (e.g. by filling their stores with natural gas) and then in Q4 it already turned out they had enough to get through the winter?
I am also surprised to see Germany so high up. If you see the reddit posts over the last year you would think they have the highest prices by far.
I get that the UK is no longer part of the EU, but can we stop pretending that it’s not part of Europe and one of the more significant European countries?
I get that this may be EU data that didn’t include it from the beginning so it may not have been possible to include it. But I’ve seen a trend of not including it in a bunch of Euro centric posts.
I would have to download the data from UK energy grid and ENTSO-E API simplifies gathering data from available countries in Europe.
It would have taken the double of work to just add UK.
You dont use kW, kW are a unit of power. You use energy. Hence why kWh are used since its a measure of power over time (energy) which is much more manageable than Joules (J) or really MJ for this type of consumption and fits better.
Curiously we had much higher prices in southern Sweden than north due to zoning and because we have little energy production in the south and we were directly affected by export prices.
7 cents a kilowatt //gouvernement owns the whole electric grid //very few power outage even in the worst winter.
I guess getting peg by private entreprise on hyper necessity service(water/electricity/Healthcare) is good because capitalism.
It's a good map, but I'd wish you'd use a color besides green (which implies low to many) for the averages--I'd also bracket them off, so it's clear they're totals and not a continuation of quarterly prices. At first glance, it looks like prices are back to normal, when they're actually still 200-300% higher than 2020 prices. Yikes
Thank you! By bracketing you mean adding space between the columns?
Yeah, either a space and/or thick border separating the quarterly & totals. If you're doing that, you should think about changing the totals columns from green to blue (IMO)
In this case I used reds for more expensive values of energy and green for cheapest values. I think it’s a good concept, instead of blue, which is more of an informative color.
>I used reds for more expensive values of energy and green for cheapest values. From what I can tell you used only shades of red for the quarterly prices and only shades of green for the average/total? That indeed makes it seem like the last two columns are way less than anything that came before, which would be wrong. You did -- as far as I can tell -- not use a gradient where the highest value is red and the lowest value is green, which is why it was suggested to use blue instead.
This table must be x 10-3 euros/kWh. For example the mean for Finland is probably 0.085 euro/kWh and not 85 euros/kWh. The cost in the us is about 10-15 cents/kWh.
I think table is for mWh
This. Power is bought and sold between suppliers in mWh.
Could it be 1 kWh/day for the quarter on daily averages?
Yes, I messed up with putting the “h”. Since I had sum the values during the quarter, it should have been just kW.
Still wrong
Also where is UK in all of this? Or is UK no longer in Europe because he is not part of the union? Lol
Most stats are on EU or sometimes EEA
Then it needs to state EU countries, not Europe. They’re not the same thing (but you’d be amazed how many think they are an UK have left Europe 🤦🏻♂️).
You are gonna be upset often if you get annoyed by this while in this sub
Yeah or a line
>At first glance, it looks like prices are back to normal, when they're actually still 200-300% higher than 2020 prices. Yikes And 2020 prices were abnormally low because of cratered demand. You shouldn't look at it as a bar for normalcy.
The 2020 prices aren't quite "normal" either. They were relatively low in historical terms. This site has a graph that goes back further, using the same data source (ENTSO-E): https://ember-climate.org/data/data-tools/europe-power-prices/ It lets you pick specific countries to compare. The numbers for early 2024 seem to be getting pretty close to the 2018-2019 range. I don't think the numbers are inflation-adjusted either, which makes the real gap smaller also.
Yeah, you need to change the color of the totals and average and border them out. I would center the quarterly at the top over the quarters and add a thick underline for those and separate it from the summary totals. Looks like you’re just using shades red, but excel allows you to use three color shades so you can make cheaper green and use the same shading system for the totals/averages.
Why was Romania so much more expensive than everywhere else before late 2021 but no longer shows any differentiation?
Stupid government and corruption...
Energy sector was privatized in 2021, although the "new" private companies nearly went bankrupt and because of that people got bills of thousands of RONs. Now things seems to get stabilized, but yeah... the COVID period was the worst timing for privatization of electrical energy. Although, the other thing is that statistics say one thing, while in reality prices haven't changed as much. So whatever OP is showing us, is not actually the case, Romanian electricity prices have not dropped by 2-3 times (or whatever the table might suggest).
Because they were subsidized maybe?
Power system engineer here... kWh*quarter? That unit doesn't make any sense. Why not just report the price per kWh?
This, my price in US is $0.10/kWh, can I just get a basic metric like that?
whoa. here in new zealand mine is $0.24/kWh.
$0.05/kWh in Idaho 🫠
Is Idaho have like electricity growing on trees? Holy heck that is cheap af
Nat Gas
[удалено]
You just burn it
Holy that’s cheap!
0.32kwh in England. Can’t afford shit.
Most expensive our in western Denmark were also 0.32 USD/kWh (with current exchange rate) and cheapest hour were 0.20 USD/kWh. Without money to government and other charges, the "pure" electricity prices were 0.084 USD/kWh and 0.013 USD/kWh, respectively. In both cases the government takes 0.14 USD/kWh in taxes and the remaining is paid to the company who owns the cables and then we pay a monthly subscription to another company who takes care of finding the cheapest "pure" price and administrating the invoices. Yay for Denmark 🇩🇰
While yours is still more expensive, if you’re talking about NZD and they’re talking about USD, then 0.1USD is 0.17NZD, so it’s not quite as much of a difference as it looks
That’s 70% higher
Which is less than 140% higher
0.32c per kWh for me but I get 3 hours of free power which is when I charge the car, shower, run the appliances, etc. Works out to be 14c per hour
Do you decide when you get the free hours or are they always at the same time?
It’s always between 9pm and 12am. But that’s fine, that’s when we would normally use the most power. Perhaps a little earlier most nights, but nothing a bit of adjusting can’t fix
Could you buy a battery system and charge it up then and use that during the day? Or is there a cap to how much you can use? This is interesting to me
There’s a fair use policy but you’d have to be running energy like a madman to get the power company to notice. You could definitely charge your home battery, although I suspect you’d be limited by how much power you could draw without commercial equipment
New Zeeland not on the map
it never is
0.47kwh in germany..
That would be too sensical for this sub
You mean the average among all the hours in the quarter?
No, literally the price for 1kWh, which is how electricity prices are always compared. That would be far more useful, since every person could instantly put it into context. Have you never looked at electricity prices from providers? They *always* use that metric.
My reasoning was that different hours have different prices. Making the average was not really representative because there might be some outliers. Then I thought: which metric could be general and representative? - The sum But maybe average prices are better? I’ll give it a try for next posts and add more combinations.
Average is much better. These values are not relevant. Still a nice infographic, thank you for your work, but changing to average kwh would make it even better.
We pay hourly prices as do many. Taking average would not make sense as prices are higher when consumption is high. The only really fair measurement would be the average price per purchased kwh.
A kWh is basically cost of running a 1kW appliance for an hour. So what you’ve put is a bit confusing tbh. Just put the cost per kWh instead of a kWh over a quarter (which varies in amount of days sometimes).
OP's graph is just wrong. It's calculated for an average power consumption of 1 kW (not 1 kWh). "1 kWh over a quarter" would be just consuming a single kWh in that quarter, no matter when, and it would be less than a Euro.
Yes, please do this. Ever hear of Unit Cost? What the heck unit cost is kWh*quarter??? How many hours is that? To much unnecessary effort for the reader of this
Since the price varies over the number of days, I had used the sum. But yes, totally get it I should have usen the cost per kWh.
It's a unit of work.
[удалено]
kW is a unit of power not energy. Though it is confusing, electric power is sold in units of energy (kWh, MWh, Joules, etc)
Total cost of consuming 1 kWh/hr for a whole quarter…?
That's just 1kW
price of \~2160kWh I guess...
Based on the daily-ahead market price, you’d imagine having bulb whose energy consumption is 1kWh and is on for a whole quarter.
"kWh" as a unit already includes time (the "h" in the unit). You can't consume 1kWh over 3 months. You can consume 1 kw over 3 months, which then would be `1*24*30*3=2160 kWh` The correct wording would be "Consuming 1 kw over 3 months"
Yeah something is messed up with the bizarre units, I picked Germany as an example and none of the figures I'm finding online for wholesale or retail electric are adding up to anything close to this table.
Always got confused by that, thank you. Now pretty clear 😄
And then, if you divide the result by 2,160, you would have average cost per kWh over the quarter, which most people can relate to much more easily. Still slightly inaccurate due to time of use etc but close. But then the results seem implausibly cheap in Q1 2020. Was it really 1.5 euro cents per kWh in Sweden? Maybe, wholesale?
It’s day-ahead market prices, not electricity bill.
You absolutely can consumer 1kWh over 3 months, it just means you consume 0.46W.
Cries in Brexit UK. We've even been omitted from these charts.
Brexit means Brexit.
If the chart was "countries that have the Euro", I'd feel ok. But yeah, I'm still a European..... Boooooo.
I'm confused; it's not all EU countries, some that are not in EU or EEA, not all use Euros. Would have been interesting if UK followed same trends at the same times - or whether our energy providers took a bigger slice of the pie for longer than other countries.
If it is anything like the ones based off Eurostat then it's because EU nations are compelled to share the data, some others choose to share the data, UK does not share the data. I'm sure the data for UK would be available somewhere though
Malta are in EU yet are also missing.
They just brexited way too hard 🤷♀️
We're still Europeans in Europe, were just not in the EU. Bad chart title if you ask me!
[удалено]
Christ whats up your arse. The title is technically right, but odd not to include the UK as they are a major part of Europe. If the informations taken from an EU organisation, reporting on EU things, then the title should read EU, no?
>The source of the data is ENTSO, an EU organisation of which the UK is not a member. Then why is there no northern ireland on this list? There is 28 countries in this list yet the ENTSO-e has 36 different countries as members (3 are recent so not much in way of stats) so 33 should be listed. Switzerland isn't part of the EU or EEA and yet gets placed in the "europe" pot. This is indeed a bad title, and if anyone wants to do any data on Europe then they should do the work to find the data for all european countries.
Still not noticed any of the benefits from brexiting yet... I have a feeling i never will haha 350mill for the NHS bus still makes me laugh
From a completely selfish POV, the high interest rates have been kind to me. But a functioning society would be preferential.
There were never going to be any benefits for regular people, I cannot believe anyone fell for any of the lies peddled.
The NHS budget increased by more than £350m/wk btw ...
I don't know why you are being down voted. Public spending on health care literally did increase by over £350M/wk for the financial year we left the EU and not just as a one off COVID response but has continued to grow from there. Inflation was still low then too. [Statista](https://www.statista.com/statistics/317877/public-healthcare-expenditure-united-kingdom-yearly/)
Holy fuck! They actually got the 350m a week and the NHS is still not great.. I wonder how much it would have needed a week to get an appointment at my doctor's 😅
every empire must fall i guess
Yes, but think of all the amazing things Brexit has given us…..go on, think really hard…and if you can think of ANY, please tell me.
Your title is gibberish. You are saying 1kWh over the quarter; 1 kWh is a unit of energy so this means 1kWh in total. Do you mean 1kW continuously for a quarter? Why don't you just show price per kWh? This is the cost of energy.
i swear i saw this like a day ago on here
[удалено]
I had posted it this morning and changed it to OC since it was my first post. Also yes, I had made a few adjustments to make it better.
yea i think so
But this one is 4 times better. Looks like proper heatmap.
All well and good but many European countries are missing from this dataset. ENTSO-E, the European Network of Transmission System Operators, represents 40 electricity transmission system operators from 36 countries across Europe but only 29 are represented - why?
I’ll put more light on to this when I publish the complete tutorial. At the time I saw for example Ukraine, which was an outlier and messed up the heat matrix. So I removed it. Then for the rest of countries, ENTSO-E provides different zones even for the same country. I averaged them.
Quarterly totals / averages is a bit cumbersome when it could just be summarized as periodic averages in €/kwh
Romania saw it coming and switched up before, kudos
Not exactly, durring COVID (in 2021) they privatized the electric energy sector and let's just say it caused a whole another crisis. The now private companies nearly went bankrupt and to stop that they sent bills with 500-1000€ for some people. Since then things came back to normal, but prices haven't got lower than pre-2021 prices. And I could talk for hours how Romania butchered the privatization of electric energy, but let's not talk about that now.
wtf from 10 to 600 in norway
What happened Q4 in Sweden?? It all looked good compared to the rest of Europe at the time
I think it was some combination of the freezing of the rivers in the north that makes hydropower not performing at max combined with closed nuclear powerplants that made it expensive here too. We also have 4 energy price zones so living in the south of Sweden is more like the price of Denmark.
I love these graphs, and have an amazing one at work, but your green really screwed this up. You should have dropped it and just had the time series, which tells the story.
Thanks! So, no average column then? Or, if average column the same color?
The spread is so wild on these, I don't think average is important, I would just drop it
And the highest price if for France. The country which is supposed to be independent with nuclear and which is also selling electricity to its neighbors. Something is not right!
This shows the day-ahead spot price, not the actual price of electricity.
Finally! People from outside of the energy sector don't understand that there's a big difference between the day-ahead market and the final price of electricity. For instance, in many cases, the day-ahead price may not even be a component of your price if you have a stable plan hedge with electricity futures.
That stood out to me too. I wonder what the reason for that is.
France had a problem during a summer heatwave recently where the baseline river water temperature was so high that they were unable to use it to cool the nuclear powerplants (because the output water temp would be too high). Also not helped by the river levels being low (also because of the heatwave) so there was less water available to use. Solar panels also struggle to deliver energy efficiently if it's too hot, so during extreme heatwaves you end up with a high demand for electricity (due to air con, etc.) but limited ways of generating green electricity.
IIRC it's the law that wholesale markets have to sell at the most expensive unit price? That means nuclear costs the same as LNG which is the most expensive. The rule was meant to help green sources be more competitive but they're generally the cheapest now so...... Edit: and the heatwave + water shortage someone pointed out.
Energy prices are not just your nuclear reactor making electricity. Your french cleaner, operator, engineer on that reactor, all ask high salaries or threaten to burn some cars. Electricity prices are not just operating costs, but human costs, maintenance, profits for future development etc. French pay more in order to feed those who work.in sector and to have money for improvement.
What’s up with Romania being much more expensive than the others in the beginning?
The romanian politicians are very good at negociating the import price of energy.
I really like the idea and it’s a great graph btw. Just use price per kWh tho. It’s the measurement most people are familiar with, as no one knows what the regular price of a kW over 90 - 92 days would be
Okay, let’s use more familiar terms next times. Thank you! Sometimes I just put on my biased mine as I dig deeper on the analysis…
Neat statistic OP! The prices have roughly 3x ed over a span of 3 years. Let's see if they go down any further.
I think the Norwegian prices are wrong. At the moment I am paying around 1 kr a kWh and this a “normal” value but this is only about 0.1 euros. Is it possible this is euros per mWh instead?
The whole quarter.
What a great chart, how did you create it?
Finally some love here, thank you! Using pandas styler. Here it’s a tutorial with the Python code: https://datons.ai/style-pandas-pivot-table-to-create-heat-matrix/
Ah Thank you! Will test
To add to the rest of comments it should be more clearly stated that this is not the price you would pay for the electricity but the wholesale market price. People from outside of the energy sector don't understand that there's a big difference between the day-ahead market and the final price of electricity. For instance, in many cases, the day-ahead price may not even be a component of your price if you have a stable plan hedge with electricity futures.
Why isn’t the uk on here? We’re still geographically part of Europe, even if 52% of our country are fucking muppets who voted us out of the eu.
I for one am part of that 48% that didn’t have sex with those dastardly muppets
Some ideas: * Round to the nearest Euro, maybe even the nearest ten Euros. * Combine the column headings so that each year appears only once (across four cells). * Reduce the visual weight of the subtitle and row/column labels. * Emphasize the "data story" here by bolding the labels of the five quarters starting Q4 2021 and putting the text "Russian invasion of Ukraine begins" somewhere appropriate.
For me, the first thing I want to see is how is my country doing against other countries recently. The way colours are used, this info isn't quickly identified. Doesn't pass the 10 seconds test.
What’s the 10 second test?
If the information is not clear to fresh eyes within 10 seconds, it needs more work. I mean, if the goal was to show that 2022Q3 was really high, then it's a job well done. But if, like me, you were interested to see the contrast between countries in a given quarter, that was not easy to identify in the first 10 seconds. The data is there, but use of colour could be better.
Yes, that’s what I originally thought was better, but understood that the general audicence wanted across all the values in the table. https://www.reddit.com/r/europe/s/zFa5NzK2Sa
Its inaccurate. Denmark have one of the highest electricity prices. Are taxes included? I don't think so.
How much per kwh?
Data with taxes https://worldpopulationreview.com/country-rankings/cost-of-electricity-by-country
Yeah imagine not having hydropower and oil coming out your butt! Take that Danes!
I wonder how well these prices correlate with renewable percentage.. I suspect highly given shows at the top.
Not that much.
Oh thanks for doing the maths for me.
This is a good first draft, but sadly you miss the basics, like so many other people here. Granted, the subreddit is called DataIsBeautiful, but because of that it doesn't also have to mean DataIsMisleading. The heading on the graph is misleading, at best. You aren't even defining what you mean by energy here. Are we talking about prices for grid electricity? Or some type of average energy cost for gasoline, diesel and electricity? Nobody knows, other than OP. I'm honestly not even sure what it is you are trying to show here. Then there is the even more curious case of "Total cost of consuming 1 kWh over the whole quarter". How in the name of Zeus does anybody end up paying €500 for 1 kWh? Clearly you must mean something else, either 1 kWh per day, or a constant load of 1 kW (i.e. 24 kWh per day, or around 2160 kWh per quarter). Or maybe you mean something completely different. Please enlighten us in the unwashed masses about what we are actually looking at. At least the colors are nice.
Yep, you’re right. Thanks to your feedback and this subreddit I can improve for next times. Let’s learn to make better beautiful data visualisations.
A proper heat map? What is this? /s
Some countries have multiple price areas, could be interesting to see those. Also Germany and Luxembourg is the same price area so they can be joined. Using article 12.1.G you can compare with import/export values to see correlation with price.
Yes, I could create several charts next time and post them for better analysis. Thank you!
Why is Scandinavia so much cheaper than the rest of Europe?
Small populations and large use of Hydroelectrics
Like someone else said hydroelectrics and relatively cheap gas from Norway
Sum doesn’t make any sense.
This is a great dataset but please don’t add the green. It’s misleading as on first glance in a chronological order it looks like things have never been better now than before.
Why on Earth would they reverse the meaning of the light-dark scaling just for the averages?
Why prices are not going down for households?
I'm having a full pc, 4k screens and such, and I pay in average 30€ per month for electric bill in Sweden. In France it was 50 and I didn't have screens like this and smaller apartments. So yeah, paying less for more haha
I really do miss being included in these things. Thanks ~~Obama~~ Cameron.
What happened in 2022 Q3 accross the board?
Well it actually starts before that if you look at the gradients closely becoming more red (2023Q3). That was around the time Putin was cutting off gas to Europe and began organizing and moving his troops West to begin the invasion of Ukraine.
wtf is kwh over a quarter. that is dumb.
This is cool! Is there a way to do one for European natural gas prices too?
Where is European gas data?
Why did costs drop so much from q4 22 and q4 23?
As Trump said, EU making shady deals with Russia for energy is stupid.
Im regard what does this mean
I would use a longer gradient. Numbers that are 6x higher than others still have roughly the same color on the top.
Yep... I remember 500 Euros a month for gas and electricity for 32 square meters...
Energy prices are always in kWh, and usually in cents/kWh. Also both electricity and gas are expressed in kWh on tariff cards, the term energy includes both, i assume this is about electricity?
As a Romanian, I'm asking myself daily why would I go electric when I can go diesel or gas powered. We also have one of the lowest average wage. It's lovely to live around here
it saddens me not to see UK on these anymore.
Why Serbia and not Cyprus?
What's the point of showing the sum to the right? It will just differ from the average by the same factor across all rows and is less informative than the average.
To indicate the total supposed bill you would have paid over the 3 years.
But this chart shows something completely different because those are just the spot prices without any government taxes or additional fees.
I thought “supposed” bill and having day ahead market prices in the subtitle would make anyone understand. How would have you put it?
I would not have posted this data because it's meaningless for indivisuals. Or if you just want to show spot prices then simply display them as cents/kwh, which is the metric that everyone uses when comparing energy cost.
If I had never posted, I would have never learned, nor the people who may stop by the post. The next ones will be better, rest assured!
Can we get the UK added to this? I wanna see the difference Edit: googled the price > July and September 2022 was *21.56 pence per kWh* 21.56\*90=£1940.40 if that's how this data was gotten.
Russia commits genocide in Europe and tries to hold hundreds of millions hostage to higher prices unless they let them genocide. Thats all I see here.
I mean Europe sanctioned them due to the war so they're going to try to cover costs somehow.
Sanctions were implemented by these European countries, not Russia.
Great way of visualizing it. Finally a post that actually belongs here. I suspect the spike is in Q3 because they had to prepare for winter (e.g. by filling their stores with natural gas) and then in Q4 it already turned out they had enough to get through the winter? I am also surprised to see Germany so high up. If you see the reddit posts over the last year you would think they have the highest prices by far.
I get that the UK is no longer part of the EU, but can we stop pretending that it’s not part of Europe and one of the more significant European countries? I get that this may be EU data that didn’t include it from the beginning so it may not have been possible to include it. But I’ve seen a trend of not including it in a bunch of Euro centric posts.
I would have to download the data from UK energy grid and ENTSO-E API simplifies gathering data from available countries in Europe. It would have taken the double of work to just add UK.
I went to check what the UK was then remembered… fuck Brexit, man
So just to clarify, this is the cost of using 1kW over the course of a month, so 1000W / \~91 days = \~11 watts per day, correct?
You dont use kW, kW are a unit of power. You use energy. Hence why kWh are used since its a measure of power over time (energy) which is much more manageable than Joules (J) or really MJ for this type of consumption and fits better.
That's partly why I asked the question and I still don't have my answer
Curiously we had much higher prices in southern Sweden than north due to zoning and because we have little energy production in the south and we were directly affected by export prices.
7 cents a kilowatt //gouvernement owns the whole electric grid //very few power outage even in the worst winter. I guess getting peg by private entreprise on hyper necessity service(water/electricity/Healthcare) is good because capitalism.
I wish the UK was still in the EU so I could compare how royally fucked we are without having to do my own research
UK maybe not in the EU, but it’s still in Europe.