Renaming Variable Names in Table Matlab
Show older comments
Hi All,
I have been trying to rename the variable names to a table. I've been folowing the tutorials and indications given in the Mathworks website but I keep getting the following error message: Scalar structure required for this assignment.
I appreciate any kind of help you can give me.
My code is the following:
Compendium_2019 = table2struct(readtable("2019_Annual_Disability_Statistics_Compendium_ALL.csv", "PreserveVariableNames", true));
tot_population = Compendium_2019(2:54);
tot_population = rmfield(tot_population, {'Var6', 'Var7_1','Var8_1','Var9_1'});
% Things that I have tried and lead to the same error message:
tot_population.Properties.VariableNames{'Table 1.1 Resident Population - States: 2015 to 2018'} = {'State'};
tot_population.Properties.VariableNames([1:5]) = {'State','2015','2016','2017','2018'};
3 Comments
Star Strider
on 6 Dec 2020
Edited: Star Strider
on 6 Dec 2020
I suspect that since you’re converting it from a table to a structure, the table operations are not appropriate to the structure. Perhaps converting to a structure after changing the variable names would work.
Natalia Feced Garcia
on 6 Dec 2020
Star Strider
on 6 Dec 2020
My pleasure!
Answers (0)
Categories
Find more on Large Files and Big Data in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!