title: insert data in its right dataframe location based on a row and column
body: <p>Hi I have a data set called <code>data1</code> with 3 columns one is called <code>Close.Date</code> the other one is called <code>Closed.Won.MRR</code> the other one is called <code>Sign.up.Date</code></p>
  <p>A sample of the data</p>
  <pre><code>Close.Date Closed.Won.MRR Sign.up.Date
  2020-04         447.0     2020-02
  2020-03         100.0     2020-02
  2022-04         536.4     2022-03
  2022-06         150.0     2022-03
  2022-06         125.0     2022-03
  2022-06         147.0     2021-10
  ...                 ...        ....
  </code></pre>
  <p>with this data and with code I already created a dataframe called <code>cohort_table2</code> that on the rows has all the Sign.up.Date possible as string names on a column called <code>Period</code> and on the columns have all the Close.Date possible as string column titles</p>
  <p>it looks like this but right now is empty</p>
  <pre><code>Period    2020-02  2020-03  2020-04  ... ... ..  
  2020-02      0        0        0
  2020-03      0        0        0
  2020-04      0        0        0
  .
  .
  . 
  .
  </code></pre>
  <p>how can I go row by row of my data and put it in the right bucket and that it keeps going summing each value in the right position until is finished, for example a record</p>
  <pre><code>Close.Date Closed.Won.MRR Sign.up.Date
  2022-04         447.0     2022-04
  </code></pre>
  <p>it will put a value of 447 on the location for (row/ period) 2022-04 and column 2022-04 (close.Date), then it will move to the next record do the same until it finishes with all the records</p>
  <p>for example for the first 2 records the dataframe <code>cohort_table2</code> will look like this</p>
  <pre><code>Period    2020-02  2020-03  2020-04  ... ... ..  
  2020-02      0      100        447
  2020-03      0        0        0
  2020-04      0        0        0
  .
  .
  . 
  .
  </code></pre>