link homework.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "1dd35642",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import requests\n",
    "import numpy as np\n",
    "from operator import index\n",
    "from re import sub\n",
    "from matplotlib.pyplot import axes\n",
    "import numpy as np\n",
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7f417240",
   "metadata": {},
   "outputs": [],
   "source": [
    "link = 'http://app-sellaci.eu-central-1.elasticbeanstalk.com/'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "323465b2",
   "metadata": {},
   "outputs": [],
   "source": [
    "r = requests.get(link)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "bfec506c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<Response [200]>"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "c36c777e",
   "metadata": {},
   "outputs": [],
   "source": [
    "json = r.json()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6918acf1",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.json_normalize(json)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "f7a6cc2e",
   "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>_id</th>\n",
       "      <th>affiliation</th>\n",
       "      <th>areCotationsAuthorized</th>\n",
       "      <th>canChangeBeneficiary</th>\n",
       "      <th>childId</th>\n",
       "      <th>createdAt</th>\n",
       "      <th>customerCreditHasBeenChecked</th>\n",
       "      <th>customerCreditHasBeenDecreased</th>\n",
       "      <th>details</th>\n",
       "      <th>deviceUsedForBooking</th>\n",
       "      <th>...</th>\n",
       "      <th>currentTreatments</th>\n",
       "      <th>hasBeenProposedToUpload</th>\n",
       "      <th>hasCurrentTreatments</th>\n",
       "      <th>mediumUsed</th>\n",
       "      <th>patientHasPriorKnowledge</th>\n",
       "      <th>patientIsReady</th>\n",
       "      <th>patientIsReadyDate</th>\n",
       "      <th>termsAcceptedByPatient</th>\n",
       "      <th>uploadWish</th>\n",
       "      <th>cart.explanation</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1202019029</td>\n",
       "      <td>qare</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td></td>\n",
       "      <td>2020-09-27T21:30:00.116Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Malade: mal de dos, fièvre, vomissements, covid</td>\n",
       "      <td>unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>232323231323212098</td>\n",
       "      <td>qare</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>23983099839023</td>\n",
       "      <td>2021-09-27T21:24:00.049Z</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>Trouble du sommeil, tension, douleurs au dos</td>\n",
       "      <td>unknown</td>\n",
       "      <td>...</td>\n",
       "      <td>Antidépresseur, anxiolitique</td>\n",
       "      <td>True</td>\n",
       "      <td>Y</td>\n",
       "      <td>android - VOG-L29</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "      <td>2021-09-27T21:25:53.140Z</td>\n",
       "      <td>True</td>\n",
       "      <td>N</td>\n",
       "      <td>always</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2 rows × 96 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                  _id affiliation  areCotationsAuthorized  \\\n",
       "0          1202019029        qare                   False   \n",
       "1  232323231323212098        qare                    True   \n",
       "\n",
       "   canChangeBeneficiary         childId                 createdAt  \\\n",
       "0                  True                  2020-09-27T21:30:00.116Z   \n",
       "1                  True  23983099839023  2021-09-27T21:24:00.049Z   \n",
       "\n",
       "   customerCreditHasBeenChecked  customerCreditHasBeenDecreased  \\\n",
       "0                          True                           False   \n",
       "1                          True                           False   \n",
       "\n",
       "                                            details deviceUsedForBooking  ...  \\\n",
       "0  Malade: mal de dos, fièvre, vomissements, covid               unknown  ...   \n",
       "1     Trouble du sommeil, tension, douleurs au dos               unknown  ...   \n",
       "\n",
       "              currentTreatments hasBeenProposedToUpload  hasCurrentTreatments  \\\n",
       "0                           NaN                     NaN                   NaN   \n",
       "1  Antidépresseur, anxiolitique                    True                     Y   \n",
       "\n",
       "          mediumUsed patientHasPriorKnowledge patientIsReady  \\\n",
       "0                NaN                      NaN            NaN   \n",
       "1  android - VOG-L29                     True           True   \n",
       "\n",
       "         patientIsReadyDate  termsAcceptedByPatient  uploadWish  \\\n",
       "0                       NaN                     NaN         NaN   \n",
       "1  2021-09-27T21:25:53.140Z                    True           N   \n",
       "\n",
       "   cart.explanation  \n",
       "0               NaN  \n",
       "1            always  \n",
       "\n",
       "[2 rows x 96 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "0c2c9b90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(json)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "23db5e48",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2, 96)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "188e12c5",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2 entries, 0 to 1\n",
      "Data columns (total 96 columns):\n",
      " #   Column                                                                       Non-Null Count  Dtype \n",
      "---  ------                                                                       --------------  ----- \n",
      " 0   _id                                                                          2 non-null      object\n",
      " 1   affiliation                                                                  2 non-null      object\n",
      " 2   areCotationsAuthorized                                                       2 non-null      bool  \n",
      " 3   canChangeBeneficiary                                                         2 non-null      bool  \n",
      " 4   childId                                                                      2 non-null      object\n",
      " 5   createdAt                                                                    2 non-null      object\n",
      " 6   customerCreditHasBeenChecked                                                 2 non-null      bool  \n",
      " 7   customerCreditHasBeenDecreased                                               2 non-null      bool  \n",
      " 8   details                                                                      2 non-null      object\n",
      " 9   deviceUsedForBooking                                                         2 non-null      object\n",
      " 10  doctorHasReviewed                                                            2 non-null      bool  \n",
      " 11  doctorId                                                                     2 non-null      object\n",
      " 12  doctorReminderSent                                                           2 non-null      bool  \n",
      " 13  doctorValidation                                                             2 non-null      bool  \n",
      " 14  estimatedStartDate                                                           2 non-null      object\n",
      " 15  eventId                                                                      2 non-null      object\n",
      " 16  facturationId                                                                2 non-null      object\n",
      " 17  hidePastConsultationsWithOtherPractitioners                                  2 non-null      bool  \n",
      " 18  isEhpad                                                                      2 non-null      bool  \n",
      " 19  isFirstConsultation                                                          2 non-null      bool  \n",
      " 20  isNotConform                                                                 2 non-null      bool  \n",
      " 21  isNotConformReason                                                           2 non-null      object\n",
      " 22  isSafari                                                                     2 non-null      bool  \n",
      " 23  patientAdministrativeArea                                                    2 non-null      object\n",
      " 24  patientHasReviewed                                                           2 non-null      bool  \n",
      " 25  patientId                                                                    2 non-null      object\n",
      " 26  patientPhoneNumber                                                           2 non-null      object\n",
      " 27  patientReminderSent                                                          2 non-null      bool  \n",
      " 28  paymentIntentStripeId                                                        2 non-null      object\n",
      " 29  preferredMedium                                                              2 non-null      object\n",
      " 30  #Version                                                               2 non-null      int64 \n",
      " 31  reminderChecked                                                              2 non-null      bool  \n",
      " 32  reopenCount                                                                  2 non-null      int64 \n",
      " 33  speciality                                                                   2 non-null      object\n",
      " 34  status                                                                       2 non-null      object\n",
      " 35  transcriptReminderSent                                                       2 non-null      bool  \n",
      " 36  updatedAt                                                                    2 non-null      object\n",
      " 37  usePaymentIntent                                                             2 non-null      bool  \n",
      " 38  visitIds                                                                     2 non-null      object\n",
      " 39  cart.act                                                                     2 non-null      object\n",
      " 40  cart.actId                                                                   2 non-null      int64 \n",
      " 41  cart.consultationPrice                                                       2 non-null      object\n",
      " 42  cart.created_at                                                              2 non-null      object\n",
      " 43  cart.currency                                                                2 non-null      object\n",
      " 44  cart.customerId                                                              2 non-null      int64 \n",
      " 45  cart.id                                                                      2 non-null      int64 \n",
      " 46  cart.isChargeable                                                            2 non-null      bool  \n",
      " 47  cart.isImmediateCharge                                                       2 non-null      bool  \n",
      " 48  cart.isRequirable                                                            2 non-null      bool  \n",
      " 49  cart.majF                                                                    2 non-null      int64 \n",
      " 50  cart.majMCG                                                                  2 non-null      int64 \n",
      " 51  cart.majMEG                                                                  2 non-null      int64 \n",
      " 52  cart.majMN35                                                                 2 non-null      int64 \n",
      " 53  cart.majMN40                                                                 2 non-null      int64 \n",
      " 54  cart.majMPA                                                                  2 non-null      int64 \n",
      " 55  cart.paymentIntents                                                          2 non-null      object\n",
      " 56  cart.price                                                                   2 non-null      int64 \n",
      " 57  cart.priceMin                                                                2 non-null      int64 \n",
      " 58  cart.quotedPrice                                                             2 non-null      int64 \n",
      " 59  cart.status                                                                  2 non-null      object\n",
      " 60  cart.tokenId                                                                 2 non-null      object\n",
      " 61  cart.updated_at                                                              2 non-null      object\n",
      " 62  cart.usePaymentIntent                                                        2 non-null      bool  \n",
      " 63  estimatedLength.unit                                                         2 non-null      object\n",
      " 64  estimatedLength.utc                                                          2 non-null      object\n",
      " 65  estimatedLength.value                                                        2 non-null      int64 \n",
      " 66  healthCenter.address                                                         1 non-null      object\n",
      " 67  healthCenter.city                                                            1 non-null      object\n",
      " 68  healthCenter.finess                                                          1 non-null      object\n",
      " 69  initiator.role                                                               2 non-null      object\n",
      " 70  snapshot.beneficiary.hasSocialSecurityNumber                                 2 non-null      bool  \n",
      " 71  snapshot.beneficiary.medicalInsurance.privateInsurance.amcId                 1 non-null      object\n",
      " 72  snapshot.beneficiary.medicalInsurance.privateInsurance.childMedicalRecordId  1 non-null      object\n",
      " 73  snapshot.beneficiary.medicalInsurance.privateInsurance.coverageEnd           1 non-null      object\n",
      " 74  snapshot.beneficiary.medicalInsurance.privateInsurance.coverageStart         1 non-null      object\n",
      " 75  snapshot.beneficiary.medicalInsurance.privateInsurance.medicalRecordId       1 non-null      object\n",
      " 76  snapshot.beneficiary.medicalInsurance.privateInsurance.memberId              1 non-null      object\n",
      " 77  snapshot.beneficiary.medicalInsurance.privateInsurance.scanResult            1 non-null      object\n",
      " 78  snapshot.beneficiary.medicalInsurance.privateInsurance.verifiedAt            1 non-null      object\n",
      " 79  snapshot.beneficiary.medicalInsurance.privateInsurance.verifiedStatus        1 non-null      object\n",
      " 80  snapshot.beneficiary.medicalInsurance.securiteSocialNumber                   2 non-null      object\n",
      " 81  snapshot.beneficiary.medicalInsurance.verifiedAt                             1 non-null      object\n",
      " 82  snapshot.beneficiary.medicalInsurance.verifiedStatus                         1 non-null      object\n",
      " 83  snapshot.consultation.isPartnershipOfferIncluded                             2 non-null      bool  \n",
      " 84  snapshot.doctor.isCME                                                        2 non-null      bool  \n",
      " 85  snapshot.doctor.offer                                                        2 non-null      object\n",
      " 86  currentTreatments                                                            1 non-null      object\n",
      " 87  hasBeenProposedToUpload                                                      1 non-null      object\n",
      " 88  hasCurrentTreatments                                                         1 non-null      object\n",
      " 89  mediumUsed                                                                   1 non-null      object\n",
      " 90  patientHasPriorKnowledge                                                     1 non-null      object\n",
      " 91  patientIsReady                                                               1 non-null      object\n",
      " 92  patientIsReadyDate                                                           1 non-null      object\n",
      " 93  termsAcceptedByPatient                                                       1 non-null      object\n",
      " 94  uploadWish                                                                   1 non-null      object\n",
      " 95  cart.explanation                                                             1 non-null      object\n",
      "dtypes: bool(24), int64(15), object(57)\n",
      "memory usage: 1.3+ KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "d73328f8",
   "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>#Version</th>\n",
       "      <th>reopenCount</th>\n",
       "      <th>cart.actId</th>\n",
       "      <th>cart.customerId</th>\n",
       "      <th>cart.id</th>\n",
       "      <th>cart.majF</th>\n",
       "      <th>cart.majMCG</th>\n",
       "      <th>cart.majMEG</th>\n",
       "      <th>cart.majMN35</th>\n",
       "      <th>cart.majMN40</th>\n",
       "      <th>cart.majMPA</th>\n",
       "      <th>cart.price</th>\n",
       "      <th>cart.priceMin</th>\n",
       "      <th>cart.quotedPrice</th>\n",
       "      <th>estimatedLength.value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.00000</td>\n",
       "      <td>2.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.827726e+06</td>\n",
       "      <td>232317.500000</td>\n",
       "      <td>1.277772e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>12.50000</td>\n",
       "      <td>5.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>6.499152e+06</td>\n",
       "      <td>7.778175</td>\n",
       "      <td>1.478504e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>17.67767</td>\n",
       "      <td>6.363961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.321310e+05</td>\n",
       "      <td>232312.000000</td>\n",
       "      <td>2.323110e+05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>0.00000</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.529928e+06</td>\n",
       "      <td>232314.750000</td>\n",
       "      <td>7.550412e+05</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>6.25000</td>\n",
       "      <td>3.250000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>4.827726e+06</td>\n",
       "      <td>232317.500000</td>\n",
       "      <td>1.277772e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>12.50000</td>\n",
       "      <td>5.500000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>7.125523e+06</td>\n",
       "      <td>232320.250000</td>\n",
       "      <td>1.800502e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>18.75000</td>\n",
       "      <td>7.750000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>6.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>9.423320e+06</td>\n",
       "      <td>232323.000000</td>\n",
       "      <td>2.323232e+06</td>\n",
       "      <td>0.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.0</td>\n",
       "      <td>25.00000</td>\n",
       "      <td>10.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       #Version  reopenCount    cart.actId  cart.customerId  \\\n",
       "count             2.0          2.0  2.000000e+00         2.000000   \n",
       "mean              6.0          0.0  4.827726e+06    232317.500000   \n",
       "std               0.0          0.0  6.499152e+06         7.778175   \n",
       "min               6.0          0.0  2.321310e+05    232312.000000   \n",
       "25%               6.0          0.0  2.529928e+06    232314.750000   \n",
       "50%               6.0          0.0  4.827726e+06    232317.500000   \n",
       "75%               6.0          0.0  7.125523e+06    232320.250000   \n",
       "max               6.0          0.0  9.423320e+06    232323.000000   \n",
       "\n",
       "            cart.id  cart.majF  cart.majMCG  cart.majMEG  cart.majMN35  \\\n",
       "count  2.000000e+00        2.0          2.0          2.0           2.0   \n",
       "mean   1.277772e+06        0.0          5.0          0.0          35.0   \n",
       "std    1.478504e+06        0.0          0.0          0.0           0.0   \n",
       "min    2.323110e+05        0.0          5.0          0.0          35.0   \n",
       "25%    7.550412e+05        0.0          5.0          0.0          35.0   \n",
       "50%    1.277772e+06        0.0          5.0          0.0          35.0   \n",
       "75%    1.800502e+06        0.0          5.0          0.0          35.0   \n",
       "max    2.323232e+06        0.0          5.0          0.0          35.0   \n",
       "\n",
       "       cart.majMN40  cart.majMPA  cart.price  cart.priceMin  cart.quotedPrice  \\\n",
       "count           2.0          2.0         2.0            2.0           2.00000   \n",
       "mean            0.0          0.0        25.0           25.0          12.50000   \n",
       "std             0.0          0.0         0.0            0.0          17.67767   \n",
       "min             0.0          0.0        25.0           25.0           0.00000   \n",
       "25%             0.0          0.0        25.0           25.0           6.25000   \n",
       "50%             0.0          0.0        25.0           25.0          12.50000   \n",
       "75%             0.0          0.0        25.0           25.0          18.75000   \n",
       "max             0.0          0.0        25.0           25.0          25.00000   \n",
       "\n",
       "       estimatedLength.value  \n",
       "count               2.000000  \n",
       "mean                5.500000  \n",
       "std                 6.363961  \n",
       "min                 1.000000  \n",
       "25%                 3.250000  \n",
       "50%                 5.500000  \n",
       "75%                 7.750000  \n",
       "max                10.000000  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "0a08ef6f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "_id                       0\n",
       "affiliation               0\n",
       "areCotationsAuthorized    0\n",
       "canChangeBeneficiary      0\n",
       "childId                   0\n",
       "                         ..\n",
       "patientIsReady            1\n",
       "patientIsReadyDate        1\n",
       "termsAcceptedByPatient    1\n",
       "uploadWish                1\n",
       "cart.explanation          1\n",
       "Length: 96, dtype: int64"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "de6944b8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2, 72)"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# remove nan values\n",
    "df.dropna(axis=1, inplace=True)\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "bbe6f1c9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['_id', 'affiliation', 'areCotationsAuthorized', 'canChangeBeneficiary',\n",
       "       'childId', 'createdAt', 'customerCreditHasBeenChecked',\n",
       "       'customerCreditHasBeenDecreased', 'details', 'deviceUsedForBooking',\n",
       "       'doctorHasReviewed', 'doctorId', 'doctorReminderSent',\n",
       "       'doctorValidation', 'estimatedStartDate', 'eventId', 'facturationId',\n",
       "       'hidePastConsultationsWithOtherPractitioners', 'isEhpad',\n",
       "       'isFirstConsultation', 'isNotConform', 'isNotConformReason', 'isSafari',\n",
       "       'patientAdministrativeArea', 'patientHasReviewed', 'patientId',\n",
       "       'patientPhoneNumber', 'patientReminderSent', 'paymentIntentStripeId',\n",
       "       'preferredMedium', '#Version', 'reminderChecked', 'reopenCount',\n",
       "       'speciality', 'status', 'transcriptReminderSent', 'updatedAt',\n",
       "       'usePaymentIntent', 'visitIds', 'cart.act', 'cart.actId',\n",
       "       'cart.consultationPrice', 'cart.created_at', 'cart.currency',\n",
       "       'cart.customerId', 'cart.id', 'cart.isChargeable',\n",
       "       'cart.isImmediateCharge', 'cart.isRequirable', 'cart.majF',\n",
       "       'cart.majMCG', 'cart.majMEG', 'cart.majMN35', 'cart.majMN40',\n",
       "       'cart.majMPA', 'cart.paymentIntents', 'cart.price', 'cart.priceMin',\n",
       "       'cart.quotedPrice', 'cart.status', 'cart.tokenId', 'cart.updated_at',\n",
       "       'cart.usePaymentIntent', 'estimatedLength.unit', 'estimatedLength.utc',\n",
       "       'estimatedLength.value', 'initiator.role',\n",
       "       'snapshot.beneficiary.hasSocialSecurityNumber',\n",
       "       'snapshot.beneficiary.medicalInsurance.securiteSocialNumber',\n",
       "       'snapshot.consultation.isPartnershipOfferIncluded',\n",
       "       'snapshot.doctor.isCME', 'snapshot.doctor.offer'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "b29e9628",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df.transpose()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "00159d4f",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>_id</th>\n",
       "      <td>1202019029</td>\n",
       "      <td>232323231323212098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>affiliation</th>\n",
       "      <td>qare</td>\n",
       "      <td>qare</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>areCotationsAuthorized</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>canChangeBeneficiary</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>childId</th>\n",
       "      <td></td>\n",
       "      <td>23983099839023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snapshot.beneficiary.hasSocialSecurityNumber</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snapshot.beneficiary.medicalInsurance.securiteSocialNumber</th>\n",
       "      <td>23232323232311</td>\n",
       "      <td>262129ZZZZ05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snapshot.consultation.isPartnershipOfferIncluded</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snapshot.doctor.isCME</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>snapshot.doctor.offer</th>\n",
       "      <td>connect</td>\n",
       "      <td>connect_plus</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>72 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                                 0  \\\n",
       "_id                                                     1202019029   \n",
       "affiliation                                                   qare   \n",
       "areCotationsAuthorized                                       False   \n",
       "canChangeBeneficiary                                          True   \n",
       "childId                                                              \n",
       "...                                                            ...   \n",
       "snapshot.beneficiary.hasSocialSecurityNumber                  True   \n",
       "snapshot.beneficiary.medicalInsurance.securiteS...  23232323232311   \n",
       "snapshot.consultation.isPartnershipOfferIncluded             False   \n",
       "snapshot.doctor.isCME                                        False   \n",
       "snapshot.doctor.offer                                      connect   \n",
       "\n",
       "                                                                     1  \n",
       "_id                                                 232323231323212098  \n",
       "affiliation                                                       qare  \n",
       "areCotationsAuthorized                                            True  \n",
       "canChangeBeneficiary                                              True  \n",
       "childId                                                 23983099839023  \n",
       "...                                                                ...  \n",
       "snapshot.beneficiary.hasSocialSecurityNumber                      True  \n",
       "snapshot.beneficiary.medicalInsurance.securiteS...        262129ZZZZ05  \n",
       "snapshot.consultation.isPartnershipOfferIncluded                 False  \n",
       "snapshot.doctor.isCME                                            False  \n",
       "snapshot.doctor.offer                                     connect_plus  \n",
       "\n",
       "[72 rows x 2 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "ea065e3e",
   "metadata": {},
   "source": [
    "# Cleaning Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "1fc7ce34",
   "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>Client 1</th>\n",
       "      <th>Client 2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>_id</th>\n",
       "      <td>1202019029</td>\n",
       "      <td>232323231323212098</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       Client 1            Client 2\n",
       "_id  1202019029  232323231323212098"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = df.rename({0: 'Client 1', 1: 'Client 2'}, axis='columns')\n",
    "df.head(1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "89eb651e",
   "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>index</th>\n",
       "      <th>Client 1</th>\n",
       "      <th>Client 2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>_id</td>\n",
       "      <td>1202019029</td>\n",
       "      <td>232323231323212098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>affiliation</td>\n",
       "      <td>qare</td>\n",
       "      <td>qare</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>areCotationsAuthorized</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>canChangeBeneficiary</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>childId</td>\n",
       "      <td></td>\n",
       "      <td>23983099839023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>snapshot.beneficiary.hasSocialSecurityNumber</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>snapshot.beneficiary.medicalInsurance.securite...</td>\n",
       "      <td>23232323232311</td>\n",
       "      <td>262129ZZZZ05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>snapshot.consultation.isPartnershipOfferIncluded</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>snapshot.doctor.isCME</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>snapshot.doctor.offer</td>\n",
       "      <td>connect</td>\n",
       "      <td>connect_plus</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>72 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                index        Client 1  \\\n",
       "0                                                 _id      1202019029   \n",
       "1                                         affiliation            qare   \n",
       "2                              areCotationsAuthorized           False   \n",
       "3                                canChangeBeneficiary            True   \n",
       "4                                             childId                   \n",
       "..                                                ...             ...   \n",
       "67       snapshot.beneficiary.hasSocialSecurityNumber            True   \n",
       "68  snapshot.beneficiary.medicalInsurance.securite...  23232323232311   \n",
       "69   snapshot.consultation.isPartnershipOfferIncluded           False   \n",
       "70                              snapshot.doctor.isCME           False   \n",
       "71                              snapshot.doctor.offer         connect   \n",
       "\n",
       "              Client 2  \n",
       "0   232323231323212098  \n",
       "1                 qare  \n",
       "2                 True  \n",
       "3                 True  \n",
       "4       23983099839023  \n",
       "..                 ...  \n",
       "67                True  \n",
       "68        262129ZZZZ05  \n",
       "69               False  \n",
       "70               False  \n",
       "71        connect_plus  \n",
       "\n",
       "[72 rows x 3 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.reset_index(inplace = True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "33c4cb72",
   "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>index</th>\n",
       "      <th>Client 1</th>\n",
       "      <th>Client 2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>beneficiary_hasSocialSecurityNumber</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>beneficiary_medicalInsurance_securiteSocialNumber</td>\n",
       "      <td>23232323232311</td>\n",
       "      <td>262129ZZZZ05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>consultation_isPartnershipOfferIncluded</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>doctor_isCME</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>doctor_offer</td>\n",
       "      <td>connect</td>\n",
       "      <td>connect_plus</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                index        Client 1  \\\n",
       "67                beneficiary_hasSocialSecurityNumber            True   \n",
       "68  beneficiary_medicalInsurance_securiteSocialNumber  23232323232311   \n",
       "69            consultation_isPartnershipOfferIncluded           False   \n",
       "70                                       doctor_isCME           False   \n",
       "71                                       doctor_offer         connect   \n",
       "\n",
       "        Client 2  \n",
       "67          True  \n",
       "68  262129ZZZZ05  \n",
       "69         False  \n",
       "70         False  \n",
       "71  connect_plus  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "snapshot_rows = df[df['index'].str.contains('snapshot')]['index']\n",
    "snapshot_rows_clean = snapshot_rows.apply(lambda x: '_'.join(x.split(\"snapshot.\")[1].split(\".\"))).tolist()\n",
    "col_rename_dict = {i:j for i,j in zip(snapshot_rows, snapshot_rows_clean)}\n",
    "\n",
    "list_ind = 0\n",
    "for i in df.index: \n",
    "  if df.at[i, 'index'] in snapshot_rows.tolist():\n",
    "    df.at[i, 'index'] = snapshot_rows_clean[list_ind]\n",
    "    list_ind += 1\n",
    "    \n",
    "df.tail()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "75b6ee92",
   "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>index</th>\n",
       "      <th>Client 1</th>\n",
       "      <th>Client 2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>_id</td>\n",
       "      <td>1202019029</td>\n",
       "      <td>232323231323212098</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>affiliation</td>\n",
       "      <td>qare</td>\n",
       "      <td>qare</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>areCotationsAuthorized</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>canChangeBeneficiary</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>childId</td>\n",
       "      <td></td>\n",
       "      <td>23983099839023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>beneficiary_hasSocialSecurityNumber</td>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>beneficiary_medicalInsurance_securiteSocialNumber</td>\n",
       "      <td>23232323232311</td>\n",
       "      <td>262129ZZZZ05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>consultation_isPartnershipOfferIncluded</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>doctor_isCME</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>doctor_offer</td>\n",
       "      <td>connect</td>\n",
       "      <td>connect_plus</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>72 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                index        Client 1  \\\n",
       "0                                                 _id      1202019029   \n",
       "1                                         affiliation            qare   \n",
       "2                              areCotationsAuthorized           False   \n",
       "3                                canChangeBeneficiary            True   \n",
       "4                                             childId                   \n",
       "..                                                ...             ...   \n",
       "67                beneficiary_hasSocialSecurityNumber            True   \n",
       "68  beneficiary_medicalInsurance_securiteSocialNumber  23232323232311   \n",
       "69            consultation_isPartnershipOfferIncluded           False   \n",
       "70                                       doctor_isCME           False   \n",
       "71                                       doctor_offer         connect   \n",
       "\n",
       "              Client 2  \n",
       "0   232323231323212098  \n",
       "1                 qare  \n",
       "2                 True  \n",
       "3                 True  \n",
       "4       23983099839023  \n",
       "..                 ...  \n",
       "67                True  \n",
       "68        262129ZZZZ05  \n",
       "69               False  \n",
       "70               False  \n",
       "71        connect_plus  \n",
       "\n",
       "[72 rows x 3 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna(subset=['Client 1', 'Client 2'], inplace=True)\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "37e6f5ff",
   "metadata": {},
   "outputs": [],
   "source": [
    "df.columns = ['Information', 'Client 1', 'Client 2']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "a287962c",
   "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>0</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>act</th>\n",
       "      <td>act</td>\n",
       "      <td>consultation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>actId</th>\n",
       "      <td>actId</td>\n",
       "      <td>232131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>consultationPrice</th>\n",
       "      <td>consultationPrice</td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>created_at</th>\n",
       "      <td>created_at</td>\n",
       "      <td>2021-09-27T21:23:04.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>currency</td>\n",
       "      <td>EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>customerId</th>\n",
       "      <td>customerId</td>\n",
       "      <td>232312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>explanation</th>\n",
       "      <td>explanation</td>\n",
       "      <td>always</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>id</td>\n",
       "      <td>232311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isChargeable</th>\n",
       "      <td>isChargeable</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isImmediateCharge</th>\n",
       "      <td>isImmediateCharge</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isRequirable</th>\n",
       "      <td>isRequirable</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majF</th>\n",
       "      <td>majF</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMCG</th>\n",
       "      <td>majMCG</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMEG</th>\n",
       "      <td>majMEG</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMN35</th>\n",
       "      <td>majMN35</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMN40</th>\n",
       "      <td>majMN40</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMPA</th>\n",
       "      <td>majMPA</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>paymentIntents</th>\n",
       "      <td>paymentIntents</td>\n",
       "      <td>[{'amount': 35, 'amountReceived': 0, 'amountRe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>price</th>\n",
       "      <td>price</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>priceMin</th>\n",
       "      <td>priceMin</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quotedPrice</th>\n",
       "      <td>quotedPrice</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>status</th>\n",
       "      <td>status</td>\n",
       "      <td>required</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tokenId</th>\n",
       "      <td>tokenId</td>\n",
       "      <td>pWI_S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>updated_at</th>\n",
       "      <td>updated_at</td>\n",
       "      <td>2021-09-27T21:23:04.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usePaymentIntent</th>\n",
       "      <td>usePaymentIntent</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   0  \\\n",
       "0                                      \n",
       "act                              act   \n",
       "actId                          actId   \n",
       "consultationPrice  consultationPrice   \n",
       "created_at                created_at   \n",
       "currency                    currency   \n",
       "customerId                customerId   \n",
       "explanation              explanation   \n",
       "id                                id   \n",
       "isChargeable            isChargeable   \n",
       "isImmediateCharge  isImmediateCharge   \n",
       "isRequirable            isRequirable   \n",
       "majF                            majF   \n",
       "majMCG                        majMCG   \n",
       "majMEG                        majMEG   \n",
       "majMN35                      majMN35   \n",
       "majMN40                      majMN40   \n",
       "majMPA                        majMPA   \n",
       "paymentIntents        paymentIntents   \n",
       "price                          price   \n",
       "priceMin                    priceMin   \n",
       "quotedPrice              quotedPrice   \n",
       "status                        status   \n",
       "tokenId                      tokenId   \n",
       "updated_at                updated_at   \n",
       "usePaymentIntent    usePaymentIntent   \n",
       "\n",
       "                                                                   1  \n",
       "0                                                                     \n",
       "act                                                     consultation  \n",
       "actId                                                         232131  \n",
       "consultationPrice                                                     \n",
       "created_at                                  2021-09-27T21:23:04.000Z  \n",
       "currency                                                         EUR  \n",
       "customerId                                                    232312  \n",
       "explanation                                                   always  \n",
       "id                                                            232311  \n",
       "isChargeable                                                    True  \n",
       "isImmediateCharge                                              False  \n",
       "isRequirable                                                   False  \n",
       "majF                                                               0  \n",
       "majMCG                                                             5  \n",
       "majMEG                                                             0  \n",
       "majMN35                                                           35  \n",
       "majMN40                                                            0  \n",
       "majMPA                                                             0  \n",
       "paymentIntents     [{'amount': 35, 'amountReceived': 0, 'amountRe...  \n",
       "price                                                             25  \n",
       "priceMin                                                          25  \n",
       "quotedPrice                                                       25  \n",
       "status                                                      required  \n",
       "tokenId                                                        pWI_S  \n",
       "updated_at                                  2021-09-27T21:23:04.000Z  \n",
       "usePaymentIntent                                                True  "
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cart1.set_index(cart1[0], inplace = True)\n",
    "cart1 = cart1.drop(columns = 0)\n",
    "cart2 = pd.DataFrame(df['cart'][1].items())\n",
    "cart2.set_index(cart2[0], inplace = True)\n",
    "cart2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "id": "0aabae89",
   "metadata": {},
   "outputs": [],
   "source": [
    "cart2 = cart2.drop(columns = 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "feb85095",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pandas.core.frame.DataFrame"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(cart1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "id": "889befa6",
   "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>1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>act</th>\n",
       "      <td>consultation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>actId</th>\n",
       "      <td>9423320</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>consultationPrice</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>created_at</th>\n",
       "      <td>2020-09-26T20:48:27.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>EUR</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          1\n",
       "0                                          \n",
       "act                            consultation\n",
       "actId                               9423320\n",
       "consultationPrice                          \n",
       "created_at         2020-09-26T20:48:27.000Z\n",
       "currency                                EUR"
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    " cart1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "id": "e4bc3b1a",
   "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>1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>act</th>\n",
       "      <td>consultation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>actId</th>\n",
       "      <td>232131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>consultationPrice</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>created_at</th>\n",
       "      <td>2021-09-27T21:23:04.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>EUR</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          1\n",
       "0                                          \n",
       "act                            consultation\n",
       "actId                                232131\n",
       "consultationPrice                          \n",
       "created_at         2021-09-27T21:23:04.000Z\n",
       "currency                                EUR"
      ]
     },
     "execution_count": 43,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cart2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "a69d45b3",
   "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>1</th>\n",
       "      <th>1</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>act</th>\n",
       "      <td>consultation</td>\n",
       "      <td>consultation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>actId</th>\n",
       "      <td>9423320</td>\n",
       "      <td>232131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>consultationPrice</th>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>created_at</th>\n",
       "      <td>2020-09-26T20:48:27.000Z</td>\n",
       "      <td>2021-09-27T21:23:04.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>EUR</td>\n",
       "      <td>EUR</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>customerId</th>\n",
       "      <td>232323</td>\n",
       "      <td>232312</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>2323232</td>\n",
       "      <td>232311</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isChargeable</th>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isImmediateCharge</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>isRequirable</th>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majF</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMCG</th>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMEG</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMN35</th>\n",
       "      <td>35</td>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMN40</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>majMPA</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>paymentIntents</th>\n",
       "      <td>[]</td>\n",
       "      <td>[{'amount': 35, 'amountReceived': 0, 'amountRe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>price</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>priceMin</th>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>quotedPrice</th>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>status</th>\n",
       "      <td>required</td>\n",
       "      <td>required</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>tokenId</th>\n",
       "      <td>Hs3330qZR</td>\n",
       "      <td>pWI_S</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>updated_at</th>\n",
       "      <td>2020-09-26T20:48:27.000Z</td>\n",
       "      <td>2021-09-27T21:23:04.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>usePaymentIntent</th>\n",
       "      <td>True</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>explanation</th>\n",
       "      <td>NaN</td>\n",
       "      <td>always</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          1  \\\n",
       "0                                             \n",
       "act                            consultation   \n",
       "actId                               9423320   \n",
       "consultationPrice                             \n",
       "created_at         2020-09-26T20:48:27.000Z   \n",
       "currency                                EUR   \n",
       "customerId                           232323   \n",
       "id                                  2323232   \n",
       "isChargeable                          False   \n",
       "isImmediateCharge                     False   \n",
       "isRequirable                          False   \n",
       "majF                                      0   \n",
       "majMCG                                    5   \n",
       "majMEG                                    0   \n",
       "majMN35                                  35   \n",
       "majMN40                                   0   \n",
       "majMPA                                    0   \n",
       "paymentIntents                           []   \n",
       "price                                    25   \n",
       "priceMin                                 25   \n",
       "quotedPrice                               0   \n",
       "status                             required   \n",
       "tokenId                           Hs3330qZR   \n",
       "updated_at         2020-09-26T20:48:27.000Z   \n",
       "usePaymentIntent                       True   \n",
       "explanation                             NaN   \n",
       "\n",
       "                                                                   1  \n",
       "0                                                                     \n",
       "act                                                     consultation  \n",
       "actId                                                         232131  \n",
       "consultationPrice                                                     \n",
       "created_at                                  2021-09-27T21:23:04.000Z  \n",
       "currency                                                         EUR  \n",
       "customerId                                                    232312  \n",
       "id                                                            232311  \n",
       "isChargeable                                                    True  \n",
       "isImmediateCharge                                              False  \n",
       "isRequirable                                                   False  \n",
       "majF                                                               0  \n",
       "majMCG                                                             5  \n",
       "majMEG                                                             0  \n",
       "majMN35                                                           35  \n",
       "majMN40                                                            0  \n",
       "majMPA                                                             0  \n",
       "paymentIntents     [{'amount': 35, 'amountReceived': 0, 'amountRe...  \n",
       "price                                                             25  \n",
       "priceMin                                                          25  \n",
       "quotedPrice                                                       25  \n",
       "status                                                      required  \n",
       "tokenId                                                        pWI_S  \n",
       "updated_at                                  2021-09-27T21:23:04.000Z  \n",
       "usePaymentIntent                                                True  \n",
       "explanation                                                   always  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_final = pd.concat([cart1,cart2],axis = 1)\n",
    "df_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "id": "5e6ccb1a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'amount': 35,\n",
       " 'amountReceived': 0,\n",
       " 'amountRefunded': 0,\n",
       " 'application': '',\n",
       " 'applicationFee': '500',\n",
       " 'balanceTransaction': '',\n",
       " 'captured': False,\n",
       " 'card_id': '',\n",
       " 'cartId': 30723292,\n",
       " 'created_at': '2021-09-27T21:23:00.000Z',\n",
       " 'currency': 'eur',\n",
       " 'description': '',\n",
       " 'destination': 'a1GS23OuGIVsKDKvJJu',\n",
       " 'dispute': '',\n",
       " 'failureCode': '',\n",
       " 'failureMessage': '',\n",
       " 'id': 76321821,\n",
       " 'invoiceId': '',\n",
       " 'payment_method_id': 4583914,\n",
       " 'refunds': [],\n",
       " 'status': 'requires_uncapture',\n",
       " 'stripeId': 'pml1223SpLuC0Xka8T6j',\n",
       " 'updated_at': '2021-09-27T21:23:04.000Z'}"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dict = df.loc[df['Information'] == 'cart.paymentIntents']['Client 2'].to_dict()[55][0]\n",
    "dict"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "id": "cd7f9db6",
   "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>0</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>amount</th>\n",
       "      <td>35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountReceived</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>amountRefunded</th>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>application</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>applicationFee</th>\n",
       "      <td>500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>balanceTransaction</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>captured</th>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>card_id</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>cartId</th>\n",
       "      <td>30723292</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>created_at</th>\n",
       "      <td>2021-09-27T21:23:00.000Z</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>currency</th>\n",
       "      <td>eur</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>description</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>destination</th>\n",
       "      <td>a1GS23OuGIVsKDKvJJu</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>dispute</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>failureCode</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>failureMessage</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>id</th>\n",
       "      <td>76321821</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>invoiceId</th>\n",
       "      <td></td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>payment_method_id</th>\n",
       "      <td>4583914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>refunds</th>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>status</th>\n",
       "      <td>requires_uncapture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>stripeId</th>\n",
       "      <td>pml1223SpLuC0Xka8T6j</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>updated_at</th>\n",
       "      <td>2021-09-27T21:23:04.000Z</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           0\n",
       "amount                                    35\n",
       "amountReceived                             0\n",
       "amountRefunded                             0\n",
       "application                                 \n",
       "applicationFee                           500\n",
       "balanceTransaction                          \n",
       "captured                               False\n",
       "card_id                                     \n",
       "cartId                              30723292\n",
       "created_at          2021-09-27T21:23:00.000Z\n",
       "currency                                 eur\n",
       "description                                 \n",
       "destination              a1GS23OuGIVsKDKvJJu\n",
       "dispute                                     \n",
       "failureCode                                 \n",
       "failureMessage                              \n",
       "id                                  76321821\n",
       "invoiceId                                   \n",
       "payment_method_id                    4583914\n",
       "refunds                                   []\n",
       "status                    requires_uncapture\n",
       "stripeId                pml1223SpLuC0Xka8T6j\n",
       "updated_at          2021-09-27T21:23:04.000Z"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_payment_intent = pd.DataFrame.from_dict(dict, orient = 'index')\n",
    "df_payment_intent"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d3907979",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.6"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}