Description Usage Arguments Value Note Examples
This function merges results coming from different excel files into one.
1 | create_results(succes, echec, resultats_vi, users)
|
succes |
A data.table object with the successful attempts at the AMF exam. |
resultats_vi |
A data.table object with the results of the "Validation Interne" exam. |
users |
A data.table object which contains informations about the userid and name of an individual. |
echecs |
A data.table object with the failed attempts at the AMF exam.. |
A unique dataset including the scores, final result, inscription and exam's date. This is returned as a data.table object.
It is important to leave spaces in the condition as the string is splitted on this pattern. Look at the next section for examples of valid conditions.
Lines with missing values will be omitted automatically.
1 2 3 4 5 6 7 8 9 10 11 12 | ## A quick example of how to call the function :
succes <- data.table(read_excel(paste0(path,"certificats.xlsx"), sheet = "Feuil1"))
echec <- data.table(read_excel(paste0(path,"envoiEchecs.xlsm"), sheet = "Feuil1", col_names = TRUE, skip = 1))
res_vi <- data.table(read_excel(paste0(path,"Extraction Résultats Validation Interne.xlsx")))
resultats <- create_results(succes,echecs,resultats_vi)
tail(resultats,3)
## This is what you'll get :
## userid %A %C resultat inscription examen
##1: 49615 47 43 0 2017-04-14 10:17:56 2017-04-19
##2: 50405 88 88 1 2017-05-18 13:20:29 2011-10-01
##3: 51183 100 91 1 2017-06-15 15:55:02 2014-08-20
|
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.