Create a panel dataset

12 views (last 30 days)
Mario Diaco
Mario Diaco on 26 May 2020
Commented: Mario Diaco on 29 May 2020
Hi!
I've to construct a panel dataset. I've to combine 2 object, where the first one of these is a table ("fund") contain the dates and the countries names, in this way:
the second object ("observation") is a cell array where the rows are the dates and the columns are the countreies names, but any cell of the array contains multiple data relative to a specific country and specific data. I've to match this data with the data in the first object

Accepted Answer

Nishant Gupta
Nishant Gupta on 29 May 2020
First convert the second object ("observation") which is a cell array into a table using 'cell2table' function.
Then, combine the two tables according to the key variable using 'join' function.
  1 Comment
Mario Diaco
Mario Diaco on 29 May 2020
thank I followed your indication! But, can I specify the "country" as a keyword too?

Sign in to comment.

More Answers (0)

Categories

Find more on Tables in Help Center and File Exchange

Products


Release

R2020a

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!