Info

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

when i use fints, fints omits some of my data why?

1 次查看(过去 30 天)
i use data and date that both of them have 3700 rows. but when i use fints, fints has 3600 rows. it omits some of my data why?

回答(1 个)

Steven Lord
Steven Lord 2018-3-19
From the documentation for fints: "If there are duplicate dates and times, the fints constructor sorts the dates and times and chooses the first instance of the duplicate dates and times. The other duplicate dates and times are removed from the object along with their corresponding data." So I suspect you have 100 duplicate dates.
Consider storing your data in a timetable instead of a fints object as the warning at the top of that documentation page recommends. You can have duplicate time and date data in a timetable:
>> T = datetime('today');
>> v = [0; 1; 2; 0; 2; 3];
>> tt = timetable(T+v, v.^2)
>> unique(tt.Time) % only 4 unique times
>> height(tt) % 6 rows in the timetable
  2 个评论
pooria mazaheri
pooria mazaheri 2018-3-19
编辑:pooria mazaheri 2018-3-19
can i use 'merge' for 'timetable'? because i needed 'fints' in order to merge my data if i use timetable 'instead' of 'fints' can i merge my data?
Steven Lord
Steven Lord 2018-3-19
See the "Resample and Aggregate Data in Timetable" topic and its sub-topics on this documentation page. I believe the retime and synchronize functions will be of interest to you.

此问题已关闭。

Community Treasure Hunt

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

Start Hunting!

Translated by