如何以一种仍然允许ggplot2绘制颜色的方式加入这些表格？

I have a data manipulation/table joining question that I have been hitting my head against for a couple of days. I am trying to create plots using ggplot2 that color the data by factors.I have a data manipulation/table joining questi