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

Question

ali koulani 2020-11-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/655893-how-to-import-table-and-column-header-from-two-diffrent-files

评论： dpb 2020-11-26

采纳的回答： dpb

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

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

dpb 2020-11-21

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/655893-how-to-import-table-and-column-header-from-two-diffrent-files#answer_551718

在 MATLAB Online 中打开

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 个评论
显示无隐藏无

ali koulani 2020-11-21

编辑：ali koulani 2020-11-26

在 MATLAB Online 中打开

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

dpb 2020-11-26

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.

请先登录，再进行评论。