Transforms a plate to a tidy dataframe

Usage

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

Arguments

file: This is the path to a xlsx or csv file containing data for the following types of plates: 6, 12, 24, 48, 96, 384, and 1536. The plate format is described below.
well_id: This is takes a character of length 1 and cannot be the same as individual plate names.
sheet: If file type is xlsx this is the sheet name (character) or number (integer).

Value

A tidy dataframe

Examples

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

data_12 <- tidy_plate(file = file_path)
#> Data: example_12_well.xlsx; Plate type: 12 well plate

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