using splitapply on a table to split a column with repeating rows

Hello, I'm using splitapply but cannot seem to solve the following where I have an initial table as follows but want the final table. Fin_year is categorical, Type is categorical, but Quantity and the resulting City_quantity and Rural_quantity are numeric. Notice the repeating year row values in the initial table.

 Akzeptierte Antwort

Star Strider
Star Strider am 12 Feb. 2021

0 Stimmen

See if the unstack function will do what you want.

4 Kommentare

I get this error message: Variable index exceeds table dimensions.
You will need to figure out what the problem is.
From the description in the documentation, it would appear to do what you want.
yes thanks, was missing the quation marks, it works now.
As always, my pleasure!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Graphics Objects finden Sie in Hilfe-Center und File Exchange

Produkte

Version

R2020b

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by