Hi folks,

I’m trying to use the readtable function to interpret a spreadsheet "Alberta.csv". I’ve tried using detectImportOpts, sadly the variables are arranged in rows and readtable seems to want to detect them as columns.
The next attempt was as follows:
seriesAL = table2dataset(rows2vars(readtable("Alberta.csv", ReadRowNames=1, MissingRule="omitrow")));
or
seriesAL = table2array(rows2vars(readtable("Alberta.csv", ReadRowNames=1, MissingRule="omitrow")));

then if I try to complete an operation:
rgdp_AL = log(0.001 .* seriesAL{:,40})
Matlab tells me I’m using too many input arguments… If I enter:
seriesAL(:,40), I’m failing to get numbers, yet seriesAL{} doesn’t want to provide the full column of values!

I’m getting very confused by the way Matlab uses tables, cells, structs, etc… Can anyone help me get numbers?Hi folks,

I’m trying to use the readtable function to interpret a spreadsheet "Alberta.csv". I’ve tried using detectImportOpts, sadly the variables are arranged in rows and readtable seems to want to detect them as columns.
The next attempt was as follows:
seriesAL = table2dataset(rows2vars(readtable("Alberta.csv", ReadRowNames=1, MissingRule="omitrow")));
or
seriesAL = table2array(rows2vars(readtable("Alberta.csv", ReadRowNames=1, MissingRule="omitrow")));

then if I try to complete an operation:
rgdp_AL = log(0.001 .* seriesAL{:,40})
Matlab tells me I’m using too many input arguments… If I enter:
seriesAL(:,40), I’m failing to get numbers, yet seriesAL{} doesn’t want to provide the full column of values!

I’m getting very confused by the way Matlab uses tables, cells, structs, etc… Can anyone help me get numbers? Hi folks,

I’m trying to use the readtable function to interpret a spreadsheet "Alberta.csv". I’ve tried using detectImportOpts, sadly the variables are arranged in rows and readtable seems to want to detect them as columns.
The next attempt was as follows:
seriesAL = table2dataset(rows2vars(readtable("Alberta.csv", ReadRowNames=1, MissingRule="omitrow")));
or
seriesAL = table2array(rows2vars(readtable("Alberta.csv", ReadRowNames=1, MissingRule="omitrow")));

then if I try to complete an operation:
rgdp_AL = log(0.001 .* seriesAL{:,40})
Matlab tells me I’m using too many input arguments… If I enter:
seriesAL(:,40), I’m failing to get numbers, yet seriesAL{} doesn’t want to provide the full column of values!

I’m getting very confused by the way Matlab uses tables, cells, structs, etc… Can anyone help me get numbers? readtable, struct MATLAB Answers — New Questions

​