'readtable' in 2023 version error （This issue did not occur in 2018）
Show older comments
Ele_intensity = readtable('electricity_consumption_carbon_intensity.csv');
Ele_intensity= Ele_intensity{1105:1152,2}; %Import data from row 1105 to 1152 ，column 2
Gas_intensity = readtable('gas_consumption_carbon_intensity.csv');
Gas_intensity= Gas_intensity{481:528,2}; %Import data from row 481 to 528 ，column 2
Ele_Quantity = readtable('electricity_consumption_quantity_price.csv');
Ele_Quantity= Ele_Quantity{1105:1152,2}; %Import data from row 1105 to 1152 ，column 2
Gas_Quantity = readtable('gas_consumption_quantity_price.csv');
Gas_Quantity= Gas_Quantity{481:528,2}; %Import data from row 481 to 528 ，column 2
The last four rows of code successfully import data from the csv document in both 2023b and 2018b，but the first four rows of code only import the right data in R2018b and in 2023b the array only has many 3. So I was wondering what was wrong with that，and is that code incompatible in two versions？
2 Comments
Dyuman Joshi
on 23 Mar 2024
How readtable() handles titles, headers etc might have changed from R2018b to R2023b.
You should check and compare the respective documentations to see what changes have been made.
Si
on 23 Mar 2024
Edited: Walter Roberson
on 23 Mar 2024
opts =
DelimitedTextImportOptions -
Delimiter: {'/'}
Whitespace: '\b\t '
LineEnding: {'\n' '\r' '\r\n'}
CommentStyle: {}
ConsecutiveDelimitersRule: 'split'
LeadingDelimitersRule: 'keep'
TrailingDelimitersRule: 'ignore'
EmptyLineRule: 'skip'
Encoding: 'UTF-8'
MissingRule: 'fill'
ImportErrorRule: 'fill'
ExtraColumnsRule: 'addvars'
VariableNames: {'Var1', 'Var2', 'Var3'}
VariableTypes: {'double', 'double', 'char'}
SelectedVariableNames: {'Var1', 'Var2', 'Var3'}
VariableOptions: 显示所有 3 VariableOptions
使用 setvaropts/getvaropts 访问 VariableOptions 子属性
VariableNamingRule: 'modify'
DataLines: [2 Inf]
VariableNamesLine: 0
RowNamesColumn: 0
VariableUnitsLine: 0
VariableDescriptionsLine: 0
This is the CSV document，and that shows the time in first column，and the data I need is in the second column
This is what matlab shows when import the whole document ，the ’carbon intensity‘column appear in the same column as time,and there are two additional columns that does not show up on the original csv file.Thank you for your reply
Accepted Answer
Star Strider
on 23 Mar 2024
0 votes
I do not understand ‘2023b the array only has many 3’, however I believe that the shortened table display in the last few releases is simply a display issue. The entire file is being imported correctly.
6 Comments
Si
on 23 Mar 2024
This is the CSV document，and that shows the time in first column，and the data I need is in the second column
This is what matlab shows when import the whole document ，the ’carbon intensity‘column appear in the same column as time,and there are two additional columns that does not show up on the original csv file.
Thank you for your reply
Star Strider
on 23 Mar 2024
It would be best for you to upload the file. Use the ‘paperclip’ button (just to the right of the Σ button) on the top toolstrip.
Si
on 23 Mar 2024
I changed the table names for convenience (making it easier to import them in a loop), otherwise your code is unchanged.
Try this —
% type('GroupNumber36_Carbon.m')
files = dir('*.csv');
for k = 1:numel(files)
filename = files(k).name
T{k,:} = readtable(filename, 'VariableNamingRule','preserve');
end
T{:}
% T{1}{:,1}.Format
% clear all
% clc
% Ele_intensity = readtable('electricity_consumption_carbon_intensity.csv');
Ele_intensity = T{1};
Ele_intensity= Ele_intensity{1105:1152,2};
% Gas_intensity = readtable('gas_consumption_carbon_intensity.csv');
Gas_intensity = T{3};
Gas_intensity= Gas_intensity{481:528,2};
% Ele_Quantity = readtable('electricity_consumption_quantity_price.csv');
Ele_Quantity = T{2};
Ele_Quantity= Ele_Quantity{1105:1152,2};
% Gas_Quantity = readtable('gas_consumption_quantity_price.csv');
Gas_Quantity = T{4};
Gas_Quantity= Gas_Quantity{481:528,2};%Import data on 24/03/2023
Total_gas_Demand=sum(Gas_Quantity);
Total_ele_Demand=sum(Ele_Quantity);
x = optimvar('x', 48, 1, 'Type', 'continuous', 'LowerBound', 0, 'UpperBound', 4);
y = optimvar('y', 48, 1, 'Type', 'continuous', 'LowerBound', 0, 'UpperBound', 1.3);
prob = optimproblem('ObjectiveSense', 'minimize');
prob.Objective = sum(Ele_intensity.* x)+sum(Gas_intensity.* y);
prob.Constraints.ele_constraint = sum(x) == sum(Total_ele_Demand);
prob.Constraints.gas_constraint = sum(y) == sum(Total_gas_Demand);
[sol,fval] = solve(prob);
% optimised_Ele_Quantity = getfield(sol,'x');
% optimised_Gas_Quantity = getfield(sol,'y');
optimised_Ele_Quantity = sol.x;
optimised_Gas_Quantity = sol.y;
optimised_emit_Ele=sum(Ele_intensity.*optimised_Ele_Quantity);
optimised_emit_Gas=sum(Gas_intensity.*optimised_Gas_Quantity);
Ele_Saving=sum(Ele_intensity.*Ele_Quantity)-optimised_emit_Ele;
Gas_Saving=sum(Gas_intensity.*Gas_Quantity)-optimised_emit_Gas;
fprintf('Optimised total emission: %f\n', fval);
fprintf('Ele emit : %f g\n',optimised_emit_Ele);
fprintf('Gas emit : %f g\n',optimised_emit_Gas);
fprintf('Ele saving : %f g\n',Ele_Saving);
fprintf('Gas saving : %f g\n',Gas_Saving);
non_optimised_total_emit=sum(Ele_intensity.*Ele_Quantity)+sum(Gas_intensity.*Gas_Quantity);
total_saving=non_optimised_total_emit-fval;
fprintf('total saving : %f g\n',total_saving);
This is working correctly in R2024a, however I believe R2023b would have produced the same relsult.
Are there problems?
.
Si
on 23 Mar 2024
Star Strider
on 23 Mar 2024
My pleasure!
If my Answer helped you solve your problem, please Accept it!
.
More Answers (0)
Categories
Find more on Web Services 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!
