remove table header row

411 ビュー (過去 30 日間)
Charles
Charles 2019 年 5 月 1 日
コメント済み: dpb 2019 年 5 月 2 日
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

採用された回答

dpb
dpb 2019 年 5 月 1 日
編集済み: dpb 2019 年 5 月 1 日
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 件のコメント
dpb
dpb 2019 年 5 月 2 日
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