Parse a Tecan Infinite 200 Pro plate reader file

tparse() reads data from a the Excel file produced by a Tecan Infinite 200 Pro plate reader. It automatically determines the type of measurement (single time point or time series, single or multiple reads per well) and will handle the data appropriately.

Usage

tparse(xlsx_file, xlsx_sheet = 1)

Arguments

xlsx_file

(character) path to Excel file

xlsx_sheet

(numeric) index of Excel sheet to read from (default: 1)

Value

A tibble::tibble() containing tidy data

Examples

tparse(
  system.file(
    "extdata",
    "time_series_multiple_reads.xlsx",
    package = "tread"
  )
)
#> ℹ Multiple reads per well detected
#> ℹ Time series detected
#> # A tibble: 120 × 10
#>    well   time  temp   mean st_dev   x1_2  x2_1   x1_1   x0_1   x1_0
#>    <chr> <dbl> <dbl>  <dbl>  <dbl>  <dbl> <dbl>  <dbl>  <dbl>  <dbl>
#>  1 A1        0  30.6 0.0959 0.0106 0.0897 0.113 0.0873 0.0902 0.0991
#>  2 A1      600  30.3 0.108  0.0207 0.0925 0.144 0.104  0.104  0.0963
#>  3 A1     1200  30.6 0.106  0.0171 0.0926 0.135 0.102  0.102  0.0961
#>  4 A1     1800  30.7 0.108  0.0193 0.0924 0.140 0.102  0.109  0.0953
#>  5 A1     2400  30.5 0.104  0.0181 0.0920 0.134 0.0908 0.105  0.0952
#>  6 A1     3000  30.5 0.103  0.0184 0.0917 0.134 0.0895 0.103  0.0947
#>  7 A1     3600  30.3 0.102  0.0187 0.0921 0.135 0.0892 0.101  0.0951
#>  8 A1     4200  30.4 0.101  0.0165 0.0919 0.130 0.0898 0.101  0.0941
#>  9 A1     4800  30.5 0.101  0.0174 0.0919 0.131 0.0893 0.0996 0.0933
#> 10 A1     5400  30.6 0.101  0.0170 0.0916 0.131 0.0887 0.0989 0.0943
#> # ℹ 110 more rows