Untitled1.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 128,
   "id": "sunset-jumping",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 129,
   "id": "accredited-miracle",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 130,
   "id": "hollow-divorce",
   "metadata": {},
   "outputs": [],
   "source": [
    "#QUESTION 1\n",
    "df = pd.read_csv('mower_market_snapshot.csv', delimiter=';') #Lire fichier CSV"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 131,
   "id": "banned-inflation",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>44.959895</td>\n",
       "      <td>0.234647</td>\n",
       "      <td>18451</td>\n",
       "      <td>63.662561</td>\n",
       "      <td>75.161102</td>\n",
       "      <td>11.498540481074583</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.000973</td>\n",
       "      <td>0.513126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>59.356058</td>\n",
       "      <td>0.253694</td>\n",
       "      <td>18663</td>\n",
       "      <td>64.014543</td>\n",
       "      <td>75.395132</td>\n",
       "      <td>11.380588736668567</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1ans</td>\n",
       "      <td>0.001038</td>\n",
       "      <td>0.547739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>67.865222</td>\n",
       "      <td>0.228935</td>\n",
       "      <td>19169</td>\n",
       "      <td>62.132035</td>\n",
       "      <td>810.883148</td>\n",
       "      <td>unknown</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001243</td>\n",
       "      <td>0.655622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>66.855435</td>\n",
       "      <td>0.244948</td>\n",
       "      <td>18946</td>\n",
       "      <td>58.697122</td>\n",
       "      <td>68.491318</td>\n",
       "      <td>9.794196773761458</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001644</td>\n",
       "      <td>0.867537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>54.712713</td>\n",
       "      <td>0.177143</td>\n",
       "      <td>19017</td>\n",
       "      <td>64.259212</td>\n",
       "      <td>74.955428</td>\n",
       "      <td>10.696216086742934</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001022</td>\n",
       "      <td>0.538969</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin       price  \\\n",
       "0     10.492623      0.042528  18377  633.766584  828.802103   \n",
       "1     20.273730      0.037896  19363  731.576817  882.894916   \n",
       "2     20.190457      0.039111  19641  741.218202  919.355522   \n",
       "3     27.220131      0.041303  18728  654.255635  817.085097   \n",
       "4     16.370911      0.037938  18722  703.094527  844.581465   \n",
       "...         ...           ...    ...         ...         ...   \n",
       "1394  44.959895      0.234647  18451   63.662561   75.161102   \n",
       "1395  59.356058      0.253694  18663   64.014543   75.395132   \n",
       "1396  67.865222      0.228935  19169   62.132035  810.883148   \n",
       "1397  66.855435      0.244948  18946   58.697122   68.491318   \n",
       "1398  54.712713      0.177143  19017   64.259212   74.955428   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "0     195.03551928211797  auto-portee     Low     3ans      0.006360   \n",
       "1     151.31809934886763  auto-portee     Low   3 ans.      0.006840   \n",
       "2     178.13731921134948  auto-portee     Low    3_ans      0.006179   \n",
       "3     162.82946157588628  auto-portee     Low   3 anss      0.007925   \n",
       "4     141.48693796090603  auto-portee  Medium    3ans.      0.007406   \n",
       "...                  ...          ...     ...      ...           ...   \n",
       "1394  11.498540481074583      essence  Medium     1 an      0.000973   \n",
       "1395  11.380588736668567      essence     Low     1ans      0.001038   \n",
       "1396             unknown      essence     Low     1an.      0.001243   \n",
       "1397   9.794196773761458      essence     Low     1 an      0.001644   \n",
       "1398  10.696216086742934      essence     Low     1an.      0.001022   \n",
       "\n",
       "      attractiveness  \n",
       "0           0.650648  \n",
       "1           0.699792  \n",
       "2           0.632129  \n",
       "3           0.810730  \n",
       "4           0.757614  \n",
       "...              ...  \n",
       "1394        0.513126  \n",
       "1395        0.547739  \n",
       "1396        0.655622  \n",
       "1397        0.867537  \n",
       "1398        0.538969  \n",
       "\n",
       "[1399 rows x 11 columns]"
      ]
     },
     "execution_count": 131,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 132,
   "id": "increasing-sessions",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1399.000000</td>\n",
       "      <td>1399.000000</td>\n",
       "      <td>1399.000000</td>\n",
       "      <td>1399.000000</td>\n",
       "      <td>1399.000000</td>\n",
       "      <td>1399.000000</td>\n",
       "      <td>1399.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>47.663266</td>\n",
       "      <td>0.166448</td>\n",
       "      <td>18958.000000</td>\n",
       "      <td>186.262609</td>\n",
       "      <td>260.075165</td>\n",
       "      <td>0.002144</td>\n",
       "      <td>0.636507</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>19.840501</td>\n",
       "      <td>0.073605</td>\n",
       "      <td>404.000825</td>\n",
       "      <td>191.011102</td>\n",
       "      <td>259.949127</td>\n",
       "      <td>0.001790</td>\n",
       "      <td>0.124016</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>0.013884</td>\n",
       "      <td>0.028906</td>\n",
       "      <td>18259.000000</td>\n",
       "      <td>52.943989</td>\n",
       "      <td>62.162200</td>\n",
       "      <td>0.000564</td>\n",
       "      <td>0.297384</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>35.853890</td>\n",
       "      <td>0.095678</td>\n",
       "      <td>18608.500000</td>\n",
       "      <td>62.247602</td>\n",
       "      <td>73.379425</td>\n",
       "      <td>0.001135</td>\n",
       "      <td>0.549369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>50.309242</td>\n",
       "      <td>0.199796</td>\n",
       "      <td>18958.000000</td>\n",
       "      <td>66.299672</td>\n",
       "      <td>78.439753</td>\n",
       "      <td>0.001399</td>\n",
       "      <td>0.641351</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>61.905015</td>\n",
       "      <td>0.228011</td>\n",
       "      <td>19307.500000</td>\n",
       "      <td>265.370973</td>\n",
       "      <td>384.265263</td>\n",
       "      <td>0.002446</td>\n",
       "      <td>0.726746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>104.614865</td>\n",
       "      <td>0.302465</td>\n",
       "      <td>19657.000000</td>\n",
       "      <td>790.012898</td>\n",
       "      <td>964.973926</td>\n",
       "      <td>0.009314</td>\n",
       "      <td>0.952877</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          capacity  failure_rate            id       margin        price  \\\n",
       "count  1399.000000   1399.000000   1399.000000  1399.000000  1399.000000   \n",
       "mean     47.663266      0.166448  18958.000000   186.262609   260.075165   \n",
       "std      19.840501      0.073605    404.000825   191.011102   259.949127   \n",
       "min       0.013884      0.028906  18259.000000    52.943989    62.162200   \n",
       "25%      35.853890      0.095678  18608.500000    62.247602    73.379425   \n",
       "50%      50.309242      0.199796  18958.000000    66.299672    78.439753   \n",
       "75%      61.905015      0.228011  19307.500000   265.370973   384.265263   \n",
       "max     104.614865      0.302465  19657.000000   790.012898   964.973926   \n",
       "\n",
       "       market_share  attractiveness  \n",
       "count   1399.000000     1399.000000  \n",
       "mean       0.002144        0.636507  \n",
       "std        0.001790        0.124016  \n",
       "min        0.000564        0.297384  \n",
       "25%        0.001135        0.549369  \n",
       "50%        0.001399        0.641351  \n",
       "75%        0.002446        0.726746  \n",
       "max        0.009314        0.952877  "
      ]
     },
     "execution_count": 132,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#QUESTION 2\n",
    "df.describe() #fonction describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 133,
   "id": "exposed-asian",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>19.548213</td>\n",
       "      <td>0.035428</td>\n",
       "      <td>18268</td>\n",
       "      <td>728.284617</td>\n",
       "      <td>905.297503</td>\n",
       "      <td>177.01288573033196</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3 ans</td>\n",
       "      <td>0.007596</td>\n",
       "      <td>0.777051</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    capacity  failure_rate     id      margin       price           prod_cost  \\\n",
       "0  10.492623      0.042528  18377  633.766584  828.802103  195.03551928211797   \n",
       "1  20.273730      0.037896  19363  731.576817  882.894916  151.31809934886763   \n",
       "2  20.190457      0.039111  19641  741.218202  919.355522  178.13731921134948   \n",
       "3  27.220131      0.041303  18728  654.255635  817.085097  162.82946157588628   \n",
       "4  16.370911      0.037938  18722  703.094527  844.581465  141.48693796090603   \n",
       "5  19.548213      0.035428  18268  728.284617  905.297503  177.01288573033196   \n",
       "\n",
       "  product_type quality warranty  market_share  attractiveness  \n",
       "0  auto-portee     Low     3ans      0.006360        0.650648  \n",
       "1  auto-portee     Low   3 ans.      0.006840        0.699792  \n",
       "2  auto-portee     Low    3_ans      0.006179        0.632129  \n",
       "3  auto-portee     Low   3 anss      0.007925        0.810730  \n",
       "4  auto-portee  Medium    3ans.      0.007406        0.757614  \n",
       "5  auto-portee  Medium    3 ans      0.007596        0.777051  "
      ]
     },
     "execution_count": 133,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[:5] #fonction loc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 134,
   "id": "palestinian-madonna",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>19.548213</td>\n",
       "      <td>0.035428</td>\n",
       "      <td>18268</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    capacity  failure_rate     id\n",
       "2  20.190457      0.039111  19641\n",
       "3  27.220131      0.041303  18728\n",
       "4  16.370911      0.037938  18722\n",
       "5  19.548213      0.035428  18268"
      ]
     },
     "execution_count": 134,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[2:5,('capacity','failure_rate','id')]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "id": "graphic-certificate",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>43.410781</td>\n",
       "      <td>0.089094</td>\n",
       "      <td>19576</td>\n",
       "      <td>286.579692</td>\n",
       "      <td>62.162200</td>\n",
       "      <td>0</td>\n",
       "      <td>electrique</td>\n",
       "      <td>Low</td>\n",
       "      <td>2 anss</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>0.622614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1052</th>\n",
       "      <td>50.843741</td>\n",
       "      <td>0.195125</td>\n",
       "      <td>18366</td>\n",
       "      <td>53.272369</td>\n",
       "      <td>62.855737</td>\n",
       "      <td>9.583368011630627</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an.</td>\n",
       "      <td>0.001364</td>\n",
       "      <td>0.719494</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>696</th>\n",
       "      <td>63.785109</td>\n",
       "      <td>0.228977</td>\n",
       "      <td>18315</td>\n",
       "      <td>55.156346</td>\n",
       "      <td>63.692980</td>\n",
       "      <td>8.536633990796986</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an.</td>\n",
       "      <td>0.001374</td>\n",
       "      <td>0.724895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>710</th>\n",
       "      <td>55.682973</td>\n",
       "      <td>0.219791</td>\n",
       "      <td>18808</td>\n",
       "      <td>53.612922</td>\n",
       "      <td>63.984195</td>\n",
       "      <td>10.371273145783007</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001545</td>\n",
       "      <td>0.815051</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>919</th>\n",
       "      <td>49.237933</td>\n",
       "      <td>0.232052</td>\n",
       "      <td>18290</td>\n",
       "      <td>55.214844</td>\n",
       "      <td>64.146445</td>\n",
       "      <td>8.931600382421172</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an</td>\n",
       "      <td>0.001269</td>\n",
       "      <td>0.669645</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin      price  \\\n",
       "535   43.410781      0.089094  19576  286.579692  62.162200   \n",
       "1052  50.843741      0.195125  18366   53.272369  62.855737   \n",
       "696   63.785109      0.228977  18315   55.156346  63.692980   \n",
       "710   55.682973      0.219791  18808   53.612922  63.984195   \n",
       "919   49.237933      0.232052  18290   55.214844  64.146445   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "535                    0   electrique     Low   2 anss      0.002389   \n",
       "1052   9.583368011630627      essence     Low    1 an.      0.001364   \n",
       "696    8.536633990796986      essence     Low    1 an.      0.001374   \n",
       "710   10.371273145783007      essence     Low     1 an      0.001545   \n",
       "919    8.931600382421172      essence     Low      1an      0.001269   \n",
       "\n",
       "      attractiveness  \n",
       "535         0.622614  \n",
       "1052        0.719494  \n",
       "696         0.724895  \n",
       "710         0.815051  \n",
       "919         0.669645  "
      ]
     },
     "execution_count": 135,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.sort_values(by='price', ascending=True).head() #fonction sort_values() + head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 136,
   "id": "specific-damage",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>66.180234</td>\n",
       "      <td>0.249758</td>\n",
       "      <td>18259</td>\n",
       "      <td>61.182062</td>\n",
       "      <td>71.867486</td>\n",
       "      <td>10.685424253813672</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an.</td>\n",
       "      <td>0.00154</td>\n",
       "      <td>0.81269</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id     margin      price  \\\n",
       "1051  66.180234      0.249758  18259  61.182062  71.867486   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "1051  10.685424253813672      essence     Low    1 an.       0.00154   \n",
       "\n",
       "      attractiveness  \n",
       "1051         0.81269  "
      ]
     },
     "execution_count": 136,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['id']==18259] #une vue != ..."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "id": "pacific-necklace",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>66.180234</td>\n",
       "      <td>0.249758</td>\n",
       "      <td>18259</td>\n",
       "      <td>61.182062</td>\n",
       "      <td>71.867486</td>\n",
       "      <td>10.685424253813672</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an.</td>\n",
       "      <td>0.00154</td>\n",
       "      <td>0.81269</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id     margin      price  \\\n",
       "1051  66.180234      0.249758  18259  61.182062  71.867486   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "1051  10.685424253813672      essence     Low    1 an.       0.00154   \n",
       "\n",
       "      attractiveness  \n",
       "1051         0.81269  "
      ]
     },
     "execution_count": 137,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['id']==18259,:] #... une copie avec loc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 138,
   "id": "useful-wheat",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>781</th>\n",
       "      <td>0.059048</td>\n",
       "      <td>0.241700</td>\n",
       "      <td>18262</td>\n",
       "      <td>58.573978</td>\n",
       "      <td>68.418652</td>\n",
       "      <td>9.844674524572053</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001324</td>\n",
       "      <td>0.698436</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1051</th>\n",
       "      <td>66.180234</td>\n",
       "      <td>0.249758</td>\n",
       "      <td>18259</td>\n",
       "      <td>61.182062</td>\n",
       "      <td>71.867486</td>\n",
       "      <td>10.685424253813672</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an.</td>\n",
       "      <td>0.001540</td>\n",
       "      <td>0.812690</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id     margin      price  \\\n",
       "781    0.059048      0.241700  18262  58.573978  68.418652   \n",
       "1051  66.180234      0.249758  18259  61.182062  71.867486   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "781    9.844674524572053      essence     Low     1 an      0.001324   \n",
       "1051  10.685424253813672      essence     Low    1 an.      0.001540   \n",
       "\n",
       "      attractiveness  \n",
       "781         0.698436  \n",
       "1051        0.812690  "
      ]
     },
     "execution_count": 138,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['id'].isin([18259,18262])] "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 139,
   "id": "exact-pathology",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    capacity  failure_rate\n",
       "0  10.492623      0.042528\n",
       "1  20.273730      0.037896\n",
       "2  20.190457      0.039111\n",
       "3  27.220131      0.041303\n",
       "4  16.370911      0.037938"
      ]
     },
     "execution_count": 139,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[:5,:2] #fonction iloc"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "id": "changing-island",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>44.959895</td>\n",
       "      <td>0.234647</td>\n",
       "      <td>18451</td>\n",
       "      <td>63.662561</td>\n",
       "      <td>75.161102</td>\n",
       "      <td>11.498540481074583</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.000973</td>\n",
       "      <td>0.513126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>59.356058</td>\n",
       "      <td>0.253694</td>\n",
       "      <td>18663</td>\n",
       "      <td>64.014543</td>\n",
       "      <td>75.395132</td>\n",
       "      <td>11.380588736668567</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1ans</td>\n",
       "      <td>0.001038</td>\n",
       "      <td>0.547739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>67.865222</td>\n",
       "      <td>0.228935</td>\n",
       "      <td>19169</td>\n",
       "      <td>62.132035</td>\n",
       "      <td>810.883148</td>\n",
       "      <td>unknown</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001243</td>\n",
       "      <td>0.655622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>66.855435</td>\n",
       "      <td>0.244948</td>\n",
       "      <td>18946</td>\n",
       "      <td>58.697122</td>\n",
       "      <td>68.491318</td>\n",
       "      <td>9.794196773761458</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001644</td>\n",
       "      <td>0.867537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>54.712713</td>\n",
       "      <td>0.177143</td>\n",
       "      <td>19017</td>\n",
       "      <td>64.259212</td>\n",
       "      <td>74.955428</td>\n",
       "      <td>10.696216086742934</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001022</td>\n",
       "      <td>0.538969</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1381 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin       price  \\\n",
       "0     10.492623      0.042528  18377  633.766584  828.802103   \n",
       "1     20.273730      0.037896  19363  731.576817  882.894916   \n",
       "2     20.190457      0.039111  19641  741.218202  919.355522   \n",
       "3     27.220131      0.041303  18728  654.255635  817.085097   \n",
       "4     16.370911      0.037938  18722  703.094527  844.581465   \n",
       "...         ...           ...    ...         ...         ...   \n",
       "1394  44.959895      0.234647  18451   63.662561   75.161102   \n",
       "1395  59.356058      0.253694  18663   64.014543   75.395132   \n",
       "1396  67.865222      0.228935  19169   62.132035  810.883148   \n",
       "1397  66.855435      0.244948  18946   58.697122   68.491318   \n",
       "1398  54.712713      0.177143  19017   64.259212   74.955428   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "0     195.03551928211797  auto-portee     Low     3ans      0.006360   \n",
       "1     151.31809934886763  auto-portee     Low   3 ans.      0.006840   \n",
       "2     178.13731921134948  auto-portee     Low    3_ans      0.006179   \n",
       "3     162.82946157588628  auto-portee     Low   3 anss      0.007925   \n",
       "4     141.48693796090603  auto-portee  Medium    3ans.      0.007406   \n",
       "...                  ...          ...     ...      ...           ...   \n",
       "1394  11.498540481074583      essence  Medium     1 an      0.000973   \n",
       "1395  11.380588736668567      essence     Low     1ans      0.001038   \n",
       "1396             unknown      essence     Low     1an.      0.001243   \n",
       "1397   9.794196773761458      essence     Low     1 an      0.001644   \n",
       "1398  10.696216086742934      essence     Low     1an.      0.001022   \n",
       "\n",
       "      attractiveness  \n",
       "0           0.650648  \n",
       "1           0.699792  \n",
       "2           0.632129  \n",
       "3           0.810730  \n",
       "4           0.757614  \n",
       "...              ...  \n",
       "1394        0.513126  \n",
       "1395        0.547739  \n",
       "1396        0.655622  \n",
       "1397        0.867537  \n",
       "1398        0.538969  \n",
       "\n",
       "[1381 rows x 11 columns]"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna() #fonction dropana()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "id": "sophisticated-replacement",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>44.959895</td>\n",
       "      <td>0.234647</td>\n",
       "      <td>18451</td>\n",
       "      <td>63.662561</td>\n",
       "      <td>75.161102</td>\n",
       "      <td>11.498540481074583</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.000973</td>\n",
       "      <td>0.513126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>59.356058</td>\n",
       "      <td>0.253694</td>\n",
       "      <td>18663</td>\n",
       "      <td>64.014543</td>\n",
       "      <td>75.395132</td>\n",
       "      <td>11.380588736668567</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1ans</td>\n",
       "      <td>0.001038</td>\n",
       "      <td>0.547739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>67.865222</td>\n",
       "      <td>0.228935</td>\n",
       "      <td>19169</td>\n",
       "      <td>62.132035</td>\n",
       "      <td>810.883148</td>\n",
       "      <td>unknown</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001243</td>\n",
       "      <td>0.655622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>66.855435</td>\n",
       "      <td>0.244948</td>\n",
       "      <td>18946</td>\n",
       "      <td>58.697122</td>\n",
       "      <td>68.491318</td>\n",
       "      <td>9.794196773761458</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001644</td>\n",
       "      <td>0.867537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>54.712713</td>\n",
       "      <td>0.177143</td>\n",
       "      <td>19017</td>\n",
       "      <td>64.259212</td>\n",
       "      <td>74.955428</td>\n",
       "      <td>10.696216086742934</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001022</td>\n",
       "      <td>0.538969</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin       price  \\\n",
       "0     10.492623      0.042528  18377  633.766584  828.802103   \n",
       "1     20.273730      0.037896  19363  731.576817  882.894916   \n",
       "2     20.190457      0.039111  19641  741.218202  919.355522   \n",
       "3     27.220131      0.041303  18728  654.255635  817.085097   \n",
       "4     16.370911      0.037938  18722  703.094527  844.581465   \n",
       "...         ...           ...    ...         ...         ...   \n",
       "1394  44.959895      0.234647  18451   63.662561   75.161102   \n",
       "1395  59.356058      0.253694  18663   64.014543   75.395132   \n",
       "1396  67.865222      0.228935  19169   62.132035  810.883148   \n",
       "1397  66.855435      0.244948  18946   58.697122   68.491318   \n",
       "1398  54.712713      0.177143  19017   64.259212   74.955428   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "0     195.03551928211797  auto-portee     Low     3ans      0.006360   \n",
       "1     151.31809934886763  auto-portee     Low   3 ans.      0.006840   \n",
       "2     178.13731921134948  auto-portee     Low    3_ans      0.006179   \n",
       "3     162.82946157588628  auto-portee     Low   3 anss      0.007925   \n",
       "4     141.48693796090603  auto-portee  Medium    3ans.      0.007406   \n",
       "...                  ...          ...     ...      ...           ...   \n",
       "1394  11.498540481074583      essence  Medium     1 an      0.000973   \n",
       "1395  11.380588736668567      essence     Low     1ans      0.001038   \n",
       "1396             unknown      essence     Low     1an.      0.001243   \n",
       "1397   9.794196773761458      essence     Low     1 an      0.001644   \n",
       "1398  10.696216086742934      essence     Low     1an.      0.001022   \n",
       "\n",
       "      attractiveness  \n",
       "0           0.650648  \n",
       "1           0.699792  \n",
       "2           0.632129  \n",
       "3           0.810730  \n",
       "4           0.757614  \n",
       "...              ...  \n",
       "1394        0.513126  \n",
       "1395        0.547739  \n",
       "1396        0.655622  \n",
       "1397        0.867537  \n",
       "1398        0.538969  \n",
       "\n",
       "[1399 rows x 11 columns]"
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2 = df.copy() #Copie DataFrame\n",
    "df2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "id": "covered-defensive",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>44.959895</td>\n",
       "      <td>0.234647</td>\n",
       "      <td>18451</td>\n",
       "      <td>63.662561</td>\n",
       "      <td>75.161102</td>\n",
       "      <td>11.498540481074583</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.000973</td>\n",
       "      <td>0.513126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>59.356058</td>\n",
       "      <td>0.253694</td>\n",
       "      <td>18663</td>\n",
       "      <td>64.014543</td>\n",
       "      <td>75.395132</td>\n",
       "      <td>11.380588736668567</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1ans</td>\n",
       "      <td>0.001038</td>\n",
       "      <td>0.547739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>67.865222</td>\n",
       "      <td>0.228935</td>\n",
       "      <td>19169</td>\n",
       "      <td>62.132035</td>\n",
       "      <td>810.883148</td>\n",
       "      <td>unknown</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001243</td>\n",
       "      <td>0.655622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>66.855435</td>\n",
       "      <td>0.244948</td>\n",
       "      <td>18946</td>\n",
       "      <td>58.697122</td>\n",
       "      <td>68.491318</td>\n",
       "      <td>9.794196773761458</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001644</td>\n",
       "      <td>0.867537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>54.712713</td>\n",
       "      <td>0.177143</td>\n",
       "      <td>19017</td>\n",
       "      <td>64.259212</td>\n",
       "      <td>74.955428</td>\n",
       "      <td>10.696216086742934</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001022</td>\n",
       "      <td>0.538969</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin       price  \\\n",
       "0     10.492623      0.042528  18377  633.766584  828.802103   \n",
       "1     20.273730      0.037896  19363  731.576817  882.894916   \n",
       "2     20.190457      0.039111  19641  741.218202  919.355522   \n",
       "3     27.220131      0.041303  18728  654.255635  817.085097   \n",
       "4     16.370911      0.037938  18722  703.094527  844.581465   \n",
       "...         ...           ...    ...         ...         ...   \n",
       "1394  44.959895      0.234647  18451   63.662561   75.161102   \n",
       "1395  59.356058      0.253694  18663   64.014543   75.395132   \n",
       "1396  67.865222      0.228935  19169   62.132035  810.883148   \n",
       "1397  66.855435      0.244948  18946   58.697122   68.491318   \n",
       "1398  54.712713      0.177143  19017   64.259212   74.955428   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "0     195.03551928211797  auto-portee     Low     3ans      0.006360   \n",
       "1     151.31809934886763  auto-portee     Low   3 ans.      0.006840   \n",
       "2     178.13731921134948  auto-portee     Low    3_ans      0.006179   \n",
       "3     162.82946157588628  auto-portee     Low   3 anss      0.007925   \n",
       "4     141.48693796090603  auto-portee  Medium    3ans.      0.007406   \n",
       "...                  ...          ...     ...      ...           ...   \n",
       "1394  11.498540481074583      essence  Medium     1 an      0.000973   \n",
       "1395  11.380588736668567      essence     Low     1ans      0.001038   \n",
       "1396             unknown      essence     Low     1an.      0.001243   \n",
       "1397   9.794196773761458      essence     Low     1 an      0.001644   \n",
       "1398  10.696216086742934      essence     Low     1an.      0.001022   \n",
       "\n",
       "      attractiveness  \n",
       "0           0.650648  \n",
       "1           0.699792  \n",
       "2           0.632129  \n",
       "3           0.810730  \n",
       "4           0.757614  \n",
       "...              ...  \n",
       "1394        0.513126  \n",
       "1395        0.547739  \n",
       "1396        0.655622  \n",
       "1397        0.867537  \n",
       "1398        0.538969  \n",
       "\n",
       "[1399 rows x 11 columns]"
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df2.drop_duplicates() # fonction drop_duplicates() \n",
    "df2 #Pas de doublons"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 143,
   "id": "better-vision",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    capacity  failure_rate     id      margin       price           prod_cost  \\\n",
       "0  10.492623      0.042528  18377  633.766584  828.802103  195.03551928211797   \n",
       "1  20.273730      0.037896  19363  731.576817  882.894916  151.31809934886763   \n",
       "2  20.190457      0.039111  19641  741.218202  919.355522  178.13731921134948   \n",
       "3  27.220131      0.041303  18728  654.255635  817.085097  162.82946157588628   \n",
       "4  16.370911      0.037938  18722  703.094527  844.581465  141.48693796090603   \n",
       "0  10.492623      0.042528  18377  633.766584  828.802103  195.03551928211797   \n",
       "1  20.273730      0.037896  19363  731.576817  882.894916  151.31809934886763   \n",
       "2  20.190457      0.039111  19641  741.218202  919.355522  178.13731921134948   \n",
       "3  27.220131      0.041303  18728  654.255635  817.085097  162.82946157588628   \n",
       "4  16.370911      0.037938  18722  703.094527  844.581465  141.48693796090603   \n",
       "\n",
       "  product_type quality warranty  market_share  attractiveness  \n",
       "0  auto-portee     Low     3ans      0.006360        0.650648  \n",
       "1  auto-portee     Low   3 ans.      0.006840        0.699792  \n",
       "2  auto-portee     Low    3_ans      0.006179        0.632129  \n",
       "3  auto-portee     Low   3 anss      0.007925        0.810730  \n",
       "4  auto-portee  Medium    3ans.      0.007406        0.757614  \n",
       "0  auto-portee     Low     3ans      0.006360        0.650648  \n",
       "1  auto-portee     Low   3 ans.      0.006840        0.699792  \n",
       "2  auto-portee     Low    3_ans      0.006179        0.632129  \n",
       "3  auto-portee     Low   3 anss      0.007925        0.810730  \n",
       "4  auto-portee  Medium    3ans.      0.007406        0.757614  "
      ]
     },
     "execution_count": 143,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.concat([df.head(),df2.head()])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "sunset-stationery",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>product_type</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>auto-portee</th>\n",
       "      <td>2584.399203</td>\n",
       "      <td>5.321437</td>\n",
       "      <td>2701431</td>\n",
       "      <td>97115.734838</td>\n",
       "      <td>116631.583129</td>\n",
       "      <td>1.0</td>\n",
       "      <td>102.302514</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>electrique</th>\n",
       "      <td>15697.770195</td>\n",
       "      <td>39.609520</td>\n",
       "      <td>7829912</td>\n",
       "      <td>110199.284139</td>\n",
       "      <td>159033.286414</td>\n",
       "      <td>1.0</td>\n",
       "      <td>260.563075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>essence</th>\n",
       "      <td>48398.740356</td>\n",
       "      <td>187.929728</td>\n",
       "      <td>15990899</td>\n",
       "      <td>53266.371298</td>\n",
       "      <td>88180.285829</td>\n",
       "      <td>1.0</td>\n",
       "      <td>527.607446</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  capacity  failure_rate        id         margin  \\\n",
       "product_type                                                        \n",
       "auto-portee    2584.399203      5.321437   2701431   97115.734838   \n",
       "electrique    15697.770195     39.609520   7829912  110199.284139   \n",
       "essence       48398.740356    187.929728  15990899   53266.371298   \n",
       "\n",
       "                      price  market_share  attractiveness  \n",
       "product_type                                               \n",
       "auto-portee   116631.583129           1.0      102.302514  \n",
       "electrique    159033.286414           1.0      260.563075  \n",
       "essence        88180.285829           1.0      527.607446  "
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.groupby('product_type').sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "id": "successful-evaluation",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>prod_cost</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>-64</th>\n",
       "      <td>938.731080</td>\n",
       "      <td>3.051811</td>\n",
       "      <td>342132</td>\n",
       "      <td>3387.840282</td>\n",
       "      <td>10240.500750</td>\n",
       "      <td>0.036359</td>\n",
       "      <td>10.630728</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>909.966696</td>\n",
       "      <td>3.416788</td>\n",
       "      <td>380220</td>\n",
       "      <td>3937.177892</td>\n",
       "      <td>11518.947665</td>\n",
       "      <td>0.049090</td>\n",
       "      <td>13.077414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.000151312469615</th>\n",
       "      <td>73.070220</td>\n",
       "      <td>0.248440</td>\n",
       "      <td>18488</td>\n",
       "      <td>66.397478</td>\n",
       "      <td>76.397629</td>\n",
       "      <td>0.001112</td>\n",
       "      <td>0.586593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.002531748228646</th>\n",
       "      <td>47.548979</td>\n",
       "      <td>0.210551</td>\n",
       "      <td>19137</td>\n",
       "      <td>56.997519</td>\n",
       "      <td>67.000051</td>\n",
       "      <td>0.001316</td>\n",
       "      <td>0.694495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10.008485830089475</th>\n",
       "      <td>64.469214</td>\n",
       "      <td>0.171804</td>\n",
       "      <td>18657</td>\n",
       "      <td>63.624150</td>\n",
       "      <td>73.632636</td>\n",
       "      <td>0.001485</td>\n",
       "      <td>0.783491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99.25351366885364</th>\n",
       "      <td>52.985916</td>\n",
       "      <td>0.094458</td>\n",
       "      <td>18550</td>\n",
       "      <td>262.216458</td>\n",
       "      <td>361.469972</td>\n",
       "      <td>0.003328</td>\n",
       "      <td>0.867279</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99.28924427491876</th>\n",
       "      <td>28.163433</td>\n",
       "      <td>0.081322</td>\n",
       "      <td>18409</td>\n",
       "      <td>263.467438</td>\n",
       "      <td>362.756682</td>\n",
       "      <td>0.002882</td>\n",
       "      <td>0.750851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99.62971468653679</th>\n",
       "      <td>41.172818</td>\n",
       "      <td>0.094580</td>\n",
       "      <td>19521</td>\n",
       "      <td>254.211481</td>\n",
       "      <td>353.841195</td>\n",
       "      <td>0.002985</td>\n",
       "      <td>0.777871</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99.81312346726344</th>\n",
       "      <td>52.451596</td>\n",
       "      <td>0.083137</td>\n",
       "      <td>18708</td>\n",
       "      <td>254.872979</td>\n",
       "      <td>354.686102</td>\n",
       "      <td>0.003453</td>\n",
       "      <td>0.899721</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>unknown</th>\n",
       "      <td>615.673860</td>\n",
       "      <td>2.251474</td>\n",
       "      <td>244481</td>\n",
       "      <td>2308.169289</td>\n",
       "      <td>7698.074389</td>\n",
       "      <td>0.026610</td>\n",
       "      <td>8.378072</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1333 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      capacity  failure_rate      id       margin  \\\n",
       "prod_cost                                                           \n",
       "-64                 938.731080      3.051811  342132  3387.840282   \n",
       "0                   909.966696      3.416788  380220  3937.177892   \n",
       "10.000151312469615   73.070220      0.248440   18488    66.397478   \n",
       "10.002531748228646   47.548979      0.210551   19137    56.997519   \n",
       "10.008485830089475   64.469214      0.171804   18657    63.624150   \n",
       "...                        ...           ...     ...          ...   \n",
       "99.25351366885364    52.985916      0.094458   18550   262.216458   \n",
       "99.28924427491876    28.163433      0.081322   18409   263.467438   \n",
       "99.62971468653679    41.172818      0.094580   19521   254.211481   \n",
       "99.81312346726344    52.451596      0.083137   18708   254.872979   \n",
       "unknown             615.673860      2.251474  244481  2308.169289   \n",
       "\n",
       "                           price  market_share  attractiveness  \n",
       "prod_cost                                                       \n",
       "-64                 10240.500750      0.036359       10.630728  \n",
       "0                   11518.947665      0.049090       13.077414  \n",
       "10.000151312469615     76.397629      0.001112        0.586593  \n",
       "10.002531748228646     67.000051      0.001316        0.694495  \n",
       "10.008485830089475     73.632636      0.001485        0.783491  \n",
       "...                          ...           ...             ...  \n",
       "99.25351366885364     361.469972      0.003328        0.867279  \n",
       "99.28924427491876     362.756682      0.002882        0.750851  \n",
       "99.62971468653679     353.841195      0.002985        0.777871  \n",
       "99.81312346726344     354.686102      0.003453        0.899721  \n",
       "unknown              7698.074389      0.026610        8.378072  \n",
       "\n",
       "[1333 rows x 7 columns]"
      ]
     },
     "execution_count": 145,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#QUESTION 3\n",
    "df.groupby('prod_cost').sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 146,
   "id": "eleven-interim",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>25.136228</td>\n",
       "      <td>0.044026</td>\n",
       "      <td>19549</td>\n",
       "      <td>618.616295</td>\n",
       "      <td>69.359766</td>\n",
       "      <td>0</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.008874</td>\n",
       "      <td>0.907834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>18.669448</td>\n",
       "      <td>0.036297</td>\n",
       "      <td>19368</td>\n",
       "      <td>738.279214</td>\n",
       "      <td>424.738557</td>\n",
       "      <td>0</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3_ans.</td>\n",
       "      <td>0.007104</td>\n",
       "      <td>0.726770</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>12.417808</td>\n",
       "      <td>0.037797</td>\n",
       "      <td>19638</td>\n",
       "      <td>672.153234</td>\n",
       "      <td>74.156037</td>\n",
       "      <td>0</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Hight</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.007923</td>\n",
       "      <td>0.810591</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>224</th>\n",
       "      <td>38.004822</td>\n",
       "      <td>0.088918</td>\n",
       "      <td>18523</td>\n",
       "      <td>255.289862</td>\n",
       "      <td>75.161299</td>\n",
       "      <td>0</td>\n",
       "      <td>electrique</td>\n",
       "      <td>Low</td>\n",
       "      <td>2_anss</td>\n",
       "      <td>0.002752</td>\n",
       "      <td>0.717166</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>377</th>\n",
       "      <td>42.216049</td>\n",
       "      <td>0.090275</td>\n",
       "      <td>18512</td>\n",
       "      <td>274.573188</td>\n",
       "      <td>877.008432</td>\n",
       "      <td>0</td>\n",
       "      <td>electrique</td>\n",
       "      <td>Medium</td>\n",
       "      <td>2_ans.</td>\n",
       "      <td>0.002511</td>\n",
       "      <td>0.654159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>485</th>\n",
       "      <td>39.530576</td>\n",
       "      <td>0.098281</td>\n",
       "      <td>18731</td>\n",
       "      <td>266.559354</td>\n",
       "      <td>785.968557</td>\n",
       "      <td>0</td>\n",
       "      <td>electrique</td>\n",
       "      <td>Hight</td>\n",
       "      <td>2 anss</td>\n",
       "      <td>0.002300</td>\n",
       "      <td>0.599176</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>535</th>\n",
       "      <td>43.410781</td>\n",
       "      <td>0.089094</td>\n",
       "      <td>19576</td>\n",
       "      <td>286.579692</td>\n",
       "      <td>62.162200</td>\n",
       "      <td>0</td>\n",
       "      <td>electrique</td>\n",
       "      <td>Low</td>\n",
       "      <td>2 anss</td>\n",
       "      <td>0.002389</td>\n",
       "      <td>0.622614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>591</th>\n",
       "      <td>59.089766</td>\n",
       "      <td>0.198374</td>\n",
       "      <td>19065</td>\n",
       "      <td>66.589054</td>\n",
       "      <td>907.224715</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Hight</td>\n",
       "      <td>1 ans</td>\n",
       "      <td>0.001037</td>\n",
       "      <td>0.547045</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>632</th>\n",
       "      <td>53.057689</td>\n",
       "      <td>0.272022</td>\n",
       "      <td>19013</td>\n",
       "      <td>59.620476</td>\n",
       "      <td>746.037497</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1_an.</td>\n",
       "      <td>0.001348</td>\n",
       "      <td>0.711382</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771</th>\n",
       "      <td>71.079908</td>\n",
       "      <td>0.204975</td>\n",
       "      <td>19084</td>\n",
       "      <td>64.761574</td>\n",
       "      <td>370.268763</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1_an</td>\n",
       "      <td>0.001273</td>\n",
       "      <td>0.671882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>803</th>\n",
       "      <td>64.469214</td>\n",
       "      <td>0.171804</td>\n",
       "      <td>18657</td>\n",
       "      <td>63.624150</td>\n",
       "      <td>73.632636</td>\n",
       "      <td>10.008485830089475</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 ans</td>\n",
       "      <td>0.001485</td>\n",
       "      <td>0.783491</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>844</th>\n",
       "      <td>54.136865</td>\n",
       "      <td>0.212580</td>\n",
       "      <td>18956</td>\n",
       "      <td>58.926577</td>\n",
       "      <td>875.686141</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001409</td>\n",
       "      <td>0.743584</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>873</th>\n",
       "      <td>73.951245</td>\n",
       "      <td>0.246320</td>\n",
       "      <td>18687</td>\n",
       "      <td>63.080659</td>\n",
       "      <td>882.868848</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001277</td>\n",
       "      <td>0.673511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>922</th>\n",
       "      <td>72.423733</td>\n",
       "      <td>0.261196</td>\n",
       "      <td>19336</td>\n",
       "      <td>68.353986</td>\n",
       "      <td>782.073365</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Hight</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001087</td>\n",
       "      <td>0.573472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>950</th>\n",
       "      <td>49.481572</td>\n",
       "      <td>0.222445</td>\n",
       "      <td>19150</td>\n",
       "      <td>63.558960</td>\n",
       "      <td>373.261749</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 an.</td>\n",
       "      <td>0.001124</td>\n",
       "      <td>0.593181</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1027</th>\n",
       "      <td>45.927230</td>\n",
       "      <td>0.194101</td>\n",
       "      <td>18816</td>\n",
       "      <td>62.608835</td>\n",
       "      <td>863.234098</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 ans</td>\n",
       "      <td>0.001111</td>\n",
       "      <td>0.586140</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1030</th>\n",
       "      <td>48.159517</td>\n",
       "      <td>0.239981</td>\n",
       "      <td>19164</td>\n",
       "      <td>61.198935</td>\n",
       "      <td>378.073376</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001145</td>\n",
       "      <td>0.604087</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1077</th>\n",
       "      <td>38.713058</td>\n",
       "      <td>0.261767</td>\n",
       "      <td>18768</td>\n",
       "      <td>65.185911</td>\n",
       "      <td>852.153035</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.000833</td>\n",
       "      <td>0.439511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1104</th>\n",
       "      <td>0.080173</td>\n",
       "      <td>0.203146</td>\n",
       "      <td>18419</td>\n",
       "      <td>67.625805</td>\n",
       "      <td>374.466095</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an.</td>\n",
       "      <td>0.001079</td>\n",
       "      <td>0.569345</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1231</th>\n",
       "      <td>55.060353</td>\n",
       "      <td>0.196546</td>\n",
       "      <td>19193</td>\n",
       "      <td>61.635817</td>\n",
       "      <td>881.308880</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1_an.</td>\n",
       "      <td>0.001246</td>\n",
       "      <td>0.657331</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1373</th>\n",
       "      <td>69.419877</td>\n",
       "      <td>0.218645</td>\n",
       "      <td>18672</td>\n",
       "      <td>61.980466</td>\n",
       "      <td>863.736257</td>\n",
       "      <td>0</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1_an</td>\n",
       "      <td>0.001267</td>\n",
       "      <td>0.668634</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin       price  \\\n",
       "47    25.136228      0.044026  19549  618.616295   69.359766   \n",
       "64    18.669448      0.036297  19368  738.279214  424.738557   \n",
       "126   12.417808      0.037797  19638  672.153234   74.156037   \n",
       "224   38.004822      0.088918  18523  255.289862   75.161299   \n",
       "377   42.216049      0.090275  18512  274.573188  877.008432   \n",
       "485   39.530576      0.098281  18731  266.559354  785.968557   \n",
       "535   43.410781      0.089094  19576  286.579692   62.162200   \n",
       "591   59.089766      0.198374  19065   66.589054  907.224715   \n",
       "632   53.057689      0.272022  19013   59.620476  746.037497   \n",
       "771   71.079908      0.204975  19084   64.761574  370.268763   \n",
       "803   64.469214      0.171804  18657   63.624150   73.632636   \n",
       "844   54.136865      0.212580  18956   58.926577  875.686141   \n",
       "873   73.951245      0.246320  18687   63.080659  882.868848   \n",
       "922   72.423733      0.261196  19336   68.353986  782.073365   \n",
       "950   49.481572      0.222445  19150   63.558960  373.261749   \n",
       "1027  45.927230      0.194101  18816   62.608835  863.234098   \n",
       "1030  48.159517      0.239981  19164   61.198935  378.073376   \n",
       "1077  38.713058      0.261767  18768   65.185911  852.153035   \n",
       "1104   0.080173      0.203146  18419   67.625805  374.466095   \n",
       "1231  55.060353      0.196546  19193   61.635817  881.308880   \n",
       "1373  69.419877      0.218645  18672   61.980466  863.736257   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "47                     0  auto-portee  Medium    3ans.      0.008874   \n",
       "64                     0  auto-portee  Medium   3_ans.      0.007104   \n",
       "126                    0  auto-portee   Hight    3_ans      0.007923   \n",
       "224                    0   electrique     Low   2_anss      0.002752   \n",
       "377                    0   electrique  Medium   2_ans.      0.002511   \n",
       "485                    0   electrique   Hight   2 anss      0.002300   \n",
       "535                    0   electrique     Low   2 anss      0.002389   \n",
       "591                    0      essence   Hight    1 ans      0.001037   \n",
       "632                    0      essence     Low    1_an.      0.001348   \n",
       "771                    0      essence     Low     1_an      0.001273   \n",
       "803   10.008485830089475      essence  Medium    1 ans      0.001485   \n",
       "844                    0      essence     Low     1 an      0.001409   \n",
       "873                    0      essence     Low     1an.      0.001277   \n",
       "922                    0      essence   Hight     1 an      0.001087   \n",
       "950                    0      essence  Medium    1 an.      0.001124   \n",
       "1027                   0      essence  Medium    1 ans      0.001111   \n",
       "1030                   0      essence  Medium     1an.      0.001145   \n",
       "1077                   0      essence     Low     1 an      0.000833   \n",
       "1104                   0      essence     Low    1 an.      0.001079   \n",
       "1231                   0      essence     Low    1_an.      0.001246   \n",
       "1373                   0      essence     Low     1_an      0.001267   \n",
       "\n",
       "      attractiveness  \n",
       "47          0.907834  \n",
       "64          0.726770  \n",
       "126         0.810591  \n",
       "224         0.717166  \n",
       "377         0.654159  \n",
       "485         0.599176  \n",
       "535         0.622614  \n",
       "591         0.547045  \n",
       "632         0.711382  \n",
       "771         0.671882  \n",
       "803         0.783491  \n",
       "844         0.743584  \n",
       "873         0.673511  \n",
       "922         0.573472  \n",
       "950         0.593181  \n",
       "1027        0.586140  \n",
       "1030        0.604087  \n",
       "1077        0.439511  \n",
       "1104        0.569345  \n",
       "1231        0.657331  \n",
       "1373        0.668634  "
      ]
     },
     "execution_count": 146,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df[df['prod_cost'].isin(['0','10.008485830089475'])]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 147,
   "id": "preceding-foster",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "capacity                                               65801.907612\n",
       "failure_rate                                             229.864404\n",
       "id                                                         26180048\n",
       "margin                                                 257191.26206\n",
       "price                                                 354001.635745\n",
       "prod_cost         195.03551928211797151.31809934886763178.137319...\n",
       "product_type      auto-porteeauto-porteeauto-porteeauto-porteeau...\n",
       "quality           LowLowLowLowMediumMediumHightLowLowLowLowMediu...\n",
       "warranty          3ans3 ans.3_ans3 anss3ans.3 ans3_ans.3 anss3_a...\n",
       "market_share                                               2.959216\n",
       "attractiveness                                           878.549034\n",
       "dtype: object"
      ]
     },
     "execution_count": 147,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#QUESTION 4\n",
    "df.dropna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "id": "empirical-extension",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>828.802103</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3ans</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>882.894916</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 ans.</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>919.355522</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3_ans</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>817.085097</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Low</td>\n",
       "      <td>3 anss</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>844.581465</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>auto-portee</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3ans.</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>44.959895</td>\n",
       "      <td>0.234647</td>\n",
       "      <td>18451</td>\n",
       "      <td>63.662561</td>\n",
       "      <td>75.161102</td>\n",
       "      <td>11.498540481074583</td>\n",
       "      <td>essence</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.000973</td>\n",
       "      <td>0.513126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>59.356058</td>\n",
       "      <td>0.253694</td>\n",
       "      <td>18663</td>\n",
       "      <td>64.014543</td>\n",
       "      <td>75.395132</td>\n",
       "      <td>11.380588736668567</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1ans</td>\n",
       "      <td>0.001038</td>\n",
       "      <td>0.547739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>67.865222</td>\n",
       "      <td>0.228935</td>\n",
       "      <td>19169</td>\n",
       "      <td>62.132035</td>\n",
       "      <td>810.883148</td>\n",
       "      <td>unknown</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001243</td>\n",
       "      <td>0.655622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>66.855435</td>\n",
       "      <td>0.244948</td>\n",
       "      <td>18946</td>\n",
       "      <td>58.697122</td>\n",
       "      <td>68.491318</td>\n",
       "      <td>9.794196773761458</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1 an</td>\n",
       "      <td>0.001644</td>\n",
       "      <td>0.867537</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>54.712713</td>\n",
       "      <td>0.177143</td>\n",
       "      <td>19017</td>\n",
       "      <td>64.259212</td>\n",
       "      <td>74.955428</td>\n",
       "      <td>10.696216086742934</td>\n",
       "      <td>essence</td>\n",
       "      <td>Low</td>\n",
       "      <td>1an.</td>\n",
       "      <td>0.001022</td>\n",
       "      <td>0.538969</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1381 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin       price  \\\n",
       "0     10.492623      0.042528  18377  633.766584  828.802103   \n",
       "1     20.273730      0.037896  19363  731.576817  882.894916   \n",
       "2     20.190457      0.039111  19641  741.218202  919.355522   \n",
       "3     27.220131      0.041303  18728  654.255635  817.085097   \n",
       "4     16.370911      0.037938  18722  703.094527  844.581465   \n",
       "...         ...           ...    ...         ...         ...   \n",
       "1394  44.959895      0.234647  18451   63.662561   75.161102   \n",
       "1395  59.356058      0.253694  18663   64.014543   75.395132   \n",
       "1396  67.865222      0.228935  19169   62.132035  810.883148   \n",
       "1397  66.855435      0.244948  18946   58.697122   68.491318   \n",
       "1398  54.712713      0.177143  19017   64.259212   74.955428   \n",
       "\n",
       "               prod_cost product_type quality warranty  market_share  \\\n",
       "0     195.03551928211797  auto-portee     Low     3ans      0.006360   \n",
       "1     151.31809934886763  auto-portee     Low   3 ans.      0.006840   \n",
       "2     178.13731921134948  auto-portee     Low    3_ans      0.006179   \n",
       "3     162.82946157588628  auto-portee     Low   3 anss      0.007925   \n",
       "4     141.48693796090603  auto-portee  Medium    3ans.      0.007406   \n",
       "...                  ...          ...     ...      ...           ...   \n",
       "1394  11.498540481074583      essence  Medium     1 an      0.000973   \n",
       "1395  11.380588736668567      essence     Low     1ans      0.001038   \n",
       "1396             unknown      essence     Low     1an.      0.001243   \n",
       "1397   9.794196773761458      essence     Low     1 an      0.001644   \n",
       "1398  10.696216086742934      essence     Low     1an.      0.001022   \n",
       "\n",
       "      attractiveness  \n",
       "0           0.650648  \n",
       "1           0.699792  \n",
       "2           0.632129  \n",
       "3           0.810730  \n",
       "4           0.757614  \n",
       "...              ...  \n",
       "1394        0.513126  \n",
       "1395        0.547739  \n",
       "1396        0.655622  \n",
       "1397        0.867537  \n",
       "1398        0.538969  \n",
       "\n",
       "[1381 rows x 11 columns]"
      ]
     },
     "execution_count": 148,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# QUESTION 5\n",
    "df.dropna(how= 'any').fillna(df.mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "id": "general-hungary",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>warranty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3ans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3 ans.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3_ans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3 anss</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3ans.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>1 an</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>1ans</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>1an.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>1 an</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>1an.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     warranty\n",
       "0        3ans\n",
       "1      3 ans.\n",
       "2       3_ans\n",
       "3      3 anss\n",
       "4       3ans.\n",
       "...       ...\n",
       "1394     1 an\n",
       "1395     1ans\n",
       "1396     1an.\n",
       "1397     1 an\n",
       "1398     1an.\n",
       "\n",
       "[1399 rows x 1 columns]"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#QUESTION 6\n",
    "df.iloc[:,8:9]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 150,
   "id": "valid-liver",
   "metadata": {},
   "outputs": [],
   "source": [
    "#QUESTION 7\n",
    "df['warranty'].shape\n",
    "df['warranty'] = df['warranty'].str[0].astype(int)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "id": "cathedral-brazil",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>warranty</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      warranty\n",
       "0            3\n",
       "1            3\n",
       "2            3\n",
       "3            3\n",
       "4            3\n",
       "...        ...\n",
       "1394         1\n",
       "1395         1\n",
       "1396         1\n",
       "1397         1\n",
       "1398         1\n",
       "\n",
       "[1399 rows x 1 columns]"
      ]
     },
     "execution_count": 151,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[:,8:9]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 152,
   "id": "comic-sarah",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([3, 2, 1])"
      ]
     },
     "execution_count": 152,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#QUESTION 8\n",
    "df['warranty'].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "id": "banned-guitar",
   "metadata": {},
   "outputs": [],
   "source": [
    "#QUESTION 9\n",
    "def catPrice(price):\n",
    "    if price <= 301:\n",
    "        return '0-300'\n",
    "    elif (price >= 300) & (price <= 500):\n",
    "        return '301 - 500'\n",
    "    elif price >= 501:\n",
    "        return '500++'\n",
    "\n",
    "df['price'] = df['price'].map(catPrice)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 154,
   "id": "typical-chess",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>500++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>500++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>500++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>500++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>500++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>0-300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>0-300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>500++</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>0-300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>0-300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      price\n",
       "0     500++\n",
       "1     500++\n",
       "2     500++\n",
       "3     500++\n",
       "4     500++\n",
       "...     ...\n",
       "1394  0-300\n",
       "1395  0-300\n",
       "1396  500++\n",
       "1397  0-300\n",
       "1398  0-300\n",
       "\n",
       "[1399 rows x 1 columns]"
      ]
     },
     "execution_count": 154,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[:,4:5]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 155,
   "id": "entire-commons",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([1, 'electrique', 3], dtype=object)"
      ]
     },
     "execution_count": 155,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#QUESTION 10\n",
    "df.loc[df['product_type']=='auto-portee','product_type']=1\n",
    "df.loc[df['product_type']=='electique','product_type']=2\n",
    "df.loc[df['product_type']=='essence','product_type']=3\n",
    "df[\"product_type\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 156,
   "id": "selective-distribution",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>product_type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 1 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     product_type\n",
       "0               1\n",
       "1               1\n",
       "2               1\n",
       "3               1\n",
       "4               1\n",
       "...           ...\n",
       "1394            3\n",
       "1395            3\n",
       "1396            3\n",
       "1397            3\n",
       "1398            3\n",
       "\n",
       "[1399 rows x 1 columns]"
      ]
     },
     "execution_count": 156,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[:,6:7]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 160,
   "id": "romantic-template",
   "metadata": {},
   "outputs": [
    {
     "ename": "AttributeError",
     "evalue": "'DataFrame' object has no attribute 'boolTypeColumns'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mAttributeError\u001b[0m                            Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-160-51137cfeb4df>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m\u001b[0m\n\u001b[1;32m      8\u001b[0m     \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mdf\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'product_type'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m==\u001b[0m\u001b[0;36m3\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m'isEssence'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;32mTrue\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      9\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m---> 10\u001b[0;31m \u001b[0mdf\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mboolTypeColumns\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/opt/conda/lib/python3.8/site-packages/pandas/core/generic.py\u001b[0m in \u001b[0;36m__getattr__\u001b[0;34m(self, name)\u001b[0m\n\u001b[1;32m   5463\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_info_axis\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_can_hold_identifiers_and_holds_name\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   5464\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mname\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 5465\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mobject\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m__getattribute__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   5466\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   5467\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m__setattr__\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mname\u001b[0m\u001b[0;34m:\u001b[0m \u001b[0mstr\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalue\u001b[0m\u001b[0;34m)\u001b[0m \u001b[0;34m->\u001b[0m \u001b[0;32mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mAttributeError\u001b[0m: 'DataFrame' object has no attribute 'boolTypeColumns'"
     ]
    }
   ],
   "source": [
    "#QUESTION 11\n",
    "df=df.assign(isEssence=False)\n",
    "df=df.assign(isElectrique=False)\n",
    "df=df.assign(isAutoPortee=False)\n",
    "df.loc[df['product_type']==1,'isAutoPortee']=True\n",
    "df.loc[df['product_type']==2,'isElectrique']=True\n",
    "df.loc[df['product_type']==3,'isEssence']=True\n",
    "\n",
    "df.boolTypeColumns()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 158,
   "id": "permanent-orleans",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>capacity</th>\n",
       "      <th>failure_rate</th>\n",
       "      <th>id</th>\n",
       "      <th>margin</th>\n",
       "      <th>price</th>\n",
       "      <th>prod_cost</th>\n",
       "      <th>product_type</th>\n",
       "      <th>quality</th>\n",
       "      <th>warranty</th>\n",
       "      <th>market_share</th>\n",
       "      <th>attractiveness</th>\n",
       "      <th>isEssence</th>\n",
       "      <th>isElectrique</th>\n",
       "      <th>isAutoPortee</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10.492623</td>\n",
       "      <td>0.042528</td>\n",
       "      <td>18377</td>\n",
       "      <td>633.766584</td>\n",
       "      <td>500++</td>\n",
       "      <td>195.03551928211797</td>\n",
       "      <td>1</td>\n",
       "      <td>Low</td>\n",
       "      <td>3</td>\n",
       "      <td>0.006360</td>\n",
       "      <td>0.650648</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20.273730</td>\n",
       "      <td>0.037896</td>\n",
       "      <td>19363</td>\n",
       "      <td>731.576817</td>\n",
       "      <td>500++</td>\n",
       "      <td>151.31809934886763</td>\n",
       "      <td>1</td>\n",
       "      <td>Low</td>\n",
       "      <td>3</td>\n",
       "      <td>0.006840</td>\n",
       "      <td>0.699792</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>20.190457</td>\n",
       "      <td>0.039111</td>\n",
       "      <td>19641</td>\n",
       "      <td>741.218202</td>\n",
       "      <td>500++</td>\n",
       "      <td>178.13731921134948</td>\n",
       "      <td>1</td>\n",
       "      <td>Low</td>\n",
       "      <td>3</td>\n",
       "      <td>0.006179</td>\n",
       "      <td>0.632129</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>27.220131</td>\n",
       "      <td>0.041303</td>\n",
       "      <td>18728</td>\n",
       "      <td>654.255635</td>\n",
       "      <td>500++</td>\n",
       "      <td>162.82946157588628</td>\n",
       "      <td>1</td>\n",
       "      <td>Low</td>\n",
       "      <td>3</td>\n",
       "      <td>0.007925</td>\n",
       "      <td>0.810730</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>16.370911</td>\n",
       "      <td>0.037938</td>\n",
       "      <td>18722</td>\n",
       "      <td>703.094527</td>\n",
       "      <td>500++</td>\n",
       "      <td>141.48693796090603</td>\n",
       "      <td>1</td>\n",
       "      <td>Medium</td>\n",
       "      <td>3</td>\n",
       "      <td>0.007406</td>\n",
       "      <td>0.757614</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1394</th>\n",
       "      <td>44.959895</td>\n",
       "      <td>0.234647</td>\n",
       "      <td>18451</td>\n",
       "      <td>63.662561</td>\n",
       "      <td>0-300</td>\n",
       "      <td>11.498540481074583</td>\n",
       "      <td>3</td>\n",
       "      <td>Medium</td>\n",
       "      <td>1</td>\n",
       "      <td>0.000973</td>\n",
       "      <td>0.513126</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1395</th>\n",
       "      <td>59.356058</td>\n",
       "      <td>0.253694</td>\n",
       "      <td>18663</td>\n",
       "      <td>64.014543</td>\n",
       "      <td>0-300</td>\n",
       "      <td>11.380588736668567</td>\n",
       "      <td>3</td>\n",
       "      <td>Low</td>\n",
       "      <td>1</td>\n",
       "      <td>0.001038</td>\n",
       "      <td>0.547739</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1396</th>\n",
       "      <td>67.865222</td>\n",
       "      <td>0.228935</td>\n",
       "      <td>19169</td>\n",
       "      <td>62.132035</td>\n",
       "      <td>500++</td>\n",
       "      <td>unknown</td>\n",
       "      <td>3</td>\n",
       "      <td>Low</td>\n",
       "      <td>1</td>\n",
       "      <td>0.001243</td>\n",
       "      <td>0.655622</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397</th>\n",
       "      <td>66.855435</td>\n",
       "      <td>0.244948</td>\n",
       "      <td>18946</td>\n",
       "      <td>58.697122</td>\n",
       "      <td>0-300</td>\n",
       "      <td>9.794196773761458</td>\n",
       "      <td>3</td>\n",
       "      <td>Low</td>\n",
       "      <td>1</td>\n",
       "      <td>0.001644</td>\n",
       "      <td>0.867537</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398</th>\n",
       "      <td>54.712713</td>\n",
       "      <td>0.177143</td>\n",
       "      <td>19017</td>\n",
       "      <td>64.259212</td>\n",
       "      <td>0-300</td>\n",
       "      <td>10.696216086742934</td>\n",
       "      <td>3</td>\n",
       "      <td>Low</td>\n",
       "      <td>1</td>\n",
       "      <td>0.001022</td>\n",
       "      <td>0.538969</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1399 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       capacity  failure_rate     id      margin  price           prod_cost  \\\n",
       "0     10.492623      0.042528  18377  633.766584  500++  195.03551928211797   \n",
       "1     20.273730      0.037896  19363  731.576817  500++  151.31809934886763   \n",
       "2     20.190457      0.039111  19641  741.218202  500++  178.13731921134948   \n",
       "3     27.220131      0.041303  18728  654.255635  500++  162.82946157588628   \n",
       "4     16.370911      0.037938  18722  703.094527  500++  141.48693796090603   \n",
       "...         ...           ...    ...         ...    ...                 ...   \n",
       "1394  44.959895      0.234647  18451   63.662561  0-300  11.498540481074583   \n",
       "1395  59.356058      0.253694  18663   64.014543  0-300  11.380588736668567   \n",
       "1396  67.865222      0.228935  19169   62.132035  500++             unknown   \n",
       "1397  66.855435      0.244948  18946   58.697122  0-300   9.794196773761458   \n",
       "1398  54.712713      0.177143  19017   64.259212  0-300  10.696216086742934   \n",
       "\n",
       "     product_type quality  warranty  market_share  attractiveness  isEssence  \\\n",
       "0               1     Low         3      0.006360        0.650648      False   \n",
       "1               1     Low         3      0.006840        0.699792      False   \n",
       "2               1     Low         3      0.006179        0.632129      False   \n",
       "3               1     Low         3      0.007925        0.810730      False   \n",
       "4               1  Medium         3      0.007406        0.757614      False   \n",
       "...           ...     ...       ...           ...             ...        ...   \n",
       "1394            3  Medium         1      0.000973        0.513126       True   \n",
       "1395            3     Low         1      0.001038        0.547739       True   \n",
       "1396            3     Low         1      0.001243        0.655622       True   \n",
       "1397            3     Low         1      0.001644        0.867537       True   \n",
       "1398            3     Low         1      0.001022        0.538969       True   \n",
       "\n",
       "      isElectrique  isAutoPortee  \n",
       "0            False          True  \n",
       "1            False          True  \n",
       "2            False          True  \n",
       "3            False          True  \n",
       "4            False          True  \n",
       "...            ...           ...  \n",
       "1394         False         False  \n",
       "1395         False         False  \n",
       "1396         False         False  \n",
       "1397         False         False  \n",
       "1398         False         False  \n",
       "\n",
       "[1399 rows x 14 columns]"
      ]
     },
     "execution_count": 158,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 159,
   "id": "complicated-greensboro",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "rising-leisure",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}