{ "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-05_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: 181, dtype: object" ] }, "execution_count": 6, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_versements.iloc[-1]" ] }, { "cell_type": "code", "execution_count": 54, "id": "c02141cb-5e89-4a51-9f56-304ed824b814", "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", "
Date du paiementStatut du paiementPrénom payeurNom payeurMontant total
252025-02-05 03:13:39PayéXavierJEGONDAY133.5
472025-01-10 16:23:26PayéXavierJEGONDAY133.5
\n", "
" ], "text/plain": [ " Date du paiement Statut du paiement Prénom payeur Nom payeur \\\n", "25 2025-02-05 03:13:39 Payé Xavier JEGONDAY \n", "47 2025-01-10 16:23:26 Payé Xavier JEGONDAY \n", "\n", " Montant total \n", "25 133.5 \n", "47 133.5 " ] }, "execution_count": 54, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_versements[df_versements['Nom payeur'] == 'Jegonday'.upper()][['Date du paiement', 'Statut du paiement', 'Prénom payeur','Nom payeur','Montant total']]\n" ] }, { "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.com400.5
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", "

107 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 400.5\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", "[107 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": 12, "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-05_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": 13, "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": 14, "id": "72a88e43-9e11-4c16-9f22-0a382e0a3b62", "metadata": {}, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "(91, 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": 15, "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
01186252922025-02-05 01:27:00ValidéPICANOBenjaminPICANOBenjaminhulrek@gmail.comFort + navire400,00
11186247692025-02-05 00:35:00ValidéRYSNinonRYSNinonninon.rys@gmail.comFort + navire400,00
21178984242025-01-30 11:03:00ValidéGANTETGuillaumeGANTETGuillaumeguilland@gmail.comFort + navire (en 3 fois SEPTEMBRE UNIQUEMENT)400,50
31178939442025-01-30 10:28:00ValidéYOGANANTHANKarunaYOGANANTHANKarunacontact@karuna.proFort + navire400,00
41175580652025-01-27 16:06:00ValidéFARWilliamFARWilliamwilliam.daniel.far@gmail.comFort + navire (en 3 fois SEPTEMBRE UNIQUEMENT)400,50
.................................
86800014652024-02-02 09:27:00ValidéBOURDETTEJulienBOURDETTEJulienclodoweg@gmail.comFort + navire400,00
87799759392024-02-01 21:32:00ValidéCERUTTILaëtitiaCERUTTILaëtitialaetitia.cerutti@gozmail.bzhFort + navire (en 3 fois)400,50
88787872822024-01-20 19:53:00ValidéJACQGaëlleJACQGaëllegaellejacq@yahoo.comFort + navire400,00
89787363622024-01-20 09:42:00ValidéBUCASEricBUCASEricsacub@sfr.frFort + navire400,00
90786609772024-01-19 10:23:00ValidéPHILBERTCharlesPHILBERTCharlesphilbert.charles@neuf.frFort + navire (en 3 fois)400,50
\n", "

91 rows × 10 columns

\n", "
" ], "text/plain": [ " Référence commande Date de la commande Statut de la commande \\\n", "0 118625292 2025-02-05 01:27:00 Validé \n", "1 118624769 2025-02-05 00:35:00 Validé \n", "2 117898424 2025-01-30 11:03:00 Validé \n", "3 117893944 2025-01-30 10:28:00 Validé \n", "4 117558065 2025-01-27 16:06:00 Validé \n", ".. ... ... ... \n", "86 80001465 2024-02-02 09:27:00 Validé \n", "87 79975939 2024-02-01 21:32:00 Validé \n", "88 78787282 2024-01-20 19:53:00 Validé \n", "89 78736362 2024-01-20 09:42:00 Validé \n", "90 78660977 2024-01-19 10:23:00 Validé \n", "\n", " Nom participant Prénom participant Nom payeur Prénom payeur \\\n", "0 PICANO Benjamin PICANO Benjamin \n", "1 RYS Ninon RYS Ninon \n", "2 GANTET Guillaume GANTET Guillaume \n", "3 YOGANANTHAN Karuna YOGANANTHAN Karuna \n", "4 FAR William FAR William \n", ".. ... ... ... ... \n", "86 BOURDETTE Julien BOURDETTE Julien \n", "87 CERUTTI Laëtitia CERUTTI Laëtitia \n", "88 JACQ Gaëlle JACQ Gaëlle \n", "89 BUCAS Eric BUCAS Eric \n", "90 PHILBERT Charles PHILBERT Charles \n", "\n", " Email payeur \\\n", "0 hulrek@gmail.com \n", "1 ninon.rys@gmail.com \n", "2 guilland@gmail.com \n", "3 contact@karuna.pro \n", "4 william.daniel.far@gmail.com \n", ".. ... \n", "86 clodoweg@gmail.com \n", "87 laetitia.cerutti@gozmail.bzh \n", "88 gaellejacq@yahoo.com \n", "89 sacub@sfr.fr \n", "90 philbert.charles@neuf.fr \n", "\n", " Tarif Montant tarif \n", "0 Fort + navire 400,00 \n", "1 Fort + navire 400,00 \n", "2 Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) 400,50 \n", "3 Fort + navire 400,00 \n", "4 Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) 400,50 \n", ".. ... ... \n", "86 Fort + navire 400,00 \n", "87 Fort + navire (en 3 fois) 400,50 \n", "88 Fort + navire 400,00 \n", "89 Fort + navire 400,00 \n", "90 Fort + navire (en 3 fois) 400,50 \n", "\n", "[91 rows x 10 columns]" ] }, "execution_count": 15, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_billets_juin" ] }, { "cell_type": "code", "execution_count": 47, "id": "2bb93f25-c86e-4a9e-a68c-bd0d047e5b23", "metadata": {}, "outputs": [ { "data": { "text/html": [ "
\n", "\n", "\n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", "
Nom participantPrénom participantDate de la commande
\n", "
" ], "text/plain": [ "Empty DataFrame\n", "Columns: [Nom participant, Prénom participant, Date de la commande]\n", "Index: []" ] }, "execution_count": 47, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_billets_juin[df_billets_juin['Nom payeur'] == 'Carpentier'][['Nom participant', 'Prénom participant','Date de la commande']]\n" ] }, { "cell_type": "markdown", "id": "3398e20e-0146-41b3-a4fe-bca5b3a72010", "metadata": {}, "source": [ "### Lecture billets septembre (billeterie)" ] }, { "cell_type": "code", "execution_count": 17, "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-05_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": 18, "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": 19, "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": 20, "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", " \n", " \n", " \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
01183841402025-02-03 10:59:00ValidéTRÉBOSCDavidTRÉBOSCDavidgiantcoucou_ml@yahoo.frFort200,00
11183711092025-02-03 09:26:00ValidéPHILBERTCharlesPHILBERTCharlesphilbert.charles@neuf.frFort200,00
21177675802025-01-29 11:11:00ValidéVOINOTSébastienVOINOTSébastiensebvoinot@yahoo.frNavire+fort400,00
31172432472025-01-24 15:29:00ValidéROLLINCecileROLLINCecilececile.rollin@gmail.comNavire+fort400,00
41172002662025-01-24 08:54:00ValidéMOULINPhilippeMOULINPhilippemoulin.philippe@gmail.comNavire+fort400,00
51170772842025-01-23 06:07:00ValidéPETITVincentPETITVincentvincentsterne@yahoo.frFort200,00
61169459892025-01-21 22:57:00ValidéPHILBERTSophiePHILBERTSophiephilbert.charles@neuf.frFort200,00
71165725982025-01-18 18:01:00ValidéJULLIENAgnèsJULLIENAgnèsag9734@yahoo.comNavire+fort400,00
81160419022025-01-14 08:43:00ValidéGIRAUDCarolineGIRAUDCarolineblue.hirondelle@gmail.comNavire+fort400,00
91159753912025-01-13 16:14:00ValidéTALLONAnyaTALLONAnyaanya.tallon@gmail.comFort200,00
101155502522025-01-09 16:11:00ValidéJONASThomasJONASThomasblack_writer@hotmail.frNavire+fort400,00
111152467622025-01-06 21:05:00ValidéTROCQUETDanielTROCQUETDanieltrocquetdaniel@gmal.comNavire+fort400,00
121128059212024-12-05 21:44:00ValidéTESTARDSolineTESTARDSolinetsoline30@gmail.comNavire+fort400,00
131124683772024-12-03 12:05:00ValidéCOSTERGGaelCOSTERGGaelg.costerg@gmail.comNavire+fort400,00
141115096402024-11-25 19:43:00ValidéHARRANDChloéHARRANDChloéchloeharrand@gmail.comFort200,00
151110570382024-11-21 20:54:00ValidéORTALOPierreORTALOPierrepierre@yuzupulse.euNavire+fort400,00
161110407092024-11-21 19:22:00ValidéBULLIERMaximeBULLIERMaximemaxime.bullier@hotmail.frFort200,00
171101143632024-11-14 16:49:00ValidéFLAMMANNSashaFLAMMANNSashasasha.flammann@gmail.comNavire+fort400,00
181099651362024-11-13 15:53:00ValidéGARROSAlbanGARROSAlbanalban.garros@gmail.comNavire+fort400,00
191099247402024-11-13 11:16:00ValidéGUTIERREZJeremyGUTIERREZJeremyjeremy.gutierrez.pharma@gmail.comNavire+fort400,00
201096460322024-11-11 12:27:00ValidéSTOLTZCharlineSTOLTZCharlinecharline.stoltz@gmail.comNavire+fort400,00
211095451002024-11-10 12:51:00ValidéVANDROUXKarineVANDROUXKarinekadroux@gmail.comNavire+fort400,00
221091931072024-11-07 17:18:00ValidéBONNECARRÈREJulieFLEUTOTAlboflèdealba.fleutot@gmail.comNavire+fort400,00
231090791412024-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 118384140 2025-02-03 10:59:00 Validé \n", "1 118371109 2025-02-03 09:26:00 Validé \n", "2 117767580 2025-01-29 11:11:00 Validé \n", "3 117243247 2025-01-24 15:29:00 Validé \n", "4 117200266 2025-01-24 08:54:00 Validé \n", "5 117077284 2025-01-23 06:07:00 Validé \n", "6 116945989 2025-01-21 22:57:00 Validé \n", "7 116572598 2025-01-18 18:01:00 Validé \n", "8 116041902 2025-01-14 08:43:00 Validé \n", "9 115975391 2025-01-13 16:14:00 Validé \n", "10 115550252 2025-01-09 16:11:00 Validé \n", "11 115246762 2025-01-06 21:05:00 Validé \n", "12 112805921 2024-12-05 21:44:00 Validé \n", "13 112468377 2024-12-03 12:05:00 Validé \n", "14 111509640 2024-11-25 19:43:00 Validé \n", "15 111057038 2024-11-21 20:54:00 Validé \n", "16 111040709 2024-11-21 19:22:00 Validé \n", "17 110114363 2024-11-14 16:49:00 Validé \n", "18 109965136 2024-11-13 15:53:00 Validé \n", "19 109924740 2024-11-13 11:16:00 Validé \n", "20 109646032 2024-11-11 12:27:00 Validé \n", "21 109545100 2024-11-10 12:51:00 Validé \n", "22 109193107 2024-11-07 17:18:00 Validé \n", "23 109079141 2024-11-06 20:12:00 Validé \n", "\n", " Nom participant Prénom participant Nom payeur Prénom payeur \\\n", "0 TRÉBOSC David TRÉBOSC David \n", "1 PHILBERT Charles PHILBERT Charles \n", "2 VOINOT Sébastien VOINOT Sébastien \n", "3 ROLLIN Cecile ROLLIN Cecile \n", "4 MOULIN Philippe MOULIN Philippe \n", "5 PETIT Vincent PETIT Vincent \n", "6 PHILBERT Sophie PHILBERT Sophie \n", "7 JULLIEN Agnès JULLIEN Agnès \n", "8 GIRAUD Caroline GIRAUD Caroline \n", "9 TALLON Anya TALLON Anya \n", "10 JONAS Thomas JONAS Thomas \n", "11 TROCQUET Daniel TROCQUET Daniel \n", "12 TESTARD Soline TESTARD Soline \n", "13 COSTERG Gael COSTERG Gael \n", "14 HARRAND Chloé HARRAND Chloé \n", "15 ORTALO Pierre ORTALO Pierre \n", "16 BULLIER Maxime BULLIER Maxime \n", "17 FLAMMANN Sasha FLAMMANN Sasha \n", "18 GARROS Alban GARROS Alban \n", "19 GUTIERREZ Jeremy GUTIERREZ Jeremy \n", "20 STOLTZ Charline STOLTZ Charline \n", "21 VANDROUX Karine VANDROUX Karine \n", "22 BONNECARRÈRE Julie FLEUTOT Alboflède \n", "23 AMOUREUX Erwan AMOUREUX Erwan \n", "\n", " Email payeur Tarif Montant tarif \n", "0 giantcoucou_ml@yahoo.fr Fort 200,00 \n", "1 philbert.charles@neuf.fr Fort 200,00 \n", "2 sebvoinot@yahoo.fr Navire+fort 400,00 \n", "3 cecile.rollin@gmail.com Navire+fort 400,00 \n", "4 moulin.philippe@gmail.com Navire+fort 400,00 \n", "5 vincentsterne@yahoo.fr Fort 200,00 \n", "6 philbert.charles@neuf.fr Fort 200,00 \n", "7 ag9734@yahoo.com Navire+fort 400,00 \n", "8 blue.hirondelle@gmail.com Navire+fort 400,00 \n", "9 anya.tallon@gmail.com Fort 200,00 \n", "10 black_writer@hotmail.fr Navire+fort 400,00 \n", "11 trocquetdaniel@gmal.com Navire+fort 400,00 \n", "12 tsoline30@gmail.com Navire+fort 400,00 \n", "13 g.costerg@gmail.com Navire+fort 400,00 \n", "14 chloeharrand@gmail.com Fort 200,00 \n", "15 pierre@yuzupulse.eu Navire+fort 400,00 \n", "16 maxime.bullier@hotmail.fr Fort 200,00 \n", "17 sasha.flammann@gmail.com Navire+fort 400,00 \n", "18 alban.garros@gmail.com Navire+fort 400,00 \n", "19 jeremy.gutierrez.pharma@gmail.com Navire+fort 400,00 \n", "20 charline.stoltz@gmail.com Navire+fort 400,00 \n", "21 kadroux@gmail.com Navire+fort 400,00 \n", "22 alba.fleutot@gmail.com Navire+fort 400,00 \n", "23 erwan.amoureux@gmail.com Navire+fort 400,00 " ] }, "execution_count": 20, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_billets_septembre" ] }, { "cell_type": "code", "execution_count": 21, "id": "cbc753a4-5656-47e9-a7fa-52c4abb0ce6e", "metadata": {}, "outputs": [], "source": [ "df_billets = pd.concat([df_billets_juin,df_billets_septembre])" ] }, { "cell_type": "code", "execution_count": 22, "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": 23, "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
..................................................................
189117898424133.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
190118371109200.02025-02-03 09:26:04PayéNonPHILBERTCharlesphilbert.charles@neuf.frGN Black Revenge - la République libre pirate ...Billetterie...200,002025-02-03 09:26:00ValidéPHILBERTCharlesPHILBERTCharlesphilbert.charles@neuf.frFort200,00
191118384140200.02025-02-03 10:59:25PayéNonTRÉBOSCDavidgiantcoucou_ml@yahoo.frGN Black Revenge - la République libre pirate ...Billetterie...200,002025-02-03 10:59:00ValidéTRÉBOSCDavidTRÉBOSCDavidgiantcoucou_ml@yahoo.frFort200,00
192118624769400.02025-02-05 00:35:52PayéNonRYSNinonninon.rys@gmail.comRetour à Nassau V1 JuinAdhésion...400,002025-02-05 00:35:00ValidéRYSNinonRYSNinonninon.rys@gmail.comFort + navire400,00
193118625292400.02025-02-05 01:27:04PayéNonPICANOBenjaminhulrek@gmail.comRetour à Nassau V1 JuinAdhésion...400,002025-02-05 01:27:00ValidéPICANOBenjaminPICANOBenjaminhulrek@gmail.comFort + navire400,00
\n", "

194 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", "189 117898424 133.5 2025-01-30 11:03:33 Payé \n", "190 118371109 200.0 2025-02-03 09:26:04 Payé \n", "191 118384140 200.0 2025-02-03 10:59:25 Payé \n", "192 118624769 400.0 2025-02-05 00:35:52 Payé \n", "193 118625292 400.0 2025-02-05 01:27:04 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", "189 Non GANTET Guillaume guilland@gmail.com \n", "190 Non PHILBERT Charles philbert.charles@neuf.fr \n", "191 Non TRÉBOSC David giantcoucou_ml@yahoo.fr \n", "192 Non RYS Ninon ninon.rys@gmail.com \n", "193 Non PICANO Benjamin hulrek@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", "189 Retour à Nassau V1 Juin Adhésion ... \n", "190 GN Black Revenge - la République libre pirate ... Billetterie ... \n", "191 GN Black Revenge - la République libre pirate ... Billetterie ... \n", "192 Retour à Nassau V1 Juin Adhésion ... \n", "193 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", "189 133,50 2025-01-30 11:03:00 Validé \n", "190 200,00 2025-02-03 09:26:00 Validé \n", "191 200,00 2025-02-03 10:59:00 Validé \n", "192 400,00 2025-02-05 00:35:00 Validé \n", "193 400,00 2025-02-05 01:27: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", "189 GANTET Guillaume GANTET Guillaume \n", "190 PHILBERT Charles PHILBERT Charles \n", "191 TRÉBOSC David TRÉBOSC David \n", "192 RYS Ninon RYS Ninon \n", "193 PICANO Benjamin PICANO Benjamin \n", "\n", " Email payeur_y Tarif \\\n", "0 philbert.charles@neuf.fr Fort + navire (en 3 fois) \n", "1 philbert.charles@neuf.fr Fort + navire (en 3 fois) \n", "2 philbert.charles@neuf.fr Fort + navire (en 3 fois) \n", "3 sacub@sfr.fr Fort + navire \n", "4 gaellejacq@yahoo.com Fort + navire \n", ".. ... ... \n", "189 guilland@gmail.com Fort + navire (en 3 fois SEPTEMBRE UNIQUEMENT) \n", "190 philbert.charles@neuf.fr Fort \n", "191 giantcoucou_ml@yahoo.fr Fort \n", "192 ninon.rys@gmail.com Fort + navire \n", "193 hulrek@gmail.com Fort + navire \n", "\n", " Montant tarif \n", "0 400,50 \n", "1 400,50 \n", "2 400,50 \n", "3 400,00 \n", "4 400,00 \n", ".. ... \n", "189 400,50 \n", "190 200,00 \n", "191 200,00 \n", "192 400,00 \n", "193 400,00 \n", "\n", "[194 rows x 21 columns]" ] }, "execution_count": 23, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_all" ] }, { "cell_type": "code", "execution_count": 24, "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
13285614116267.02024-09-06 03:20:00PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois267,00
15985614116267.02024-06-06 03:05:31PayéOuiVIGIERYanyanvigier63@gmail.comRetour à Nassau V1 JuinAdhésionPaiement en plusieurs fois267,00
16585614116267.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", "132 85614116 267.0 2024-09-06 03:20:00 Payé \n", "159 85614116 267.0 2024-06-06 03:05:31 Payé \n", "165 85614116 267.0 2024-03-30 16:25:40 Payé \n", "\n", " Versé Nom payeur Prénom payeur Email payeur \\\n", "132 Oui VIGIER Yan yanvigier63@gmail.com \n", "159 Oui VIGIER Yan yanvigier63@gmail.com \n", "165 Oui VIGIER Yan yanvigier63@gmail.com \n", "\n", " Campagne Type de campagne Type \\\n", "132 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "159 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "165 Retour à Nassau V1 Juin Adhésion Paiement en plusieurs fois \n", "\n", " Montant du tarif \n", "132 267,00 \n", "159 267,00 \n", "165 267,00 " ] }, "execution_count": 24, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_versements[df_versements['Nom payeur'] == 'VIGIER']\n" ] }, { "cell_type": "code", "execution_count": 25, "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": 25, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_all[df_all['Nom participant'] == 'VIGIER']\n" ] }, { "cell_type": "code", "execution_count": 26, "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", " \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
BATTUNGCoralie400.5
BERGERETMathieu400.5
BESSIÈREJohanna400.0
BIRATStéphanie400.0
BONFYAmélia400.5
BONNECARRÈREJulie400.0
BOUHEDJANawel400.5
BOURDETTEJulien400.0
BOUROUMEAUKévin400.5
BRANDELYGuillaume405.5
BRULEMélanie400.0
BUCASEric400.0
BULLIERMaxime200.0
CARPENTIERGuillaume534.0
CERUTTILaëtitia400.5
CHAMONTINFlorian267.0
CHAPELONRomain400.5
CHASSERATEmmanuel400.5
CHOJNICKISolenn534.0
CORNETRenart400.0
CORNUFrancoise200.1
COSTERGGael400.0
DANCOTOlivier534.0
DAVIDCédric405.5
DEJARNACPierre200.0
DELAPORTEArnaud400.0
DUMASMarc200.0
DUVERTGuy-roger405.0
EUVEMaxime400.0
FABREAlexandre400.5
FARWilliam133.5
FLAMMANNSasha400.0
FRACHONAurélia400.5
GANTETGuillaume133.5
GARCIAHugo400.5
GARROSAlban400.0
GAYOTEléna400.5
GERBERONElodie400.5
GIRAUDCaroline400.0
GOURYFabien267.0
GRUNEMWALDThomas400.0
GUEXBenjamin400.0
GUTIERREZJeremy400.0
GUYOTRomain133.5
HARRANDChloé200.0
HURELMarcouf400.5
JACQGaëlle400.0
JALLETBenoit400.0
JEGONDAYXavier267.0
JONASThomas400.0
JULLIENAgnès400.0
LAFOSSECandice400.5
LAIRFrançois410.0
LALLIERFrédéric400.0
Olivier400.5
LAURENTSaada133.5
LENOUVELMaryline200.0
LETTERONSebastien205.0
LORENTEYann200.1
LUCARELLIJean-yves400.0
MAGNANTCatherine400.5
MAILLOTRoland205.1
MARCELIN-GABRIELMagali200.0
MARECHALWilliam400.5
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
PHILBERTCharles600.5
Sophie200.0
PICANOBenjamin400.0
PICHOTClaire133.5
PICQDylan200.1
PITELMarion200.0
POIMBOEUFThibault400.0
QUINTEROFlorie200.0
RAIMBAULTCécile801.0
RICHARDMarion800.0
Patrice800.0
RICHERPriscillia534.0
RIGAUDVéronique400.5
ROLLINCecile400.0
ROZIERMorgane801.0
RYSNinon400.0
RÉVEILJean carly400.0
SCHEUBERJoachim267.0
SECHERGaël400.0
SEMPÉRÉLionel200.0
SERVELManon267.0
STOLTZCharline400.0
SUPIOTLara200.1
TALLONAnya200.0
TESTARDSoline400.0
TROCQUETDaniel400.0
TRÉBOSCDavid200.0
VACARILydia200.1
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 400.5\n", "BERGERET Mathieu 400.5\n", "BESSIÈRE Johanna 400.0\n", "BIRAT Stéphanie 400.0\n", "BONFY Amélia 400.5\n", "BONNECARRÈRE Julie 400.0\n", "BOUHEDJA Nawel 400.5\n", "BOURDETTE Julien 400.0\n", "BOUROUMEAU Kévin 400.5\n", "BRANDELY Guillaume 405.5\n", "BRULE Mélanie 400.0\n", "BUCAS Eric 400.0\n", "BULLIER Maxime 200.0\n", "CARPENTIER Guillaume 534.0\n", "CERUTTI Laëtitia 400.5\n", "CHAMONTIN Florian 267.0\n", "CHAPELON Romain 400.5\n", "CHASSERAT Emmanuel 400.5\n", "CHOJNICKI Solenn 534.0\n", "CORNET Renart 400.0\n", "CORNU Francoise 200.1\n", "COSTERG Gael 400.0\n", "DANCOT Olivier 534.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 400.5\n", "FAR William 133.5\n", "FLAMMANN Sasha 400.0\n", "FRACHON Aurélia 400.5\n", "GANTET Guillaume 133.5\n", "GARCIA Hugo 400.5\n", "GARROS Alban 400.0\n", "GAYOT Eléna 400.5\n", "GERBERON Elodie 400.5\n", "GIRAUD Caroline 400.0\n", "GOURY Fabien 267.0\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 267.0\n", "JONAS Thomas 400.0\n", "JULLIEN Agnès 400.0\n", "LAFOSSE Candice 400.5\n", "LAIR François 410.0\n", "LALLIER Frédéric 400.0\n", " Olivier 400.5\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 205.1\n", "MARCELIN-GABRIEL Magali 200.0\n", "MARECHAL William 400.5\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 600.5\n", " Sophie 200.0\n", "PICANO Benjamin 400.0\n", "PICHOT Claire 133.5\n", "PICQ Dylan 200.1\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 534.0\n", "RIGAUD Véronique 400.5\n", "ROLLIN Cecile 400.0\n", "ROZIER Morgane 801.0\n", "RYS Ninon 400.0\n", "RÉVEIL Jean carly 400.0\n", "SCHEUBER Joachim 267.0\n", "SECHER Gaël 400.0\n", "SEMPÉRÉ Lionel 200.0\n", "SERVEL Manon 267.0\n", "STOLTZ Charline 400.0\n", "SUPIOT Lara 200.1\n", "TALLON Anya 200.0\n", "TESTARD Soline 400.0\n", "TROCQUET Daniel 400.0\n", "TRÉBOSC David 200.0\n", "VACARI Lydia 200.1\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": 26, "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": 43, "id": "4edb6d86-7971-4796-a396-44cb4b04aa0f", "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", "
Nom payeur_xPrénom payeur_xDate du paiementStatut du paiementMontant du tarif
144CARPENTIERGuillaume2025-02-05 04:15:16Payé267,00
145CARPENTIERGuillaume2025-02-05 04:15:16Payé267,00
146CARPENTIERGuillaume2024-11-13 19:43:45Payé267,00
147CARPENTIERGuillaume2024-11-13 19:43:45Payé267,00
\n", "
" ], "text/plain": [ " Nom payeur_x Prénom payeur_x Date du paiement Statut du paiement \\\n", "144 CARPENTIER Guillaume 2025-02-05 04:15:16 Payé \n", "145 CARPENTIER Guillaume 2025-02-05 04:15:16 Payé \n", "146 CARPENTIER Guillaume 2024-11-13 19:43:45 Payé \n", "147 CARPENTIER Guillaume 2024-11-13 19:43:45 Payé \n", "\n", " Montant du tarif \n", "144 267,00 \n", "145 267,00 \n", "146 267,00 \n", "147 267,00 " ] }, "execution_count": 43, "metadata": {}, "output_type": "execute_result" } ], "source": [ "df_all[df_all['Nom payeur_x'] == 'Carpentier'.upper()][['Nom payeur_x', 'Prénom payeur_x','Date du paiement','Statut du paiement','Montant du tarif']]\n" ] }, { "cell_type": "code", "execution_count": 27, "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", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \n", " \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
79100957132133.52025-02-05 07:32:27RefuséNonBRANDELYGuillaumeyom54@hotmail.comRetour à Nassau V1 JuinAdhésion...133,502024-09-06 21:33:00ValidéBRANDELYGuillaumeBRANDELYGuillaumeyom54@hotmail.comFort + navire (en 3 fois)400,50
8310102631266.72025-02-05 07:21:41RefuséNonCORNUFrancoisewamael@aol.comRetour à Nassau V1 JuinAdhésion...66,702024-09-07 13:01:00ValidéCORNUFrancoiseCORNUFrancoisewamael@aol.comFort (en 3 fois)200,10
8410102631266.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
105102753570133.52025-02-05 06:18:00Refusé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
106102753570133.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
11210318017066.72025-02-05 06:07:00RefuséNonVACARILydiavacarilydia@hotmail.frRetour à Nassau V1 JuinAdhésion...66,702024-09-22 19:31:00ValidéVACARILydiaVACARILydiavacarilydia@hotmail.frFort (en 3 fois)200,10
119103364829133.52025-02-05 06:01:27RefuséNonMARECHALWilliamwillmarechal87@gmail.comRetour à Nassau V1 JuinAdhésion...133,502024-09-23 23:01:00ValidéMARECHALWilliamMARECHALWilliamwillmarechal87@gmail.comFort + navire (en 3 fois)400,50
122103971089133.52025-02-05 05:24:37Refusé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
123103971089133.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
152110047919133.52025-02-05 04:15:00RefuséNonSCHEUBERJoachimscheuber.joachim@gmail.comRetour à Nassau V1 JuinAdhésion...133,502024-11-14 08:11:00ValidéSCHEUBERJoachimSCHEUBERJoachimscheuber.joachim@gmail.comFort + navire (en 3 fois)267,00
166114909886133.52025-02-05 03:23:24RefuséNonSERVELManonservel.manon@orange.frRetour à Nassau V1 JuinAdhésion...133,502025-01-02 16:50:00ValidéSERVELManonSERVELManonservel.manon@orange.frFort + navire (en 3 fois)267,00
\n", "

11 rows × 21 columns

\n", "
" ], "text/plain": [ " Référence commande Montant total Date du paiement Statut du paiement \\\n", "79 100957132 133.5 2025-02-05 07:32:27 Refusé \n", "83 101026312 66.7 2025-02-05 07:21:41 Refusé \n", "84 101026312 66.7 2024-11-12 19:06:02 Refusé \n", "105 102753570 133.5 2025-02-05 06:18:00 Refusé \n", "106 102753570 133.5 2024-11-05 09:53:40 Refusé \n", "112 103180170 66.7 2025-02-05 06:07:00 Refusé \n", "119 103364829 133.5 2025-02-05 06:01:27 Refusé \n", "122 103971089 133.5 2025-02-05 05:24:37 Refusé \n", "123 103971089 133.5 2024-11-05 08:44:40 Refusé \n", "152 110047919 133.5 2025-02-05 04:15:00 Refusé \n", "166 114909886 133.5 2025-02-05 03:23:24 Refusé \n", "\n", " Versé Nom payeur_x Prénom payeur_x Email payeur_x \\\n", "79 Non BRANDELY Guillaume yom54@hotmail.com \n", "83 Non CORNU Francoise wamael@aol.com \n", "84 Non CORNU Francoise wamael@aol.com \n", "105 Non FABRE Alexandre alexandre.fabre@free.fr \n", "106 Non FABRE Alexandre alexandre.fabre@free.fr \n", "112 Non VACARI Lydia vacarilydia@hotmail.fr \n", "119 Non MARECHAL William willmarechal87@gmail.com \n", "122 Non GARCIA Hugo hugo@garcia-cotte.com \n", "123 Non GARCIA Hugo hugo@garcia-cotte.com \n", "152 Non SCHEUBER Joachim scheuber.joachim@gmail.com \n", "166 Non SERVEL Manon servel.manon@orange.fr \n", "\n", " Campagne Type de campagne ... Montant du tarif \\\n", "79 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "83 Retour à Nassau V1 Juin Adhésion ... 66,70 \n", "84 Retour à Nassau V1 Juin Adhésion ... 66,70 \n", "105 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "106 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "112 Retour à Nassau V1 Juin Adhésion ... 66,70 \n", "119 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "122 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "123 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "152 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "166 Retour à Nassau V1 Juin Adhésion ... 133,50 \n", "\n", " Date de la commande Statut de la commande Nom participant \\\n", "79 2024-09-06 21:33:00 Validé BRANDELY \n", "83 2024-09-07 13:01:00 Validé CORNU \n", "84 2024-09-07 13:01:00 Validé CORNU \n", "105 2024-09-19 12:42:00 Validé FABRE \n", "106 2024-09-19 12:42:00 Validé FABRE \n", "112 2024-09-22 19:31:00 Validé VACARI \n", "119 2024-09-23 23:01:00 Validé MARECHAL \n", "122 2024-09-27 21:49:00 Validé GARCIA \n", "123 2024-09-27 21:49:00 Validé GARCIA \n", "152 2024-11-14 08:11:00 Validé SCHEUBER \n", "166 2025-01-02 16:50:00 Validé SERVEL \n", "\n", " Prénom participant Nom payeur_y Prénom payeur_y \\\n", "79 Guillaume BRANDELY Guillaume \n", "83 Francoise CORNU Francoise \n", "84 Francoise CORNU Francoise \n", "105 Alexandre FABRE Alexandre \n", "106 Alexandre FABRE Alexandre \n", "112 Lydia VACARI Lydia \n", "119 William MARECHAL William \n", "122 Hugo GARCIA Hugo \n", "123 Hugo GARCIA Hugo \n", "152 Joachim SCHEUBER Joachim \n", "166 Manon SERVEL Manon \n", "\n", " Email payeur_y Tarif Montant tarif \n", "79 yom54@hotmail.com Fort + navire (en 3 fois) 400,50 \n", "83 wamael@aol.com Fort (en 3 fois) 200,10 \n", "84 wamael@aol.com Fort (en 3 fois) 200,10 \n", "105 alexandre.fabre@free.fr Fort + navire (en 3 fois) 400,50 \n", "106 alexandre.fabre@free.fr Fort + navire (en 3 fois) 400,50 \n", "112 vacarilydia@hotmail.fr Fort (en 3 fois) 200,10 \n", "119 willmarechal87@gmail.com Fort + navire (en 3 fois) 400,50 \n", "122 hugo@garcia-cotte.com Fort + navire (en 3 fois) 400,50 \n", "123 hugo@garcia-cotte.com Fort + navire (en 3 fois) 400,50 \n", "152 scheuber.joachim@gmail.com Fort + navire (en 3 fois) 267,00 \n", "166 servel.manon@orange.fr Fort + navire (en 3 fois) 267,00 \n", "\n", "[11 rows x 21 columns]" ] }, "execution_count": 27, "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": 28, "id": "53feaffd-262a-4960-a6d3-d74a50635eaa", "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)", "File \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\\indexes\\base.py:3805\u001b[0m, in \u001b[0;36mIndex.get_loc\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m 3804\u001b[0m \u001b[38;5;28;01mtry\u001b[39;00m:\n\u001b[1;32m-> 3805\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43m_engine\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_loc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mcasted_key\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m 3806\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m \u001b[38;5;28;01mas\u001b[39;00m err:\n", "File \u001b[1;32mindex.pyx:167\u001b[0m, in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n", "File \u001b[1;32mindex.pyx:196\u001b[0m, in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[1;34m()\u001b[0m\n", "File \u001b[1;32mpandas\\\\_libs\\\\hashtable_class_helper.pxi:7081\u001b[0m, in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n", "File \u001b[1;32mpandas\\\\_libs\\\\hashtable_class_helper.pxi:7089\u001b[0m, in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[1;34m()\u001b[0m\n", "\u001b[1;31mKeyError\u001b[0m: 'Email payeur'", "\nThe above exception was the direct cause of the following exception:\n", "\u001b[1;31mKeyError\u001b[0m Traceback (most recent call last)", "Cell \u001b[1;32mIn[28], line 10\u001b[0m\n\u001b[0;32m 1\u001b[0m correspondance_email \u001b[38;5;241m=\u001b[39m {\n\u001b[0;32m 2\u001b[0m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124malba.fleutot@gmail.com\u001b[39m\u001b[38;5;124m\"\u001b[39m: \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mjulie@nebulae.world\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m 3\u001b[0m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mj.warszawski@hotmail.fr\u001b[39m\u001b[38;5;124m\"\u001b[39m: \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mjessica.warszawski@gmail.com\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[1;32m (...)\u001b[0m\n\u001b[0;32m 8\u001b[0m \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mguillaume@wavemeup.fr\u001b[39m\u001b[38;5;124m\"\u001b[39m: \u001b[38;5;124m\"\u001b[39m\u001b[38;5;124mguillaume.surflife@gmail.com\u001b[39m\u001b[38;5;124m\"\u001b[39m,\n\u001b[0;32m 9\u001b[0m }\n\u001b[1;32m---> 10\u001b[0m df_versements_joueur[\u001b[38;5;124m'\u001b[39m\u001b[38;5;124mEmail payeur\u001b[39m\u001b[38;5;124m'\u001b[39m] \u001b[38;5;241m=\u001b[39m \u001b[43mdf_versements_joueur\u001b[49m\u001b[43m[\u001b[49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[38;5;124;43mEmail payeur\u001b[39;49m\u001b[38;5;124;43m'\u001b[39;49m\u001b[43m]\u001b[49m\u001b[38;5;241m.\u001b[39mreplace(correspondance_email)\n\u001b[0;32m 11\u001b[0m df_versements_joueur\n", "File \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\\frame.py:4102\u001b[0m, in \u001b[0;36mDataFrame.__getitem__\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m 4100\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39mcolumns\u001b[38;5;241m.\u001b[39mnlevels \u001b[38;5;241m>\u001b[39m \u001b[38;5;241m1\u001b[39m:\n\u001b[0;32m 4101\u001b[0m \u001b[38;5;28;01mreturn\u001b[39;00m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_getitem_multilevel(key)\n\u001b[1;32m-> 4102\u001b[0m indexer \u001b[38;5;241m=\u001b[39m \u001b[38;5;28;43mself\u001b[39;49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mcolumns\u001b[49m\u001b[38;5;241;43m.\u001b[39;49m\u001b[43mget_loc\u001b[49m\u001b[43m(\u001b[49m\u001b[43mkey\u001b[49m\u001b[43m)\u001b[49m\n\u001b[0;32m 4103\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m is_integer(indexer):\n\u001b[0;32m 4104\u001b[0m indexer \u001b[38;5;241m=\u001b[39m [indexer]\n", "File \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\\indexes\\base.py:3812\u001b[0m, in \u001b[0;36mIndex.get_loc\u001b[1;34m(self, key)\u001b[0m\n\u001b[0;32m 3807\u001b[0m \u001b[38;5;28;01mif\u001b[39;00m \u001b[38;5;28misinstance\u001b[39m(casted_key, \u001b[38;5;28mslice\u001b[39m) \u001b[38;5;129;01mor\u001b[39;00m (\n\u001b[0;32m 3808\u001b[0m \u001b[38;5;28misinstance\u001b[39m(casted_key, abc\u001b[38;5;241m.\u001b[39mIterable)\n\u001b[0;32m 3809\u001b[0m \u001b[38;5;129;01mand\u001b[39;00m \u001b[38;5;28many\u001b[39m(\u001b[38;5;28misinstance\u001b[39m(x, \u001b[38;5;28mslice\u001b[39m) \u001b[38;5;28;01mfor\u001b[39;00m x \u001b[38;5;129;01min\u001b[39;00m casted_key)\n\u001b[0;32m 3810\u001b[0m ):\n\u001b[0;32m 3811\u001b[0m \u001b[38;5;28;01mraise\u001b[39;00m InvalidIndexError(key)\n\u001b[1;32m-> 3812\u001b[0m \u001b[38;5;28;01mraise\u001b[39;00m \u001b[38;5;167;01mKeyError\u001b[39;00m(key) \u001b[38;5;28;01mfrom\u001b[39;00m\u001b[38;5;250m \u001b[39m\u001b[38;5;21;01merr\u001b[39;00m\n\u001b[0;32m 3813\u001b[0m \u001b[38;5;28;01mexcept\u001b[39;00m \u001b[38;5;167;01mTypeError\u001b[39;00m:\n\u001b[0;32m 3814\u001b[0m \u001b[38;5;66;03m# If we have a listlike key, _check_indexing_error will raise\u001b[39;00m\n\u001b[0;32m 3815\u001b[0m \u001b[38;5;66;03m# InvalidIndexError. Otherwise we fall through and re-raise\u001b[39;00m\n\u001b[0;32m 3816\u001b[0m \u001b[38;5;66;03m# the TypeError.\u001b[39;00m\n\u001b[0;32m 3817\u001b[0m \u001b[38;5;28mself\u001b[39m\u001b[38;5;241m.\u001b[39m_check_indexing_error(key)\n", "\u001b[1;31mKeyError\u001b[0m: 'Email payeur'" ] } ], "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": null, "id": "0a4e6169-b768-46c5-8a5d-1eccd84bb3c0", "metadata": {}, "outputs": [], "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": null, "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": null, "id": "a20565b4-f5cc-4664-a910-12d0acf3204e", "metadata": {}, "outputs": [], "source": [ "df_fusionne\n" ] }, { "cell_type": "code", "execution_count": null, "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": null, "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": null, "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": null, "id": "ecc2c712-aeb7-4b26-adcd-e59b5a031afc", "metadata": {}, "outputs": [], "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 }