I have a large dataset (almost 300K rows) with multiple years of information (2003-2016). I'm trying to assign size into a Small, Medium, and Large category by year. My first attempt was to determine the quartiles then manually assign the size to a category but I'm sure there is a more efficient way of doing this. Thank you for your help.
<colgroup><col><col></colgroup><tbody>
</tbody>
Year | Size |
2003 | 136 |
2003 | 146 |
2003 | 107 |
2003 | 139 |
2003 | 152 |
2003 | 125 |
2003 | 102 |
2004 | 147 |
2004 | 106 |
2004 | 119 |
2004 | 125 |
2004 | |
2004 | 152 |
2004 | 107 |
2004 | 116 |
2005 | 129 |
2005 | 106 |
2005 | 102 |
2005 | 114 |
2005 | 120 |
2005 | 126 |
2005 | 118 |
2006 | 119 |
2006 | 108 |
2006 | 149 |
2006 | 143 |
2006 | 132 |
2006 | 128 |
2006 | 135 |
2006 | 113 |
<colgroup><col><col></colgroup><tbody>
</tbody>