Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

4
  • 1
    And for consecutively missing values? Commented Jan 26, 2022 at 17:31
  • @KamilMaciorowski Sorry. Good catch! When I got to the second part I changed it to a 9 to make the math cleaner and didn't update the original. fixed now. FWIW, I don't care if the "average" is an integer or floating. Commented Jan 26, 2022 at 17:52
  • 1
    @FelixJN I updated post to say consecutively missing values can search outward to the nearest valid data points. Also row count shouldn't go above 30 if that matters. These are traceroutes after all. Commented Jan 26, 2022 at 17:55
  • What should the output be if the first line has a * for the 2nd field? Commented Jan 26, 2022 at 20:36