velcro | stitching together modules and code | Build Tool library

What started out yesterday as the beginnings of an answer for, or improvements to, code found in this question has now become something of an enigma. I cannot figure why the dynamically generated query produces different results to the equivilent when run in the mysqli client or even when written out in php as a standard prepared statement ( losing the dynamic element )

For anyone wishing to experiment I included the table schema and dummy records.

The dynamic query is built based upon existence of certain variables ( these would, in the original question, have been POST variables ) but here are static - though they can be negated by commenting them out which will in turn affect the WHERE clause that is generated.

I want to add a notice section to order emails sent to admin if specific meta has a specific value (Umbrella Hole is "YES").

Code up till now:

I have two datasets. One dataset has about ~30k rows, and the second dataset has ~60k rows. The smaller dataset (df1) has a unique identifier (upc), which is critical to my analysis.

The larger dataset (df2) does not have this unique identifier, but it does have a descriptive variable (product_title) that can be matched with a similar description variable in df1 and used to infer the unique identifier.

I am trying to keep things simple, so I used expand.grid.

Actual code: I am trying to scrape from several pages from a medical products website for each of their products based on different product detail features(name, brand, packaging, availability, and price). I am able to go through each of the pages and collect the data as demonstrated in the internal python output. However, only the last 25 products are transcribed in the CSV file instead of all requested in the scraping process.

Before you say this is a duplicate of Split Strings with Multiple Delimiters?, I think that the solution for this problem should be less complicated than 'importing re' or importing anything because this problem is from a website called Grok Learning where I haven't learnt how to do that yet.

Anyways, my code works fine except for one part. When I enter a word with a full stop after it, for example: "I like Velcro and Kleenex.' The Velcro part turns into the correct key from the dictionary, but Kleenex doesn't because it has . after it meaning the program is searching for 'Kleenex.' instead of 'Kleenex'

I've already split the input by ' ' (a space) but I was wondering how I could split it from multiple things like a '.' as well?

Im trying to access a dict ive created called Brands. I am then trying to replace information from a user input with information from the dict. I am struggiling to print out and replace text of the user input. Currently the only thing I can get it to do is print out all of the table content, with words inserted which unfortunately doesnt help very much.

I have a task that was assigned to me for homework. Basically the problem is:

Write a program that can get rid of the brand names and replace them with the generic names.

The table below shows some brand names that have generic names. The mapping has also been provided to you in your program as the BRANDS dictionary.

I'm developing a shopping cart app that needs to store and modify a subtotal value. Ideally, when a user scans a product QR code the JSON data associated with the code is imported, then the "price" attribute is added to a Subtotal state (or subtracted if the product is later removed by the user).

Here is sample JSON data: