Skip to contents

tidy_plate() reads a microwell plate shaped csv or excel file and returns a tibble for downstream data analysis. In order to create an template file use the build_plate() function.

Usage

tidy_plate(file, well_id = "well", sheet = 1)

Arguments

file

A character string containing the path to a csv or excel file. The format is described below.

well_id

A character string that will be the name for the well id column.

sheet

A character or integer indicating the excel sheet to be read.

Value

A tibble.

Examples

file_path <- system.file("extdata", "example_12_well.xlsx",
  package = "tidyplate"
)

data_12 <- tidy_plate(file = file_path)
#> Plate type: 12-well

head(data_12)
#> # A tibble: 6 × 4
#>   well  drug      cell_line percent_survived
#>   <chr> <chr>     <chr>                <int>
#> 1 A01   Neomycin  HEK293                  60
#> 2 A02   Puromycin HEK293                  NA
#> 3 A03   Neomycin  Hela                    52
#> 4 A04   Puromycin Hela                    18
#> 5 B01   Neomycin  HEK293                  62
#> 6 B02   Puromycin HEK293                  23