Info

此问题已关闭。请重新打开它进行编辑或回答。

Load csv with date-time column and other colums with numbers and changing date-time to number.

1 次查看（过去 30 天）

显示更早的评论

Eclip7e 2017-11-21

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/368419-load-csv-with-date-time-column-and-other-colums-with-numbers-and-changing-date-time-to-number

关闭： MATLAB Answer Bot 2021-8-20

Hello, I have csv file of stock data that has around 5000 rows and looks like this:

timestamp,open,high,low,close,volume 2017-11-03,5.7000,5.9400,5.6300,5.7500,822395 2017-11-02,5.6100,5.8100,5.5500,5.7800,1120941 2017-11-01,5.4600,5.6300,5.4400,5.6200,717112

Now I would like to load it into matrix, but timestamps i would like to change to some number and then i would like to be able to easily transform this number back to timestamp.

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

此问题已关闭。

回答（1 个）

KL 2017-11-21

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/368419-load-csv-with-date-time-column-and-other-colums-with-numbers-and-changing-date-time-to-number#answer_292391

编辑：KL 2017-11-21

在 MATLAB Online 中打开

If you have 2013b or later use readtable,

https://www.mathworks.com/help/matlab/ref/readtable.html

data = readtable('filename.csv');

your first column will have datetime format by default (if your data is properly formatted), you can modify a specific row by

data.timestamp(your_row) = some other date here

then you use writetable if you want to export the updated data to csv

https://www.mathworks.com/help/matlab/ref/writetable.html

writetable(data,'filename.csv');

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

此问题已关闭。

标签

Community Treasure Hunt

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

Translated by