remove the first header

95 vues (au cours des 30 derniers jours)
SYML2nd
SYML2nd le 6 Août 2019
Modifié(e) : Jyotsna Talluri le 11 Août 2019
Hi
I have this csv file. As you can see in the png file the first header is useless for me. I want to import a table and then remove the first row, I want to use as headerline the second row (the one that have "Time, w-vel_1, v-vel_1, u-vel_1, w-vel_1.25").
I tried to do that using the command readtable, but once I use this command it considers the first row as headerline and I don't know how to remove it and use as headerline "Time, w-vel_1, v-vel_1, u-vel_1, w-vel_1.25"
Thank you in advance

Réponses (1)

Jyotsna Talluri
Jyotsna Talluri le 11 Août 2019
Modifié(e) : Jyotsna Talluri le 11 Août 2019
Hi,
Variables w-vel_1, v-vel_1, u-vel_1, w-vel_1.25 are not valid variable names as these include ‘-’,’.’ characters. So change your header variable names.
% reading csv file to a table without header
m=readtable('questionmatlabs.csv','ReadVariableNames',0);
t=m(2,:); %extracting the data of the second row
c=table2cell(t); %converting table to cellarray
c={'Time','w_vel_1','v_vel_1','uvel_1','w_vel_25'};
m.Properties.VariableNames=c; % setting the second row as header
m([1,2],:)=[]; % deleting first 2 rows of table

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!

Translated by