Skip to content

the LI6400 portable photosynthesis meter exports data as a series of poorly formatted .xls files. If you've used "add remark" to indicate sample ID, these are shown as rows, not a separate column. This script extracts relevant data, and moves the sample ID information from remarks into a column.

Notifications You must be signed in to change notification settings

Aariq/li6400-data-wrangling

Repository files navigation

li6400-data-wrangling

the LI6400 portable photosynthesis meter exports data as a series of poorly formatted .xls files. If you've used "add remark" to indicate sample ID, these are shown as rows, not a separate column. This script extracts relevant data, and moves the sample ID information from remarks into a column.

In this example, I've recorded photosynthesis measurements from several plots, several plants within a plot and three leaves per plant. For each leaf, I recorded three measurements. Each time I switched leaves, I added a remark that indicated plot with a letter, plant ID with a number, and leaf with "a", "b", or "c". The output is in multiple files since I had to unplug the LI6400 and move it between plots.

The .R file is an old version where I attempted to make a generic portable script that would work for everyone. I abandoned that idea since not everyone uses the remarks on the LI6400 the same way. Instead I've provided sample data and worked through it in the .Rmd file.

About

the LI6400 portable photosynthesis meter exports data as a series of poorly formatted .xls files. If you've used "add remark" to indicate sample ID, these are shown as rows, not a separate column. This script extracts relevant data, and moves the sample ID information from remarks into a column.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages