I have excel sheets that contain written reviews of apartment complexes. Currently my team and I go through the reviews by hand and color code sentences by certain complaint categories. Ex. Noise, smoke, communication, maintenance, etc.
I would like to automate this process because for thousands of properties it is extremely time consuming to do every week.
I am asking for thoughts on how best to do this. I am wondering if it would be best to separate the reviews by sentence and then create a numbering system to classify each sentence. Ex. 1 for noise and 2 for smoke and so on. Then using some algorithm to try to classify the sentences.
Any input would be much appreciated because my background is not in machine learning or computer science. Thank you.