I need help plotting data from a file
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Kenzie
le 31 Jan 2024
Réponse apportée : Walter Roberson
le 1 Fév 2024
I am trying to write a code to plot the data from the mauna loa observatory, and after having previous trouble of matlab not being able to find my file, I am now getting an error on line 7 saying "Error using .
The VariableNames property must contain one name for each variable in the table."
here is my code:
% Load the data
filename = 'maunaloa_weekly.csv';
data = readtable(filename, 'ReadVariableNames', false, 'Delimiter', ',');
variableNames = {'Date', 'Values'};
% Assign variable names to the table
data.Properties.VariableNames = variableNames;
% Convert the dates to datetime format
dates = datetime(data.Date, 'Format', 'dd/MM/yyyy');
Values = data.Values;
% Create a time vector using datetime
time_vector = dates;
% Plot the data
figure;
subplot(2, 1, 1);
plot(dates, Values, 'LineWidth', 2);
title('Maunaloa Weekly Data');
xlabel('Time');
ylabel('Floating Point Values');
if i were to run this code now, there would be an error showing that they can find the file, but thats not the problem I am working on now.
0 commentaires
Réponse acceptée
Cris LaPierre
le 31 Jan 2024
Your table must have more variable names than just those you are renaming. Try this.
data.Properties.VariableNames(1:2) = variableNames;
Plus de réponses (1)
Walter Roberson
le 1 Fév 2024
The table you are reading has some number of variables that is different than 2.
There are ways to specify the range that you want to read in, or which columns of the table you want to read. For example
opts = detectImportOptions(filename, 'ReadVariableNames', false, 'Delimiter', ',');
opts.SelectedVariableNames = {'Var1', 'Var3'};
data = readtable(filename, opts);
variableNames = {'Date', 'Values'};
% Assign variable names to the table
data.Properties.VariableNames = variableNames;
If you wanted to select the first and third columns.
0 commentaires
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!