Week 10 Ass.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "b11abbd3",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import matplotlib.pyplot as py\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "b6de7b05",
   "metadata": {},
   "source": [
    "1. Read the data into python"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "b338f77b",
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv('week10.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "3bbc19bd",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 2011 entries, 0 to 2010\n",
      "Data columns (total 9 columns):\n",
      " #   Column           Non-Null Count  Dtype  \n",
      "---  ------           --------------  -----  \n",
      " 0   ph               2011 non-null   float64\n",
      " 1   Hardness         2011 non-null   float64\n",
      " 2   Solids           2011 non-null   float64\n",
      " 3   Chloramines      2011 non-null   float64\n",
      " 4   Sulfate          2011 non-null   float64\n",
      " 5   Conductivity     2011 non-null   float64\n",
      " 6   Organic_carbon   2011 non-null   float64\n",
      " 7   Trihalomethanes  2011 non-null   float64\n",
      " 8   Turbidity        2011 non-null   float64\n",
      "dtypes: float64(9)\n",
      "memory usage: 141.5 KB\n"
     ]
    }
   ],
   "source": [
    "df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "abc3bd75",
   "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>ph</th>\n",
       "      <th>Hardness</th>\n",
       "      <th>Solids</th>\n",
       "      <th>Chloramines</th>\n",
       "      <th>Sulfate</th>\n",
       "      <th>Conductivity</th>\n",
       "      <th>Organic_carbon</th>\n",
       "      <th>Trihalomethanes</th>\n",
       "      <th>Turbidity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8.316766</td>\n",
       "      <td>214.373394</td>\n",
       "      <td>22018.41744</td>\n",
       "      <td>8.059332</td>\n",
       "      <td>356.886136</td>\n",
       "      <td>363.266516</td>\n",
       "      <td>18.436525</td>\n",
       "      <td>100.341674</td>\n",
       "      <td>4.628771</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>9.092223</td>\n",
       "      <td>181.101509</td>\n",
       "      <td>17978.98634</td>\n",
       "      <td>6.546600</td>\n",
       "      <td>310.135738</td>\n",
       "      <td>398.410813</td>\n",
       "      <td>11.558279</td>\n",
       "      <td>31.997993</td>\n",
       "      <td>4.075075</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.584087</td>\n",
       "      <td>188.313324</td>\n",
       "      <td>28748.68774</td>\n",
       "      <td>7.544869</td>\n",
       "      <td>326.678363</td>\n",
       "      <td>280.467916</td>\n",
       "      <td>8.399735</td>\n",
       "      <td>54.917862</td>\n",
       "      <td>2.559708</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>10.223862</td>\n",
       "      <td>248.071735</td>\n",
       "      <td>28749.71654</td>\n",
       "      <td>7.513408</td>\n",
       "      <td>393.663395</td>\n",
       "      <td>283.651634</td>\n",
       "      <td>13.789695</td>\n",
       "      <td>84.603556</td>\n",
       "      <td>2.672989</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>8.635849</td>\n",
       "      <td>203.361523</td>\n",
       "      <td>13672.09176</td>\n",
       "      <td>4.563009</td>\n",
       "      <td>303.309771</td>\n",
       "      <td>474.607645</td>\n",
       "      <td>12.363817</td>\n",
       "      <td>62.798309</td>\n",
       "      <td>4.401425</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "          ph    Hardness       Solids  Chloramines     Sulfate  Conductivity  \\\n",
       "0   8.316766  214.373394  22018.41744     8.059332  356.886136    363.266516   \n",
       "1   9.092223  181.101509  17978.98634     6.546600  310.135738    398.410813   \n",
       "2   5.584087  188.313324  28748.68774     7.544869  326.678363    280.467916   \n",
       "3  10.223862  248.071735  28749.71654     7.513408  393.663395    283.651634   \n",
       "4   8.635849  203.361523  13672.09176     4.563009  303.309771    474.607645   \n",
       "\n",
       "   Organic_carbon  Trihalomethanes  Turbidity  \n",
       "0       18.436525       100.341674   4.628771  \n",
       "1       11.558279        31.997993   4.075075  \n",
       "2        8.399735        54.917862   2.559708  \n",
       "3       13.789695        84.603556   2.672989  \n",
       "4       12.363817        62.798309   4.401425  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "394a16fc",
   "metadata": {},
   "source": [
    "2.Check for null values"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "dcbf4dfc",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "ph                 0\n",
       "Hardness           0\n",
       "Solids             0\n",
       "Chloramines        0\n",
       "Sulfate            0\n",
       "Conductivity       0\n",
       "Organic_carbon     0\n",
       "Trihalomethanes    0\n",
       "Turbidity          0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.isnull().sum() #there is no null values"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "252a4205",
   "metadata": {},
   "source": [
    "3.Examine the variables ‘Hardness’, ‘Sulfate’, and ‘Organic_carbon’ and\n",
    "comment on your observations."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "58f69b0c",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "195.968071557499"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Hardness'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "14fb23a5",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "333.2246718894589"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Sulfate'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "85528fda",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "14.35770940908255"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['Organic_carbon'].mean()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "9330b04b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='Sulfate'>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYIAAAEGCAYAAABo25JHAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAQDklEQVR4nO3dfcyddX3H8fdnrZ0zagprwdrWtdNusVuM1rOOxRl1PKSthJpsWSBxVv2jIRmZZDOuilmy/3xIpmEySKNmENnQRY2NqUFk+I8Rxl2Ekq4itwRHbZViFnRjkXR+98e5Og63p73PfZ9zP/F7v5KTc67fw3V9fzmhH67rnHPdqSokSe36laUuQJK0tAwCSWqcQSBJjTMIJKlxBoEkNW71UhcwH+vWrastW7YsdRmStKIcOXLkqapaP7N9RQbBli1bmJqaWuoyJGlFSfKDYe1eGpKkxhkEktQ4g0CSGmcQSFLjDAJJapxBIEmNMwgkqXEGgSQ1ziCQpMYZBJLUOINAkhpnEEhS4wwCSWqcQSBJjTMIJKlxBoEkNc4gkKTGGQSS1DiDQJIaZxBIUuMMAklqnEEgSY0zCCSpcQaBJDXOIJCkxk0kCJLsSvJIkukkB4b0J8mNXf/RJDtm9K9K8p0kX51EPZKk0Y0dBElWATcBu4HtwDVJts8YthvY1j32AzfP6H8fcHzcWiRJczeJM4KdwHRVPVZVzwJ3AHtnjNkL3FZ99wJrk2wASLIJeDvw6QnUIkmao0kEwUbgiYHtE13bqGM+CXwA+MX5DpJkf5KpJFOnT58eq2BJ0nMmEQQZ0lajjElyJfBkVR2Z7SBVdbCqelXVW79+/XzqlCQNMYkgOAFsHtjeBJwcccybgKuSPE7/ktIfJfncBGqSJI1oEkFwP7AtydYka4CrgUMzxhwC3tV9e+gS4OmqOlVVH6yqTVW1pZv3r1X1zgnUJEka0epxd1BVZ5JcB9wJrAI+W1XHklzb9d8CHAb2ANPAM8B7xj2uJGkyUjXzcv7y1+v1ampqaqnLkKQVJcmRqurNbPeXxZLUOINAkhpnEEhS4wwCSWqcQSBJjTMIJKlxBoEkNc4gkKTGGQSS1DiDQJIaZxBIUuMMAklqnEEgSY0zCCSpcQaBJDXOIJCkxhkEktQ4g0CSGmcQSFLjDAJJapxBIEmNMwgkqXEGgSQ1ziCQpMYZBJLUOINAkhpnEEhS4wwCSWqcQSBJjTMIJKlxEwmCJLuSPJJkOsmBIf1JcmPXfzTJjq59c5J7khxPcizJ+yZRjyRpdGMHQZJVwE3AbmA7cE2S7TOG7Qa2dY/9wM1d+xngr6rqtcAlwJ8PmStJWkCTOCPYCUxX1WNV9SxwB7B3xpi9wG3Vdy+wNsmGqjpVVQ8AVNXPgOPAxgnUJEka0SSCYCPwxMD2CX75H/NZxyTZArwBuG8CNUmSRjSJIMiQtprLmCQvBb4IXF9VPx16kGR/kqkkU6dPn553sZKk55tEEJwANg9sbwJOjjomyYvoh8DtVfWlcx2kqg5WVa+qeuvXr59A2ZIkmEwQ3A9sS7I1yRrgauDQjDGHgHd13x66BHi6qk4lCfAZ4HhV/d0EapEkzdHqcXdQVWeSXAfcCawCPltVx5Jc2/XfAhwG9gDTwDPAe7rpbwL+DHg4yYNd24eq6vC4dUmSRpOqmZfzl79er1dTU1NLXYYkrShJjlRVb2a7vyyWpMYZBJLUOINAkhpnEEhS4wwCSWqcQSBJjTMIJKlxBoEkNc4gkKTGGQSS1DiDQJIaZxBIUuMMAklqnEEgSY0zCCSpcQaBJDXOIJCkxhkEktQ4g0CSGmcQSFLjDAJJapxBIEmNMwgkqXEGgSQ1ziCQpMYZBJLUOINAkhpnEEhS4wwCSWqcQSBJjTMIJKlxEwmCJLuSPJJkOsmBIf1JcmPXfzTJjlHnSpIW1thBkGQVcBOwG9gOXJNk+4xhu4Ft3WM/cPMc5kqSFtAkzgh2AtNV9VhVPQvcAeydMWYvcFv13QusTbJhxLmSpAU0iSDYCDwxsH2iaxtlzChzAUiyP8lUkqnTp0+PXbQkqW8SQZAhbTXimFHm9hurDlZVr6p669evn2OJkqRzWT2BfZwANg9sbwJOjjhmzQhzJUkLaBJnBPcD25JsTbIGuBo4NGPMIeBd3beHLgGerqpTI86VJC2gsc8IqupMkuuAO4FVwGer6liSa7v+W4DDwB5gGngGeM/55o5bkyRpdKkaekl+Wev1ejU1NbXUZUjSipLkSFX1Zrb7y2JJapxBIEmNMwgkqXEGgSQ1ziCQpMYZBJLUOINAkhpnEEhS4wwCSWqcQSBJjTMIJKlxBoEkNc4gkKTGGQSS1DiDQJIaZxBIUuMMAklqnEEgSY0zCCSpcQaBJDXOIJCkxhkEktQ4g0CSGmcQSFLjDAJJapxBIEmNMwgkqXEGgSQ1ziCQpMYZBJLUuLGCIMmFSe5K8mj3fME5xu1K8kiS6SQHBto/nuS7SY4m+XKStePUI0mau3HPCA4Ad1fVNuDubvt5kqwCbgJ2A9uBa5Js77rvAn63ql4HfA/44Jj1SJLmaNwg2Avc2r2+FXjHkDE7gemqeqyqngXu6OZRVV+vqjPduHuBTWPWI0mao3GD4OKqOgXQPV80ZMxG4ImB7RNd20zvBb42Zj2SpDlaPduAJN8AXjGk64YRj5EhbTXjGDcAZ4Dbz1PHfmA/wKte9aoRDy1Jms2sQVBVl52rL8mPk2yoqlNJNgBPDhl2Atg8sL0JODmwj33AlcClVVWcQ1UdBA4C9Hq9c46TJM3NuJeGDgH7utf7gK8MGXM/sC3J1iRrgKu7eSTZBfw1cFVVPTNmLZKkeRg3CD4CXJ7kUeDybpskr0xyGKD7MPg64E7gOPCFqjrWzf8U8DLgriQPJrllzHokSXM066Wh86mqnwCXDmk/CewZ2D4MHB4y7jXjHF+SND5/WSxJjTMIJKlxBoEkNc4gkKTGGQSS1DiDQJIaZxBIUuMMAklqnEEgSY0zCCSpcQaBJDXOIJCkxhkEktQ4g0CSGmcQSFLjDAJJapxBIEmNMwgkqXEGgSQ1ziCQpMYZBJLUOINAkhpnEEhS4wwCSWqcQSBJjTMIJKlxBoEkNc4gkKTGGQSS1DiDQJIaZxBIUuPGCoIkFya5K8mj3fMF5xi3K8kjSaaTHBjS//4klWTdOPVIkuZu3DOCA8DdVbUNuLvbfp4kq4CbgN3AduCaJNsH+jcDlwP/MWYtkqR5GDcI9gK3dq9vBd4xZMxOYLqqHquqZ4E7unlnfQL4AFBj1iJJmodxg+DiqjoF0D1fNGTMRuCJge0TXRtJrgJ+WFUPzXagJPuTTCWZOn369JhlS5LOWj3bgCTfAF4xpOuGEY+RIW2V5CXdPq4YZSdVdRA4CNDr9Tx7kKQJmTUIquqyc/Ul+XGSDVV1KskG4Mkhw04Amwe2NwEngVcDW4GHkpxtfyDJzqr60RzWIEkaw7iXhg4B+7rX+4CvDBlzP7AtydYka4CrgUNV9XBVXVRVW6pqC/3A2GEISNLiGjcIPgJcnuRR+t/8+QhAklcmOQxQVWeA64A7gePAF6rq2JjHlSRNyKyXhs6nqn4CXDqk/SSwZ2D7MHB4ln1tGacWSdL8+MtiSWqcQSBJjTMIJKlxBoEkNc4gkKTGGQSS1DiDQJIaZxBIUuMMAklqnEEgSY0zCCSpcQaBJDXOIJCkxhkEktQ4g0CSGmcQSFLjDAJJapxBIEmNMwgkqXEGgSQ1ziCQpMYZBJLUOINAkhpnEEhS41JVS13DnCU5DfxgqeuYh3XAU0tdxCJqbb3gmluxUtf8G1W1fmbjigyClSrJVFX1lrqOxdLaesE1t+KFtmYvDUlS4wwCSWqcQbC4Di51AYustfWCa27FC2rNfkYgSY3zjECSGmcQSFLjDIIJSnJhkruSPNo9X3COcbuSPJJkOsmBIf3vT1JJ1i181eMZd81JPp7ku0mOJvlykrWLVvwcjfC+JcmNXf/RJDtGnbtczXfNSTYnuSfJ8STHkrxv8aufn3He565/VZLvJPnq4lU9pqryMaEH8DHgQPf6APDRIWNWAd8HfhNYAzwEbB/o3wzcSf8Hc+uWek0LvWbgCmB19/qjw+Yvh8ds71s3Zg/wNSDAJcB9o85djo8x17wB2NG9fhnwvRf6mgf6/xL4J+CrS72eUR+eEUzWXuDW7vWtwDuGjNkJTFfVY1X1LHBHN++sTwAfAFbKp/hjrbmqvl5VZ7px9wKbFrbceZvtfaPbvq367gXWJtkw4tzlaN5rrqpTVfUAQFX9DDgObFzM4udpnPeZJJuAtwOfXsyix2UQTNbFVXUKoHu+aMiYjcATA9snujaSXAX8sKoeWuhCJ2isNc/wXvr/p7UcjbKGc40Zdf3LzThr/n9JtgBvAO6bfIkTN+6aP0n/f+R+sUD1LYjVS13ASpPkG8ArhnTdMOouhrRVkpd0+7hivrUtlIVa84xj3ACcAW6fW3WLZtY1nGfMKHOXo3HW3O9MXgp8Ebi+qn46wdoWyrzXnORK4MmqOpLkrZMubCEZBHNUVZedqy/Jj8+eFnenik8OGXaC/ucAZ20CTgKvBrYCDyU52/5Akp1V9aOJLWAeFnDNZ/exD7gSuLS6i6zL0HnXMMuYNSPMXY7GWTNJXkQ/BG6vqi8tYJ2TNM6a/wS4Kske4MXAy5N8rqreuYD1TsZSf0jxQnoAH+f5H5x+bMiY1cBj9P/RP/th1O8MGfc4K+PD4rHWDOwC/h1Yv9RrmWWds75v9K8ND36I+G9zec+X22PMNQe4DfjkUq9jsdY8Y8xbWUEfFi95AS+kB/DrwN3Ao93zhV37K4HDA+P20P8WxfeBG86xr5USBGOtGZimf731we5xy1Kv6Txr/aU1ANcC13avA9zU9T8M9Obyni/Hx3zXDPwh/UsqRwfe2z1LvZ6Ffp8H9rGigsBbTEhS4/zWkCQ1ziCQpMYZBJLUOINAkhpnEEhS4wwCaUCSG7q7ZR5N8mCS3z/P2Hcn+VT3en2S+7q7Tr75PHOu735FLi0b/rJY6iT5A/q/cN5RVT/vbgO+ZsTplwLfrap9s4y7Hvgc8My8C5UmzDMC6TkbgKeq6ucAVfVUVZ1M8vjZvw2RpJfkm4OTkrye/u2493RnEb+W5OYkU93Zxd924/6C/g/t7klyT9d2RZJvJ3kgyb909+aRFpVBID3n68DmJN9L8g9J3jLKpKp6EPgb4PNV9fqq+h/6v0jtAa8D3pLkdVV1I/170rytqt7WhcuHgcuqagcwRf9e9tKi8tKQ1Kmq/0ryRuDNwNuAz4/x18T+NMl++v+NbQC207/dwqBLuvZvdTcaXAN8e57Hk+bNIJAGVNX/At8EvpnkYWAf/dtjnz17fvFs+0iyFXg/8HtV9Z9J/vEc8wLcVVXXTKB0ad68NCR1kvx2km0DTa+n/ydDHwfe2LX98Qi7ejnw38DTSS4Gdg/0/Yz+n26E/l9ke1OS13THf0mS35r3AqR58oxAes5Lgb9Pspb+WcA0sB94LfCZJB9ihL+yVVUPJfkOcIz+LY2/NdB9EPhaklPd5wTvBv45ya92/R+mf+dLadF491FJapyXhiSpcQaBJDXOIJCkxhkEktQ4g0CSGmcQSFLjDAJJatz/AVOxk2KttWPgAAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "sns.scatterplot(data=df,x=df['Sulfate'])"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9f4a3493",
   "metadata": {},
   "source": [
    "4.Carry out correlation analysis on the dataset and find the correlation factor\n",
    "between\n",
    "a. ph and Chloramines\n",
    "b. ph and Conductivity\n",
    "What do we infer from this correlation value"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "6a93c84e",
   "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>ph</th>\n",
       "      <th>Hardness</th>\n",
       "      <th>Solids</th>\n",
       "      <th>Chloramines</th>\n",
       "      <th>Sulfate</th>\n",
       "      <th>Conductivity</th>\n",
       "      <th>Organic_carbon</th>\n",
       "      <th>Trihalomethanes</th>\n",
       "      <th>Turbidity</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>ph</th>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.108948</td>\n",
       "      <td>-0.087615</td>\n",
       "      <td>-0.024768</td>\n",
       "      <td>0.010524</td>\n",
       "      <td>0.014128</td>\n",
       "      <td>0.028375</td>\n",
       "      <td>0.018278</td>\n",
       "      <td>-0.035849</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hardness</th>\n",
       "      <td>0.108948</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.053269</td>\n",
       "      <td>-0.022685</td>\n",
       "      <td>-0.108521</td>\n",
       "      <td>0.011731</td>\n",
       "      <td>0.013224</td>\n",
       "      <td>-0.015400</td>\n",
       "      <td>-0.034831</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Solids</th>\n",
       "      <td>-0.087615</td>\n",
       "      <td>-0.053269</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.051789</td>\n",
       "      <td>-0.162769</td>\n",
       "      <td>-0.005198</td>\n",
       "      <td>-0.005484</td>\n",
       "      <td>-0.015668</td>\n",
       "      <td>0.019409</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chloramines</th>\n",
       "      <td>-0.024768</td>\n",
       "      <td>-0.022685</td>\n",
       "      <td>-0.051789</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.006254</td>\n",
       "      <td>-0.028277</td>\n",
       "      <td>-0.023808</td>\n",
       "      <td>0.014990</td>\n",
       "      <td>0.013137</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sulfate</th>\n",
       "      <td>0.010524</td>\n",
       "      <td>-0.108521</td>\n",
       "      <td>-0.162769</td>\n",
       "      <td>0.006254</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.016192</td>\n",
       "      <td>0.026776</td>\n",
       "      <td>-0.023347</td>\n",
       "      <td>-0.009934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Conductivity</th>\n",
       "      <td>0.014128</td>\n",
       "      <td>0.011731</td>\n",
       "      <td>-0.005198</td>\n",
       "      <td>-0.028277</td>\n",
       "      <td>-0.016192</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.015647</td>\n",
       "      <td>0.004888</td>\n",
       "      <td>0.012495</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Organic_carbon</th>\n",
       "      <td>0.028375</td>\n",
       "      <td>0.013224</td>\n",
       "      <td>-0.005484</td>\n",
       "      <td>-0.023808</td>\n",
       "      <td>0.026776</td>\n",
       "      <td>0.015647</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.005667</td>\n",
       "      <td>-0.015428</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Trihalomethanes</th>\n",
       "      <td>0.018278</td>\n",
       "      <td>-0.015400</td>\n",
       "      <td>-0.015668</td>\n",
       "      <td>0.014990</td>\n",
       "      <td>-0.023347</td>\n",
       "      <td>0.004888</td>\n",
       "      <td>-0.005667</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>-0.020497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Turbidity</th>\n",
       "      <td>-0.035849</td>\n",
       "      <td>-0.034831</td>\n",
       "      <td>0.019409</td>\n",
       "      <td>0.013137</td>\n",
       "      <td>-0.009934</td>\n",
       "      <td>0.012495</td>\n",
       "      <td>-0.015428</td>\n",
       "      <td>-0.020497</td>\n",
       "      <td>1.000000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                       ph  Hardness    Solids  Chloramines   Sulfate  \\\n",
       "ph               1.000000  0.108948 -0.087615    -0.024768  0.010524   \n",
       "Hardness         0.108948  1.000000 -0.053269    -0.022685 -0.108521   \n",
       "Solids          -0.087615 -0.053269  1.000000    -0.051789 -0.162769   \n",
       "Chloramines     -0.024768 -0.022685 -0.051789     1.000000  0.006254   \n",
       "Sulfate          0.010524 -0.108521 -0.162769     0.006254  1.000000   \n",
       "Conductivity     0.014128  0.011731 -0.005198    -0.028277 -0.016192   \n",
       "Organic_carbon   0.028375  0.013224 -0.005484    -0.023808  0.026776   \n",
       "Trihalomethanes  0.018278 -0.015400 -0.015668     0.014990 -0.023347   \n",
       "Turbidity       -0.035849 -0.034831  0.019409     0.013137 -0.009934   \n",
       "\n",
       "                 Conductivity  Organic_carbon  Trihalomethanes  Turbidity  \n",
       "ph                   0.014128        0.028375         0.018278  -0.035849  \n",
       "Hardness             0.011731        0.013224        -0.015400  -0.034831  \n",
       "Solids              -0.005198       -0.005484        -0.015668   0.019409  \n",
       "Chloramines         -0.028277       -0.023808         0.014990   0.013137  \n",
       "Sulfate             -0.016192        0.026776        -0.023347  -0.009934  \n",
       "Conductivity         1.000000        0.015647         0.004888   0.012495  \n",
       "Organic_carbon       0.015647        1.000000        -0.005667  -0.015428  \n",
       "Trihalomethanes      0.004888       -0.005667         1.000000  -0.020497  \n",
       "Turbidity            0.012495       -0.015428        -0.020497   1.000000  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.corr()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9936b62d",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "673daee3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "-0.02476849122452137"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['ph'].corr(df['Chloramines'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9187535f",
   "metadata": {},
   "outputs": [],
   "source": [
    "4"
   ]
  }
 ],
 "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.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}