How to bring a document to one language (layout)?

Question

Python

Hello. There is an Excel document. The document was filled in by several people, someone used the Russian layout, someone English to write characters that are present in both Russian and English. This is the file I am processing with a python script. Due to the fact that it is not clear in which layout this or that record is, I cannot correctly set the condition in the script. In this regard, the question is: how to bring the document to one layout in a few simple steps?

Answer 1

You process everything en masse in the uppercase/English layout (that is, change H to H, A to A, and so on) and then also translate your condition in the script into the same kind of uppercase/English layout. (You can, on the contrary, convert from Latin to
Russian, depending on the predominance of Russian / English) Everything will work. Something like this.

Answer 2

Open the document in Excel and go through the mass replacement of each Latin letter with Cyrillic. Well, either make a macro on VBS for the future, so that everything is replaced in one click, and if the document is small, then real-time autocorrect can be organized using the same VBS