How to import Table and column header from two diffrent files?

5 vues (au cours des 30 derniers jours)
ali koulani
ali koulani le 21 Nov 2020
Commenté : dpb le 26 Nov 2020
hey guys i have a problem importing data from my .csv file and my headers from my .txt file
when i open my data.csv in excel i get them in a single column with a '','' delimiter between them.
my txt file contains my headers for data columns they are seprated with a ''|'' delimiter .
how can i import these into a single table which i can work with ?
i tried readtable or importdata but couldnt find the correct options
btw im using matlab online r2020b and im trying to do everything with program code to use as in my internship report

Réponse acceptée

dpb
dpb le 21 Nov 2020
W/o an example to confirm but from the description alone something like:
tData=readtable('thedatafile.csv');
hdrs=readcell('thehdeadersfile.txt');
tData.Properties.VariableNames=hdrs;
Which begs the question of why not create a single file containing column headings and data together to begin with?
  2 commentaires
ali koulani
ali koulani le 21 Nov 2020
Modifié(e) : ali koulani le 26 Nov 2020
thanks i think this is the correct answer, i will try it tommorow aand post an update
edit:
data=readtable('DFL_stat_20_09_23.csv');
hdrs=["UEin","std_UEin","Un","std_Un","Us","std_Us","Ur","std_Ur"];%vektor of my headlines
data.Properties.VariableNames=hdrs;
i still dont know why the readcell funktion didnt work to read the headlines from the text file
this is the text file
UEin | std_UEIN | Un | std_Un | Us | std_Us |Ur | std_Ur
dpb
dpb le 26 Nov 2020
Would have to see the code and the actual file to know...although the code and error in context might point to the cause. In general, we can't diagnose what we can't see.

Connectez-vous pour commenter.

Plus de réponses (0)

Produits


Version

R12.1

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by