Find duplicate of first xx entries and average associated values

3 次查看（过去 30 天）
Minh Phuong Truong
评论： Minh Phuong Truong 2022-7-7
Hi all,
I have 140000x3 array data (time, lat, lon). The time column looks like [2019/12/18 上午 07:53:00]. I would like to get the mean lon and lat of several points in the same minute, like [2019/12/18 上午 07:53].
Thanks
  5 个评论
显示 3更早的评论
Chris Burschyk
Chris Burschyk 2022-7-7
You could load the data into a timetable and then use something like
T = readtimetable("YourFile.csv");
YourYear = 2019;
YourMonth = 1;
YourDay = 8;
YourHour = 8;
YourMin = 41:
mean(T{T.SYSTEMTIME.Year == YourYear & T.SYSTEMTIME.Month == YourMonth & T.SYSTEMTIME.Day == YourDay & T.SYSTEMTIME.Hour == YourHour & T.SYSTEMTIME.Minute == YourMinute, "LONGITUDE" })
Maybe not the prettiest way to do, but you could use it with a loop as well.

请先登录，再进行评论。

请先登录，再回答此问题。

回答（1 个）

KSSV
KSSV 2022-7-7
Read the file into MATLAB using readtable.
See to it that your dates i.e. thirs column is in datetime class. For this read about datetime, datestr, datenum.
Find the duplicates using unique. By using the indices you can get the required mean.

类别

在 Help Center 和 File Exchange 中查找有关 Dates and Time 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by