I wonder if it is possible to automate the analyses of the geological map with Python or R.

I have maps with different horizonts (each jpeg file approx. 16 mb size), from which the data must be transfered to the excell table with template.

I provide the legend in excell

Example: eiho
folowing 3 Horizonts are emtpty.
qb

output should be like : result

1st issue could that script have to add excell line if a horizont contains 3 layers.
2nd issue could be the errors on the map itself, where code have to inndicate NA value.
3d thing is to catch the special charachters like ? mark near the layer.

I tried asking GPT, of course it says it is possible, but how we all know it is not right in all cases.Wanted to ask profies if it is generally possible and should I invest my time in it.