Reordering column so the values match an already reordered column

2 次查看（过去 30 天）
Moey Rojas
Moey Rojas 2020-5-27
评论： Star Strider 2020-5-27
Hi, I created a column of serial date numbers from three separate columns and then sorted the serial date numbers in ascending order to plot pCO2 according to serial date number.
DateNumber = datenum[yr, mon, day]
DateNumber2=sort(DateNumber)
scatter(DateNumber, fCO2)
I have a separate column of pH data (fCO2) that matches up with the non-sorted serial date numbers but not the sorted serial date numbers. Is there a way to sort the pH data so that the pH values match with the ascending serial date number values so I can bin the pH values according to month?

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

采纳的回答

Star Strider
Star Strider 2020-5-27
I am not certain what you want to do.
Note that the sort function has two outputs, the first being the sorted values and the second being the original indices of those values. One option is to use the second output as an index into the unsorted array.
Another option is to use the intersect function (with additional index outputs) to identify the matching dates in the ‘fCO2’ data with the ‘pH’ data. Then index them appropriately to get the result you want.
  3 个评论
显示 1更早的评论
Moey Rojas
Moey Rojas 2020-5-27
Great, thank you all so much. I didn't know what indexing was (VERY new to MATLAB), these answers helped a ton.
Star Strider
Star Strider 2020-5-27
Moey Rojas — As always, my pleasure!
Mohammad Sami — Thank you for providing an example.

请先登录，再进行评论。

更多回答（0 个）

类别

在 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