Group Abstract Group Abstract

Message Boards Message Boards

Forecasting with paneldata - ANN-Gaussian Process Model

Hello.I want to predict CO2 emission for a country. My data is for 28 province in 15 year.How can I import data in panel data structure in wolfram mathematica? I want with using this data, predictive Co2 emission became the average of this provinces and I have only one value for each year. because I want to use relative errors and other graphs to compare model.

Attachments:
Book1.xlsx
POSTED BY: elham shabani
2 Replies
Sort By:
POSTED BY: elham shabani
Rohit Namjoshi
Rohit Namjoshi
Posted 7 years ago

Hi Elham,

Not sure what you mean by "panel data". Maybe you mean Dataset? If so, this should get you started.

dataset = Import["~/Downloads/Book1.xlsx", {"Dataset", 1}, HeaderLines -> 1]

enter image description here

Group by year and compute mean of perco2.

meanCO2ByYear = dataset[GroupBy["year"], Mean, "perco2"]

enter image description here

Plot it

meanCO2ByYear // Normal // ListLinePlot

enter image description here
POSTED BY: Rohit Namjoshi
Reply to this discussion
Community posts can be styled and formatted using the Markdown syntax.
Tag limit exceeded
Note: Only the first five people you tag will receive an email notification; the other tagged names will appear as links to their profiles.
Reply Preview
Attachments
Remove
or Discard