glidertools.utils.merge_dimensions¶
-
glidertools.utils.
merge_dimensions
(df1, df2, interp_lim=3)¶ Merges variables measured at different time intervals. Glider data may be sampled at different time intervals, as is the case for primary CTD and SciCon data.
Parameters: - df1 (pandas.DataFrame) – A dataframe indexed by datetime64 sampling times. Can have multiple columns. The index of this first dataframe will be preserved.
- df2 (pandas.DataFrame) – A dataframe indexed by datetime64 sampling times. Can have multiple columns. This second dataframe will be interpolated linearly onto the first dataframe.
Returns: merged_df – The combined arrays interpolated onto the index of the first axis
Return type: pandas.DataFrame
Raises: Userwarning
– If either one of the indicies are not datetime64 dtypesExample
You can use the following code and alter it if you want more control
>>> df = pd.concat([df1, df2], sort=True, join='outer') # doctest: +SKIP >>> df = (df .sort_index() .interpolate(limit=interp_lim) .bfill(limit=interp_lim) .loc[df1.index] )