lackey | Automatically create and manage a lower-quality mirror

Background

I have 2 data frames which has no common key to which I can merge them. Both df have a column that contains "entity name". One df contains 8000+ entities and the other close to 2000 entities.

Sample Data:

I'm ranking the top ten basketball players in the NBA via points, minutes, free throws, and efficiency. However, when I go to print the rankings the rankings are incorrect. It seems to be ranking them in terms of the value of each character in the numbers but I want them to be ranked by the highest amount to the lowest amount of those previously mentioned values.

My code:

I would like to know if it can be a good idea to set certain attributes of an object only when there's a get request and the attribute was not set already. If so, is this an appropriate approach (EAFP, few lines, @property)? If not, are there best practices?

I'm setting up a GUI tests environment with lackey and unittest in python. The visual recognition by ly.Pattern() i.e. the initialization of GUI elements takes some time so I want to do this only once and only when it's necessary.

so im writing an assignment for class. I have gotten stuck in my attempts to write a function to select a random element. The array that I am trying to access is stored in an interface file. I have one main file that implements the interface, and then multiple files extending the main file.

I am to write and test out how to select a random element from that interface file. The file contains many different arrays but for testing purposes, I will be selecting the lastName[]. How the function is written below is throwing an out of bounds error, but I don't know how to go about correcting it.

This is the test file:

I would like to do a screenshot with lackey of ideally the screen of an app (but to begin with, a screenshot of the whole screen would be OK).

I have tried

I'm trying to mock a networking result data and mock it in the JSON.txt, I want to perform unit test of json parsing but it seems that I always failed to read the JSON.txt file

the method that will be tested:

I want to automate a few of the menial tasks that I do every single day both at my rented and home office.

I was looking into how I'd go about getting the local cursor/mouse position within a window rather than the global position on the screen, but as far as I've read online it seems like that's no easy task.

I know that I could use image recognition with PyAutoGui, PyWinAuto, Lackey or the java/python hybrid SikuliX. This of course works, but it seems like small variances in screen sizes and window sizes effectively renders most of the previously taken images unusable and you end up having to re-take most if not all.

The relationship between elements within the window stays the same. (They only scale up/down based on window size)

Is something like this possible? How much work am I looking at here? I appreciate any nudges in the right direction and I'm open to using other modules if available.

Please and thank you.

Big picture is

In Windows 7, lackey installed with pip in a python3.6.1 virtualenv created with a python2.7.2 interpreter from an unpacked .tar.gz of virtualenv15.1.0 can't import the cv2 module.

Context / Environment

In Windows 7 (x64) with C:\Users\user1>C:\Python27\python.exe C:\VirtualenvTools\virtualenv-15.1.0\virtualenv.py --python=C:\VirtualenvTools\Python36\Python.exe C:\virtualenvs\virtualenv (all one line) I create a virtualenv and set its C:\virtualenvs\virtualenvname\Scripts\Python.exe file as the main interpreter for a PyDev project in Eclipse.

I also installed lackey after entering the virtualenv with activate and then the pip install lackey command @ the C:\virtualenvs\virtualenvname\Scripts\ directory without any listed errors (installation worked).

The problem

When I import lackey with from lackey import * in my PyDev project, there is an ImportError from Eclipse's console.

The console's stackTrace:
Traceback (most recent call last):
File "C:\Users\user1\workspace\sikulixframework0.1\testManager.py", line 4, in
from lackey import *
File "C:\virtualenvs\virtualenvname\lib\site-packages\lackey\__init__.py", line 31, in
from .RegionMatching import Pattern, Region, Match, Screen, ObserveEvent
File "C:\virtualenvs\virtualenvname\lib\site-packages\lackey\RegionMatching.py", line 17, in
import cv2
File "C:\virtualenvs\virtualenvname\lib\site-packages\cv2\__init__.py", line 7, in
from . import cv2
ImportError: DLL load failed: Le module spécifié est introuvable.

(Le module spécifié est introuvable. = The specified module could not be found.)

When using the same interpreter (C:\virtualenvs\virtualenvname\Scripts\Python.exe) directly, if I write from lackey import * I get the same stackTrace

My resolution tries

I tried the same things (from lackey import *) outside a virtual environment and it worked. Like suggested in an answer to the stackoverflow's question 'Can't import cv2; “DLL load failed”', I downloaded the Visual C++ 2015 redistributable package but nothing of my complications changed.

When reading a large hdf file with pandas.read_hdf() I get extremely slow read time. My hdf has 50 million rows, 3 columns with integers and 2 with strings. Writing this using to_hdf() with table format and indexing took almost 10 minutes. While this is also slow, I am not too concerned as read speed is more important.

I have tried saving as fixed/table format, with/without compression, however the read time ranges between 2-5 minutes. By comparison, read_csv() on the same data takes 4 minutes.

I have also tried to read the hdf using pytables directly. This is much faster at 6 seconds and this would be the speed I would like to see.