Carbon allocation trade data (EEX)

rhubarbarosa·January 22, 2025

Description

The data from the EEX is cleaned and unified into three tables

Summary


  • A simple, yet thorough summary of what ETS is can be found here
  • A dashboard for all ETS data is found at the EEA website here
    • The underlying data for this dashboard is here
  • An absolutely confusing explanation of ETS is found here
  • The website for EEX is here
    • Links to the original datafiles is here

Cleaning and Unifying the data

The downloadable excel files are slightly different between years. The main differeneces are:

  • At one point the information about buyer is converted from a text format to multiple columns
  • There are a versions of the files that have "guest" columns - these columns were dropped
  • There is a change in what measures are reported in the data, sometimes statistics include values for variations in trade volume. The cleaning pivots this data to measure-value form ​

Basic info
Author
rhubarbarosa
Shared withEveryone
CreatedNovember 30, 2022
Size7 MB
LicensePublic Domain
Dictionary3 tables
Original URLGo to check
Publishedimage
public datasets
Advanced features
Insights
Based on the provided information of the dataset, would it be possible to provide some relevant inquiries?
What columns are included in the document?
How many rows does the document contain?

Carbon allocation trade data (EEX)

rhubarbarosa·January 22, 2025

Description

The data from the EEX is cleaned and unified into three tables

Summary


  • A simple, yet thorough summary of what ETS is can be found here
  • A dashboard for all ETS data is found at the EEA website here
    • The underlying data for this dashboard is here
  • An absolutely confusing explanation of ETS is found here
  • The website for EEX is here
    • Links to the original datafiles is here

Cleaning and Unifying the data

The downloadable excel files are slightly different between years. The main differeneces are:

  • At one point the information about buyer is converted from a text format to multiple columns
  • There are a versions of the files that have "guest" columns - these columns were dropped
  • There is a change in what measures are reported in the data, sometimes statistics include values for variations in trade volume. The cleaning pivots this data to measure-value form ​

Scan the QR code to ask more questions about the paper
© 2025 Powerdrill. All rights reserved.