base-files | I use these to start new projects

I am running Linux 4.14.149 built with Yocto Zeus (3.0.0). I am running a read only filesystem, and recently found an issue where my UID (/etc/machine-id)was getting changed every boot (a result of this question - https://superuser.com/questions/1668481/dhcpd-doesnt-issue-the-same-lease-after-reboot ).

I am trying to make that file a link to the user-data partition so it will persist across reboots. I have tried making the link as part of a base-files_%.bbappend which is the way I made the link for the hostname (which works). This is the contents of that file (/var/local is our user data partition with is mounted RW in the init script):

I tried to install the FLIR Lepton library on Raspberry Pi zero w but as i was theFLIR Lepton (sudo apt-get install qt4-dev-tools)in pi this error message show up

Im trying to batch load several xlsx files to a single dataframe. So far i have this piece of code which works great.

I'm trying to create a fresh database each time I test my SQL code as I'm learning SQL, by referring to a file that I delete before making a new database in its place (I'm aware of :memory: and might use that if using files doesn't work), but SQLite says that the table already exists whenever it's a file path I've used before. For example, I used the "recipes3.db" path and it had no error, but then I deleted the file and used it again and it said the table already existed. I've restarted the interpreter and reset connections and nothing frees up the file. The files are being created and deleted in the expected directory. I have no idea where this data is sticking around such that I can't reuse paths.

I've tested some more and I can sqlite3.connect("recipes2.db") then select * from recipes and there's a table with that name in the database, as I created before, even though the "recipes2.db" file doesn't exist, before or after running the command. Going with "recipes5.db", it doesn't see any such table as I haven't used that path. Now that path contains a table. So there's some memory somewhere that I don't know about.

My code: