https://source.geography.bristol.ac.uk/mediawiki/index.php?action=history&feed=atom&title=Data_formatting_and_preprocessing 2026-04-04T18:22:34Z Revision history for this page on the wiki MediaWiki 1.35.8 https://source.geography.bristol.ac.uk/mediawiki/index.php?title=Data_formatting_and_preprocessing&diff=5296&oldid=prev 2008-06-04T13:34:02Z

<p></p> <table class="diff diff-contentalign-left diff-editfont-monospace" data-mw="interface"> <col class="diff-marker" /> <col class="diff-content" /> <col class="diff-marker" /> <col class="diff-content" /> <tr class="diff-title" lang="en"> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">← Older revision</td> <td colspan="2" style="background-color: #fff; color: #202122; text-align: center;">Revision as of 13:34, 4 June 2008</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l6" >Line 6:</td> <td colspan="2" class="diff-lineno">Line 6:</td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Linear interpolation==</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>==Linear interpolation==</div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Remove (short) gaps in a timeseries by linear interpolation<del class="diffchange diffchange-inline">:</del></div></td><td class='diff-marker'>+</td><td style="color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>Remove (short) gaps in a timeseries by linear interpolation<ins class="diffchange diffchange-inline">. Make sure your last value is not an NA because then the while loop runs forever.</ins></div></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>     for(i in 1:length(timeseries)) {</div></td><td class='diff-marker'> </td><td style="background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;"><div>     for(i in 1:length(timeseries)) {</div></td></tr> </table>

Wbuytaert https://source.geography.bristol.ac.uk/mediawiki/index.php?title=Data_formatting_and_preprocessing&diff=5255&oldid=prev 2008-06-02T13:16:02Z

<p></p> <p><b>New page</b></p><div>[[Category:Projects]]<br /> [[Category:Hydrology in R]]<br /> <br /> These are quick and dirty scripts that often are not very efficient but do their job. <br /> <br /> ==Linear interpolation==<br /> <br /> Remove (short) gaps in a timeseries by linear interpolation:<br /> <br /> for(i in 1:length(timeseries)) {<br /> if(is.na(timeseries[i])) {<br /> j &lt;- 1<br /> while(is.na(timeseries[i+j])) j &lt;- j+1<br /> delta &lt;- (timeseries[i+j] - timeseries[i-1]) / (j+1)<br /> timeseries[i] &lt;- timeseries[i - 1] + delta<br /> }<br /> }</div>

Wbuytaert