##statistiques drugcam
library(questionr)
library(tidyverse)
## ── Attaching core tidyverse packages ──────────────────────── tidyverse 2.0.0 ──
## ✔ dplyr     1.1.1     ✔ readr     2.1.4
## ✔ forcats   1.0.0     ✔ stringr   1.5.0
## ✔ ggplot2   3.4.2     ✔ tibble    3.2.1
## ✔ lubridate 1.9.2     ✔ tidyr     1.3.0
## ✔ purrr     1.0.1     
## ── Conflicts ────────────────────────────────────────── tidyverse_conflicts() ──
## ✖ dplyr::filter() masks stats::filter()
## ✖ dplyr::lag()    masks stats::lag()
## ℹ Use the conflicted package (<http://conflicted.r-lib.org/>) to force all conflicts to become errors
library(tableone)
library(labelled)
library(gtsummary)
library(GGally)
## Registered S3 method overwritten by 'GGally':
##   method from   
##   +.gg   ggplot2
library(readxl)
library(effects)
## Le chargement a nécessité le package : carData
## lattice theme set by effectsTheme()
## See ?effectsTheme for details.
library(survival)
library(survminer)
## Le chargement a nécessité le package : ggpubr
## 
## Attachement du package : 'survminer'
## 
## L'objet suivant est masqué depuis 'package:survival':
## 
##     myeloma
library(ggplot2)
library(labelled)
# chargement des données
suivi_drugcam <- read_excel("Y:/fp/docs transitoires/suivi_drugcam.xlsx")
## Warning: Expecting numeric in A2083 / R2083C1: got 'PHUPCO005'
## Warning: Expecting numeric in A9994 / R9994C1: got 'PHIUC0246'
## Warning: Expecting numeric in A9995 / R9995C1: got 'LOT32000237'
## Warning: Expecting numeric in A9996 / R9996C1: got 'LOT52000237'
## Warning: Expecting numeric in A9997 / R9997C1: got 'LOT42000237'
## Warning: Expecting numeric in A9998 / R9998C1: got 'LOT62000237'
## Warning: Expecting numeric in A9999 / R9999C1: got 'LOT12000237'
## Warning: Expecting numeric in A10000 / R10000C1: got 'LOT22000237'
## Warning: Expecting numeric in A10001 / R10001C1: got 'LOT43500237'
## Warning: Expecting numeric in A10002 / R10002C1: got 'LOT63500237'
## Warning: Expecting numeric in A10003 / R10003C1: got 'LOT53500237'
## Warning: Expecting numeric in A10004 / R10004C1: got 'LOT33500237'
## Warning: Expecting numeric in A10005 / R10005C1: got 'LOT23500237'
## Warning: Expecting numeric in A10006 / R10006C1: got 'LOT13500237'
## Warning: Expecting numeric in A10007 / R10007C1: got 'LOT14000237'
## Warning: Expecting numeric in A10008 / R10008C1: got 'LOT24000237'
## Warning: Expecting numeric in A10009 / R10009C1: got 'Lot9-350PHIUC0241'
## Warning: Expecting numeric in A10010 / R10010C1: got 'Lot8-350PHIUC0241'
## Warning: Expecting numeric in A10011 / R10011C1: got 'Lot7-350PHIUC0241'
## Warning: Expecting numeric in A13726 / R13726C1: got 'PHUPCO004'
##selection d'un préparateur
celine<-filter(suivi_drugcam, c(preparateur=="celine_delrieu"))
agathe<-filter(suivi_drugcam, c(preparateur=="agathe"))
kate<-filter(suivi_drugcam, c(preparateur=="kate"))
popo<-filter(suivi_drugcam, c(preparateur=="popo"))
sand<-filter(suivi_drugcam, c(preparateur=="sand_pacher"))

celine_nov<-filter(celine, c(mois=="11"))
celine_jan<-filter(celine, c(mois=="01"))

##resumé du temps préparation par preparateur 

tbl_summary(
  suivi_drugcam, include = c("temps_min"),
  by="preparateur",
)
Characteristic a_fontanier, N = 191 a_grand, N = 201 agathe, N = 7951 anais, N = 6111 aurelie, N = 4751 bastien, N = 11 c_combis, N = 71 candice, N = 11 cecilia, N = 11 celine_delrieu, N = 7211 charlene, N = 7841 charline, N = 4511 charlotte, N = 9621 charly, N = 1001 clement, N = 161 coralie, N = 111 corentin, N = 131 elina, N = 141 elodie, N = 2831 elsa_gota, N = 4661 elsa_soula, N = 51 emma, N = 161 fanny, N = 1141 farda, N = 3591 florent, N = 81 guillaume, N = 11 jade, N = 151 jean_yve, N = 1,0061 jibi, N = 5691 joana, N = 7071 jobo, N = 121 kate, N = 7771 laeti_pou, N = 1161 lena, N = 191 lesly, N = 3851 lucie, N = 1,1061 magali, N = 31 marie_b, N = 9551 marie_v, N = 21 marion_p, N = 5751 oceane, N = 7121 olivia, N = 11 pauline_c, N = 301 popo, N = 1191 raphaelle, N = 5801 sand_herve, N = 41 sand_pacher, N = 1351 sara_himoudi, N = 2401 sophie_p, N = 81 souf, N = 61 sylvain, N = 301 vivi, N = 481
temps_min 5.73 (4.80, 8.41) 3.11 (1.92, 5.56) 3.29 (2.24, 4.99) 2.49 (1.82, 3.61) 1.63 (1.11, 2.34) 9.14 (9.14, 9.14) 10.09 (4.82, 24.53) 8.24 (8.24, 8.24) 7.05 (7.05, 7.05) 3.40 (2.30, 4.82) 1.90 (1.38, 2.86) 1.89 (1.30, 2.86) 1.98 (1.39, 3.04) 2.73 (2.01, 3.80) 2.92 (2.60, 3.61) 5.17 (3.25, 6.85) 2.72 (1.88, 4.60) 2.45 (1.76, 3.02) 4.40 (3.14, 6.42) 1.83 (1.23, 2.67) 2.36 (2.21, 6.99) 7.46 (6.49, 10.77) 3.56 (2.47, 6.37) 2.79 (1.88, 4.20) 3.25 (2.59, 7.88) 7.94 (7.94, 7.94) 8.37 (6.21, 10.65) 2.10 (1.42, 3.00) 2.18 (1.42, 3.27) 2.76 (1.90, 3.76) 7.96 (6.05, 14.00) 2.39 (1.69, 3.43) 1.55 (0.96, 2.45) 8.78 (4.97, 10.27) 1.65 (1.22, 2.43) 1.91 (1.36, 2.82) 2.28 (2.02, 4.71) 2.12 (1.42, 3.09) 7.49 (7.38, 7.60) 1.87 (1.24, 2.80) 1.83 (1.25, 2.72) 13.28 (13.28, 13.28) 2.78 (2.05, 5.45) 1.74 (1.14, 2.60) 2.62 (1.96, 3.68) 4.58 (2.93, 6.72) 2.09 (1.41, 3.08) 2.15 (1.55, 3.15) 7.23 (4.90, 8.30) 5.47 (4.38, 6.71) 2.44 (1.41, 4.03) 2.19 (1.60, 3.38)
1 Median (IQR)
summary(celine$temps_min)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   2.296   3.403   3.972   4.818  23.275
summary(agathe$temps_min)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.8325  2.2384  3.2873  4.3877  4.9896 52.5266
summary(kate$temps_min)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##   0.000   1.695   2.389   2.854   3.431  22.658
summary(popo$temps_min)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.7009  1.1406  1.7386  2.1717  2.6027 20.3720
summary(sand$temps_min)
##    Min. 1st Qu.  Median    Mean 3rd Qu.    Max. 
##  0.8185  1.4106  2.0907  2.6201  3.0775 22.6712
##description temps preparation selon molecule

tbl_summary(
  celine, include = c("temps_min"),
  by="dci",
)
Characteristic 5fu, N = 271 Amsacrine, N = 11 Arsenic trioxyde 2mg/mL, N = 31 Asparaginase recombinante, N = 11 Atezolizumab, N = 41 Bendamustine, N = 31 Bevacizumab, N = 461 Bleomycine, N = 31 Bortezomib SC, N = 81 Brentuximab, N = 41 Busulfan injectable, N = 11 Cabazitaxel 20mg/mL, N = 11 Carboplatine, N = 311 Carfilzomib, N = 21 Cetuximab, N = 51 Cisplatine, N = 231 Cyclophosphamide, N = 491 Cytarabine, N = 151 Cytarabine INTRATHECAL, N = 21 Dacarbazine, N = 61 Daratumumab SC, N = 191 Daunorubicine, N = 11 Docetaxel, N = 71 Dostarlimab (s), N = 11 Doxorubicine, N = 261 Doxorubicine liposomale pegylee, N = 11 Doxorubicine lyophilisat, N = 11 Durvalumab, N = 51 Eculizumab, N = 51 Enfortumab Vedotin (s), N = 21 Epcoritamab (s) 60MG/ML, N = 31 Epirubicine, N = 201 Eribuline, N = 71 Etoposide, N = 91 Etoposide phosphate, N = 201 Fludarabine, N = 71 Fotemustine, N = 11 Ganciclovir, N = 31 Gemcitabine, N = 121 Idarubicine inject, N = 21 Ifosfamide, N = 131 Ipilimumab, N = 31 Irinotecan, N = 11 Levofolinate de Ca, N = 391 Lurbinectedin (s), N = 11 Mesna, N = 531 Methotrexate 100 mg/ml, N = 51 Methotrexate INTRATHECAL, N = 31 Methylprednisolone INTRATHECAL, N = 21 Mitomycine C EndoV (flacon 40MG), N = 11 Nelarabine, N = 31 Nivolumab, N = 41 Obinutuzumab, N = 51 Oxaliplatine, N = 41 Paclitaxel, N = 141 Paclitaxel-albumine, N = 51 Pembrolizumab, N = 421 Pemetrexed, N = 51 Pertuzumab, N = 61 Rituximab, N = 11 Rituximab SC, N = 21 Sacituzumab govitecan (s), N = 41 Teclistamab 90MG/ML, N = 51 Trabectedine, N = 21 Trastuzumab Sous-cutane, N = 341 Trastuzumab biosimilaire, N = 81 Trastuzumab deruxtecan, N = 131 Trastuzumab emtansine, N = 31 Vinblastine, N = 61 Vincristine, N = 211 Vinorelbine, N = 21 actinomycine, N = 11 phesgo_de, N = 211 thymoglobuline, N = 21
temps_min 5.15 (4.64, 5.82) 9.63 (9.63, 9.63) 2.61 (2.11, 3.21) 6.06 (6.06, 6.06) 2.31 (1.95, 2.71) 10.67 (6.57, 10.69) 3.24 (2.43, 4.13) 4.56 (4.25, 4.76) 2.40 (2.14, 3.56) 6.55 (5.98, 7.35) 11.27 (11.27, 11.27) 1.50 (1.50, 1.50) 4.01 (2.86, 4.68) 7.31 (7.07, 7.55) 5.62 (4.98, 6.12) 4.09 (3.52, 5.17) 3.18 (2.36, 4.17) 2.97 (2.25, 4.32) 4.69 (2.34, 7.03) 7.06 (5.84, 8.12) 2.26 (1.96, 2.47) 10.23 (10.23, 10.23) 2.72 (2.54, 3.22) 4.43 (4.43, 4.43) 3.32 (2.84, 4.00) 4.11 (4.11, 4.11) 3.97 (3.97, 3.97) 3.46 (3.28, 3.55) 8.23 (7.24, 9.00) 10.45 (10.34, 10.57) 5.80 (4.70, 7.82) 4.53 (4.16, 5.33) 2.94 (2.69, 3.40) 2.48 (2.27, 2.74) 5.22 (4.68, 7.08) 3.63 (2.88, 3.71) 9.87 (9.87, 9.87) 3.02 (2.82, 3.27) 2.61 (2.30, 2.68) 3.22 (2.88, 3.56) 8.11 (6.33, 9.75) 6.66 (6.02, 7.24) 2.63 (2.63, 2.63) 3.58 (3.20, 4.26) 5.69 (5.69, 5.69) 1.81 (1.55, 2.09) 6.51 (4.28, 8.35) 4.29 (2.60, 5.51) 2.01 (1.05, 2.97) 5.07 (5.07, 5.07) 7.65 (7.42, 8.43) 2.25 (1.85, 2.90) 3.44 (3.23, 4.34) 1.80 (1.64, 1.94) 3.54 (2.27, 3.99) 7.68 (6.99, 7.97) 3.36 (2.65, 4.38) 3.02 (3.01, 3.09) 1.81 (1.64, 2.15) 4.62 (4.62, 4.62) 2.57 (2.42, 2.72) 9.85 (8.90, 10.34) 4.68 (2.97, 4.84) 6.62 (5.24, 7.99) 1.81 (1.55, 2.22) 4.20 (3.62, 5.02) 6.74 (6.41, 7.37) 4.78 (4.54, 5.15) 3.27 (2.80, 4.66) 3.48 (2.87, 3.80) 3.47 (3.19, 3.75) 12.06 (12.06, 12.06) 2.11 (1.72, 2.44) 22.54 (22.18, 22.91)
1 Median (IQR)
##descriptif temps par dci

tbl_nov<-tbl_summary(
  celine_nov, include = c("temps_min"),
  by="dci",
)

##comparaison temps median par mois
tbl_summary(
  celine, include = c("temps_min"),
  by="mois",
)
Characteristic 01, N = 4321 11, N = 2891
temps_min 3.17 (2.26, 4.64) 3.67 (2.51, 5.01)
1 Median (IQR)
tbl_jan<-tbl_summary(
  celine_jan, include = c("temps_min"),
  by="dci",
)

##recap par molecule janvier vs novembre 
tbl_merge(
  list(tbl_nov, tbl_jan),
  tab_spanner = c("**Analyse nov**", "**Analyse jan**")
)
Characteristic Analyse nov Analyse jan
5fu, N = 41 Arsenic trioxyde 2mg/mL, N = 11 Atezolizumab, N = 41 Bendamustine, N = 31 Bevacizumab, N = 211 Bortezomib SC, N = 11 Brentuximab, N = 21 Busulfan injectable, N = 11 Carboplatine, N = 111 Carfilzomib, N = 11 Cetuximab, N = 31 Cisplatine, N = 71 Cyclophosphamide, N = 191 Cytarabine, N = 41 Dacarbazine, N = 31 Daratumumab SC, N = 51 Daunorubicine, N = 11 Docetaxel, N = 31 Doxorubicine, N = 111 Doxorubicine liposomale pegylee, N = 11 Doxorubicine lyophilisat, N = 11 Eculizumab, N = 31 Enfortumab Vedotin (s), N = 11 Epcoritamab (s) 60MG/ML, N = 21 Epirubicine, N = 71 Eribuline, N = 21 Etoposide, N = 31 Etoposide phosphate, N = 51 Fludarabine, N = 21 Gemcitabine, N = 71 Ifosfamide, N = 71 Ipilimumab, N = 21 Irinotecan, N = 11 Levofolinate de Ca, N = 221 Mesna, N = 291 Methotrexate 100 mg/ml, N = 31 Methotrexate INTRATHECAL, N = 11 Nelarabine, N = 31 Nivolumab, N = 21 Obinutuzumab, N = 21 Oxaliplatine, N = 11 Paclitaxel, N = 71 Paclitaxel-albumine, N = 31 Pembrolizumab, N = 171 Pemetrexed, N = 21 Pertuzumab, N = 11 Rituximab SC, N = 11 Sacituzumab govitecan (s), N = 31 Teclistamab 90MG/ML, N = 11 Trastuzumab Sous-cutane, N = 91 Trastuzumab biosimilaire, N = 51 Trastuzumab deruxtecan, N = 51 Trastuzumab emtansine, N = 11 Vinblastine, N = 11 Vincristine, N = 101 Vinorelbine, N = 11 phesgo_de, N = 91 thymoglobuline, N = 11 5fu, N = 231 Amsacrine, N = 11 Arsenic trioxyde 2mg/mL, N = 21 Asparaginase recombinante, N = 11 Bevacizumab, N = 251 Bleomycine, N = 31 Bortezomib SC, N = 71 Brentuximab, N = 21 Cabazitaxel 20mg/mL, N = 11 Carboplatine, N = 201 Carfilzomib, N = 11 Cetuximab, N = 21 Cisplatine, N = 161 Cyclophosphamide, N = 301 Cytarabine, N = 111 Cytarabine INTRATHECAL, N = 21 Dacarbazine, N = 31 Daratumumab SC, N = 141 Docetaxel, N = 41 Dostarlimab (s), N = 11 Doxorubicine, N = 151 Durvalumab, N = 51 Eculizumab, N = 21 Enfortumab Vedotin (s), N = 11 Epcoritamab (s) 60MG/ML, N = 11 Epirubicine, N = 131 Eribuline, N = 51 Etoposide, N = 61 Etoposide phosphate, N = 151 Fludarabine, N = 51 Fotemustine, N = 11 Ganciclovir, N = 31 Gemcitabine, N = 51 Idarubicine inject, N = 21 Ifosfamide, N = 61 Ipilimumab, N = 11 Levofolinate de Ca, N = 171 Lurbinectedin (s), N = 11 Mesna, N = 241 Methotrexate 100 mg/ml, N = 21 Methotrexate INTRATHECAL, N = 21 Methylprednisolone INTRATHECAL, N = 21 Mitomycine C EndoV (flacon 40MG), N = 11 Nivolumab, N = 21 Obinutuzumab, N = 31 Oxaliplatine, N = 31 Paclitaxel, N = 71 Paclitaxel-albumine, N = 21 Pembrolizumab, N = 251 Pemetrexed, N = 31 Pertuzumab, N = 51 Rituximab, N = 11 Rituximab SC, N = 11 Sacituzumab govitecan (s), N = 11 Teclistamab 90MG/ML, N = 41 Trabectedine, N = 21 Trastuzumab Sous-cutane, N = 251 Trastuzumab biosimilaire, N = 31 Trastuzumab deruxtecan, N = 81 Trastuzumab emtansine, N = 21 Vinblastine, N = 51 Vincristine, N = 111 Vinorelbine, N = 11 actinomycine, N = 11 phesgo_de, N = 121 thymoglobuline, N = 11
temps_min 4.39 (1.89, 6.86) 3.82 (3.82, 3.82) 2.31 (1.95, 2.71) 10.67 (6.57, 10.69) 3.39 (2.89, 4.16) 3.55 (3.55, 3.55) 7.78 (7.35, 8.21) 11.27 (11.27, 11.27) 4.58 (3.64, 4.76) 6.83 (6.83, 6.83) 6.12 (5.45, 6.39) 4.68 (3.48, 7.46) 3.36 (2.45, 4.74) 4.37 (3.36, 6.07) 8.13 (8.10, 10.48) 2.40 (1.96, 3.29) 10.23 (10.23, 10.23) 2.72 (2.63, 2.90) 3.07 (2.42, 4.07) 4.11 (4.11, 4.11) 3.97 (3.97, 3.97) 8.23 (6.24, 9.06) 10.22 (10.22, 10.22) 7.82 (6.81, 8.83) 4.31 (4.18, 4.62) 3.21 (2.84, 3.58) 2.57 (1.98, 2.65) 6.85 (3.96, 7.76) 3.71 (3.70, 3.72) 2.66 (2.61, 2.79) 6.33 (5.17, 8.57) 7.24 (6.95, 7.53) 2.63 (2.63, 2.63) 4.07 (3.52, 4.39) 1.83 (1.60, 2.19) 8.35 (5.25, 10.31) 6.73 (6.73, 6.73) 7.65 (7.42, 8.43) 2.03 (1.77, 2.28) 4.68 (4.51, 4.84) 1.83 (1.83, 1.83) 4.05 (3.59, 4.25) 7.68 (7.33, 8.67) 4.02 (3.53, 5.05) 3.18 (3.10, 3.26) 1.60 (1.60, 1.60) 2.87 (2.87, 2.87) 10.12 (9.85, 10.55) 2.32 (2.32, 2.32) 1.75 (1.55, 2.07) 4.10 (3.65, 4.44) 6.58 (6.41, 9.05) 5.52 (5.52, 5.52) 5.00 (5.00, 5.00) 3.55 (3.02, 3.79) 4.03 (4.03, 4.03) 2.39 (2.11, 2.73) 21.81 (21.81, 21.81) 5.15 (4.74, 5.52) 9.63 (9.63, 9.63) 2.11 (1.86, 2.36) 6.06 (6.06, 6.06) 2.76 (2.27, 3.96) 4.56 (4.25, 4.76) 2.27 (2.12, 3.05) 5.79 (5.59, 5.98) 1.50 (1.50, 1.50) 3.58 (2.64, 4.35) 7.79 (7.79, 7.79) 5.30 (5.14, 5.46) 4.03 (3.67, 4.62) 3.14 (2.29, 3.81) 2.75 (2.25, 3.83) 4.69 (2.34, 7.03) 5.77 (5.36, 5.92) 2.24 (1.98, 2.42) 2.96 (2.44, 3.44) 4.43 (4.43, 4.43) 3.36 (3.04, 3.74) 3.46 (3.28, 3.55) 8.12 (7.68, 8.56) 10.68 (10.68, 10.68) 3.59 (3.59, 3.59) 4.65 (4.16, 5.59) 2.94 (2.91, 3.18) 2.38 (2.27, 2.68) 5.18 (4.77, 5.86) 2.99 (2.77, 3.63) 9.87 (9.87, 9.87) 3.02 (2.82, 3.27) 2.36 (1.99, 2.50) 3.22 (2.88, 3.56) 8.93 (8.00, 10.60) 5.38 (5.38, 5.38) 3.23 (3.08, 3.58) 5.69 (5.69, 5.69) 1.73 (1.48, 2.08) 5.39 (4.83, 5.95) 2.60 (1.75, 3.45) 2.01 (1.05, 2.97) 5.07 (5.07, 5.07) 2.99 (2.48, 3.51) 3.23 (2.90, 3.33) 1.78 (1.51, 2.04) 2.48 (1.89, 3.44) 7.18 (6.78, 7.57) 2.75 (2.54, 3.33) 3.01 (2.79, 3.05) 1.87 (1.74, 2.25) 4.62 (4.62, 4.62) 2.27 (2.27, 2.27) 6.84 (6.84, 6.84) 4.76 (4.25, 5.04) 6.62 (5.24, 7.99) 1.92 (1.61, 2.23) 4.31 (3.91, 5.54) 6.92 (6.27, 7.18) 4.54 (4.42, 4.66) 2.90 (2.76, 3.65) 3.30 (2.66, 3.78) 2.92 (2.92, 2.92) 12.06 (12.06, 12.06) 1.98 (1.69, 2.19) 23.28 (23.28, 23.28)
1 Median (IQR)