Replacing installed packages with equivalent packages; identifying equivalent packages with artificial intelligence and determining the package name; rpm to flatpak, flatpak to rpm python scripting

I’m a Fedora 40 Workstation user and it takes too long to manage applications from gnome-software. What I want to do is to replace rpmfusion free or non-free applications installed on the system with the equivalent of fedora rpm applications. ignoring the version difference. or I want to replace any rpm package installed on the system from any rpm repository with fedora flatpaks packages from the registry.fedoraproject.org repository. let fedora flatpaks be the primary exchange repository and the flathub flatpak repository be the secondary exchange repository. If there is no equivalent in the fedora flatpaks repo, I want flathub to install from the flatpak repo. I do this if I want to run security and 3rd party packages in an isolated environment and to avoid conflicts.
Or I can do the opposite, if I want to use co-dependencies to minimize system footprint, I can install all flatpak repos and all installed flatpak packages from the fedora x86_64 rpm repo and fedora_updates repo as primary source, rpmfusion_free repos as secondary source, rpmfusion_non-free repos as tertiary source. maybe i just change the primary and secondary repo packages to rpm, change the non-free packages to flatpak. many combinations are possible. i already have lists of 11 application installation names from 11 repos. i want to match these lists by application name and create a table. i want to write the matching equivalent packages in the same row, in the cell under the application repo heading. column 12 should be the application name. Column 12 should be column A. The remaining 11 columns should be the names of the 11 repos. You can find my detailed work on this topic at this address. Please review it.
packages lists - flathub discourse

For scripts: google drive scripts link
For lists: google drive link - packages lists txt and csv files