Optimize python code on google collab

I attach my google collabolatory script. It does what it is supposed to do, but it works very slow, much too slow. So slow, that collab cannot process the file in reasonable time. The code is supposed to do just simple comparison of two files an based on that join other files. It also consumes tones of RAM. Can you help optimize it so that it works fast.