-
Notifications
You must be signed in to change notification settings - Fork 0
Tutorial 01
Here is a tutorial outlining the workflow from data import to defining and applying interpolation.
The data originate from the Ocean Drilling Program (ODP).
-- Prepared by Elisabeth Michel (LSCE)
- At the first stage, we import the series from a spreadsheet.
flowchart LR
A["Import data ODP849, ODP846, Age Probstack scale as series"]
- In this stage, we interpolate series from ODP846 to the horizontal axis of series from ODP849. With PyAnalySeries, multiple series can be interpolated simultaneously, allowing switching between δ13C and δ18O from ODP846, and δ13C and δ18O from ODP849, to define the most consistent interpolation relative to the reference. When defining pointers, i.e. the connections between series, it is preferable in our case to consider transitions rather than individual data points. Once the interpolation is defined, it can be applied to all series of interest that have not yet been interpolated. At the end of this stage, δ13C and δ18O from ODP‑846 should be interpolated onto the horizontal axis of the ODP‑849 series.
flowchart LR
B["Define Interpolation from depth ODP846 to depth ODP849"] --> C["Apply defined Interpolation to depth ODP846 series"]
- Next, we define an interpolation from the depth axis of ODP‑849 to the Probstack age model. Then we apply that interpolation to all series using the ODP‑849 depth axis.
flowchart LR
D["Define Interpolation from depth ODP849 to Age Probstack scale"] --> E["Apply defined Interpolation to all depth ODP849 series and ODP846 interpolated series to ODP849"]
Let us detail each step below.
-
Open the file
tutorial_01/data_DP849_DP846.xlsxusing a spreadsheet application. -
Launch PyAnalySeries and open the Create / Import Data menu.
-
In the spreadsheet, select the range of cells to copy. Be sure to include the column headers.
UseCtrl + Shift + ↓to select all rows, then copy the selection withCtrl + C.

-
In the Import Data window of PyAnalySeries, paste the content from the clipboard using
Ctrl + V.

-
Click on Import series.
-
The first 3 series are now successfully imported into PyAnalySeries.

-
Rename the worksheet as your convenience. Here:
myWS.xlsx -
Repeat this process for the other measurements using the X, Y1, Y2 format, ensuring the corresponding columns are selected.
No need to erase the Import Data window; just paste the new clipboard content usingCtrl + V.


-
You should now have all the series to continue your work.

-
Save the worksheet using
Ctrl + S
-
Explore the different display modes: Display Single, Display Together, and Display Stacked

-
Learn how to pan and zoom on a plot, both horizontally and vertically. Learn how to reset axis ranges or the entire view.
Here is a summary of interactions:Interaction Area Action / Shortcut Zoom Axis & Plot Mouse scroll (up/down) Pan Axis & Plot Click + drag Reset view (auto range) Axis & Plot Press A -
Refer to the
Statstab when displaying a series

-
Change colors and orientation as needed.
-
Add units or rename axes if needed by clicking in the corresponding column (Name, X, Y).
Select all series that are appropriate for defining the interpolation. The order of the selected series will determine the order of display in the combo box.

Here pointers defined with δ18O from ODP849 and ODP846.

Then switch to δ13C from ODP849 and ODP846.

You can save the interpolation and apply it to the currently selected disordered series. This may result in duplicated interpolation items, which can be removed with Ctrl+X.
You can also apply an interpolation that has already been saved. Simply select the series you want to interpolate and apply the chosen interpolation.

At this stage, you should have δ13C and δ18O from ODP846 interpolated to the horizontal axis of ODP849 series.

Select all series with a depth ODP849 axis and the serie δ18O with the Age Probstack scale, and define pointers.

Apply the previously defined interpolation to δ18O series with a depth ODP849 axis.
You should have items as in the following capture.

You can download the final worksheet from here.