MATLAB Answers

remove table header row

조회 수: 383(최근 30일)
Charles
Charles 1 May 2019
댓글: dpb 2 May 2019
I have the attached table which I wish to
1) Remove the header row.
2) duplicate the second column and append to end, making a third column
3) convert resulting n x 3 structure to a text file.
I have tried converting the table to an array, and then duplicating the second column and appending it to the end making a gthord coliumn, without much luck
Any help greatly appreciated

  댓글 수: 0

댓글을 달려면 로그인하십시오.

채택된 답변

dpb
dpb 1 May 2019
편집: dpb 1 May 2019
Should show your work when you've tried something that seems like should but doesn't...it's really quite a straightforward task--tables really do simplify a lot of machinations, particularly when have differing data types as here, for example, between datetime and double.
tst=AUDCAD1d(1:10,:); % again, only a little is as good as a whole lot...
tst.New=tst.Open; % make a new column with content of second
writetable(tst,'AUD.csv','WriteVariableNames',0) % write a csv file without header...
See what we gots...
>> type AUD.csv
20190501095950 ,0.94472,0.94472
20190501095955 ,0.94473,0.94473
20190501100000 ,0.9447,0.9447
20190501100005 ,0.94471,0.94471
20190501100010 ,0.94473,0.94473
20190501100015 ,0.94471,0.94471
20190501100020 ,0.9447,0.9447
20190501100025 ,0.94475,0.94475
20190501100030 ,0.94474,0.94474
20190501100035 ,0.94476,0.94476
>>
looks to satisfy requirements to me... :)
Excepting looks like there's an extra space on the time data...hmmm, let's see---
>> tst.Var1.Format
ans =
'yyyyMMddHHmmss '
>>
and indeed, there is. Might want to clean that up altho it may not hurt depending on the use of the file.

  댓글 수: 5

표시 이전 댓글 수: 2
dpb
dpb 2 May 2019
All it would take is to go back to where you created the variable and get the output format string correct there...do it right the first time instead of having to clean up later.
Charles
Charles 2 May 2019
Done. Thank you
dpb
dpb 2 May 2019
Glad to help... :)

댓글을 달려면 로그인하십시오.

추가 답변(0개)

태그

제품

Community Treasure Hunt

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

Start Hunting!

Translated by