{ "cells": [ { "cell_type": "code", "execution_count": 1, "id": "21f29d86-6660-48e5-815d-ed80a1e4ebe8", "metadata": {}, "outputs": [], "source": [ "import pandas as pd\n", "import os\n", "import glob\n", "import time" ] }, { "cell_type": "markdown", "id": "135745c1-7bd1-4185-8449-45c7b8be13b2", "metadata": {}, "source": [ "## Recherche du dernier fichier avec les données déposé" ] }, { "cell_type": "code", "execution_count": 2, "id": "410340ac-dc68-4eef-8365-b20a1cc9a050", "metadata": {}, "outputs": [], "source": [ "def trouver_fichier_le_plus_recent(repertoire):\n", " \"\"\"\n", " Trouve le fichier le plus récent dans un répertoire.\n", "\n", " Args:\n", " repertoire: Le chemin du répertoire à rechercher.\n", "\n", " Returns:\n", " Le chemin du fichier le plus récent, ou None si le répertoire est vide \n", " ou ne contient pas de fichiers.\n", " \"\"\"\n", " try:\n", " # Obtient la liste de tous les fichiers dans le répertoire\n", " fichiers = glob.glob(os.path.join(repertoire, '*'))\n", "\n", " # Exclut les sous-répertoires\n", " fichiers = [f for f in fichiers if os.path.isfile(f)]\n", "\n", " if not fichiers:\n", " return None\n", "\n", " # Trouve le fichier avec la date de modification la plus récente\n", " fichier_le_plus_recent = max(fichiers, key=os.path.getmtime)\n", "\n", " return fichier_le_plus_recent\n", " except FileNotFoundError:\n", " print(f\"Erreur : Le répertoire '{repertoire}' n'existe pas.\")\n", " return None\n", "\n" ] }, { "cell_type": "code", "execution_count": 3, "id": "c3eecce4-ef95-46fc-8c55-d4706e69f9f1", "metadata": {}, "outputs": [], "source": [ "# Constantes" ] }, { "cell_type": "code", "execution_count": 4, "id": "ccc7e273-3de1-479a-a10e-f4765b960787", "metadata": {}, "outputs": [], "source": [ "# Date limite\n", "date_limite = pd.to_datetime('2024-01-01')" ] }, { "cell_type": "markdown", "id": "a1fbe50c-bec0-46d4-a6b4-4b96600d7138", "metadata": {}, "source": [ "## Lecture du fichier de versements" ] }, { "cell_type": "code", "execution_count": 5, "id": "61bb45fa-c75e-45e5-8f92-73b4f122a657", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "lecture du fichier ./data/helloasso_versements\\export-paiements-les-nuits-de-beltane-17_12_2021-01_02_2025.csv ...\n" ] } ], "source": [ "repertoire_helloasso_versements = \"./data/helloasso_versements\" # Remplacez par le chemin de votre répertoire\n", "fichier_recent = trouver_fichier_le_plus_recent(repertoire_helloasso_versements)\n", "\n", "if not fichier_recent:\n", " print(\"Le répertoire est vide ou ne contient pas de fichiers.\")\n", " exit(1)\n", "print(f\"lecture du fichier {fichier_recent} ...\")\n", "_usecols = ['Référence commande', \n", " 'Montant total',\n", " 'Date du paiement',\n", " 'Statut du paiement',\n", " 'Versé',\n", " 'Nom payeur',\n", " 'Prénom payeur',\n", " 'Email payeur',\n", " 'Campagne',\n", " 'Type de campagne',\n", " 'Type',\n", " 'Montant du tarif'\n", " ]\n", "_dtype = {}\n", "_dtype.setdefault(str)\n", "_dates=[\"Date du paiement\"]\n", "df_versements = pd.read_csv(fichier_recent, sep=';', usecols=_usecols, dtype=_dtype)\n", "df_versements['Montant total'] = df_versements['Montant total'].str.replace(',', '.')\n", "df_versements['Montant total'] = pd.to_numeric(df_versements['Montant total'], errors='coerce')\n", "for d in _dates:\n", " df_versements[d] = pd.to_datetime(df_versements[d], format='%d/%m/%Y %H:%M:%S')\n", "df_versements['Email payeur'] = df_versements['Email payeur'].astype(str).str.lower().str.strip()\n", "df_versements['Nom payeur'] = df_versements['Nom payeur'].astype(str).str.upper().str.strip()\n", "df_versements['Prénom payeur'] = df_versements['Prénom payeur'].astype(str).str.capitalize().str.strip()\n", "# Sélection des lignes\n", "df_versements = df_versements[df_versements[\"Date du paiement\"] >= date_limite]\n", "df_pb_versement = df_versements[df_versements['Statut du paiement'] != 'Payé']\n", "df_versements_ok = df_versements[df_versements['Statut du paiement'] == 'Payé']" ] }, { "cell_type": "code", "execution_count": 6, "id": "c2749eaa-20d5-49e0-8d10-388bf19acbf1", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "Référence commande 78660977\n", "Montant total 133.5\n", "Date du paiement 2024-01-19 10:23:16\n", "Statut du paiement Payé\n", "Versé Oui\n", "Nom payeur PHILBERT\n", "Prénom payeur Charles\n", "Email payeur philbert.charles@neuf.fr\n", "Campagne Retour à Nassau V1 Juin\n", "Type de campagne Adhésion\n", "Type Paiement en plusieurs fois\n", "Montant du tarif 133,50\n", "Name: 151, dtype: object" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_versements.iloc[-1]" ] }, { "cell_type": "markdown", "id": "a81cf78a-b413-4bdb-8981-961dbcbbecfe", "metadata": {}, "source": [ "## Lecture du fichier du tableau de bord" ] }, { "cell_type": "code", "execution_count": 7, "id": "8a84dbbb-3501-42bd-b83a-af5204443202", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "lecture du fichier ./data/tdb_joueurs\\Tableau de bord - remplissage du jeu.csv ...\n" ] } ], "source": [ "repertoire_tdb_joueurs = \"./data/tdb_joueurs\" # Remplacez par le chemin de votre répertoire\n", "fichier_recent = trouver_fichier_le_plus_recent(repertoire_tdb_joueurs)\n", "if not fichier_recent:\n", " print(\"Le répertoire est vide ou ne contient pas de fichiers.\")\n", " exit(1)\n", "print(f\"lecture du fichier {fichier_recent} ...\")\n" ] }, { "cell_type": "code", "execution_count": 8, "id": "3c69644b-b03b-4f8d-a1a2-078268eaa33e", "metadata": {}, "outputs": [ { "data": { "text/plain": [ "1\n", "date\\ninscription 12/01/2024\n", "NOM ARVIN-BEROD\n", "Prénom Florence\n", "Genre F\n", "age 33\n", "E-MAIL flofloab@yahoo.fr\n", "FB Florence ARVIN-BEROD \n", "Tél 0617161474\n", "souhait type\\nparticipation Pur PJ\n", "Personnage\\nattribué -\n", "souhait\\nsession juin\n", "souhait lieu Navire et fort\n", " acceptation OK\n", "email de validation\\n+ invit DISCORD OK\n", "session\\nattribuée juin\n", "Lieu Navire & Fort\n", "somme\\nversée 400,00 €\n", "état PAF PAF finalisée\n", "photo ? non reçue\n", "compétence medicale R.A.S.\n", "arrivée samedi\n", "Reste si \\npas Shtandart ? Reste\n", "NaN NaN\n", "Name: 0, dtype: object" ] }, "execution_count": 8, "metadata": {}, "output_type": "execute_result" } ], "source": [ "_dtype = {}\n", "_dtype.setdefault(str)\n", "# Lecture du fichier CSV sans en-tête\n", "df_joueurs = pd.read_csv(fichier_recent, sep=',', header=None)\n", "# Remplacement des noms de colonnes par la première ligne\n", "df_joueurs.columns = df_joueurs.iloc[1]\n", "# Suppression de la première ligne (qui est maintenant l'en-tête)\n", "df_joueurs = df_joueurs[13:220]\n", "# Réinitialisation de l'index\n", "df_joueurs = df_joueurs.reset_index(drop=True)\n", "df_joueurs = df_joueurs.dropna(subset=['NOM'])\n", "df_joueurs['E-MAIL'] = df_joueurs['E-MAIL'].astype(str).str.strip().str.lower()\n", "df_joueurs['NOM'] = df_joueurs['NOM'].astype(str).str.strip().str.upper()\n", "df_joueurs['Prénom'] = df_joueurs['Prénom'].astype(str).str.strip().str.capitalize()\n", "df_joueurs.iloc[0]" ] }, { "cell_type": "markdown", "id": "9617ae45-0077-49fa-b588-39a7a868ada2", "metadata": {}, "source": [ "## calcul des sommes versés par chaque joueur" ] }, { "cell_type": "code", "execution_count": 9, "id": "1c7ecb8e-997e-4ed9-952e-a143bae0ada1", "metadata": {}, "outputs": [], "source": [ "df_versements_joueur = df_versements.groupby(['Nom payeur', 'Prénom payeur', 'Email payeur']).agg(somme_versee=('Montant total','sum'))" ] }, { "cell_type": "code", "execution_count": 10, "id": "955d301f-cd1e-49c2-ab8a-6a2f3feeeccb", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
somme_versee
Nom payeurPrénom payeurEmail payeur
AMOUREUXErwanerwan.amoureux@gmail.com400.0
ARDALANPouriapepebicho@yahoo.com200.0
ARVIN-BEROD GOSETFlorenceflofloab@yahoo.fr400.0
BATTUNGCoraliecorabattung@gmail.com267.0
BERGERETMathieubergeretmathieu.pro@gmail.com400.5
............
VIGIERYanyanvigier63@gmail.com801.0
VIGNIERFannyfannyvignier@hotmail.fr400.5
VOINOTSébastiensebvoinot@yahoo.fr400.0
WARSZAWSKIJessicaj.warszawski@hotmail.fr400.5
YOGANANTHANKarunacontact@karuna.pro400.0
\n", "

104 rows × 1 columns

\n", "
" ], "text/plain": [ " somme_versee\n", "Nom payeur Prénom payeur Email payeur \n", "AMOUREUX Erwan erwan.amoureux@gmail.com 400.0\n", "ARDALAN Pouria pepebicho@yahoo.com 200.0\n", "ARVIN-BEROD GOSET Florence flofloab@yahoo.fr 400.0\n", "BATTUNG Coralie corabattung@gmail.com 267.0\n", "BERGERET Mathieu bergeretmathieu.pro@gmail.com 400.5\n", "... ...\n", "VIGIER Yan yanvigier63@gmail.com 801.0\n", "VIGNIER Fanny fannyvignier@hotmail.fr 400.5\n", "VOINOT Sébastien sebvoinot@yahoo.fr 400.0\n", "WARSZAWSKI Jessica j.warszawski@hotmail.fr 400.5\n", "YOGANANTHAN Karuna contact@karuna.pro 400.0\n", "\n", "[104 rows x 1 columns]" ] }, "execution_count": 10, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_versements_joueur" ] }, { "cell_type": "code", "execution_count": 11, "id": "12a43522-d10c-428b-a95b-9b4ac02979bb", "metadata": {}, "outputs": [], "source": [ "df_versements_joueur = df_versements_joueur.reset_index()\n" ] }, { "cell_type": "markdown", "id": "c237a599-f9d0-4cbf-853a-eea5939d66b9", "metadata": {}, "source": [ "### Lecture billets juin (adhésions)" ] }, { "cell_type": "code", "execution_count": 58, "id": "12640bc7-514b-46e5-803d-52010e005347", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "lecture du fichier ./data/billets_juin\\export-retour-a-nassau-les-nuits-de-beltane-19_01_2024-01_02_2025.csv ...\n" ] } ], "source": [ "repertoire_billets_juin = \"./data/billets_juin\" # Remplacez par le chemin de votre répertoire\n", "fichier_recent = trouver_fichier_le_plus_recent(repertoire_billets_juin)\n", "if not fichier_recent:\n", " print(\"Le répertoire est vide ou ne contient pas de fichiers.\")\n", " exit(1)\n", "print(f\"lecture du fichier {fichier_recent} ...\")" ] }, { "cell_type": "code", "execution_count": 59, "id": "7aaf7f99-709d-4d7d-a238-f05877f55168", "metadata": {}, "outputs": [], "source": [ "_usecols= [\n", " 'Référence commande', \n", " 'Date de la commande',\n", " 'Statut de la commande',\n", " 'Nom adhérent',\n", " 'Prénom adhérent',\n", " 'Nom payeur',\n", " 'Prénom payeur',\n", " 'Email payeur',\n", " 'Tarif',\n", " 'Montant tarif'\n", "]" ] }, { "cell_type": "code", "execution_count": 65, "id": "72a88e43-9e11-4c16-9f22-0a382e0a3b62", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "(89, 10)\n", "(89, 10)\n", "(89, 10)\n" ] } ], "source": [ "_dtype = {}\n", "_dtype.setdefault(str)\n", "_dates=[\"Date de la commande\"]\n", "df_billets_juin = pd.read_csv(fichier_recent, sep=';', usecols=_usecols, dtype=_dtype)\n", "df_billets_juin = df_billets_juin.rename(columns={'Nom adhérent': 'Nom participant', 'Prénom adhérent': 'Prénom participant'})\n", "\n", "for d in _dates:\n", " df_billets_juin[d] = pd.to_datetime(df_billets_juin[d], format='%d/%m/%Y %H:%M')\n", "df_billets_juin['Nom participant'] = df_billets_juin['Nom participant'].astype(str).str.strip().str.upper()\n", "df_billets_juin['Prénom participant'] = df_billets_juin['Prénom participant'].astype(str).str.strip().str.capitalize()\n", "df_billets_juin['Email payeur'] = df_billets_juin['Email payeur'].astype(str).str.strip().str.lower()\n", "df_billets_juin['Nom payeur'] = df_billets_juin['Nom payeur'].astype(str).str.strip().str.upper()\n", "df_billets_juin['Prénom payeur'] = df_billets_juin['Prénom payeur'].astype(str).str.strip().str.capitalize()\n", "\n", "# Sélection des lignes\n", "df_billets_juin = df_billets_juin[df_billets_juin['Date de la commande'] >= date_limite]\n", "print(df_billets_juin.shape)\n" ] }, { "cell_type": "code", "execution_count": 61, "id": "fea45f36-3966-4a18-be42-1e0bf2111990", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeDate de la commandeStatut de la commandeNom participantPrénom participantNom payeurPrénom payeurEmail payeurTarifMontant tarif
01178984242025-01-30 11:03:00ValidéGANTETGuillaumeGANTETGuillaumeguilland@gmail.comFort + navire (en 3 fois SEPTEMBRE UNIQUEMENT)400,50
11178939442025-01-30 10:28:00ValidéYOGANANTHANKarunaYOGANANTHANKarunacontact@karuna.proFort + navire400,00
21175580652025-01-27 16:06:00ValidéFARWilliamFARWilliamwilliam.daniel.far@gmail.comFort + navire (en 3 fois SEPTEMBRE UNIQUEMENT)400,50
31169830112025-01-22 12:13:00ValidéLAURENTSaadaSAADALaurentlaursaad@gmail.comFort + navire (en 3 fois SEPTEMBRE UNIQUEMENT)400,50
41169502502025-01-22 00:33:00ValidéRÉVEILJean carlyMAYORTomtom.bonaventure.mayor@gmail.comFort + navire400,00
.................................
84800014652024-02-02 09:27:00ValidéBOURDETTEJulienBOURDETTEJulienclodoweg@gmail.comFort + navire400,00
85799759392024-02-01 21:32:00ValidéCERUTTILaëtitiaCERUTTILaëtitialaetitia.cerutti@gozmail.bzhFort + navire (en 3 fois)400,50
86787872822024-01-20 19:53:00ValidéJACQGaëlleJACQGaëllegaellejacq@yahoo.comFort + navire400,00
87787363622024-01-20 09:42:00ValidéBUCASEricBUCASEricsacub@sfr.frFort + navire400,00
88786609772024-01-19 10:23:00ValidéPHILBERTCharlesPHILBERTCharlesphilbert.charles@neuf.frFort + navire (en 3 fois)400,50
\n", "

89 rows × 10 columns

\n", "
" ], "text/plain": [ " Référence commande Date de la commande Statut de la commande \\\n", "0 117898424 2025-01-30 11:03:00 Validé \n", "1 117893944 2025-01-30 10:28:00 Validé \n", "2 117558065 2025-01-27 16:06:00 Validé \n", "3 116983011 2025-01-22 12:13:00 Validé \n", "4 116950250 2025-01-22 00:33:00 Validé \n", ".. ... ... ... \n", "84 80001465 2024-02-02 09:27:00 Validé \n", "85 79975939 2024-02-01 21:32:00 Validé \n", "86 78787282 2024-01-20 19:53:00 Validé \n", "87 78736362 2024-01-20 09:42:00 Validé \n", "88 78660977 2024-01-19 10:23:00 Validé \n", "\n", " Nom participant Prénom participant Nom payeur Prénom payeur \\\n", "0 GANTET Guillaume GANTET Guillaume \n", "1 YOGANANTHAN Karuna YOGANANTHAN Karuna \n", "2 FAR William FAR William \n", "3 LAURENT Saada SAADA Laurent \n", "4 RÉVEIL Jean carly MAYOR Tom \n", ".. ... ... ... ... \n", "84 BOURDETTE Julien BOURDETTE Julien \n", "85 CERUTTI Laëtitia CERUTTI Laëtitia \n", "86 JACQ Gaëlle JACQ Gaëlle \n", "87 BUCAS Eric BUCAS Eric \n", "88 PHILBERT Charles PHILBERT Charles \n", "\n", " Email payeur \\\n", "0 guilland@gmail.com \n", "1 contact@karuna.pro \n", "2 william.daniel.far@gmail.com \n", "3 laursaad@gmail.com \n", "4 tom.bonaventure.mayor@gmail.com \n", ".. ... \n", "84 clodoweg@gmail.com \n", "85 laetitia.cerutti@gozmail.bzh \n", "86 gaellejacq@yahoo.com \n", "87 sacub@sfr.fr \n", "88 philbert.charles@neuf.fr \n", "\n", " Tarif Montant tarif \n", "0 Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) 400,50 \n", "1 Fort + navire 400,00 \n", "2 Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) 400,50 \n", "3 Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) 400,50 \n", "4 Fort + navire 400,00 \n", ".. ... ... \n", "84 Fort + navire 400,00 \n", "85 Fort + navire (en 3 fois) 400,50 \n", "86 Fort + navire 400,00 \n", "87 Fort + navire 400,00 \n", "88 Fort + navire (en 3 fois) 400,50 \n", "\n", "[89 rows x 10 columns]" ] }, "execution_count": 61, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_billets_juin" ] }, { "cell_type": "code", "execution_count": 66, "id": "2bb93f25-c86e-4a9e-a68c-bd0d047e5b23", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeDate de la commandeStatut de la commandeNom participantPrénom participantNom payeurPrénom payeurEmail payeurTarifMontant tarif
71856141162024-03-30 16:25:00ValidéRAIMBAULTCécileVIGIERYanyanvigier63@gmail.comFort + navire (en 3 fois)400,50
72856141162024-03-30 16:25:00ValidéVIGIERYanVIGIERYanyanvigier63@gmail.comFort + navire (en 3 fois)400,50
\n", "
" ], "text/plain": [ " Référence commande Date de la commande Statut de la commande \\\n", "71 85614116 2024-03-30 16:25:00 Validé \n", "72 85614116 2024-03-30 16:25:00 Validé \n", "\n", " Nom participant Prénom participant Nom payeur Prénom payeur \\\n", "71 RAIMBAULT Cécile VIGIER Yan \n", "72 VIGIER Yan VIGIER Yan \n", "\n", " Email payeur Tarif Montant tarif \n", "71 yanvigier63@gmail.com Fort + navire (en 3 fois) 400,50 \n", "72 yanvigier63@gmail.com Fort + navire (en 3 fois) 400,50 " ] }, "execution_count": 66, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_billets_juin[df_billets_juin['Nom payeur'] == 'VIGIER']" ] }, { "cell_type": "markdown", "id": "3398e20e-0146-41b3-a4fe-bca5b3a72010", "metadata": {}, "source": [ "### Lecture billets septembre (billeterie)" ] }, { "cell_type": "code", "execution_count": 16, "id": "b0b75b10-3805-4570-9597-2c87d93e5927", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "lecture du fichier ./data/billets_septembre\\export-gn-black-revenge-la-republique-libre-pirate-les-nuits-de-beltane-06_11_2024-01_02_2025.csv ...\n" ] } ], "source": [ "repertoire_billets_septembre = \"./data/billets_septembre\" # Remplacez par le chemin de votre répertoire\n", "fichier_recent = trouver_fichier_le_plus_recent(repertoire_billets_septembre)\n", "if not fichier_recent:\n", " print(\"Le répertoire est vide ou ne contient pas de fichiers.\")\n", " exit(1)\n", "print(f\"lecture du fichier {fichier_recent} ...\")" ] }, { "cell_type": "code", "execution_count": 17, "id": "50097bd0-a619-4bed-a629-6ad0f9595adc", "metadata": {}, "outputs": [], "source": [ "_usecols= [\n", " 'Référence commande', \n", " 'Date de la commande',\n", " 'Statut de la commande',\n", " 'Nom participant',\n", " 'Prénom participant',\n", " 'Nom payeur',\n", " 'Prénom payeur',\n", " 'Email payeur',\n", " 'Tarif',\n", " 'Montant tarif'\n", "]" ] }, { "cell_type": "code", "execution_count": 18, "id": "d2ed99d7-00c0-469f-87e2-2ad1140606ca", "metadata": {}, "outputs": [], "source": [ "_dtype = {}\n", "_dtype.setdefault(str)\n", "_dates=[\"Date de la commande\"]\n", "df_billets_septembre = pd.read_csv(fichier_recent, sep=';', usecols=_usecols, dtype=_dtype)\n", "for d in _dates:\n", " df_billets_septembre[d] = pd.to_datetime(df_billets_septembre[d], format='%d/%m/%Y %H:%M')\n", "df_billets_septembre['Nom participant'] = df_billets_septembre['Nom participant'].astype(str).str.strip().str.upper()\n", "df_billets_septembre['Prénom participant'] = df_billets_septembre['Prénom participant'].astype(str).str.strip().str.capitalize()\n", "df_billets_septembre['Email payeur'] = df_billets_septembre['Email payeur'].astype(str).str.strip().str.lower()\n", "df_billets_septembre['Nom payeur'] = df_billets_septembre['Nom payeur'].astype(str).str.strip().str.upper()\n", "df_billets_septembre['Prénom payeur'] = df_billets_septembre['Prénom payeur'].astype(str).str.strip().str.capitalize()\n", "# Date limite\n", "date_limite = pd.to_datetime('2024-01-01')\n", "# Sélection des lignes\n", "d= 'Date de la commande'\n", "df_billets_septembre = df_billets_septembre[df_billets_septembre[d] >= date_limite]" ] }, { "cell_type": "code", "execution_count": 19, "id": "adb5e0dc-0e18-4ee4-ab74-1c25e96fa521", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeDate de la commandeStatut de la commandeNom participantPrénom participantNom payeurPrénom payeurEmail payeurTarifMontant tarif
01177675802025-01-29 11:11:00ValidéVOINOTSébastienVOINOTSébastiensebvoinot@yahoo.frNavire+fort400,00
11172432472025-01-24 15:29:00ValidéROLLINCecileROLLINCecilececile.rollin@gmail.comNavire+fort400,00
21172002662025-01-24 08:54:00ValidéMOULINPhilippeMOULINPhilippemoulin.philippe@gmail.comNavire+fort400,00
31170772842025-01-23 06:07:00ValidéPETITVincentPETITVincentvincentsterne@yahoo.frFort200,00
41169459892025-01-21 22:57:00ValidéPHILBERTSophiePHILBERTSophiephilbert.charles@neuf.frFort200,00
51165725982025-01-18 18:01:00ValidéJULLIENAgnèsJULLIENAgnèsag9734@yahoo.comNavire+fort400,00
61160419022025-01-14 08:43:00ValidéGIRAUDCarolineGIRAUDCarolineblue.hirondelle@gmail.comNavire+fort400,00
71159753912025-01-13 16:14:00ValidéTALLONAnyaTALLONAnyaanya.tallon@gmail.comFort200,00
81155502522025-01-09 16:11:00ValidéJONASThomasJONASThomasblack_writer@hotmail.frNavire+fort400,00
91152467622025-01-06 21:05:00ValidéTROCQUETDanielTROCQUETDanieltrocquetdaniel@gmal.comNavire+fort400,00
101128059212024-12-05 21:44:00ValidéTESTARDSolineTESTARDSolinetsoline30@gmail.comNavire+fort400,00
111124683772024-12-03 12:05:00ValidéCOSTERGGaelCOSTERGGaelg.costerg@gmail.comNavire+fort400,00
121115096402024-11-25 19:43:00ValidéHARRANDChloéHARRANDChloéchloeharrand@gmail.comFort200,00
131110570382024-11-21 20:54:00ValidéORTALOPierreORTALOPierrepierre@yuzupulse.euNavire+fort400,00
141110407092024-11-21 19:22:00ValidéBULLIERMaximeBULLIERMaximemaxime.bullier@hotmail.frFort200,00
151101143632024-11-14 16:49:00ValidéFLAMMANNSashaFLAMMANNSashasasha.flammann@gmail.comNavire+fort400,00
161099651362024-11-13 15:53:00ValidéGARROSAlbanGARROSAlbanalban.garros@gmail.comNavire+fort400,00
171099247402024-11-13 11:16:00ValidéGUTIERREZJeremyGUTIERREZJeremyjeremy.gutierrez.pharma@gmail.comNavire+fort400,00
181096460322024-11-11 12:27:00ValidéSTOLTZCharlineSTOLTZCharlinecharline.stoltz@gmail.comNavire+fort400,00
191095451002024-11-10 12:51:00ValidéVANDROUXKarineVANDROUXKarinekadroux@gmail.comNavire+fort400,00
201091931072024-11-07 17:18:00ValidéBONNECARRÈREJulieFLEUTOTAlboflèdealba.fleutot@gmail.comNavire+fort400,00
211090791412024-11-06 20:12:00ValidéAMOUREUXErwanAMOUREUXErwanerwan.amoureux@gmail.comNavire+fort400,00
\n", "
" ], "text/plain": [ " Référence commande Date de la commande Statut de la commande \\\n", "0 117767580 2025-01-29 11:11:00 Validé \n", "1 117243247 2025-01-24 15:29:00 Validé \n", "2 117200266 2025-01-24 08:54:00 Validé \n", "3 117077284 2025-01-23 06:07:00 Validé \n", "4 116945989 2025-01-21 22:57:00 Validé \n", "5 116572598 2025-01-18 18:01:00 Validé \n", "6 116041902 2025-01-14 08:43:00 Validé \n", "7 115975391 2025-01-13 16:14:00 Validé \n", "8 115550252 2025-01-09 16:11:00 Validé \n", "9 115246762 2025-01-06 21:05:00 Validé \n", "10 112805921 2024-12-05 21:44:00 Validé \n", "11 112468377 2024-12-03 12:05:00 Validé \n", "12 111509640 2024-11-25 19:43:00 Validé \n", "13 111057038 2024-11-21 20:54:00 Validé \n", "14 111040709 2024-11-21 19:22:00 Validé \n", "15 110114363 2024-11-14 16:49:00 Validé \n", "16 109965136 2024-11-13 15:53:00 Validé \n", "17 109924740 2024-11-13 11:16:00 Validé \n", "18 109646032 2024-11-11 12:27:00 Validé \n", "19 109545100 2024-11-10 12:51:00 Validé \n", "20 109193107 2024-11-07 17:18:00 Validé \n", "21 109079141 2024-11-06 20:12:00 Validé \n", "\n", " Nom participant Prénom participant Nom payeur Prénom payeur \\\n", "0 VOINOT Sébastien VOINOT Sébastien \n", "1 ROLLIN Cecile ROLLIN Cecile \n", "2 MOULIN Philippe MOULIN Philippe \n", "3 PETIT Vincent PETIT Vincent \n", "4 PHILBERT Sophie PHILBERT Sophie \n", "5 JULLIEN Agnès JULLIEN Agnès \n", "6 GIRAUD Caroline GIRAUD Caroline \n", "7 TALLON Anya TALLON Anya \n", "8 JONAS Thomas JONAS Thomas \n", "9 TROCQUET Daniel TROCQUET Daniel \n", "10 TESTARD Soline TESTARD Soline \n", "11 COSTERG Gael COSTERG Gael \n", "12 HARRAND Chloé HARRAND Chloé \n", "13 ORTALO Pierre ORTALO Pierre \n", "14 BULLIER Maxime BULLIER Maxime \n", "15 FLAMMANN Sasha FLAMMANN Sasha \n", "16 GARROS Alban GARROS Alban \n", "17 GUTIERREZ Jeremy GUTIERREZ Jeremy \n", "18 STOLTZ Charline STOLTZ Charline \n", "19 VANDROUX Karine VANDROUX Karine \n", "20 BONNECARRÈRE Julie FLEUTOT Alboflède \n", "21 AMOUREUX Erwan AMOUREUX Erwan \n", "\n", " Email payeur Tarif Montant tarif \n", "0 sebvoinot@yahoo.fr Navire+fort 400,00 \n", "1 cecile.rollin@gmail.com Navire+fort 400,00 \n", "2 moulin.philippe@gmail.com Navire+fort 400,00 \n", "3 vincentsterne@yahoo.fr Fort 200,00 \n", "4 philbert.charles@neuf.fr Fort 200,00 \n", "5 ag9734@yahoo.com Navire+fort 400,00 \n", "6 blue.hirondelle@gmail.com Navire+fort 400,00 \n", "7 anya.tallon@gmail.com Fort 200,00 \n", "8 black_writer@hotmail.fr Navire+fort 400,00 \n", "9 trocquetdaniel@gmal.com Navire+fort 400,00 \n", "10 tsoline30@gmail.com Navire+fort 400,00 \n", "11 g.costerg@gmail.com Navire+fort 400,00 \n", "12 chloeharrand@gmail.com Fort 200,00 \n", "13 pierre@yuzupulse.eu Navire+fort 400,00 \n", "14 maxime.bullier@hotmail.fr Fort 200,00 \n", "15 sasha.flammann@gmail.com Navire+fort 400,00 \n", "16 alban.garros@gmail.com Navire+fort 400,00 \n", "17 jeremy.gutierrez.pharma@gmail.com Navire+fort 400,00 \n", "18 charline.stoltz@gmail.com Navire+fort 400,00 \n", "19 kadroux@gmail.com Navire+fort 400,00 \n", "20 alba.fleutot@gmail.com Navire+fort 400,00 \n", "21 erwan.amoureux@gmail.com Navire+fort 400,00 " ] }, "execution_count": 19, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_billets_septembre" ] }, { "cell_type": "code", "execution_count": 38, "id": "cbc753a4-5656-47e9-a7fa-52c4abb0ce6e", "metadata": {}, "outputs": [], "source": [ "df_billets = pd.concat([df_billets_juin,df_billets_septembre])" ] }, { "cell_type": "code", "execution_count": 39, "id": "6d9f5369-33c9-46ab-8fce-ba86dd589941", "metadata": {}, "outputs": [], "source": [ "df_all = pd.merge(left=df_versements, right=df_billets, left_on='Référence commande', right_on='Référence commande', how='outer')" ] }, { "cell_type": "code", "execution_count": 40, "id": "ea84a742-075f-433c-9bdf-442dc6636e88", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeMontant totalDate du paiementStatut du paiementVerséNom payeur_xPrénom payeur_xEmail payeur_xCampagneType de campagne...Montant du tarifDate de la commandeStatut de la commandeNom participantPrénom participantNom payeur_yPrénom payeur_yEmail payeur_yTarifMontant tarif
078660977133.52024-09-06 03:21:01PayéOuiPHILBERTCharlesphilbert.charles@neuf.frRetour à Nassau V1 JuinAdhésion...133,502024-01-19 10:23:00ValidéPHILBERTCharlesPHILBERTCharlesphilbert.charles@neuf.frFort + navire (en 3 fois)400,50
178660977133.52024-06-06 03:11:41PayéOuiPHILBERTCharlesphilbert.charles@neuf.frRetour à Nassau V1 JuinAdhésion...133,502024-01-19 10:23:00ValidéPHILBERTCharlesPHILBERTCharlesphilbert.charles@neuf.frFort + navire (en 3 fois)400,50
278660977133.52024-01-19 10:23:16PayéOuiPHILBERTCharlesphilbert.charles@neuf.frRetour à Nassau V1 JuinAdhésion...133,502024-01-19 10:23:00ValidéPHILBERTCharlesPHILBERTCharlesphilbert.charles@neuf.frFort + navire (en 3 fois)400,50
378736362400.02024-01-20 09:42:27PayéOuiBUCASEricsacub@sfr.frRetour à Nassau V1 JuinAdhésion...400,002024-01-20 09:42:00ValidéBUCASEricBUCASEricsacub@sfr.frFort + navire400,00
478787282400.02024-01-20 19:53:25PayéOuiJACQGaëllegaellejacq@yahoo.comRetour à Nassau V1 JuinAdhésion...400,002024-01-20 19:53:00ValidéJACQGaëlleJACQGaëllegaellejacq@yahoo.comFort + navire400,00
..................................................................
157117243247400.02025-01-24 15:29:11PayéNonROLLINCecilececile.rollin@gmail.comGN Black Revenge - la République libre pirate ...Billetterie...400,002025-01-24 15:29:00ValidéROLLINCecileROLLINCecilececile.rollin@gmail.comNavire+fort400,00
158117558065133.52025-01-27 16:06:13PayéNonFARWilliamwilliam.daniel.far@gmail.comRetour à Nassau V1 JuinAdhésion...133,502025-01-27 16:06:00ValidéFARWilliamFARWilliamwilliam.daniel.far@gmail.comFort + navire (en 3 fois SEPTEMBRE UNIQUEMENT)400,50
159117767580400.02025-01-29 11:11:56PayéNonVOINOTSébastiensebvoinot@yahoo.frGN Black Revenge - la République libre pirate ...Billetterie...400,002025-01-29 11:11:00ValidéVOINOTSébastienVOINOTSébastiensebvoinot@yahoo.frNavire+fort400,00
160117893944400.02025-01-30 10:28:36PayéNonYOGANANTHANKarunacontact@karuna.proRetour à Nassau V1 JuinAdhésion...400,002025-01-30 10:28:00ValidéYOGANANTHANKarunaYOGANANTHANKarunacontact@karuna.proFort + navire400,00
161117898424133.52025-01-30 11:03:33PayéNonGANTETGuillaumeguilland@gmail.comRetour à Nassau V1 JuinAdhésion...133,502025-01-30 11:03:00ValidéGANTETGuillaumeGANTETGuillaumeguilland@gmail.comFort + navire (en 3 fois SEPTEMBRE UNIQUEMENT)400,50
\n", "

162 rows × 21 columns

\n", "
" ], "text/plain": [ " Référence commande Montant total Date du paiement Statut du paiement \\\n", "0 78660977 133.5 2024-09-06 03:21:01 Payé \n", "1 78660977 133.5 2024-06-06 03:11:41 Payé \n", "2 78660977 133.5 2024-01-19 10:23:16 Payé \n", "3 78736362 400.0 2024-01-20 09:42:27 Payé \n", "4 78787282 400.0 2024-01-20 19:53:25 Payé \n", ".. ... ... ... ... \n", "157 117243247 400.0 2025-01-24 15:29:11 Payé \n", "158 117558065 133.5 2025-01-27 16:06:13 Payé \n", "159 117767580 400.0 2025-01-29 11:11:56 Payé \n", "160 117893944 400.0 2025-01-30 10:28:36 Payé \n", "161 117898424 133.5 2025-01-30 11:03:33 Payé \n", "\n", " Versé Nom payeur_x Prénom payeur_x Email payeur_x \\\n", "0 Oui PHILBERT Charles philbert.charles@neuf.fr \n", "1 Oui PHILBERT Charles philbert.charles@neuf.fr \n", "2 Oui PHILBERT Charles philbert.charles@neuf.fr \n", "3 Oui BUCAS Eric sacub@sfr.fr \n", "4 Oui JACQ Gaëlle gaellejacq@yahoo.com \n", ".. ... ... ... ... \n", "157 Non ROLLIN Cecile cecile.rollin@gmail.com \n", "158 Non FAR William william.daniel.far@gmail.com \n", "159 Non VOINOT Sébastien sebvoinot@yahoo.fr \n", "160 Non YOGANANTHAN Karuna contact@karuna.pro \n", "161 Non GANTET Guillaume guilland@gmail.com \n", "\n", " Campagne Type de campagne ... \\\n", "0 Retour à Nassau V1 Juin Adhésion ... \n", "1 Retour à Nassau V1 Juin Adhésion ... \n", "2 Retour à Nassau V1 Juin Adhésion ... \n", "3 Retour à Nassau V1 Juin Adhésion ... \n", "4 Retour à Nassau V1 Juin Adhésion ... \n", ".. ... ... ... \n", "157 GN Black Revenge - la République libre pirate ... Billetterie ... \n", "158 Retour à Nassau V1 Juin Adhésion ... \n", "159 GN Black Revenge - la République libre pirate ... Billetterie ... \n", "160 Retour à Nassau V1 Juin Adhésion ... \n", "161 Retour à Nassau V1 Juin Adhésion ... \n", "\n", " Montant du tarif Date de la commande Statut de la commande \\\n", "0 133,50 2024-01-19 10:23:00 Validé \n", "1 133,50 2024-01-19 10:23:00 Validé \n", "2 133,50 2024-01-19 10:23:00 Validé \n", "3 400,00 2024-01-20 09:42:00 Validé \n", "4 400,00 2024-01-20 19:53:00 Validé \n", ".. ... ... ... \n", "157 400,00 2025-01-24 15:29:00 Validé \n", "158 133,50 2025-01-27 16:06:00 Validé \n", "159 400,00 2025-01-29 11:11:00 Validé \n", "160 400,00 2025-01-30 10:28:00 Validé \n", "161 133,50 2025-01-30 11:03:00 Validé \n", "\n", " Nom participant Prénom participant Nom payeur_y Prénom payeur_y \\\n", "0 PHILBERT Charles PHILBERT Charles \n", "1 PHILBERT Charles PHILBERT Charles \n", "2 PHILBERT Charles PHILBERT Charles \n", "3 BUCAS Eric BUCAS Eric \n", "4 JACQ Gaëlle JACQ Gaëlle \n", ".. ... ... ... ... \n", "157 ROLLIN Cecile ROLLIN Cecile \n", "158 FAR William FAR William \n", "159 VOINOT Sébastien VOINOT Sébastien \n", "160 YOGANANTHAN Karuna YOGANANTHAN Karuna \n", "161 GANTET Guillaume GANTET Guillaume \n", "\n", " Email payeur_y \\\n", "0 philbert.charles@neuf.fr \n", "1 philbert.charles@neuf.fr \n", "2 philbert.charles@neuf.fr \n", "3 sacub@sfr.fr \n", "4 gaellejacq@yahoo.com \n", ".. ... \n", "157 cecile.rollin@gmail.com \n", "158 william.daniel.far@gmail.com \n", "159 sebvoinot@yahoo.fr \n", "160 contact@karuna.pro \n", "161 guilland@gmail.com \n", "\n", " Tarif Montant tarif \n", "0 Fort + navire (en 3 fois) 400,50 \n", "1 Fort + navire (en 3 fois) 400,50 \n", "2 Fort + navire (en 3 fois) 400,50 \n", "3 Fort + navire 400,00 \n", "4 Fort + navire 400,00 \n", ".. ... ... \n", "157 Navire+fort 400,00 \n", "158 Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) 400,50 \n", "159 Navire+fort 400,00 \n", "160 Fort + navire 400,00 \n", "161 Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) 400,50 \n", "\n", "[162 rows x 21 columns]" ] }, "execution_count": 40, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_all" ] }, { "cell_type": "code", "execution_count": 51, "id": "0597c8d4-3528-437b-8c1f-4fedead1fae6", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeMontant totalDate du paiementStatut du paiementVerséNom payeurPrénom payeurEmail payeurCampagneType de campagneTypeMontant du tarif
10285614116267.02024-09-06 03:20:00PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois267,00
12985614116267.02024-06-06 03:05:31PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois267,00
13585614116267.02024-03-30 16:25:40PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois267,00
\n", "
" ], "text/plain": [ " Référence commande Montant total Date du paiement Statut du paiement \\\n", "102 85614116 267.0 2024-09-06 03:20:00 Payé \n", "129 85614116 267.0 2024-06-06 03:05:31 Payé \n", "135 85614116 267.0 2024-03-30 16:25:40 Payé \n", "\n", " Versé Nom payeur Prénom payeur Email payeur \\\n", "102 Oui VIGIER Yan yanvigier63@gmail.com \n", "129 Oui VIGIER Yan yanvigier63@gmail.com \n", "135 Oui VIGIER Yan yanvigier63@gmail.com \n", "\n", " Campagne Type de campagne Type \\\n", "102 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "129 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "135 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "\n", " Montant du tarif \n", "102 267,00 \n", "129 267,00 \n", "135 267,00 " ] }, "execution_count": 51, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_versements[df_versements['Nom payeur'] == 'VIGIER']\n" ] }, { "cell_type": "code", "execution_count": 50, "id": "30501b5c-c092-4aea-b295-7bc57f3eb457", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeMontant totalDate du paiementStatut du paiementVerséNom payeur_xPrénom payeur_xEmail payeur_xCampagneType de campagne...Montant du tarifDate de la commandeStatut de la commandeNom participantPrénom participantNom payeur_yPrénom payeur_yEmail payeur_yTarifMontant tarif
3585614116267.02024-09-06 03:20:00PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésion...267,002024-03-30 16:25:00ValidéVIGIERYanVIGIERYanyanvigier63@gmail.comFort + navire (en 3 fois)400,50
3785614116267.02024-06-06 03:05:31PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésion...267,002024-03-30 16:25:00ValidéVIGIERYanVIGIERYanyanvigier63@gmail.comFort + navire (en 3 fois)400,50
3985614116267.02024-03-30 16:25:40PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésion...267,002024-03-30 16:25:00ValidéVIGIERYanVIGIERYanyanvigier63@gmail.comFort + navire (en 3 fois)400,50
\n", "

3 rows × 21 columns

\n", "
" ], "text/plain": [ " Référence commande Montant total Date du paiement Statut du paiement \\\n", "35 85614116 267.0 2024-09-06 03:20:00 Payé \n", "37 85614116 267.0 2024-06-06 03:05:31 Payé \n", "39 85614116 267.0 2024-03-30 16:25:40 Payé \n", "\n", " Versé Nom payeur_x Prénom payeur_x Email payeur_x \\\n", "35 Oui VIGIER Yan yanvigier63@gmail.com \n", "37 Oui VIGIER Yan yanvigier63@gmail.com \n", "39 Oui VIGIER Yan yanvigier63@gmail.com \n", "\n", " Campagne Type de campagne ... Montant du tarif \\\n", "35 Retour à Nassau V1 Juin Adhésion ... 267,00 \n", "37 Retour à Nassau V1 Juin Adhésion ... 267,00 \n", "39 Retour à Nassau V1 Juin Adhésion ... 267,00 \n", "\n", " Date de la commande Statut de la commande Nom participant \\\n", "35 2024-03-30 16:25:00 Validé VIGIER \n", "37 2024-03-30 16:25:00 Validé VIGIER \n", "39 2024-03-30 16:25:00 Validé VIGIER \n", "\n", " Prénom participant Nom payeur_y Prénom payeur_y Email payeur_y \\\n", "35 Yan VIGIER Yan yanvigier63@gmail.com \n", "37 Yan VIGIER Yan yanvigier63@gmail.com \n", "39 Yan VIGIER Yan yanvigier63@gmail.com \n", "\n", " Tarif Montant tarif \n", "35 Fort + navire (en 3 fois) 400,50 \n", "37 Fort + navire (en 3 fois) 400,50 \n", "39 Fort + navire (en 3 fois) 400,50 \n", "\n", "[3 rows x 21 columns]" ] }, "execution_count": 50, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_all[df_all['Nom participant'] == 'VIGIER']\n" ] }, { "cell_type": "code", "execution_count": 67, "id": "94706079-4a20-46a9-aaa4-a5d149323d1a", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
somme_versee
Nom participantPrénom participant
AMOUREUXErwan400.0
ARDALANPouria200.0
ARVIN-BEROD GOSETFlorence400.0
BATTUNGCoralie267.0
BERGERETMathieu400.5
BESSIÈREJohanna400.0
BIRATStéphanie400.0
BONFYAmélia267.0
BONNECARRÈREJulie400.0
BOUHEDJANawel267.0
BOURDETTEJulien400.0
BOUROUMEAUKévin267.0
BRANDELYGuillaume272.0
BRULEMélanie400.0
BUCASEric400.0
BULLIERMaxime200.0
CARPENTIERGuillaume267.0
CERUTTILaëtitia400.5
CHAMONTINFlorian133.5
CHAPELONRomain267.0
CHASSERATEmmanuel267.0
CHOJNICKISolenn267.0
CORNETRenart400.0
CORNUFrancoise133.4
COSTERGGael400.0
DANCOTOlivier267.0
DAVIDCédric405.5
DEJARNACPierre200.0
DELAPORTEArnaud400.0
DUMASMarc200.0
DUVERTGuy-roger405.0
EUVEMaxime400.0
FABREAlexandre267.0
FARWilliam133.5
FLAMMANNSasha400.0
FRACHONAurélia267.0
GANTETGuillaume133.5
GARCIAHugo267.0
GARROSAlban400.0
GAYOTEléna267.0
GERBERONElodie400.5
GIRAUDCaroline400.0
GOURYFabien133.5
GRUNEMWALDThomas400.0
GUEXBenjamin400.0
GUTIERREZJeremy400.0
GUYOTRomain133.5
HARRANDChloé200.0
HURELMarcouf400.5
JACQGaëlle400.0
JALLETBenoit400.0
JEGONDAYXavier133.5
JONASThomas400.0
JULLIENAgnès400.0
LAFOSSECandice267.0
LAIRFrançois410.0
LALLIERFrédéric400.0
Olivier267.0
LAURENTSaada133.5
LENOUVELMaryline200.0
LETTERONSebastien205.0
LORENTEYann200.1
LUCARELLIJean-yves400.0
MAGNANTCatherine400.5
MAILLOTRoland138.4
MARCELIN-GABRIELMagali200.0
MARECHALWilliam267.0
MAURYAurélie800.0
Raphaël800.0
MAYORTom400.0
MOULINPhilippe400.0
MÉRANDNicolas400.0
MÉRONThomas400.0
NICOLETRobin400.0
ORFEUVREEmilie200.0
ORTALOPierre400.0
PAYENRenaud205.0
PELTIERJean-philippe801.0
PETITVincent220.0
PHILBERTCharles400.5
Sophie200.0
PICHOTClaire133.5
PICQDylan133.4
PITELMarion200.0
POIMBOEUFThibault400.0
QUINTEROFlorie200.0
RAIMBAULTCécile801.0
RICHARDMarion800.0
Patrice800.0
RICHERPriscillia267.0
RIGAUDVéronique400.5
ROLLINCecile400.0
ROZIERMorgane801.0
RÉVEILJean carly400.0
SCHEUBERJoachim133.5
SECHERGaël400.0
SEMPÉRÉLionel200.0
SERVELManon133.5
STOLTZCharline400.0
SUPIOTLara133.4
TALLONAnya200.0
TESTARDSoline400.0
TROCQUETDaniel400.0
VACARILydia133.4
VAESThomas400.5
VANDROUXKarine400.0
VIGIERYan801.0
VIGNIERFanny400.5
VOINOTSébastien400.0
WARSZAWSKIJessica400.5
YOGANANTHANKaruna400.0
\n", "
" ], "text/plain": [ " somme_versee\n", "Nom participant Prénom participant \n", "AMOUREUX Erwan 400.0\n", "ARDALAN Pouria 200.0\n", "ARVIN-BEROD GOSET Florence 400.0\n", "BATTUNG Coralie 267.0\n", "BERGERET Mathieu 400.5\n", "BESSIÈRE Johanna 400.0\n", "BIRAT Stéphanie 400.0\n", "BONFY Amélia 267.0\n", "BONNECARRÈRE Julie 400.0\n", "BOUHEDJA Nawel 267.0\n", "BOURDETTE Julien 400.0\n", "BOUROUMEAU Kévin 267.0\n", "BRANDELY Guillaume 272.0\n", "BRULE Mélanie 400.0\n", "BUCAS Eric 400.0\n", "BULLIER Maxime 200.0\n", "CARPENTIER Guillaume 267.0\n", "CERUTTI Laëtitia 400.5\n", "CHAMONTIN Florian 133.5\n", "CHAPELON Romain 267.0\n", "CHASSERAT Emmanuel 267.0\n", "CHOJNICKI Solenn 267.0\n", "CORNET Renart 400.0\n", "CORNU Francoise 133.4\n", "COSTERG Gael 400.0\n", "DANCOT Olivier 267.0\n", "DAVID Cédric 405.5\n", "DEJARNAC Pierre 200.0\n", "DELAPORTE Arnaud 400.0\n", "DUMAS Marc 200.0\n", "DUVERT Guy-roger 405.0\n", "EUVE Maxime 400.0\n", "FABRE Alexandre 267.0\n", "FAR William 133.5\n", "FLAMMANN Sasha 400.0\n", "FRACHON Aurélia 267.0\n", "GANTET Guillaume 133.5\n", "GARCIA Hugo 267.0\n", "GARROS Alban 400.0\n", "GAYOT Eléna 267.0\n", "GERBERON Elodie 400.5\n", "GIRAUD Caroline 400.0\n", "GOURY Fabien 133.5\n", "GRUNEMWALD Thomas 400.0\n", "GUEX Benjamin 400.0\n", "GUTIERREZ Jeremy 400.0\n", "GUYOT Romain 133.5\n", "HARRAND Chloé 200.0\n", "HUREL Marcouf 400.5\n", "JACQ Gaëlle 400.0\n", "JALLET Benoit 400.0\n", "JEGONDAY Xavier 133.5\n", "JONAS Thomas 400.0\n", "JULLIEN Agnès 400.0\n", "LAFOSSE Candice 267.0\n", "LAIR François 410.0\n", "LALLIER Frédéric 400.0\n", " Olivier 267.0\n", "LAURENT Saada 133.5\n", "LENOUVEL Maryline 200.0\n", "LETTERON Sebastien 205.0\n", "LORENTE Yann 200.1\n", "LUCARELLI Jean-yves 400.0\n", "MAGNANT Catherine 400.5\n", "MAILLOT Roland 138.4\n", "MARCELIN-GABRIEL Magali 200.0\n", "MARECHAL William 267.0\n", "MAURY Aurélie 800.0\n", " Raphaël 800.0\n", "MAYOR Tom 400.0\n", "MOULIN Philippe 400.0\n", "MÉRAND Nicolas 400.0\n", "MÉRON Thomas 400.0\n", "NICOLET Robin 400.0\n", "ORFEUVRE Emilie 200.0\n", "ORTALO Pierre 400.0\n", "PAYEN Renaud 205.0\n", "PELTIER Jean-philippe 801.0\n", "PETIT Vincent 220.0\n", "PHILBERT Charles 400.5\n", " Sophie 200.0\n", "PICHOT Claire 133.5\n", "PICQ Dylan 133.4\n", "PITEL Marion 200.0\n", "POIMBOEUF Thibault 400.0\n", "QUINTERO Florie 200.0\n", "RAIMBAULT Cécile 801.0\n", "RICHARD Marion 800.0\n", " Patrice 800.0\n", "RICHER Priscillia 267.0\n", "RIGAUD Véronique 400.5\n", "ROLLIN Cecile 400.0\n", "ROZIER Morgane 801.0\n", "RÉVEIL Jean carly 400.0\n", "SCHEUBER Joachim 133.5\n", "SECHER Gaël 400.0\n", "SEMPÉRÉ Lionel 200.0\n", "SERVEL Manon 133.5\n", "STOLTZ Charline 400.0\n", "SUPIOT Lara 133.4\n", "TALLON Anya 200.0\n", "TESTARD Soline 400.0\n", "TROCQUET Daniel 400.0\n", "VACARI Lydia 133.4\n", "VAES Thomas 400.5\n", "VANDROUX Karine 400.0\n", "VIGIER Yan 801.0\n", "VIGNIER Fanny 400.5\n", "VOINOT Sébastien 400.0\n", "WARSZAWSKI Jessica 400.5\n", "YOGANANTHAN Karuna 400.0" ] }, "execution_count": 67, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_versements_joueur = df_all.groupby(['Nom participant', 'Prénom participant']).agg(somme_versee=('Montant total','sum'))\n", "pd.set_option('display.max_rows', None)\n", "df_versements_joueur" ] }, { "cell_type": "code", "execution_count": 45, "id": "117fb550-7fc4-4f4e-b678-6a58a3dcb8ac", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeMontant totalDate du paiementStatut du paiementVerséNom payeur_xPrénom payeur_xEmail payeur_xCampagneType de campagne...Montant du tarifDate de la commandeStatut de la commandeNom participantPrénom participantNom payeur_yPrénom payeur_yEmail payeur_yTarifMontant tarif
7810102631266.72024-11-12 19:06:02RefuséNonCORNUFrancoisewamael@aol.comRetour à Nassau V1 JuinAdhésion...66,702024-09-07 13:01:00ValidéCORNUFrancoiseCORNUFrancoisewamael@aol.comFort (en 3 fois)200,10
95102753570133.52024-11-05 09:53:40RefuséNonFABREAlexandrealexandre.fabre@free.frRetour à Nassau V1 JuinAdhésion...133,502024-09-19 12:42:00ValidéFABREAlexandreFABREAlexandrealexandre.fabre@free.frFort + navire (en 3 fois)400,50
107103971089133.52024-11-05 08:44:40RefuséNonGARCIAHugohugo@garcia-cotte.comRetour à Nassau V1 JuinAdhésion...133,502024-09-27 21:49:00ValidéGARCIAHugoGARCIAHugohugo@garcia-cotte.comFort + navire (en 3 fois)400,50
\n", "

3 rows × 21 columns

\n", "
" ], "text/plain": [ " Référence commande Montant total Date du paiement Statut du paiement \\\n", "78 101026312 66.7 2024-11-12 19:06:02 Refusé \n", "95 102753570 133.5 2024-11-05 09:53:40 Refusé \n", "107 103971089 133.5 2024-11-05 08:44:40 Refusé \n", "\n", " Versé Nom payeur_x Prénom payeur_x Email payeur_x \\\n", "78 Non CORNU Francoise wamael@aol.com \n", "95 Non FABRE Alexandre alexandre.fabre@free.fr \n", "107 Non GARCIA Hugo hugo@garcia-cotte.com \n", "\n", " Campagne Type de campagne ... Montant du tarif \\\n", "78 Retour à Nassau V1 Juin Adhésion ... 66,70 \n", "95 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "107 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "\n", " Date de la commande Statut de la commande Nom participant \\\n", "78 2024-09-07 13:01:00 Validé CORNU \n", "95 2024-09-19 12:42:00 Validé FABRE \n", "107 2024-09-27 21:49:00 Validé GARCIA \n", "\n", " Prénom participant Nom payeur_y Prénom payeur_y Email payeur_y \\\n", "78 Francoise CORNU Francoise wamael@aol.com \n", "95 Alexandre FABRE Alexandre alexandre.fabre@free.fr \n", "107 Hugo GARCIA Hugo hugo@garcia-cotte.com \n", "\n", " Tarif Montant tarif \n", "78 Fort (en 3 fois) 200,10 \n", "95 Fort + navire (en 3 fois) 400,50 \n", "107 Fort + navire (en 3 fois) 400,50 \n", "\n", "[3 rows x 21 columns]" ] }, "execution_count": 45, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_all[df_all['Statut du paiement'] == 'Refusé']\n", "#df_all.columns" ] }, { "cell_type": "markdown", "id": "d250ba93-b044-47fd-ace0-40dce4f62d1c", "metadata": {}, "source": [ "### E-mails payeur --> E-mails joueur" ] }, { "cell_type": "code", "execution_count": 23, "id": "53feaffd-262a-4960-a6d3-d74a50635eaa", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Nom payeurPrénom payeurEmail payeursomme_versee
0AMOUREUXErwanerwan.amoureux@gmail.com400.0
1ARDALANPouriapepebicho@yahoo.com200.0
2ARVIN-BEROD GOSETFlorenceflofloab@yahoo.fr400.0
3BATTUNGCoraliecorabattung@gmail.com267.0
4BERGERETMathieubergeretmathieu.pro@gmail.com400.5
...............
99VIGIERYanyanvigier63@gmail.com801.0
100VIGNIERFannyfannyvignier@hotmail.fr400.5
101VOINOTSébastiensebvoinot@yahoo.fr400.0
102WARSZAWSKIJessicajessica.warszawski@gmail.com400.5
103YOGANANTHANKarunacontact@karuna.pro400.0
\n", "

104 rows × 4 columns

\n", "
" ], "text/plain": [ " Nom payeur Prénom payeur Email payeur \\\n", "0 AMOUREUX Erwan erwan.amoureux@gmail.com \n", "1 ARDALAN Pouria pepebicho@yahoo.com \n", "2 ARVIN-BEROD GOSET Florence flofloab@yahoo.fr \n", "3 BATTUNG Coralie corabattung@gmail.com \n", "4 BERGERET Mathieu bergeretmathieu.pro@gmail.com \n", ".. ... ... ... \n", "99 VIGIER Yan yanvigier63@gmail.com \n", "100 VIGNIER Fanny fannyvignier@hotmail.fr \n", "101 VOINOT Sébastien sebvoinot@yahoo.fr \n", "102 WARSZAWSKI Jessica jessica.warszawski@gmail.com \n", "103 YOGANANTHAN Karuna contact@karuna.pro \n", "\n", " somme_versee \n", "0 400.0 \n", "1 200.0 \n", "2 400.0 \n", "3 267.0 \n", "4 400.5 \n", ".. ... \n", "99 801.0 \n", "100 400.5 \n", "101 400.0 \n", "102 400.5 \n", "103 400.0 \n", "\n", "[104 rows x 4 columns]" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "correspondance_email = {\n", " \"alba.fleutot@gmail.com\": \"julie@nebulae.world\",\n", " \"j.warszawski@hotmail.fr\": \"jessica.warszawski@gmail.com\",\n", " \"larasupiot@hotmail.fr\": \"larasupiot@gmail.com\",\n", " \"sofides@wanadoo.fr\": \"philbert.charles@neuf.fr\",\n", " \"trocquetdaniel@gmal.com\": \"trocquetdaniel@gmail.com\",\n", " \"yom54@hotmail.com\": \"yom@mythoz.org\",\n", " \"guillaume@wavemeup.fr\": \"guillaume.surflife@gmail.com\",\n", "}\n", "df_versements_joueur['Email payeur'] = df_versements_joueur['Email payeur'].replace(correspondance_email)\n", "df_versements_joueur" ] }, { "cell_type": "code", "execution_count": 46, "id": "0a4e6169-b768-46c5-8a5d-1eccd84bb3c0", "metadata": {}, "outputs": [ { "ename": "KeyError", "evalue": "'Email payeur'", "output_type": "error", "traceback": [ "\u001b[1;31m---------------------------------------------------------------------------\u001b[0m", "\u001b[1;31mKeyError\u001b[0m Traceback (most recent call last)", "\u001b[1;32m~\\AppData\\Local\\Temp\\ipykernel_7748\\2828747750.py\u001b[0m in \u001b[0;36m?\u001b[1;34m()\u001b[0m\n\u001b[1;32m----> 1\u001b[1;33m \u001b[0mdf_fusionne\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mpd\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mmerge\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mleft\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mdf_joueurs\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mright\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mdf_all\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mleft_on\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'E-MAIL'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mright_on\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'Email payeur'\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mhow\u001b[0m\u001b[1;33m=\u001b[0m\u001b[1;34m'outer'\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m", "\u001b[1;32m~\\AppData\\Local\\Packages\\PythonSoftwareFoundation.Python.3.12_qbz5n2kfra8p0\\LocalCache\\Local\\pypoetry\\Cache\\virtualenvs\\helloasso-gOYHrhgU-py3.12\\Lib\\site-packages\\pandas\\core\\reshape\\merge.py\u001b[0m in \u001b[0;36m?\u001b[1;34m(left, right, how, on, left_on, right_on, left_index, right_index, sort, suffixes, copy, indicator, validate)\u001b[0m\n\u001b[0;32m 166\u001b[0m \u001b[0mvalidate\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mvalidate\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 167\u001b[0m \u001b[0mcopy\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mcopy\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 168\u001b[0m \u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 169\u001b[0m \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 170\u001b[1;33m op = _MergeOperation(\n\u001b[0m\u001b[0;32m 171\u001b[0m \u001b[0mleft_df\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 172\u001b[0m \u001b[0mright_df\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 173\u001b[0m \u001b[0mhow\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mhow\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n", "\u001b[1;32m~\\AppData\\Local\\Packages\\PythonSoftwareFoundation.Python.3.12_qbz5n2kfra8p0\\LocalCache\\Local\\pypoetry\\Cache\\virtualenvs\\helloasso-gOYHrhgU-py3.12\\Lib\\site-packages\\pandas\\core\\reshape\\merge.py\u001b[0m in \u001b[0;36m?\u001b[1;34m(self, left, right, how, on, left_on, right_on, left_index, right_index, sort, suffixes, indicator, validate)\u001b[0m\n\u001b[0;32m 790\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mright_join_keys\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 791\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mjoin_names\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 792\u001b[0m \u001b[0mleft_drop\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 793\u001b[0m \u001b[0mright_drop\u001b[0m\u001b[1;33m,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m--> 794\u001b[1;33m \u001b[1;33m)\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_get_merge_keys\u001b[0m\u001b[1;33m(\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 795\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 796\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mleft_drop\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 797\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mleft\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mleft\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_drop_labels_or_levels\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mleft_drop\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n", "\u001b[1;32m~\\AppData\\Local\\Packages\\PythonSoftwareFoundation.Python.3.12_qbz5n2kfra8p0\\LocalCache\\Local\\pypoetry\\Cache\\virtualenvs\\helloasso-gOYHrhgU-py3.12\\Lib\\site-packages\\pandas\\core\\reshape\\merge.py\u001b[0m in \u001b[0;36m?\u001b[1;34m(self)\u001b[0m\n\u001b[0;32m 1293\u001b[0m \u001b[1;31m# Then we're either Hashable or a wrong-length arraylike,\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1294\u001b[0m \u001b[1;31m# the latter of which will raise\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1295\u001b[0m \u001b[0mrk\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mcast\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mHashable\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0mrk\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1296\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mrk\u001b[0m \u001b[1;32mis\u001b[0m \u001b[1;32mnot\u001b[0m \u001b[1;32mNone\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1297\u001b[1;33m \u001b[0mright_keys\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mright\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_get_label_or_level_values\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mrk\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 1298\u001b[0m \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1299\u001b[0m \u001b[1;31m# work-around for merge_asof(right_index=True)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1300\u001b[0m \u001b[0mright_keys\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mright\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mindex\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_values\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n", "\u001b[1;32m~\\AppData\\Local\\Packages\\PythonSoftwareFoundation.Python.3.12_qbz5n2kfra8p0\\LocalCache\\Local\\pypoetry\\Cache\\virtualenvs\\helloasso-gOYHrhgU-py3.12\\Lib\\site-packages\\pandas\\core\\generic.py\u001b[0m in \u001b[0;36m?\u001b[1;34m(self, key, axis)\u001b[0m\n\u001b[0;32m 1907\u001b[0m \u001b[0mvalues\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mxs\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0mother_axes\u001b[0m\u001b[1;33m[\u001b[0m\u001b[1;36m0\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_values\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1908\u001b[0m \u001b[1;32melif\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_is_level_reference\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m,\u001b[0m \u001b[0maxis\u001b[0m\u001b[1;33m=\u001b[0m\u001b[0maxis\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1909\u001b[0m \u001b[0mvalues\u001b[0m \u001b[1;33m=\u001b[0m \u001b[0mself\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0maxes\u001b[0m\u001b[1;33m[\u001b[0m\u001b[0maxis\u001b[0m\u001b[1;33m]\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mget_level_values\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0m_values\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1910\u001b[0m \u001b[1;32melse\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[1;32m-> 1911\u001b[1;33m \u001b[1;32mraise\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[1;33m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[1;33m)\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0m\u001b[0;32m 1912\u001b[0m \u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1913\u001b[0m \u001b[1;31m# Check for duplicates\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n\u001b[0;32m 1914\u001b[0m \u001b[1;32mif\u001b[0m \u001b[0mvalues\u001b[0m\u001b[1;33m.\u001b[0m\u001b[0mndim\u001b[0m \u001b[1;33m>\u001b[0m \u001b[1;36m1\u001b[0m\u001b[1;33m:\u001b[0m\u001b[1;33m\u001b[0m\u001b[1;33m\u001b[0m\u001b[0m\n", "\u001b[1;31mKeyError\u001b[0m: 'Email payeur'" ] } ], "source": [ "df_fusionne = pd.merge(left=df_joueurs, right=df_all, left_on='E-MAIL', right_on='Email payeur', how='outer')" ] }, { "cell_type": "code", "execution_count": 25, "id": "f74ba370-fea8-455f-b95f-df22ef16ff54", "metadata": {}, "outputs": [], "source": [ "df_fusionne.to_csv('./data/resultat.csv', index=False, sep=',')\n" ] }, { "cell_type": "code", "execution_count": 26, "id": "a20565b4-f5cc-4664-a910-12d0acf3204e", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
date\\ninscriptionNOMPrénomGenreageE-MAILFBTélsouhait type\\nparticipationPersonnage\\nattribué...état PAFphoto ?compétence medicalearrivéeReste si \\npas Shtandart ?NaNNom payeurPrénom payeurEmail payeursomme_versee
007/09/2024ABBÉValentinH31abbe.valentin@gmail.comAbbé Valentin0621641087Pur PJ-...gratuitnon reçueR.A.S.samediResteNaNNaNNaNNaNNaN
116/01/2025JULLIENAgnesF44ag9734@yahoo.comAgnès Jullien0642584516Pur PJ-...PAF finaliséenon reçueR.A.S.samediResteNaNJULLIENAgnèsag9734@yahoo.com400.0
209/11/2024GARROSAlbanH38alban.garros@gmail.comGreffier Vicious Soul0686285280PJ+PNJ-...PAF finaliséenon reçueR.A.S.samediResteNaNGARROSAlbanalban.garros@gmail.com400.0
318/06/2024FABREAlexandreH39alexandre.fabre@free.frAlexandre Fabre0607341244Pur PJ-...PAF partielle + erreurnon reçueR.A.S.samediResteNaNFABREAlexandrealexandre.fabre@free.fr267.0
418/09/2024BONFYAméliaF31amelia.bonfy@gmail.comBonfy Amélia681619704Pur PJ-...PAF partiellenon reçueR.A.S.samediResteNaNBONFYAméliaamelia.bonfy@gmail.com267.0
..................................................................
15121/09/2024MARÉCHALWilliamH37willmarechal87@gmail.comWilliam Maréchal+33679462220PJ+PNJ-...PAF partiellenon reçueR.A.S.samediResteNaNMARECHALWilliamwillmarechal87@gmail.com267.0
15218/09/2024JEGONDAYXavierH32xavier.jegonday@hotmail.frKurai Ketsurui0786189956Pur PJ-...PAF partiellenon reçueR.A.S.samediResteNaNJEGONDAYXavierxavier.jegonday@hotmail.fr133.5
15312/01/2024LORENTEYannH42yann.lorente@gmail.comYann lo+33630208984PJ+PNJ-...PAF partiellenon reçueR.A.S.samediResteNaNLORENTEYannyann.lorente@gmail.com200.1
15413/01/2024VIGIERYannH48yanvigier63@gmail.comLialn Di Maluisien0634991751PJ+PNJ-...PAF finaliséenon reçueR.A.S.samediResteNaNVIGIERYanyanvigier63@gmail.com801.0
15525/07/2024BRANDELYGuillaumeH51yom@mythoz.orgGuillaume BRANDELY+33661799673Pur PJ-...PAF partiellenon reçueR.A.S.samediNONNaNBRANDELYGuillaumeyom@mythoz.org272.0
\n", "

156 rows × 27 columns

\n", "
" ], "text/plain": [ " date\\ninscription NOM Prénom Genre age \\\n", "0 07/09/2024 ABBÉ Valentin H 31 \n", "1 16/01/2025 JULLIEN Agnes F 44 \n", "2 09/11/2024 GARROS Alban H 38 \n", "3 18/06/2024 FABRE Alexandre H 39 \n", "4 18/09/2024 BONFY Amélia F 31 \n", ".. ... ... ... ... .. \n", "151 21/09/2024 MARÉCHAL William H 37 \n", "152 18/09/2024 JEGONDAY Xavier H 32 \n", "153 12/01/2024 LORENTE Yann H 42 \n", "154 13/01/2024 VIGIER Yann H 48 \n", "155 25/07/2024 BRANDELY Guillaume H 51 \n", "\n", " E-MAIL FB Tél \\\n", "0 abbe.valentin@gmail.com Abbé Valentin 0621641087 \n", "1 ag9734@yahoo.com Agnès Jullien 0642584516 \n", "2 alban.garros@gmail.com Greffier Vicious Soul 0686285280 \n", "3 alexandre.fabre@free.fr Alexandre Fabre 0607341244 \n", "4 amelia.bonfy@gmail.com Bonfy Amélia 681619704 \n", ".. ... ... ... \n", "151 willmarechal87@gmail.com William Maréchal +33679462220 \n", "152 xavier.jegonday@hotmail.fr Kurai Ketsurui 0786189956 \n", "153 yann.lorente@gmail.com Yann lo +33630208984 \n", "154 yanvigier63@gmail.com Lialn Di Maluisien 0634991751 \n", "155 yom@mythoz.org Guillaume BRANDELY +33661799673 \n", "\n", " souhait type\\nparticipation Personnage\\nattribué ... \\\n", "0 Pur PJ - ... \n", "1 Pur PJ - ... \n", "2 PJ+PNJ - ... \n", "3 Pur PJ - ... \n", "4 Pur PJ - ... \n", ".. ... ... ... \n", "151 PJ+PNJ - ... \n", "152 Pur PJ - ... \n", "153 PJ+PNJ - ... \n", "154 PJ+PNJ - ... \n", "155 Pur PJ - ... \n", "\n", " état PAF photo ? compétence medicale arrivée \\\n", "0 gratuit non reçue R.A.S. samedi \n", "1 PAF finalisée non reçue R.A.S. samedi \n", "2 PAF finalisée non reçue R.A.S. samedi \n", "3 PAF partielle + erreur non reçue R.A.S. samedi \n", "4 PAF partielle non reçue R.A.S. samedi \n", ".. ... ... ... ... \n", "151 PAF partielle non reçue R.A.S. samedi \n", "152 PAF partielle non reçue R.A.S. samedi \n", "153 PAF partielle non reçue R.A.S. samedi \n", "154 PAF finalisée non reçue R.A.S. samedi \n", "155 PAF partielle non reçue R.A.S. samedi \n", "\n", " Reste si \\npas Shtandart ? NaN Nom payeur Prénom payeur \\\n", "0 Reste NaN NaN NaN \n", "1 Reste NaN JULLIEN Agnès \n", "2 Reste NaN GARROS Alban \n", "3 Reste NaN FABRE Alexandre \n", "4 Reste NaN BONFY Amélia \n", ".. ... ... ... ... \n", "151 Reste NaN MARECHAL William \n", "152 Reste NaN JEGONDAY Xavier \n", "153 Reste NaN LORENTE Yann \n", "154 Reste NaN VIGIER Yan \n", "155 NON NaN BRANDELY Guillaume \n", "\n", " Email payeur somme_versee \n", "0 NaN NaN \n", "1 ag9734@yahoo.com 400.0 \n", "2 alban.garros@gmail.com 400.0 \n", "3 alexandre.fabre@free.fr 267.0 \n", "4 amelia.bonfy@gmail.com 267.0 \n", ".. ... ... \n", "151 willmarechal87@gmail.com 267.0 \n", "152 xavier.jegonday@hotmail.fr 133.5 \n", "153 yann.lorente@gmail.com 200.1 \n", "154 yanvigier63@gmail.com 801.0 \n", "155 yom@mythoz.org 272.0 \n", "\n", "[156 rows x 27 columns]" ] }, "execution_count": 26, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_fusionne\n" ] }, { "cell_type": "code", "execution_count": 27, "id": "8b26bd98-71b7-4a38-b97f-8f788adb4dbb", "metadata": {}, "outputs": [], "source": [ " df_check = df_fusionne[['NOM', 'Prénom', 'E-MAIL', 'FB', 'somme\\nversée', 'somme_versee', 'Nom payeur', 'Prénom payeur', 'Email payeur']].copy()" ] }, { "cell_type": "code", "execution_count": 28, "id": "a1c7ef74-fe52-48f2-88d4-0d9c7eb6085a", "metadata": {}, "outputs": [], "source": [ "# Convertir la colonne en chaîne de caractères\n", "df_check['somme_versee'] = df_check['somme_versee'].astype(str)\n", "# Remplacer les points par des virgules\n", "df_check['somme_versee'] = df_check['somme_versee'].str.replace('.', ',', regex=False)\n", "df_check.to_csv('./data/resultat_check.csv', index=False, sep=',')\n" ] }, { "cell_type": "code", "execution_count": 29, "id": "e69517c2-eeed-4885-a116-16da5fc081ad", "metadata": {}, "outputs": [], "source": [ "df_pb_versement.to_csv('./data/pb_versement.csv', index=False, sep=',')" ] }, { "cell_type": "code", "execution_count": 30, "id": "ecc2c712-aeb7-4b26-adcd-e59b5a031afc", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Référence commandeMontant totalDate du paiementStatut du paiementVerséNom payeurPrénom payeurEmail payeurCampagneType de campagneTypeMontant du tarif
3710102631266.72024-11-12 19:06:02RefuséNonCORNUFrancoisewamael@aol.comRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois66,70
56102753570133.52024-11-05 09:53:40RefuséNonFABREAlexandrealexandre.fabre@free.frRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois133,50
60103971089133.52024-11-05 08:44:40RefuséNonGARCIAHugohugo@garcia-cotte.comRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois133,50
\n", "
" ], "text/plain": [ " Référence commande Montant total Date du paiement Statut du paiement \\\n", "37 101026312 66.7 2024-11-12 19:06:02 Refusé \n", "56 102753570 133.5 2024-11-05 09:53:40 Refusé \n", "60 103971089 133.5 2024-11-05 08:44:40 Refusé \n", "\n", " Versé Nom payeur Prénom payeur Email payeur \\\n", "37 Non CORNU Francoise wamael@aol.com \n", "56 Non FABRE Alexandre alexandre.fabre@free.fr \n", "60 Non GARCIA Hugo hugo@garcia-cotte.com \n", "\n", " Campagne Type de campagne Type \\\n", "37 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "56 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "60 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "\n", " Montant du tarif \n", "37 66,70 \n", "56 133,50 \n", "60 133,50 " ] }, "execution_count": 30, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_pb_versement" ] }, { "cell_type": "code", "execution_count": null, "id": "7fac4caf-8e97-4fed-94a1-d4eef782d571", "metadata": {}, "outputs": [], "source": [] } ], "metadata": { "kernelspec": { "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, "language_info": { "codemirror_mode": { "name": "ipython", "version": 3 }, "file_extension": ".py", "mimetype": "text/x-python", "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", "version": "3.12.8" } }, "nbformat": 4, "nbformat_minor": 5 }