How can i convert a Time series data from table to cell array ?

35 ビュー (過去 30 日間)
israt fatema
israt fatema 2019 年 10 月 17 日
回答済み: Ganesh Regoti 2019 年 10 月 22 日
I have a dataset as .csv like
Date Value
8/10/2019 11:50 1642
8/10/2019 11:55 1621
I want to use the https://au.mathworks.com/help/deeplearning/examples/time-series-forecasting-using-deep-learning.html Time Series Forecasting Using Deep Learning (LSTM) with my data set. I tried to read the table first then convert the table to cell C = table2cell(T) to match the example
data = chickenpox_dataset;
data = [data{:}];
but it didn't match. As you can see, my dataset contains time series, with time steps corresponding to Date (and time) and values corresponding to some number. How to conver this table of 2 X 100 (0r more) as a cell array, where each element is a single time step and Reshape the data to be a row vector to match the exaple? Like row 1 contains the Date and time and row 2 contains value of each date and time, so that i can experiemnt the example?
  2 件のコメント
Ganesh Regoti
Ganesh Regoti 2019 年 10 月 21 日
Hi Israt,
Could send a small snippet of data that would help in gaining more insight on the issue?
Stephen23
Stephen23 2019 年 10 月 21 日
israt fatema's "Answer" moved here:

サインインしてコメントする。

採用された回答

Ganesh Regoti
Ganesh Regoti 2019 年 10 月 22 日
Hi Stephen,
The model which you have specified is expecting an array of numeric data. I presume that you have converted the table data to cell format but not cell to array format. Here is the code snippet that could help you solve the issue
T = readtable('test.csv');
C = table2cell(T);
C = C';
Data = [C{2,:}];
Hope this helps!

その他の回答 (0 件)

カテゴリ

Help Center および File ExchangeTables についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by