fillmissing function and obtaining replacement data from reference source

3 次查看(过去 30 天)
Hi
I have multiple timetables, each holds data of sensors.
At times sensors malfunction and produce false results. Therefore those samples or data are to NaN.
Is it possible to use fillmissing to obtain data from the other timetables?
For examples i have 8 sensors, i would then like ot use the mean data of the other 7 to replace when every data is NaN. Can this be possible?
It would need to obtain data from the closest timestamp(maybe few seconds to few mins apart)
Thanks

采纳的回答

Himanshu
Himanshu 2023-8-29
Hello Dharmesh,
I understand that you are trying to replace NaN values in your sensor data using the mean data from other sensors when the data is NaN at a timestamp.
You can follow the below steps:
  1. Initially, you can combine sensor data into a single "timetable" using the "synchronize" function.
  2. Next, you can identify timestamps with all NaN values, calculate means, and replace the NaNs using "all" and "ismissing" functions.
  3. You can perform time-based interpolation for remaining NaN values using the "fillmissing" function.
You can refer to the below documentation to learn more about the "timetable", "synchronize", and "fillmissing" functions in MATLAB.

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Data Preprocessing 的更多信息

产品


版本

R2022b

Community Treasure Hunt

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

Start Hunting!

Translated by