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

6 visualizaciones (últimos 30 días)
ali koulani
ali koulani el 21 de Nov. de 2020
Comentada: dpb el 26 de Nov. de 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

Respuesta aceptada

dpb
dpb el 21 de Nov. de 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 comentarios
ali koulani
ali koulani el 21 de Nov. de 2020
Editada: ali koulani el 26 de Nov. de 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 el 26 de Nov. de 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.

Iniciar sesión para comentar.

Más respuestas (0)

Productos


Versión

R12.1

Community Treasure Hunt

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

Start Hunting!

Translated by