Russian - InflationRate - 3rdUpdate.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "06482e89",
   "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>Year</th>\n",
       "      <th>January</th>\n",
       "      <th>February</th>\n",
       "      <th>March</th>\n",
       "      <th>April</th>\n",
       "      <th>May</th>\n",
       "      <th>June</th>\n",
       "      <th>July</th>\n",
       "      <th>August</th>\n",
       "      <th>September</th>\n",
       "      <th>October</th>\n",
       "      <th>November</th>\n",
       "      <th>December</th>\n",
       "      <th>Total</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1991</td>\n",
       "      <td>6.20</td>\n",
       "      <td>4.80</td>\n",
       "      <td>6.30</td>\n",
       "      <td>63.50</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.10</td>\n",
       "      <td>3.50</td>\n",
       "      <td>8.90</td>\n",
       "      <td>12.10</td>\n",
       "      <td>160.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1992</td>\n",
       "      <td>245.30</td>\n",
       "      <td>38.00</td>\n",
       "      <td>29.90</td>\n",
       "      <td>21.70</td>\n",
       "      <td>11.90</td>\n",
       "      <td>19.10</td>\n",
       "      <td>10.60</td>\n",
       "      <td>8.60</td>\n",
       "      <td>11.50</td>\n",
       "      <td>22.90</td>\n",
       "      <td>26.10</td>\n",
       "      <td>25.20</td>\n",
       "      <td>2508.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1993</td>\n",
       "      <td>25.80</td>\n",
       "      <td>24.70</td>\n",
       "      <td>20.10</td>\n",
       "      <td>18.70</td>\n",
       "      <td>18.10</td>\n",
       "      <td>19.90</td>\n",
       "      <td>22.39</td>\n",
       "      <td>26.00</td>\n",
       "      <td>23.00</td>\n",
       "      <td>19.50</td>\n",
       "      <td>16.39</td>\n",
       "      <td>12.50</td>\n",
       "      <td>839.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1994</td>\n",
       "      <td>17.90</td>\n",
       "      <td>10.82</td>\n",
       "      <td>7.41</td>\n",
       "      <td>8.49</td>\n",
       "      <td>6.91</td>\n",
       "      <td>6.00</td>\n",
       "      <td>5.33</td>\n",
       "      <td>4.62</td>\n",
       "      <td>7.96</td>\n",
       "      <td>15.00</td>\n",
       "      <td>14.61</td>\n",
       "      <td>16.44</td>\n",
       "      <td>215.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1995</td>\n",
       "      <td>17.77</td>\n",
       "      <td>11.02</td>\n",
       "      <td>8.94</td>\n",
       "      <td>8.47</td>\n",
       "      <td>7.93</td>\n",
       "      <td>6.66</td>\n",
       "      <td>5.38</td>\n",
       "      <td>4.56</td>\n",
       "      <td>4.46</td>\n",
       "      <td>4.72</td>\n",
       "      <td>4.56</td>\n",
       "      <td>3.20</td>\n",
       "      <td>131.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1996</td>\n",
       "      <td>4.11</td>\n",
       "      <td>2.79</td>\n",
       "      <td>2.80</td>\n",
       "      <td>2.16</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1.17</td>\n",
       "      <td>0.72</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.88</td>\n",
       "      <td>1.42</td>\n",
       "      <td>21.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1997</td>\n",
       "      <td>2.34</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1.43</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.94</td>\n",
       "      <td>1.10</td>\n",
       "      <td>0.93</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>-0.30</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.96</td>\n",
       "      <td>11.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1998</td>\n",
       "      <td>1.51</td>\n",
       "      <td>0.89</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.17</td>\n",
       "      <td>3.67</td>\n",
       "      <td>38.43</td>\n",
       "      <td>4.54</td>\n",
       "      <td>5.67</td>\n",
       "      <td>11.61</td>\n",
       "      <td>84.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1999</td>\n",
       "      <td>8.38</td>\n",
       "      <td>4.13</td>\n",
       "      <td>2.79</td>\n",
       "      <td>3.03</td>\n",
       "      <td>2.22</td>\n",
       "      <td>1.91</td>\n",
       "      <td>2.82</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.48</td>\n",
       "      <td>1.37</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.26</td>\n",
       "      <td>36.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2000</td>\n",
       "      <td>2.33</td>\n",
       "      <td>1.04</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.89</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.55</td>\n",
       "      <td>1.79</td>\n",
       "      <td>0.98</td>\n",
       "      <td>1.32</td>\n",
       "      <td>2.11</td>\n",
       "      <td>1.52</td>\n",
       "      <td>1.64</td>\n",
       "      <td>20.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2001</td>\n",
       "      <td>2.76</td>\n",
       "      <td>2.28</td>\n",
       "      <td>1.86</td>\n",
       "      <td>1.79</td>\n",
       "      <td>1.78</td>\n",
       "      <td>1.62</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.09</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.60</td>\n",
       "      <td>18.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2002</td>\n",
       "      <td>3.09</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.08</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.07</td>\n",
       "      <td>1.61</td>\n",
       "      <td>1.54</td>\n",
       "      <td>15.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2003</td>\n",
       "      <td>2.40</td>\n",
       "      <td>1.63</td>\n",
       "      <td>1.05</td>\n",
       "      <td>1.02</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.71</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.96</td>\n",
       "      <td>1.10</td>\n",
       "      <td>11.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2004</td>\n",
       "      <td>1.75</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.43</td>\n",
       "      <td>1.14</td>\n",
       "      <td>1.11</td>\n",
       "      <td>1.14</td>\n",
       "      <td>11.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2005</td>\n",
       "      <td>2.62</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.34</td>\n",
       "      <td>1.12</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.46</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.82</td>\n",
       "      <td>10.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2006</td>\n",
       "      <td>2.43</td>\n",
       "      <td>1.66</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.79</td>\n",
       "      <td>9.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2007</td>\n",
       "      <td>1.68</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.79</td>\n",
       "      <td>1.64</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.13</td>\n",
       "      <td>11.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2008</td>\n",
       "      <td>2.31</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.42</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.69</td>\n",
       "      <td>13.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2009</td>\n",
       "      <td>2.37</td>\n",
       "      <td>1.65</td>\n",
       "      <td>1.31</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.41</td>\n",
       "      <td>8.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2010</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.81</td>\n",
       "      <td>1.08</td>\n",
       "      <td>8.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2011</td>\n",
       "      <td>2.37</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.23</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.44</td>\n",
       "      <td>6.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2012</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.89</td>\n",
       "      <td>1.23</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.54</td>\n",
       "      <td>6.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2013</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.66</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.51</td>\n",
       "      <td>6.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2014</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.70</td>\n",
       "      <td>1.02</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.82</td>\n",
       "      <td>1.28</td>\n",
       "      <td>2.62</td>\n",
       "      <td>11.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015</td>\n",
       "      <td>3.85</td>\n",
       "      <td>2.22</td>\n",
       "      <td>1.21</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.77</td>\n",
       "      <td>12.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2016</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.40</td>\n",
       "      <td>5.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.07</td>\n",
       "      <td>-0.54</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.42</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.84</td>\n",
       "      <td>4.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2019</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.20</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.36</td>\n",
       "      <td>3.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2020</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.35</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.71</td>\n",
       "      <td>0.83</td>\n",
       "      <td>4.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2021</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.66</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.82</td>\n",
       "      <td>8.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2022</td>\n",
       "      <td>0.99</td>\n",
       "      <td>1.17</td>\n",
       "      <td>7.61</td>\n",
       "      <td>1.56</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>11.66</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Year   January   February   March   April    May   June   July   August  \\\n",
       "0   1991      6.20       4.80    6.30   63.50   3.00   1.20   0.60     0.50   \n",
       "1   1992    245.30      38.00   29.90   21.70  11.90  19.10  10.60     8.60   \n",
       "2   1993     25.80      24.70   20.10   18.70  18.10  19.90  22.39    26.00   \n",
       "3   1994     17.90      10.82    7.41    8.49   6.91   6.00   5.33     4.62   \n",
       "4   1995     17.77      11.02    8.94    8.47   7.93   6.66   5.38     4.56   \n",
       "5   1996      4.11       2.79    2.80    2.16   1.60   1.17   0.72    -0.21   \n",
       "6   1997      2.34       1.54    1.43    0.96   0.94   1.10   0.93    -0.14   \n",
       "7   1998      1.51       0.89    0.64    0.38   0.50   0.08   0.17     3.67   \n",
       "8   1999      8.38       4.13    2.79    3.03   2.22   1.91   2.82     1.16   \n",
       "9   2000      2.33       1.04    0.64    0.89   1.75   2.55   1.79     0.98   \n",
       "10  2001      2.76       2.28    1.86    1.79   1.78   1.62   0.45     0.01   \n",
       "11  2002      3.09       1.16    1.08    1.16   1.69   0.53   0.72     0.09   \n",
       "12  2003      2.40       1.63    1.05    1.02   0.80   0.80   0.71    -0.41   \n",
       "13  2004      1.75       0.99    0.75    0.99   0.74   0.78   0.92     0.42   \n",
       "14  2005      2.62       1.23    1.34    1.12   0.80   0.64   0.46    -0.14   \n",
       "15  2006      2.43       1.66    0.82    0.35   0.48   0.28   0.67     0.19   \n",
       "16  2007      1.68       1.11    0.59    0.57   0.63   0.95   0.87     0.09   \n",
       "17  2008      2.31       1.20    1.20    1.42   1.35   0.97   0.51     0.36   \n",
       "18  2009      2.37       1.65    1.31    0.69   0.57   0.60   0.63     0.00   \n",
       "19  2010      1.64       0.86    0.63    0.29   0.50   0.39   0.36     0.55   \n",
       "20  2011      2.37       0.78    0.62    0.43   0.48   0.23  -0.01    -0.24   \n",
       "21  2012      0.50       0.37    0.58    0.31   0.52   0.89   1.23     0.10   \n",
       "22  2013      0.97       0.56    0.34    0.51   0.66   0.42   0.82     0.14   \n",
       "23  2014      0.59       0.70    1.02    0.90   0.90   0.62   0.49     0.24   \n",
       "24  2015      3.85       2.22    1.21    0.46   0.35   0.19   0.80     0.35   \n",
       "25  2016      0.96       0.63    0.46    0.44   0.41   0.36   0.54     0.01   \n",
       "26  2017      0.62       0.22    0.13    0.33   0.37   0.61   0.07    -0.54   \n",
       "27  2018      0.31       0.21    0.29    0.38   0.38   0.49   0.27     0.01   \n",
       "28  2019      1.01       0.44    0.32    0.29   0.34   0.04   0.20    -0.24   \n",
       "29  2020      0.40       0.33    0.55    0.83   0.27   0.22   0.35    -0.04   \n",
       "30  2021      0.67       0.78    0.66    0.58   0.74   0.69   0.31     0.17   \n",
       "31  2022      0.99       1.17    7.61    1.56    NaN    NaN    NaN      NaN   \n",
       "\n",
       "     September   October   November   December    Total  \n",
       "0         1.10      3.50       8.90      12.10   160.40  \n",
       "1        11.50     22.90      26.10      25.20  2508.85  \n",
       "2        23.00     19.50      16.39      12.50   839.87  \n",
       "3         7.96     15.00      14.61      16.44   215.02  \n",
       "4         4.46      4.72       4.56       3.20   131.33  \n",
       "5         0.33      1.20       1.88       1.42    21.81  \n",
       "6        -0.30      0.17       0.61       0.96    11.03  \n",
       "7        38.43      4.54       5.67      11.61    84.44  \n",
       "8         1.48      1.37       1.23       1.26    36.56  \n",
       "9         1.32      2.11       1.52       1.64    20.20  \n",
       "10        0.60      1.09       1.36       1.60    18.58  \n",
       "11        0.40      1.07       1.61       1.54    15.06  \n",
       "12        0.34      1.00       0.96       1.10    11.99  \n",
       "13        0.43      1.14       1.11       1.14    11.74  \n",
       "14        0.25      0.55       0.74       0.82    10.91  \n",
       "15        0.09      0.28       0.63       0.79     9.00  \n",
       "16        0.79      1.64       1.23       1.13    11.87  \n",
       "17        0.80      0.91       0.83       0.69    13.28  \n",
       "18       -0.03      0.00       0.29       0.41     8.80  \n",
       "19        0.84      0.50       0.81       1.08     8.78  \n",
       "20       -0.04      0.48       0.42       0.44     6.10  \n",
       "21        0.55      0.46       0.34       0.54     6.58  \n",
       "22        0.21      0.57       0.56       0.51     6.45  \n",
       "23        0.65      0.82       1.28       2.62    11.36  \n",
       "24        0.57      0.74       0.75       0.77    12.91  \n",
       "25        0.17      0.43       0.44       0.40     5.38  \n",
       "26       -0.15      0.20       0.22       0.42     2.52  \n",
       "27        0.16      0.35       0.50       0.84     4.27  \n",
       "28       -0.16      0.13       0.28       0.36     3.05  \n",
       "29       -0.07      0.43       0.71       0.83     4.91  \n",
       "30        0.60      1.11       0.96       0.82     8.39  \n",
       "31         NaN       NaN        NaN        NaN    11.66  "
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "#turning the CSV dataset into a dataframe\n",
    "df = pd.read_csv('russia.inflation.monthly (statbureau.org).csv')\n",
    "Inflate = df\n",
    "Inflate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "7401f64b",
   "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>Year</th>\n",
       "      <th>January</th>\n",
       "      <th>February</th>\n",
       "      <th>March</th>\n",
       "      <th>April</th>\n",
       "      <th>May</th>\n",
       "      <th>June</th>\n",
       "      <th>July</th>\n",
       "      <th>August</th>\n",
       "      <th>September</th>\n",
       "      <th>October</th>\n",
       "      <th>November</th>\n",
       "      <th>December</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1991</td>\n",
       "      <td>6.20</td>\n",
       "      <td>4.80</td>\n",
       "      <td>6.30</td>\n",
       "      <td>63.50</td>\n",
       "      <td>3.00</td>\n",
       "      <td>1.20</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.50</td>\n",
       "      <td>1.10</td>\n",
       "      <td>3.50</td>\n",
       "      <td>8.90</td>\n",
       "      <td>12.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1992</td>\n",
       "      <td>245.30</td>\n",
       "      <td>38.00</td>\n",
       "      <td>29.90</td>\n",
       "      <td>21.70</td>\n",
       "      <td>11.90</td>\n",
       "      <td>19.10</td>\n",
       "      <td>10.60</td>\n",
       "      <td>8.60</td>\n",
       "      <td>11.50</td>\n",
       "      <td>22.90</td>\n",
       "      <td>26.10</td>\n",
       "      <td>25.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1993</td>\n",
       "      <td>25.80</td>\n",
       "      <td>24.70</td>\n",
       "      <td>20.10</td>\n",
       "      <td>18.70</td>\n",
       "      <td>18.10</td>\n",
       "      <td>19.90</td>\n",
       "      <td>22.39</td>\n",
       "      <td>26.00</td>\n",
       "      <td>23.00</td>\n",
       "      <td>19.50</td>\n",
       "      <td>16.39</td>\n",
       "      <td>12.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1994</td>\n",
       "      <td>17.90</td>\n",
       "      <td>10.82</td>\n",
       "      <td>7.41</td>\n",
       "      <td>8.49</td>\n",
       "      <td>6.91</td>\n",
       "      <td>6.00</td>\n",
       "      <td>5.33</td>\n",
       "      <td>4.62</td>\n",
       "      <td>7.96</td>\n",
       "      <td>15.00</td>\n",
       "      <td>14.61</td>\n",
       "      <td>16.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1995</td>\n",
       "      <td>17.77</td>\n",
       "      <td>11.02</td>\n",
       "      <td>8.94</td>\n",
       "      <td>8.47</td>\n",
       "      <td>7.93</td>\n",
       "      <td>6.66</td>\n",
       "      <td>5.38</td>\n",
       "      <td>4.56</td>\n",
       "      <td>4.46</td>\n",
       "      <td>4.72</td>\n",
       "      <td>4.56</td>\n",
       "      <td>3.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1996</td>\n",
       "      <td>4.11</td>\n",
       "      <td>2.79</td>\n",
       "      <td>2.80</td>\n",
       "      <td>2.16</td>\n",
       "      <td>1.60</td>\n",
       "      <td>1.17</td>\n",
       "      <td>0.72</td>\n",
       "      <td>-0.21</td>\n",
       "      <td>0.33</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.88</td>\n",
       "      <td>1.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1997</td>\n",
       "      <td>2.34</td>\n",
       "      <td>1.54</td>\n",
       "      <td>1.43</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.94</td>\n",
       "      <td>1.10</td>\n",
       "      <td>0.93</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>-0.30</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1998</td>\n",
       "      <td>1.51</td>\n",
       "      <td>0.89</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.08</td>\n",
       "      <td>0.17</td>\n",
       "      <td>3.67</td>\n",
       "      <td>38.43</td>\n",
       "      <td>4.54</td>\n",
       "      <td>5.67</td>\n",
       "      <td>11.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1999</td>\n",
       "      <td>8.38</td>\n",
       "      <td>4.13</td>\n",
       "      <td>2.79</td>\n",
       "      <td>3.03</td>\n",
       "      <td>2.22</td>\n",
       "      <td>1.91</td>\n",
       "      <td>2.82</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.48</td>\n",
       "      <td>1.37</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2000</td>\n",
       "      <td>2.33</td>\n",
       "      <td>1.04</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.89</td>\n",
       "      <td>1.75</td>\n",
       "      <td>2.55</td>\n",
       "      <td>1.79</td>\n",
       "      <td>0.98</td>\n",
       "      <td>1.32</td>\n",
       "      <td>2.11</td>\n",
       "      <td>1.52</td>\n",
       "      <td>1.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2001</td>\n",
       "      <td>2.76</td>\n",
       "      <td>2.28</td>\n",
       "      <td>1.86</td>\n",
       "      <td>1.79</td>\n",
       "      <td>1.78</td>\n",
       "      <td>1.62</td>\n",
       "      <td>0.45</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.09</td>\n",
       "      <td>1.36</td>\n",
       "      <td>1.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>2002</td>\n",
       "      <td>3.09</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.08</td>\n",
       "      <td>1.16</td>\n",
       "      <td>1.69</td>\n",
       "      <td>0.53</td>\n",
       "      <td>0.72</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.40</td>\n",
       "      <td>1.07</td>\n",
       "      <td>1.61</td>\n",
       "      <td>1.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>2003</td>\n",
       "      <td>2.40</td>\n",
       "      <td>1.63</td>\n",
       "      <td>1.05</td>\n",
       "      <td>1.02</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.71</td>\n",
       "      <td>-0.41</td>\n",
       "      <td>0.34</td>\n",
       "      <td>1.00</td>\n",
       "      <td>0.96</td>\n",
       "      <td>1.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>2004</td>\n",
       "      <td>1.75</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.99</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.92</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.43</td>\n",
       "      <td>1.14</td>\n",
       "      <td>1.11</td>\n",
       "      <td>1.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>2005</td>\n",
       "      <td>2.62</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.34</td>\n",
       "      <td>1.12</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.64</td>\n",
       "      <td>0.46</td>\n",
       "      <td>-0.14</td>\n",
       "      <td>0.25</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>2006</td>\n",
       "      <td>2.43</td>\n",
       "      <td>1.66</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>2007</td>\n",
       "      <td>1.68</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.95</td>\n",
       "      <td>0.87</td>\n",
       "      <td>0.09</td>\n",
       "      <td>0.79</td>\n",
       "      <td>1.64</td>\n",
       "      <td>1.23</td>\n",
       "      <td>1.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>2008</td>\n",
       "      <td>2.31</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.20</td>\n",
       "      <td>1.42</td>\n",
       "      <td>1.35</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.91</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>2009</td>\n",
       "      <td>2.37</td>\n",
       "      <td>1.65</td>\n",
       "      <td>1.31</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.60</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.00</td>\n",
       "      <td>-0.03</td>\n",
       "      <td>0.00</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>2010</td>\n",
       "      <td>1.64</td>\n",
       "      <td>0.86</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.39</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.84</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.81</td>\n",
       "      <td>1.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>2011</td>\n",
       "      <td>2.37</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.23</td>\n",
       "      <td>-0.01</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>0.48</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>2012</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.52</td>\n",
       "      <td>0.89</td>\n",
       "      <td>1.23</td>\n",
       "      <td>0.10</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>2013</td>\n",
       "      <td>0.97</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.51</td>\n",
       "      <td>0.66</td>\n",
       "      <td>0.42</td>\n",
       "      <td>0.82</td>\n",
       "      <td>0.14</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.56</td>\n",
       "      <td>0.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>2014</td>\n",
       "      <td>0.59</td>\n",
       "      <td>0.70</td>\n",
       "      <td>1.02</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.90</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.24</td>\n",
       "      <td>0.65</td>\n",
       "      <td>0.82</td>\n",
       "      <td>1.28</td>\n",
       "      <td>2.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>2015</td>\n",
       "      <td>3.85</td>\n",
       "      <td>2.22</td>\n",
       "      <td>1.21</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.19</td>\n",
       "      <td>0.80</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.57</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.75</td>\n",
       "      <td>0.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>2016</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.63</td>\n",
       "      <td>0.46</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.41</td>\n",
       "      <td>0.36</td>\n",
       "      <td>0.54</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>2017</td>\n",
       "      <td>0.62</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.37</td>\n",
       "      <td>0.61</td>\n",
       "      <td>0.07</td>\n",
       "      <td>-0.54</td>\n",
       "      <td>-0.15</td>\n",
       "      <td>0.20</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2018</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.21</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.38</td>\n",
       "      <td>0.49</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.01</td>\n",
       "      <td>0.16</td>\n",
       "      <td>0.35</td>\n",
       "      <td>0.50</td>\n",
       "      <td>0.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2019</td>\n",
       "      <td>1.01</td>\n",
       "      <td>0.44</td>\n",
       "      <td>0.32</td>\n",
       "      <td>0.29</td>\n",
       "      <td>0.34</td>\n",
       "      <td>0.04</td>\n",
       "      <td>0.20</td>\n",
       "      <td>-0.24</td>\n",
       "      <td>-0.16</td>\n",
       "      <td>0.13</td>\n",
       "      <td>0.28</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2020</td>\n",
       "      <td>0.40</td>\n",
       "      <td>0.33</td>\n",
       "      <td>0.55</td>\n",
       "      <td>0.83</td>\n",
       "      <td>0.27</td>\n",
       "      <td>0.22</td>\n",
       "      <td>0.35</td>\n",
       "      <td>-0.04</td>\n",
       "      <td>-0.07</td>\n",
       "      <td>0.43</td>\n",
       "      <td>0.71</td>\n",
       "      <td>0.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>2021</td>\n",
       "      <td>0.67</td>\n",
       "      <td>0.78</td>\n",
       "      <td>0.66</td>\n",
       "      <td>0.58</td>\n",
       "      <td>0.74</td>\n",
       "      <td>0.69</td>\n",
       "      <td>0.31</td>\n",
       "      <td>0.17</td>\n",
       "      <td>0.60</td>\n",
       "      <td>1.11</td>\n",
       "      <td>0.96</td>\n",
       "      <td>0.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>2022</td>\n",
       "      <td>0.99</td>\n",
       "      <td>1.17</td>\n",
       "      <td>7.61</td>\n",
       "      <td>1.56</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",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    Year   January   February   March   April    May   June   July   August  \\\n",
       "0   1991      6.20       4.80    6.30   63.50   3.00   1.20   0.60     0.50   \n",
       "1   1992    245.30      38.00   29.90   21.70  11.90  19.10  10.60     8.60   \n",
       "2   1993     25.80      24.70   20.10   18.70  18.10  19.90  22.39    26.00   \n",
       "3   1994     17.90      10.82    7.41    8.49   6.91   6.00   5.33     4.62   \n",
       "4   1995     17.77      11.02    8.94    8.47   7.93   6.66   5.38     4.56   \n",
       "5   1996      4.11       2.79    2.80    2.16   1.60   1.17   0.72    -0.21   \n",
       "6   1997      2.34       1.54    1.43    0.96   0.94   1.10   0.93    -0.14   \n",
       "7   1998      1.51       0.89    0.64    0.38   0.50   0.08   0.17     3.67   \n",
       "8   1999      8.38       4.13    2.79    3.03   2.22   1.91   2.82     1.16   \n",
       "9   2000      2.33       1.04    0.64    0.89   1.75   2.55   1.79     0.98   \n",
       "10  2001      2.76       2.28    1.86    1.79   1.78   1.62   0.45     0.01   \n",
       "11  2002      3.09       1.16    1.08    1.16   1.69   0.53   0.72     0.09   \n",
       "12  2003      2.40       1.63    1.05    1.02   0.80   0.80   0.71    -0.41   \n",
       "13  2004      1.75       0.99    0.75    0.99   0.74   0.78   0.92     0.42   \n",
       "14  2005      2.62       1.23    1.34    1.12   0.80   0.64   0.46    -0.14   \n",
       "15  2006      2.43       1.66    0.82    0.35   0.48   0.28   0.67     0.19   \n",
       "16  2007      1.68       1.11    0.59    0.57   0.63   0.95   0.87     0.09   \n",
       "17  2008      2.31       1.20    1.20    1.42   1.35   0.97   0.51     0.36   \n",
       "18  2009      2.37       1.65    1.31    0.69   0.57   0.60   0.63     0.00   \n",
       "19  2010      1.64       0.86    0.63    0.29   0.50   0.39   0.36     0.55   \n",
       "20  2011      2.37       0.78    0.62    0.43   0.48   0.23  -0.01    -0.24   \n",
       "21  2012      0.50       0.37    0.58    0.31   0.52   0.89   1.23     0.10   \n",
       "22  2013      0.97       0.56    0.34    0.51   0.66   0.42   0.82     0.14   \n",
       "23  2014      0.59       0.70    1.02    0.90   0.90   0.62   0.49     0.24   \n",
       "24  2015      3.85       2.22    1.21    0.46   0.35   0.19   0.80     0.35   \n",
       "25  2016      0.96       0.63    0.46    0.44   0.41   0.36   0.54     0.01   \n",
       "26  2017      0.62       0.22    0.13    0.33   0.37   0.61   0.07    -0.54   \n",
       "27  2018      0.31       0.21    0.29    0.38   0.38   0.49   0.27     0.01   \n",
       "28  2019      1.01       0.44    0.32    0.29   0.34   0.04   0.20    -0.24   \n",
       "29  2020      0.40       0.33    0.55    0.83   0.27   0.22   0.35    -0.04   \n",
       "30  2021      0.67       0.78    0.66    0.58   0.74   0.69   0.31     0.17   \n",
       "31  2022      0.99       1.17    7.61    1.56    NaN    NaN    NaN      NaN   \n",
       "\n",
       "     September   October   November   December  \n",
       "0         1.10      3.50       8.90      12.10  \n",
       "1        11.50     22.90      26.10      25.20  \n",
       "2        23.00     19.50      16.39      12.50  \n",
       "3         7.96     15.00      14.61      16.44  \n",
       "4         4.46      4.72       4.56       3.20  \n",
       "5         0.33      1.20       1.88       1.42  \n",
       "6        -0.30      0.17       0.61       0.96  \n",
       "7        38.43      4.54       5.67      11.61  \n",
       "8         1.48      1.37       1.23       1.26  \n",
       "9         1.32      2.11       1.52       1.64  \n",
       "10        0.60      1.09       1.36       1.60  \n",
       "11        0.40      1.07       1.61       1.54  \n",
       "12        0.34      1.00       0.96       1.10  \n",
       "13        0.43      1.14       1.11       1.14  \n",
       "14        0.25      0.55       0.74       0.82  \n",
       "15        0.09      0.28       0.63       0.79  \n",
       "16        0.79      1.64       1.23       1.13  \n",
       "17        0.80      0.91       0.83       0.69  \n",
       "18       -0.03      0.00       0.29       0.41  \n",
       "19        0.84      0.50       0.81       1.08  \n",
       "20       -0.04      0.48       0.42       0.44  \n",
       "21        0.55      0.46       0.34       0.54  \n",
       "22        0.21      0.57       0.56       0.51  \n",
       "23        0.65      0.82       1.28       2.62  \n",
       "24        0.57      0.74       0.75       0.77  \n",
       "25        0.17      0.43       0.44       0.40  \n",
       "26       -0.15      0.20       0.22       0.42  \n",
       "27        0.16      0.35       0.50       0.84  \n",
       "28       -0.16      0.13       0.28       0.36  \n",
       "29       -0.07      0.43       0.71       0.83  \n",
       "30        0.60      1.11       0.96       0.82  \n",
       "31         NaN       NaN        NaN        NaN  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Dropping the total column\n",
    "Inflate = Inflate.iloc[:, :-1]\n",
    "Inflate"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e9f297c4",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1991</td>\n",
       "      <td>January</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1992</td>\n",
       "      <td>January</td>\n",
       "      <td>245.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1993</td>\n",
       "      <td>January</td>\n",
       "      <td>25.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1994</td>\n",
       "      <td>January</td>\n",
       "      <td>17.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1995</td>\n",
       "      <td>January</td>\n",
       "      <td>17.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>2018</td>\n",
       "      <td>December</td>\n",
       "      <td>0.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>2019</td>\n",
       "      <td>December</td>\n",
       "      <td>0.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>2020</td>\n",
       "      <td>December</td>\n",
       "      <td>0.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>2021</td>\n",
       "      <td>December</td>\n",
       "      <td>0.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>2022</td>\n",
       "      <td>December</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>384 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year      Month   value\n",
       "0    1991    January    6.20\n",
       "1    1992    January  245.30\n",
       "2    1993    January   25.80\n",
       "3    1994    January   17.90\n",
       "4    1995    January   17.77\n",
       "..    ...        ...     ...\n",
       "379  2018   December    0.84\n",
       "380  2019   December    0.36\n",
       "381  2020   December    0.83\n",
       "382  2021   December    0.82\n",
       "383  2022   December     NaN\n",
       "\n",
       "[384 rows x 3 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Using melt function to stack up the columns and rows \n",
    "df1 = pd.melt(Inflate, id_vars=['Year'], var_name=['Month'])\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "32fe2617",
   "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>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>value</th>\n",
       "      <th>Date</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1991</td>\n",
       "      <td>January</td>\n",
       "      <td>6.20</td>\n",
       "      <td>1991-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1992</td>\n",
       "      <td>January</td>\n",
       "      <td>245.30</td>\n",
       "      <td>1992-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1993</td>\n",
       "      <td>January</td>\n",
       "      <td>25.80</td>\n",
       "      <td>1993-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1994</td>\n",
       "      <td>January</td>\n",
       "      <td>17.90</td>\n",
       "      <td>1994-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1995</td>\n",
       "      <td>January</td>\n",
       "      <td>17.77</td>\n",
       "      <td>1995-01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>379</th>\n",
       "      <td>2018</td>\n",
       "      <td>December</td>\n",
       "      <td>0.84</td>\n",
       "      <td>2018-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>2019</td>\n",
       "      <td>December</td>\n",
       "      <td>0.36</td>\n",
       "      <td>2019-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>381</th>\n",
       "      <td>2020</td>\n",
       "      <td>December</td>\n",
       "      <td>0.83</td>\n",
       "      <td>2020-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>382</th>\n",
       "      <td>2021</td>\n",
       "      <td>December</td>\n",
       "      <td>0.82</td>\n",
       "      <td>2021-12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>383</th>\n",
       "      <td>2022</td>\n",
       "      <td>December</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2022-12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>384 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Year      Month   value     Date\n",
       "0    1991    January    6.20  1991-01\n",
       "1    1992    January  245.30  1992-01\n",
       "2    1993    January   25.80  1993-01\n",
       "3    1994    January   17.90  1994-01\n",
       "4    1995    January   17.77  1995-01\n",
       "..    ...        ...     ...      ...\n",
       "379  2018   December    0.84  2018-12\n",
       "380  2019   December    0.36  2019-12\n",
       "381  2020   December    0.83  2020-12\n",
       "382  2021   December    0.82  2021-12\n",
       "383  2022   December     NaN  2022-12\n",
       "\n",
       "[384 rows x 4 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Tranversing the data month in words to date-time\n",
    "df1['Date'] = pd.to_datetime(df1['Year'].astype(str) + '-' + df1['Month'].astype(str)).dt.strftime('%Y-%m')\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "b099b677",
   "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>Date</th>\n",
       "      <th>value</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1991-01</td>\n",
       "      <td>6.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1991-02</td>\n",
       "      <td>4.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1991-03</td>\n",
       "      <td>6.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1991-04</td>\n",
       "      <td>63.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1991-05</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>371</th>\n",
       "      <td>2021-12</td>\n",
       "      <td>0.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>372</th>\n",
       "      <td>2022-01</td>\n",
       "      <td>0.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>373</th>\n",
       "      <td>2022-02</td>\n",
       "      <td>1.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>374</th>\n",
       "      <td>2022-03</td>\n",
       "      <td>7.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>375</th>\n",
       "      <td>2022-04</td>\n",
       "      <td>1.56</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>376 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Date  value\n",
       "0    1991-01   6.20\n",
       "1    1991-02   4.80\n",
       "2    1991-03   6.30\n",
       "3    1991-04  63.50\n",
       "4    1991-05   3.00\n",
       "..       ...    ...\n",
       "371  2021-12   0.82\n",
       "372  2022-01   0.99\n",
       "373  2022-02   1.17\n",
       "374  2022-03   7.61\n",
       "375  2022-04   1.56\n",
       "\n",
       "[376 rows x 2 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Dropping the exessive columns and reset the index\n",
    "df1 = df1.sort_values(by=['Date']).drop(columns=['Month', 'Year']).reset_index(drop=['index'])\n",
    "#Reindexing in wanted format \n",
    "df1 = df1.reindex(['Date','value'], axis=1)\n",
    "#Dropping the last 8 NaN values \n",
    "df1 = df1.iloc[:-8, :]\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "9862da37",
   "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.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}