Dataset: Campus France Rouen 2019 Admission

About this Dataset

Campus France Rouen 2019 Admission

Context

Data from Rouen University services. Those data is about campus france application at Rouen for 2019. But identifications features are all anonymize (please check original version to see it)

This dataset (v1.capuse_france_rouen_dataset) base on the original dataset(which is also upload here) collect informations about international students that have applied for campus france admission in 2019. Those data is only about 2019 and the aim is to collect the maximum informations about candidate learning levels and the university commission decision about their application.

Content

What's inside is more than just rows and columns. I've remove ID row because it doesn't have any specific informations.

Libellé formation de la candidature : the field where the candidate apply
Année d'entrée de la candidature : the degree candidate have applied for. 1 for master 1, 2 for Licence 2 and 3 for Licence 3
Avis SCAC: favorable or not
Niveau du dernier diplôme obtenu : last graduate level
Moyenne du dernier diplôme obtenu : note of last graduate
Appréciation SCAC sur cursus : SCAS appreciation about candidate school curriculum
Capacité à se faire comprendre : capacity of candidate to make himself understand
Capacité à comprendre : capacity of candidate to understand
Etat de la candidature : application result

Check this link to better understand SCAS : http://etudier-en-france.fr/avis-scac/

Acknowledgements

Self learning data science i do believe that "the best way to learn is to give".

Inspiration

How far can we how what make Rouen University commision to select or not a future lectures? What are the similarity and the dissimilarity between those selected and those rejected? How well can we predict the future candidate result base on theirs informations?

Feel free to contact me if you have any questions.
my linkedIn : williams AVOCE
mail : canisius.avoce@outlook.com
Or kindly ask Rouen university services
Thanks and good job all.

Tables

Original Campus France Rouen 2019 Dataset

@kaggle.williamscanisius_campus_france_rouen_2019_dataset.original_campus_france_rouen_2019_dataset

421.04 KB
4024 rows
59 columns


CREATE TABLE original_campus_france_rouen_2019_dataset (
  "num_ro_de_la_candidature" VARCHAR,
  "espace_campusfrance" VARCHAR,
  "nom_de_l_tudiant" VARCHAR,
  "pr_nom_de_l_tudiant" VARCHAR,
  "etat_de_la_candidature" VARCHAR,
  "date_limite_de_traitement" VARCHAR,
  "entretien_ecf" VARCHAR,
  "dossier_de_l_tudiant" VARCHAR,
  "adresse_mail" VARCHAR,
  "date_de_naissance" TIMESTAMP,
  "sexe" VARCHAR,
  "t_l_phone_fixe" VARCHAR,
  "t_l_phone_portable" VARCHAR,
  "pays_de_nationalit" VARCHAR,
  "pays_de_naissance" VARCHAR,
  "ville_de_naissance" VARCHAR,
  "adresse_de_r_sidence" VARCHAR,
  "ville_de_r_sidence" VARCHAR,
  "pays_de_r_sidence" VARCHAR,
  "statut_particulier_bac" VARCHAR,
  "statut_particulier_bourse" VARCHAR,
  "statut_particulier_autre" VARCHAR,
  "libell_formation_de_la_candidature" VARCHAR,
  "etablissement_de_la_candidature" VARCHAR,
  "composante_de_la_candidature" VARCHAR,
  "site_de_la_candidature" VARCHAR,
  "ann_e_d_entr_e_de_la_candidature" BIGINT,
  "priorit" DOUBLE,
  "avis_scac" VARCHAR,
  "appr_ciation_scac" VARCHAR,
  "ann_e_scolaire_du_dernier_dipl_me_obtenu" DOUBLE,
  "type_du_dernier_dipl_me_obtenu" VARCHAR,
  "niveau_du_dernier_dipl_me_obtenu" VARCHAR,
  "etablissement_du_dernier_dipl_me_obtenu" VARCHAR,
  "ville_du_dernier_dipl_me_obtenu" VARCHAR,
  "r_gion_du_dernier_dipl_me_obtenu" VARCHAR,
  "pays_du_dernier_dipl_me_obtenu" VARCHAR,
  "moyenne_du_dernier_dipl_me_obtenu" VARCHAR,
  "mention_du_dernier_dipl_me_obtenu" VARCHAR,
  "appr_ciation_scac_sur_cursus" VARCHAR,
  "dernier_test_de_fran_ais_obtenu" VARCHAR,
  "niveau_global_du_dernier_test_obtenu" VARCHAR,
  "score_global_du_dernier_test_obtenu" DOUBLE,
  "date_d_obtention_du_dernier_test_obtenu" TIMESTAMP,
  "date_d_expiration_du_dernier_test_obtenu" VARCHAR,
  "num_ro_d_attestation_du_dernier_test_obtenu" VARCHAR,
  "dispens_de_certification_en_fran_ais_par_l_espace_cf" VARCHAR,
  "a_pass_une_partie_de_sa_scolarit_en_fran_ais" VARCHAR,
  "a_tudi_le_fran_ais" VARCHAR,
  "etablissement" VARCHAR,
  "ville" VARCHAR,
  "r_gion" VARCHAR,
  "pays" VARCHAR,
  "volume_d_heures" VARCHAR,
  "dur_e_d_tude" VARCHAR,
  "niveau_obtenu" VARCHAR,
  "capacit_se_faire_comprendre" VARCHAR,
  "capacit_comprendre" VARCHAR,
  "exon_ration" VARCHAR
);

V1 Campus France Rouen Dataset

@kaggle.williamscanisius_campus_france_rouen_2019_dataset.v1_campus_france_rouen_dataset

24.93 KB
3585 rows
9 columns


CREATE TABLE v1_campus_france_rouen_dataset (
  "libell_formation_de_la_candidature" VARCHAR,
  "ann_e_d_entr_e_de_la_candidature" BIGINT,
  "avis_scac" VARCHAR,
  "niveau_du_dernier_dipl_me_obtenu" BIGINT,
  "moyenne_du_dernier_dipl_me_obtenu" VARCHAR,
  "appr_ciation_scac_sur_cursus" VARCHAR,
  "capacit_se_faire_comprendre" VARCHAR,
  "capacit_comprendre" VARCHAR,
  "etat_de_la_candidature" VARCHAR
);