Convert blank cells to NA for consistency?

[ivelsko]

Hi guys, I encountered some inconsistent sidora table formatting that caused me some confusion while trying to filter and join tables. In some columns where there's no entry a cell is left blank, while in others it's filled with NA. For example

df_list <- get_df_list(c(
  "TAB_Library", "TAB_Capture", "TAB_Sequencing"
), con = con)

lib_info <- join_pandora_tables(df_list)

lib_info <- convert_all_ids_to_values(lib_info, con)

lib_info %>% 
  filter(str_detect(library.Full_Library_Id, "CMC040")) %>%
  select(library.Full_Library_Id, library.Protocol, library.Batch, sequencing.Full_Sequencing_Id) 

# A tibble: 3 × 4
  library.Full_Library_Id library.Protocol       library.Batch        sequencing.Full_Sequencing_Id
  <chr>                   <chr>                  <chr>                <chr>                        
1 CMC040.A0201            dsLibrary non UDG 2015 ""                   NA                           
2 CMC040.B0101            dsLibrary non UDG 2015 "Li04_VE_2019-04-17" CMC040.B0101.SG1.1           
3 CMC040.B0101            dsLibrary non UDG 2015 "Li04_VE_2019-04-17" CMC040.B0101.SG1.2           

In Pandora the cell for the library batch is empty. Is this just an R/Pandora thing that has to be tolerated, or would it be possible to have this made consistent (everything is NA)?