Read “MBL International Trial Sizes - 11-May.2016.xlsx” file

## Loading required package: rJava
## Loading required package: xlsxjars
## 'data.frame':    240 obs. of  22 variables:
##  $ Code.Number            : Factor w/ 240 levels "3305A","3310A",..: 1 2 3 4 5 6 7 8 9 10 ...
##  $ Product.Name           : Factor w/ 233 levels "A-Renilla Luciferase poab  Trial Size",..: 180 201 232 231 199 188 179 230 39 3 ...
##  $ Size                   : Factor w/ 17 levels "1 kit","1 mL",..: 13 13 13 12 13 13 1 1 7 17 ...
##  $ Target                 : Factor w/ 131 levels "0","Atg10","Atg12",..: 13 27 129 NA 26 16 NA NA 26 26 ...
##  $ Host.Species           : Factor w/ 7 levels "0","Mouse","Mouse ",..: NA NA NA NA NA NA NA NA 5 5 ...
##  $ Application            : Factor w/ 25 levels "","0","ChIP , EM , ICC , IHC , IP , WB",..: 1 1 1 NA 1 1 NA NA 24 20 ...
##  $ web.page.link          : Factor w/ 240 levels "http://www.mblintl.com/products/wu1001",..: 3 4 5 6 7 8 9 10 11 12 ...
##  $ Product.Line.Category  : Factor w/ 8 levels "Agarose","Alexa Fluor®",..: 6 6 6 NA 6 6 NA NA 4 1 ...
##  $ Category.1             : Factor w/ 6 levels "Autophagy ","Cell Biology",..: 3 3 3 3 3 3 3 3 3 3 ...
##  $ Formulation            : Factor w/ 25 levels "","0","1 mg/mL in PBS (pH 7.2) containing 1% BSA and 0.09% NaN3*Azide may react with copper or lead in plumbing system to form explosi"| __truncated__,..: 1 1 1 NA 1 1 NA NA 1 18 ...
##  $ Immunogen.Translated   : Factor w/ 157 levels "","6myc-tag fusion protein",..: 1 1 1 NA 1 1 NA NA NA 155 ...
##  $ Isotype                : Factor w/ 14 levels "Affinity Purified Ig ",..: NA NA NA NA NA NA NA NA 2 2 ...
##  $ Polycolonal..Monoclonal: Factor w/ 3 levels "","Monoclonal",..: 1 1 1 NA 1 1 NA NA 3 3 ...
##  $ Product.Type           : Factor w/ 4 levels "Antibody","Kit",..: 2 2 2 2 2 2 2 2 1 1 ...
##  $ Reactivity             : Factor w/ 173 levels "The reactivity of this antibody has been confirmed by Western blotting to detect the full-length of human SLC2A4 transiently ex"| __truncated__,..: NA NA NA NA NA NA NA NA NA 159 ...
##  $ Species.Reactivities   : Factor w/ 9 levels "","E.Coli Beta-Galactosidase",..: 1 1 1 NA 1 1 NA NA 1 1 ...
##  $ References             : Factor w/ 143 levels ") Uldry, M.,\net al\n.,\nEMBO J\n.\n20\n, 4467-4477 (2001)\n2) Bourgeois, F.,\net al\n.,\nJ. Physiol.\n563\n, 333-343 (2005) ",..: 14 26 73 NA NA NA NA NA NA 72 ...
##  $ Sample                 : logi  NA NA NA NA NA NA ...
##  $ Sensitivity            : logi  NA NA NA NA NA NA ...
##  $ Shipping               : Factor w/ 1 level "4°C": 1 1 1 1 1 1 1 1 1 1 ...
##  $ Storage                : Factor w/ 3 levels "-20°C","4°C",..: 2 2 2 2 2 2 2 2 2 2 ...
##  $ Source                 : Factor w/ 163 levels "0","P\nurified\nIgG from hybridoma supernatant ",..: NA NA NA NA NA NA NA NA NA 147 ...

Exploring variables

Code_number

  • 240 valeurs uniques / 240 enregistrements
  • Pourrait servir d’un identidiant unique des produits

Product_name

-233 valeurs uniques / 240 enregistrements : -Lignes redondantes ou bien -Même nom_produit mais avec un dosage différent par exemple … -Product_name ne pourrait pas servir d’un identifiant unique ? -Type : Text

Species

## [1] "0"       "Mouse"   "Mouse "  "Mouse  " "Rabbit"  "Rat"     "Rat "
  • 0 pourrait être une erreur/valeur manquante
  • prend 3 valeurs différentes “Mouse”, “Rabbit”, “Rat”
  • Cette variable a tendance à prendre un nombre limité de valeurs

Application

##  [1] ""                                "0"                              
##  [3] "ChIP , EM , ICC , IHC , IP , WB" "ChIP , ICC , IP , WB"           
##  [5] "ELISA"                           "FCM , ICC"                      
##  [7] "FCM , ICC , IHC"                 "FCM , ICC , IHC , IP , WB"      
##  [9] "FCM , ICC , IHC , WB"            "FCM , ICC , IP , WB"            
## [11] "FCM , IHC"                       "ICC"                            
## [13] "ICC , IHC , IP , WB"             "ICC , IHC , WB"                 
## [15] "ICC , IP"                        "ICC , IP , WB"                  
## [17] "ICC , WB"                        "IHC , WB"                       
## [19] "IHC, IP, WB, ICC"                "IP"                             
## [21] "IP , WB"                         "IP, WB"                         
## [23] "IP, WB, RIP, ICC"                "WB"                             
## [25] "WB, ICC"

Pour cette variable, on a des NULL et 0 comme valeurs, à confirmer s’ils sont valables ou qu’il s’agit d’une erreur.

Product_line_category

## [1] "Agarose"              "Alexa Fluor®"        "Biotin"              
## [4] "DirecT"               "ELISA kit"            "Protein Purification"
## [7] "Smart IP"             "Tag"
  • Type : text
  • 8 valeurs uniques

Category.1

## [1] "Autophagy "           "Cell Biology"         "Epitope Tag"         
## [4] "Fluorescent Proteins" "Immunology"           "Transfection"
  • Type : text
  • 6 valeurs uniques

Product_type

## [1] "Antibody"             "Kit"                  "Miscellaneous"       
## [4] "Transfection Reagent"

Clone

## [1] ""           "Monoclonal" "Polyclonal"

-Type : text - 2 valeurs uniques (à confirmer s’ils sont les 2 seules possibilités)

Delivery temperature

## [1] "4°C"

Type : number

storage temperature

## [1] "-20°C"                                                    
## [2] "4°C"                                                      
## [3] "4°C. Please refer to datasheet for additional information"
  • Type : number/ ou text en cas de présence de mentions spéciales