from mikeio import Dfs0
dfs0 = Dfs0("../tests/testdata/eq_relative.dfs0")
dfs0
<mikeio.Dfs0> Timeaxis: TimeAxisType.EquidistantRelative Items: 0: Item 1 <Undefined> (undefined) 1: Item 2 <Undefined> (undefined) 2: Item 3 <Undefined> (undefined) 3: Item 4 <Undefined> (undefined) 4: Item 5 <Undefined> (undefined)
ds = dfs0.read()
ds
<mikeio.Dataset> Dimensions: (504,) Time: 1970-01-01 00:00:00 - 1970-01-01 00:00:56.236909 Items: 0: Item 1 <Undefined> (undefined) 1: Item 2 <Undefined> (undefined) 2: Item 3 <Undefined> (undefined) 3: Item 4 <Undefined> (undefined) 4: Item 5 <Undefined> (undefined)
df = ds.to_dataframe()
df.head()
Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | |
---|---|---|---|---|---|
1970-01-01 00:00:00.000000 | -0.006862 | -0.000611 | 0.177047 | 32.484425 | -304.720428 |
1970-01-01 00:00:00.111803 | -0.011746 | -0.000611 | 0.189257 | 32.292774 | -308.553406 |
1970-01-01 00:00:00.223606 | -0.006862 | -0.000611 | 0.189257 | 32.292774 | -308.553406 |
1970-01-01 00:00:00.335409 | -0.001978 | 0.004273 | 0.189257 | 32.292774 | -300.887482 |
1970-01-01 00:00:00.447212 | 0.002906 | 0.009157 | 0.177047 | 32.292774 | -300.887482 |
Correcing the dataframe index by subtracting start time to get relative time axis.
df.index = (df.index - df.index[0]).total_seconds()
df.head()
Item 1 | Item 2 | Item 3 | Item 4 | Item 5 | |
---|---|---|---|---|---|
0.000000 | -0.006862 | -0.000611 | 0.177047 | 32.484425 | -304.720428 |
0.111803 | -0.011746 | -0.000611 | 0.189257 | 32.292774 | -308.553406 |
0.223606 | -0.006862 | -0.000611 | 0.189257 | 32.292774 | -308.553406 |
0.335409 | -0.001978 | 0.004273 | 0.189257 | 32.292774 | -300.887482 |
0.447212 | 0.002906 | 0.009157 | 0.177047 | 32.292774 | -300.887482 |
df['Item 5'].plot()
<AxesSubplot:>