{"id":233902,"date":"2024-03-21T09:21:40","date_gmt":"2024-03-21T09:21:40","guid":{"rendered":"https:\/\/datascientest.com\/?p=233902"},"modified":"2024-11-07T10:42:23","modified_gmt":"2024-11-07T10:42:23","slug":"astuces-pandas-indispensables","status":"publish","type":"post","link":"https:\/\/datascientest.com\/astuces-pandas-indispensables","title":{"rendered":"Les astuces Pandas indispensables pour transformer votre travail"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"233902\" class=\"elementor elementor-233902\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-dbce9b5 e-flex e-con-boxed e-con\" data-id=\"dbce9b5\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-720c57b elementor-widget elementor-widget-heading\" data-id=\"720c57b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Avec ses nombreuses fonctionnalit\u00e9s permettant de traiter les donn\u00e9es sur lesquelles nous travaillons, Pandas s\u2019est \u00e9tabli comme un outil indispensable pour les Data Scientists et Data Analysts. Dans cet article vous verrez quelques fonctions, assez m\u00e9connues, qui pourront changer votre mani\u00e8re de travailler.<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-7ee3053 e-flex e-con-boxed e-con\" data-id=\"7ee3053\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-df129f2 elementor-widget elementor-widget-heading\" data-id=\"df129f2\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">1. Ajouter une l\u00e9gende \u00e0 un dataframe<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e03581f elementor-widget elementor-widget-text-editor\" data-id=\"e03581f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">De la m\u00eame mani\u00e8re que pour les graphiques que l\u2019on affiche avec <a href=\"https:\/\/datascientest.com\/matplotlib-tout-savoir\">Matplotlib<\/a> ou <a href=\"https:\/\/datascientest.com\/seaborn-tout-savoir\">Seaborn<\/a>, il est possible, gr\u00e2ce \u00e0 une ligne de code, d\u2019ajouter une l\u00e9gende \u00e0 un dataframe au moment de l\u2019affichage.<\/span><\/p><p><span style=\"font-weight: 400;\">Commen\u00e7ons par importer les librairies dont nous aurons besoin :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6ffb142 elementor-widget elementor-widget-code-highlight\" data-id=\"6ffb142\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import pandas as pd\r\nimport numpy as np<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7358d2b elementor-widget elementor-widget-text-editor\" data-id=\"7358d2b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Nous allons ensuite cr\u00e9er un dataframe avec des donn\u00e9es al\u00e9atoires :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-454fec9 elementor-widget elementor-widget-code-highlight\" data-id=\"454fec9\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>df = pd.DataFrame({'Age': np.random.randint(20, 80, size=5),\r\n                   'Taille': np.random.randint(150, 190, size=5),\r\n                   'Poids': np.random.randint(50, 100, size=5),\r\n                   'Salaire': np.random.randint(1000, 4000, size=5)})<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0a0f4f2 elementor-widget elementor-widget-text-editor\" data-id=\"0a0f4f2\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Enfin, en utilisant la fonction <strong>set_caption()<\/strong> on ajoute la l\u00e9gende au dataframe :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-47dccc7 elementor-widget elementor-widget-code-highlight\" data-id=\"47dccc7\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>legende = \"Ceci est une l\u00e9gende\"\r\ndf.style.set_caption(legende)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-77e004d elementor-widget elementor-widget-image\" data-id=\"77e004d\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"445\" height=\"291\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image4-1.png\" class=\"attachment-full size-full wp-image-233905\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image4-1.png 445w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image4-1-300x196.png 300w\" sizes=\"(max-width: 445px) 100vw, 445px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-5c4d714 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"5c4d714\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-analyst\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 ajouter une l\u00e9gende \u00e0 un dataframe<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-dffb2ec e-flex e-con-boxed e-con\" data-id=\"dffb2ec\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-d20c526 elementor-widget elementor-widget-heading\" data-id=\"d20c526\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">2. Ajouter une barre de progression<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-967aead elementor-widget elementor-widget-text-editor\" data-id=\"967aead\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Lorsque vous appliquez un traitement sur les donn\u00e9es de votre <a href=\"https:\/\/datascientest.com\/quest-ce-quun-dataframe\">dataframe<\/a>, ce traitement peut prendre un certain temps et vous pourriez avoir envie de <strong>suivre son \u00e9volution<\/strong>. Pour cela il est possible d\u2019afficher une barre de progression qui \u00e9volue avec le pourcentage du traitement compl\u00e9t\u00e9.<\/span><\/p><p><span style=\"font-weight: 400;\">Commen\u00e7ons par importer les librairies dont nous aurons besoin :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-28396b4 elementor-widget elementor-widget-code-highlight\" data-id=\"28396b4\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import pandas as pd\r\nimport time\r\nfrom tqdm.notebook import tqdm<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ff72c68 elementor-widget elementor-widget-text-editor\" data-id=\"ff72c68\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On initialise la fonction <strong>tqdm<\/strong>, qui nous servira \u00e0 afficher la barre de progression dans le notebook :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-129f78e elementor-widget elementor-widget-code-highlight\" data-id=\"129f78e\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>tqdm.pandas()<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e68a41f elementor-widget elementor-widget-text-editor\" data-id=\"e68a41f\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Nous allons ensuite cr\u00e9er un dataframe avec des donn\u00e9es al\u00e9atoires :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4f578ec elementor-widget elementor-widget-code-highlight\" data-id=\"4f578ec\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>df = pd.DataFrame({'Age': np.random.randint(20, 80, size=5),\r\n                   'Taille': np.random.randint(150, 190, size=5),\r\n                   'Poids': np.random.randint(50, 100, size=5),\r\n                   'Salaire': np.random.randint(1000, 4000, size=5)})<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cd3f488 elementor-widget elementor-widget-text-editor\" data-id=\"cd3f488\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On cr\u00e9e une fonction qui simule un traitement sur un dataframe qui prendrait 0.5 seconde par ligne :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-2d5874e elementor-widget elementor-widget-code-highlight\" data-id=\"2d5874e\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>def process_row(row):\r\n    tqdm.pandas(desc=\"Traitement en cours\")\r\n    time.sleep(0.5)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-837a010 elementor-widget elementor-widget-text-editor\" data-id=\"837a010\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On applique le traitement sur le dataframe, tout en affichant la barre de progression :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-926a186 elementor-widget elementor-widget-code-highlight\" data-id=\"926a186\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>df.progress_apply(process_row, axis=1)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-99f4b91 elementor-widget elementor-widget-text-editor\" data-id=\"99f4b91\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On affiche un message une fois le traitement termin\u00e9 :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6770e31 elementor-widget elementor-widget-code-highlight\" data-id=\"6770e31\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>print(\"Traitement du DataFrame termin\u00e9.\")<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ed720c5 elementor-widget elementor-widget-image\" data-id=\"ed720c5\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"725\" height=\"79\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image1-1.png\" class=\"attachment-full size-full wp-image-233922\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image1-1.png 725w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image1-1-300x33.png 300w\" sizes=\"(max-width: 725px) 100vw, 725px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7f3a754 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"7f3a754\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-analyst\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Savoir utiliser la barre de progression<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-1a7e661 e-flex e-con-boxed e-con\" data-id=\"1a7e661\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-98c256b elementor-widget elementor-widget-heading\" data-id=\"98c256b\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">3. Modifier le formatage de notre dataframe<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-70e4540 elementor-widget elementor-widget-text-editor\" data-id=\"70e4540\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Lors de l\u2019affichage de notre dataframe, il est possible d\u2019ajouter des couleurs, de d\u00e9finir le nombre de d\u00e9cimales affich\u00e9es ou d\u2019ajouter les unit\u00e9s associ\u00e9es aux diff\u00e9rentes colonnes. Pour cela nous pouvons utiliser la fonction style.format() de <a href=\"https:\/\/datascientest.com\/pandas-python-data-science\">Pandas<\/a>.<\/span><\/p><p><span style=\"font-weight: 400;\">Comme pr\u00e9c\u00e9demment on importe les librairies n\u00e9cessaires et on cr\u00e9e le dataframe qui sera utilis\u00e9 :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4de8f1c elementor-widget elementor-widget-code-highlight\" data-id=\"4de8f1c\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import pandas as pd\r\nimport numpy as np\r\n\r\n\r\ndf = pd.DataFrame({'Age': np.random.randint(20, 80, size=10),\r\n                   'Taille': np.random.randint(1500, 1900, size=10)\/1000,\r\n                   'Poids': np.random.randint(5000, 10000, size=10)\/100,\r\n                   'Salaire': np.random.randint(100000, 400000, size=10)\/100})<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-dcaa1aa elementor-widget elementor-widget-text-editor\" data-id=\"dcaa1aa\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On affiche le dataframe pour voir l\u2019affichage par d\u00e9faut :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b8eee56 elementor-widget elementor-widget-code-highlight\" data-id=\"b8eee56\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>df<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-85c7814 elementor-widget elementor-widget-text-editor\" data-id=\"85c7814\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On applique maintenant un formatage sur les donn\u00e9es :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9076c61 elementor-widget elementor-widget-code-highlight\" data-id=\"9076c61\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>df.style.format({\"Age\": \"{} ans\",\r\n                 \"Taille\": \"{:.2f} cm\",\r\n                 \"Poids\": \"{:.1f} kgs\",\r\n                 \"Salaire\":\"{:,.2f}\u20ac\"})\\\r\n                 .background_gradient()<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-08a6c83 elementor-widget elementor-widget-text-editor\" data-id=\"08a6c83\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">D\u00e9taillons les diff\u00e9rents \u00e9l\u00e9ments de cette commande :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b028137 elementor-widget elementor-widget-code-highlight\" data-id=\"b028137\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>\"Salaire\":\"{:,.2f}\u20ac\"<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4050fea elementor-widget elementor-widget-text-editor\" data-id=\"4050fea\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400; color: #339966;\">.2<\/span><span style=\"font-weight: 400;\"> indique que l\u2019on veut garder 2 d\u00e9cimales.<\/span><\/p><p><span style=\"font-weight: 400; color: #339966;\">f<\/span><span style=\"font-weight: 400;\"> indique que l\u2019on veut renvoyer un nombre \u00e0 virgule flottante (float).<\/span><\/p><p><span style=\"font-weight: 400;\">La virgule apr\u00e8s les deux points indique que l\u2019on veut s\u00e9parer les milliers par des virgules.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9201e4a elementor-widget elementor-widget-code-highlight\" data-id=\"9201e4a\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>background_gradient()<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9507bda elementor-widget elementor-widget-text-editor\" data-id=\"9507bda\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Permet de colorer les cases des diff\u00e9rentes colonnes avec un d\u00e9grad\u00e9 de couleur, les valeurs les plus \u00e9lev\u00e9es ayant les couleurs les plus sombres.<\/span><\/p><p><span style=\"font-weight: 400;\">On obtient le r\u00e9sultat suivant :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8508ace elementor-widget elementor-widget-image\" data-id=\"8508ace\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"410\" height=\"457\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image2-1.png\" class=\"attachment-full size-full wp-image-233926\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image2-1.png 410w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image2-1-269x300.png 269w\" sizes=\"(max-width: 410px) 100vw, 410px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a84e4c4 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a84e4c4\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-analyst\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Savoir modifier le formatage d'un dataframe<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-14aea4f e-flex e-con-boxed e-con\" data-id=\"14aea4f\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-0b9a4b3 elementor-widget elementor-widget-heading\" data-id=\"0b9a4b3\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">4. Ajouter une moyenne glissante<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7bdac85 elementor-widget elementor-widget-text-editor\" data-id=\"7bdac85\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La moyenne glissante est utilis\u00e9e dans l&rsquo;analyse des <a href=\"https:\/\/datascientest.com\/series-temporelles\">s\u00e9ries temporelles<\/a> pour lisser les variations \u00e0 court terme, r\u00e9duire le bruit et mettre en \u00e9vidence les tendances sous-jacentes. Il est possible d\u2019ajouter une moyenne glissante dans un dataframe gr\u00e2ce \u00e0 la fonction <strong>rolling()<\/strong>.<\/span><\/p><p><span style=\"font-weight: 400;\">On importe les librairies n\u00e9cessaires et on cr\u00e9e notre jeu de donn\u00e9es al\u00e9atoirement :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0c0ffd9 elementor-widget elementor-widget-code-highlight\" data-id=\"0c0ffd9\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import pandas as pd\r\nimport numpy as np\r\nimport matplotlib.pyplot as plt\r\nliste_dates = pd.date_range(start='2023-01-01', end='2023-12-31', freq='D')\r\nrandom_data = np.random.randn(len(liste_dates))\r\ntime_series = pd.DataFrame({'Valeur' : random_data}, index=liste_dates)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d1455f5 elementor-widget elementor-widget-text-editor\" data-id=\"d1455f5\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On cr\u00e9e ensuite la moyenne glissante avec une fen\u00eatre de 7 jours dans une nouvelle colonne de notre dataframe :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8f3d719 elementor-widget elementor-widget-code-highlight\" data-id=\"8f3d719\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>time_series[\"moyenne_glissante\"] = time_series[\"Valeur\"].rolling(window=7).mean()\r\ntime_series.head(10)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0fa8923 elementor-widget elementor-widget-text-editor\" data-id=\"0fa8923\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On obtient le dataframe suivant. Nous pouvons voir que les six premi\u00e8res lignes n\u2019ont pas de valeur pour la moyenne mobile. Cela vient du fait que la moyenne mobile pour une date est calcul\u00e9e \u00e0 partir des dates pr\u00e9c\u00e9dentes.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-87a9eb6 elementor-widget elementor-widget-image\" data-id=\"87a9eb6\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"404\" height=\"435\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image6-1.png\" class=\"attachment-full size-full wp-image-233930\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image6-1.png 404w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image6-1-279x300.png 279w\" sizes=\"(max-width: 404px) 100vw, 404px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-02cfe02 elementor-widget elementor-widget-text-editor\" data-id=\"02cfe02\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On affiche ensuite la s\u00e9rie initiale et la courbe de la moyenne glissante :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-b690037 elementor-widget elementor-widget-code-highlight\" data-id=\"b690037\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard word-wrap\">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>plt.figure(figsize=(10, 6))\r\nplt.plot(time_series[\"Valeur\"], label='S\u00e9rie Temporelle Al\u00e9atoire')\r\nplt.plot(time_series[\"moyenne_glissante\"], label='Moyenne Glissante (fen\u00eatre de 7 jours)', color='orange')\r\nplt.title('S\u00e9rie Temporelle Al\u00e9atoire avec Moyenne Glissante')\r\nplt.xlabel('Date')\r\nplt.ylabel('Valeur')\r\nplt.legend()\r\nplt.show()<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-940c833 elementor-widget elementor-widget-image\" data-id=\"940c833\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"1096\" height=\"683\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image5-1.png\" class=\"attachment-full size-full wp-image-233934\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image5-1.png 1096w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image5-1-300x187.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image5-1-1024x638.png 1024w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image5-1-768x479.png 768w\" sizes=\"(max-width: 1096px) 100vw, 1096px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-a01a861 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"a01a861\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-analyst\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 ajouter une moyenne glissante<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-2fcd1ea e-flex e-con-boxed e-con\" data-id=\"2fcd1ea\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-ef1cd1e elementor-widget elementor-widget-heading\" data-id=\"ef1cd1e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">5. Afficher des courbes dans un dataframe<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-729e4a9 elementor-widget elementor-widget-text-editor\" data-id=\"729e4a9\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Il est possible d\u2019ajouter des courbes dans un dataframe<\/span><\/p><p><span style=\"font-weight: 400;\">On importe les librairies n\u00e9cessaires :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d13dcb7 elementor-widget elementor-widget-code-highlight\" data-id=\"d13dcb7\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>import pandas as pd\r\nimport numpy as np\r\nimport matplotlib.pyplot as plt\r\n\r\n\r\nfrom base64 import b64encode\r\nfrom io import BytesIO\r\nfrom IPython.display import HTML<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ec14f76 elementor-widget elementor-widget-text-editor\" data-id=\"ec14f76\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On ajoute ensuite la ligne suivante pour permettre \u00e0 Matplotlib d\u2019afficher des graphiques dans le flux du code :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-12495d0 elementor-widget elementor-widget-code-highlight\" data-id=\"12495d0\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>%matplotlib inline<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-df3da34 elementor-widget elementor-widget-text-editor\" data-id=\"df3da34\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On cr\u00e9e ensuite un dataframe avec des donn\u00e9es al\u00e9atoires :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0ff9189 elementor-widget elementor-widget-code-highlight\" data-id=\"0ff9189\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>data = [('Euro', np.random.randint(40000, size=100)),\r\n        ('Dollar', np.random.randint(5000, size=100)),\r\n        ('Yen', np.random.randint(15000, size=100))]\r\n\r\n\r\ndf = pd.DataFrame(data, columns=['Devise', 'Cours'])<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7e8d159 elementor-widget elementor-widget-text-editor\" data-id=\"7e8d159\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">On va ensuite d\u00e9finir une fonction pour cr\u00e9er les courbes que l\u2019on veut afficher :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-885c38c elementor-widget elementor-widget-code-highlight\" data-id=\"885c38c\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp># On convertit le dataframe en liste\r\n    data = list(data)\r\n\r\n\r\n    # On cr\u00e9e le graphique avec une taille d\u00e9finie\r\n    fig, ax = plt.subplots(1, 1, figsize=(5, 1))\r\n\r\n\r\n    # On affiche les donn\u00e9es\r\n    ax.plot(data)\r\n\r\n\r\n    # On ferme le graphique pour ne pas qu\u2019il s\u2019affiche en dehors des endroits voulus\r\n    plt.close(fig)\r\n\r\n\r\n    # On enregistre l\u2019image en png et on sauvegarde ses donn\u00e9es binaires\r\n    img = BytesIO()\r\n    fig.savefig(img, format='png')\r\n    encoded = b64encode(img.getvalue()).decode('utf-8')\r\n\r\n\r\n    # On renvoie l\u2019image encod\u00e9e en HTML\r\n    return '<img decoding=\"async\" src=\"data:image\/png;base64,{}\"\/>'.format(encoded)<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e633102 elementor-widget elementor-widget-text-editor\" data-id=\"e633102\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Enfin, on affiche le dataframe avec les courbes :<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-fe03454 elementor-widget elementor-widget-code-highlight\" data-id=\"fe03454\" data-element_type=\"widget\" data-widget_type=\"code-highlight.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"prismjs-default copy-to-clipboard \">\n\t\t\t<pre data-line=\"\" class=\"highlight-height language-python \">\n\t\t\t\t<code readonly=\"true\" class=\"language-python\">\n\t\t\t\t\t<xmp>df['Courbe du cours'] = df['Cours'].apply(create_line)\r\nHTML(df.drop(columns = ['Cours']).to_html(escape=False))<\/xmp>\n\t\t\t\t<\/code>\n\t\t\t<\/pre>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c02c98 elementor-widget elementor-widget-image\" data-id=\"8c02c98\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"825\" height=\"508\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image3-1.png\" class=\"attachment-full size-full wp-image-233935\" alt=\"\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image3-1.png 825w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image3-1-300x185.png 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/image3-1-768x473.png 768w\" sizes=\"(max-width: 825px) 100vw, 825px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-3498abe elementor-widget elementor-widget-text-editor\" data-id=\"3498abe\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Les diff\u00e9rentes fonctions pr\u00e9sent\u00e9es dans cet article vous permettront d\u2019<strong>ajouter des informations dans vos dataframes<\/strong> et ainsi en tirer plus de donn\u00e9es pertinentes lorsque vous devrez les pr\u00e9senter !<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-d5bbaa0 elementor-widget elementor-widget-text-editor\" data-id=\"d5bbaa0\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Si vous souhaitez ma\u00eetriser les dataframes de A \u00e0 Z, <strong>consultez notre formation de Data Scientist<\/strong> !<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e827a23 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e827a23\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-data-analyst\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir notre formation Data Scientist<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-cbd6374 elementor-widget elementor-widget-html\" data-id=\"cbd6374\" data-element_type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<script type=\"application\/ld+json\">\r\n{\r\n  \"@context\": \"https:\/\/schema.org\",\r\n  \"@type\": \"FAQPage\",\r\n  \"mainEntity\": [{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Qu\u2019est-ce que Pandas ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"La biblioth\u00e8que logicielle open-source Pandas est sp\u00e9cifiquement con\u00e7ue pour la manipulation et l\u2019analyse de donn\u00e9es en langage Python. Elle est \u00e0 la fois performante, flexible et simple d\u2019utilisation.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"Comment fonctionne Pandas ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Pandas fonctionne gr\u00e2ce aux \u00ab DataFrames \u00bb : des tableaux de donn\u00e9es en deux dimensions, dont chaque colonne contient les valeurs d\u2019une variable et chaque ligne contient un ensemble de valeurs de chaque colonne. Les donn\u00e9es stock\u00e9es dans un DataFrame peuvent \u00eatre des nombres ou des caract\u00e8res.\"\r\n    }\r\n  },{\r\n    \"@type\": \"Question\",\r\n    \"name\": \"\u00c0 quoi vous servent les astuces Pandas ?\",\r\n    \"acceptedAnswer\": {\r\n      \"@type\": \"Answer\",\r\n      \"text\": \"Les diff\u00e9rentes fonctions pr\u00e9sent\u00e9es dans cet article vous permettront d\u2019ajouter des informations dans vos dataframes et ainsi en tirer plus de donn\u00e9es pertinentes lorsque vous devrez les pr\u00e9senter !\"\r\n    }\r\n  }]\r\n}\r\n<\/script>\r\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Avec ses nombreuses fonctionnalit\u00e9s permettant de traiter les donn\u00e9es sur lesquelles nous travaillons, Pandas s\u2019est \u00e9tabli comme un outil indispensable pour les Data Scientists et Data Analysts. Dans cet article vous verrez quelques fonctions, assez m\u00e9connues, qui pourront changer votre mani\u00e8re de travailler. 1. Ajouter une l\u00e9gende \u00e0 un dataframe De la m\u00eame mani\u00e8re que [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":233904,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Les astuces Pandas indispensables pour transformer votre travail<\/title>\n<meta name=\"description\" content=\"De l&#039;ajout de l\u00e9gendes \u00e0 l&#039;affichage de courbes dans un dataframe, d\u00e9couvrez les astuces Pandas indispensables pour optimiser votre travail.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/astuces-pandas-indispensables\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Les astuces Pandas indispensables pour transformer votre travail\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/astuces-pandas-indispensables\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-21T09:21:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-11-07T10:42:23+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/Illu_BLOG__GCollab-copie.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"562\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/astuces-pandas-indispensables\",\"url\":\"https:\/\/datascientest.com\/astuces-pandas-indispensables\",\"name\":\"Les astuces Pandas indispensables pour transformer votre travail\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2024-03-21T09:21:40+00:00\",\"dateModified\":\"2024-11-07T10:42:23+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"De l'ajout de l\u00e9gendes \u00e0 l'affichage de courbes dans un dataframe, d\u00e9couvrez les astuces Pandas indispensables pour optimiser votre travail.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/astuces-pandas-indispensables\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Les astuces Pandas indispensables pour transformer votre travail","description":"De l'ajout de l\u00e9gendes \u00e0 l'affichage de courbes dans un dataframe, d\u00e9couvrez les astuces Pandas indispensables pour optimiser votre travail.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/datascientest.com\/astuces-pandas-indispensables","og_locale":"fr_FR","og_type":"article","og_title":"Les astuces Pandas indispensables pour transformer votre travail","og_url":"https:\/\/datascientest.com\/astuces-pandas-indispensables","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2024-03-21T09:21:40+00:00","article_modified_time":"2024-11-07T10:42:23+00:00","og_image":[{"width":1024,"height":562,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2024\/03\/Illu_BLOG__GCollab-copie.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/astuces-pandas-indispensables","url":"https:\/\/datascientest.com\/astuces-pandas-indispensables","name":"Les astuces Pandas indispensables pour transformer votre travail","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2024-03-21T09:21:40+00:00","dateModified":"2024-11-07T10:42:23+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"De l'ajout de l\u00e9gendes \u00e0 l'affichage de courbes dans un dataframe, d\u00e9couvrez les astuces Pandas indispensables pour optimiser votre travail.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/astuces-pandas-indispensables"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/233902"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=233902"}],"version-history":[{"count":1,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/233902\/revisions"}],"predecessor-version":[{"id":256440,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/233902\/revisions\/256440"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/233904"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=233902"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=233902"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=233902"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}