Hello I have some data that I tab in excel monthly, which is very repetitive. I would like to know if there is any way to use machine learning in R to teach an algorithm, based on the data I already have, to fill in the new incoming data. Basically I get the data in columns with ID, source, description, quantities, values, and so on. About this data I tabulate the detailed information I need, such as the mark (eg, look at the description column and check what the mark is) and so on I put the tabulated data in the desired form in other columns on the same worksheet. This process is too repetitive and too time consuming. Reading about Machine Learning I saw that in R language I can train an algorithm to analyze my previously tabulated data and based on that the algorithm could provide me what would be the brands, producers, origins and etc.
My question is, how can I apply this to my work using R to streamline the process?
Ps. If it has not yet become very clear, forgive me because it is really difficult to describe.