create_and_maintain_a_meta_data_table.RmdInstall necessary packages in RStudio:
install.packages("BiocManager")
BiocManager::install("flowCore")
install.packages("devtools")
devtools::install_github("Close-your-eyes/fcexpr")
library(fcexpr)In order to plot data from a flowjo workspace (event counts or MFIs) meta data about the FCS files have to be provided. To avoid that respective tables are created individually (~with different formats) for every single experiment the sync_sampledescription function may be used. The respective table containing meta data will be referred to as ‘sampledescription’.
Pick a directory on your disk and create a template folder with fcexpr::new_exp(). A respective folder appears in “path”. It has a default structure and contains a few template folders and files.
dir <- "/Users/vonskopnik/Documents"
fcexpr::new_exp(path = dir, name = "my_experiment", date_prefix = F)
#> /var/folders/hd/gcy53z2x6sxd77_f8wl01by81nxlrm/T//RtmpjPzLE7/my_experiment created.
# you may prefer date_prefix = T to have the folder automatically prefixed by todays dateSave the path to that folder in a variable to access it easily below.
wd <- "/Users/vonskopnik/Documents/my_experiment"Next, add FCS files to the FCS_files folder. Here, example files from this package are used.
list.files(file.path(wd, "FCS_files", "Part_1"))[1:5]
#> [1] "Specimen_001_Tube_001_001.fcs" "Specimen_001_Tube_002_002.fcs"
#> [3] "Specimen_001_Tube_003_003.fcs" "Specimen_001_Tube_004_004.fcs"
#> [5] "Specimen_001_Tube_005_005.fcs"To initiate a sampledescription run sync_sampledescription. The respective file is always written to the parent folder of FCS.file.folder. By default it is an xlsx file named ‘sampledescription.xlsx’. You may change that to a open formats like .txt or .tsv. See ?sync_sampledescription.
fcexpr::sync_sampledescription(FCS.file.folder = file.path(wd, "FCS_files"), init.columns = c())
#> [1] "sampledescription.xlsx initiated."All FCS files have been entered as rows. The FileNames are prefixed with a continuous number to make them unique. The identity column is necessary for the function to identify the FCS unambiguously. Check the sampledescription file on your disk!
sampledescription:
| FileName | identity |
|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 |
| 0002_-_Specimen_001_Tube_002_002.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 |
| 0003_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 |
| 0004_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 |
| 0005_-_Specimen_001_Tube_005_005.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 |
| 0007_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 |
| 0008_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 |
| 0009_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 |
| 0010_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 |
Also, FCS files have been renamed with a prefix. The names of the FCS files and the entries in the sampledescription have been synchronized.
list.files(file.path(wd, "FCS_files", "Part_1"))[1:5]
#> [1] "0001_-_Specimen_001_Tube_001_001.fcs"
#> [2] "0002_-_Specimen_001_Tube_002_002.fcs"
#> [3] "0003_-_Specimen_001_Tube_003_003.fcs"
#> [4] "0004_-_Specimen_001_Tube_004_004.fcs"
#> [5] "0005_-_Specimen_001_Tube_005_005.fcs"Additional columns with meta data may be added. These columns serve to document the content of FCS files. Simultaneously, one can use them to group or arrange data when plotting.
sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex |
|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M |
| 0002_-_Specimen_001_Tube_002_002.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M |
| 0003_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M |
| 0004_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M |
| 0005_-_Specimen_001_Tube_005_005.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F |
| 0007_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F |
| 0008_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F |
| 0009_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F |
| 0010_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F |
When the names in the FileName column are changed and sync_sampledescription is run, synchronization takes place.
sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex |
|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M |
| File_2 | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M |
| 0003_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M |
| 0004_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M |
| File_5 | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F |
| 0007_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F |
| 0008_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F |
| 0009_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F |
| 0010_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F |
fcexpr::sync_sampledescription(FCS.file.folder = file.path(wd, "FCS_files"), write.log = F)
#> FileName PreviousFileName
#> 1 0002_-_File_2.fcs 0002_-_Specimen_001_Tube_002_002.fcs
#> 2 0005_-_File_5.fcs 0005_-_Specimen_001_Tube_005_005.fcsThe prefixed continuous number and the .fcs-suffix are obligatory and are added automatically. sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex |
|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M |
| 0002_-_File_2.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M |
| 0003_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M |
| 0004_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M |
| 0005_-_File_5.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F |
| 0007_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F |
| 0008_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F |
| 0009_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F |
| 0010_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F |
FCS files have been renamed accordingly.
list.files(file.path(wd, "FCS_files", "Part_1"))
#> [1] "0001_-_Specimen_001_Tube_001_001.fcs"
#> [2] "0002_-_File_2.fcs"
#> [3] "0003_-_Specimen_001_Tube_003_003.fcs"
#> [4] "0004_-_Specimen_001_Tube_004_004.fcs"
#> [5] "0005_-_File_5.fcs"
#> [6] "0006_-_Specimen_001_Tube_006_006.fcs"
#> [7] "0007_-_Specimen_001_Tube_007_007.fcs"
#> [8] "0008_-_Specimen_001_Tube_008_008.fcs"
#> [9] "0009_-_Specimen_001_Tube_009_009.fcs"
#> [10] "0010_-_Specimen_001_Tube_010_010.fcs"** Note: When files are renamed, respective FlowJo Workspaces have to be opened once in order to adopt the changes in file names in the wsp-file. FlowJo recognizes FCS by other parameters than the file name.**
The FCS files have been added in chronological order of acquisition (see the date in identity column). If one is not happy with that, the row-order in the sampledescription can be changed. When running sync_sampledescription the prefix-number will be adjusted. NOTE: Never change the content of the identity column and never mix up rows of FileName and identity!!!
sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex |
|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M |
| 0002_-_File_2.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M |
| 0009_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F |
| 0010_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F |
| 0005_-_File_5.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F |
| 0003_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M |
| 0004_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M |
| 0007_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F |
| 0008_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F |
fcexpr::sync_sampledescription(FCS.file.folder = file.path(wd, "FCS_files"), write.log = F)
#> FileName PreviousFileName
#> 1 0003_-_Specimen_001_Tube_009_009.fcs 0009_-_Specimen_001_Tube_009_009.fcs
#> 2 0004_-_Specimen_001_Tube_010_010.fcs 0010_-_Specimen_001_Tube_010_010.fcs
#> 3 0007_-_Specimen_001_Tube_003_003.fcs 0003_-_Specimen_001_Tube_003_003.fcs
#> 4 0008_-_Specimen_001_Tube_004_004.fcs 0004_-_Specimen_001_Tube_004_004.fcs
#> 5 0009_-_Specimen_001_Tube_007_007.fcs 0007_-_Specimen_001_Tube_007_007.fcs
#> 6 0010_-_Specimen_001_Tube_008_008.fcs 0008_-_Specimen_001_Tube_008_008.fcs
list.files(file.path(wd, "FCS_files", "Part_1"))
#> [1] "0001_-_Specimen_001_Tube_001_001.fcs"
#> [2] "0002_-_File_2.fcs"
#> [3] "0003_-_Specimen_001_Tube_009_009.fcs"
#> [4] "0004_-_Specimen_001_Tube_010_010.fcs"
#> [5] "0005_-_File_5.fcs"
#> [6] "0006_-_Specimen_001_Tube_006_006.fcs"
#> [7] "0007_-_Specimen_001_Tube_003_003.fcs"
#> [8] "0008_-_Specimen_001_Tube_004_004.fcs"
#> [9] "0009_-_Specimen_001_Tube_007_007.fcs"
#> [10] "0010_-_Specimen_001_Tube_008_008.fcs"When FCS files are added to the FCS_files folder and sync_sampledescription is run, the sampledescription will be appended by the new files (~synchronized).
# here, example files from this package have been added
list.files(file.path(wd, "FCS_files"))
#> [1] "Part_1" "Part_2"
fcexpr::sync_sampledescription(FCS.file.folder = file.path(wd, "FCS_files"), write.log = F)
#> 7 new files have been found and added to the sampledescription.sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex |
|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M |
| 0002_-_File_2.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M |
| 0003_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F |
| 0004_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F |
| 0005_-_File_5.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F |
| 0007_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M |
| 0008_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M |
| 0009_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F |
| 0010_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F |
| 0011_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.13-10.52.35 | |||
| 0012_-_PE_comp.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.13-10.54.03 | |||
| 0013_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.13-10.55.58 | |||
| 0014_-_FITC_comp.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.13-10.57.14 | |||
| 0015_-_Specimen_001_Tube_005_005.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.13-10.58.34 | |||
| 0016_-_APC_comp.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.13-10.59.23 | |||
| 0017_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.13-11.00.06 |
The function argument exclude.folders in sync_sampledescription specifies folder names that will be ignored for syncing with the sampledescription. Such folders may contain controls like rainbow beads or compensation controls or similar - in general, files which do not contain biological information. If, by accident, one or more of these files end up in our sampledescription since one forgot to copy them to a respective folder one can have them removed by deleting the FileName, but only the FileName, from the sampledescription.
sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex |
|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M |
| 0002_-_File_2.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M |
| 0003_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F |
| 0004_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F |
| 0005_-_File_5.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F |
| 0007_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M |
| 0008_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M |
| 0009_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F |
| 0010_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F |
| 0011_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.13-10.52.35 | |||
| Specimen_001_Tube_002_002.fcs_-1-_2021.02.13-10.54.03 | ||||
| 0013_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.13-10.55.58 | |||
| Specimen_001_Tube_004_004.fcs_-1-_2021.02.13-10.57.14 | ||||
| 0015_-_Specimen_001_Tube_005_005.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.13-10.58.34 | |||
| Specimen_001_Tube_006_006.fcs_-1-_2021.02.13-10.59.23 | ||||
| 0017_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.13-11.00.06 |
fcexpr::sync_sampledescription(FCS.file.folder = file.path(wd, "FCS_files"), write.log = F)
#> FCS files moved to deleted_FCS_files and sampledescription.xlsx updated.The prefixed numbers are made continuous by renaming files accordingly.
sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex |
|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M |
| 0002_-_File_2.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M |
| 0003_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F |
| 0004_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F |
| 0005_-_File_5.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F |
| 0007_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M |
| 0008_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M |
| 0009_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F |
| 0010_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F |
| 0011_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.13-10.52.35 | |||
| 0012_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.13-10.55.58 | |||
| 0013_-_Specimen_001_Tube_005_005.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.13-10.58.34 | |||
| 0014_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.13-11.00.06 |
By default a log file is written (write.log = T) which documents all changes to sampledescription. On Mac/linux it is hidden, on Windows it is not.
Add the sub-folders which FCS files are in to sampledescription:
sd <- openxlsx::read.xlsx(xlsxFile = file.path(wd, "sampledescription.xlsx"))
files <- list.files(file.path(wd, "FCS_files"), pattern = "\\.fcs", recursive = T, ignore.case = T)
files_table <- data.frame(FileName = basename(files), Folder = dirname(files))
sd <- dplyr::left_join(sd, files_table)
#> Joining, by = "FileName"
# then save
openxlsx::write.xlsx(sd, file.path(wd, "sampledescription.xlsx"), overwrite = T)sampledescription:
| FileName | identity | Patient_ID | Staining | Patient_sex | Folder |
|---|---|---|---|---|---|
| 0001_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.06-18.30.04 | 1 | FMO | M | Part_1 |
| 0002_-_File_2.fcs | Specimen_001_Tube_002_002.fcs_-1-_2021.02.06-18.31.33 | 1 | full | M | Part_1 |
| 0003_-_Specimen_001_Tube_009_009.fcs | Specimen_001_Tube_009_009.fcs_-1-_2021.02.06-18.38.51 | 5 | FMO | F | Part_1 |
| 0004_-_Specimen_001_Tube_010_010.fcs | Specimen_001_Tube_010_010.fcs_-1-_2021.02.06-18.39.39 | 5 | full | F | Part_1 |
| 0005_-_File_5.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.06-18.34.49 | 3 | FMO | F | Part_1 |
| 0006_-_Specimen_001_Tube_006_006.fcs | Specimen_001_Tube_006_006.fcs_-1-_2021.02.06-18.35.39 | 3 | full | F | Part_1 |
| 0007_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.06-18.33.06 | 2 | FMO | M | Part_1 |
| 0008_-_Specimen_001_Tube_004_004.fcs | Specimen_001_Tube_004_004.fcs_-1-_2021.02.06-18.34.01 | 2 | full | M | Part_1 |
| 0009_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.06-18.36.52 | 4 | FMO | F | Part_1 |
| 0010_-_Specimen_001_Tube_008_008.fcs | Specimen_001_Tube_008_008.fcs_-1-_2021.02.06-18.38.03 | 4 | full | F | Part_1 |
| 0011_-_Specimen_001_Tube_001_001.fcs | Specimen_001_Tube_001_001.fcs_-1-_2021.02.13-10.52.35 | Part_2 | |||
| 0012_-_Specimen_001_Tube_003_003.fcs | Specimen_001_Tube_003_003.fcs_-1-_2021.02.13-10.55.58 | Part_2 | |||
| 0013_-_Specimen_001_Tube_005_005.fcs | Specimen_001_Tube_005_005.fcs_-1-_2021.02.13-10.58.34 | Part_2 | |||
| 0014_-_Specimen_001_Tube_007_007.fcs | Specimen_001_Tube_007_007.fcs_-1-_2021.02.13-11.00.06 | Part_2 |