Pineapple | 2D game engine with a modern intuitive API | Game Engine library

I'm trying to generate some data for testing by duplicating existing data in my database. There are a number of tables linked by FKs and I want to keep the same data profile. I think it's easiest to explain with an example:

I want to duplicate all the customers who are older than 18, including all of their linked data. So for the Customers table it's easy enough to do something like:

Let's say we have a example dataframe like below,

I have a pandas DataFrame like below:

I have 4 postgres tables:

• Fruit with attribute freshness (int) that goes to 1 to 5 and a serial id pk
• Banana with curvature (int) that goes from 0 to 360 and a serial id pk that is both foreign key to fruit and bananas primary key
• Apple with color as text and the same fk pk id
• pineapple with weight as int and the same fk id as the other two

Heres an example for a fruit (you can imagine the others, they are very similar):

I want to eliminate the nested loop in my code and I can't seem to figure out the best way to do it. I have explained what I am trying to do below:

I have a dataframe df.

I am having trouble finding a way to cleaning update the amount column in table 1 with the price column in table 2. I know that left_join and merge could be used to join the price column, rename it, and then drop it, but I am wondering if there is simpler way to avoid creating a mess.

I should state that the real dataset is more complicated and that the amount column in table 1 needs to be conditionally updated somehow based on table 2.

Table 1

Table 2

The problem statement is

Write a Java program to create a new array list, add some Fruits (String) and print out the collection.

My solution:

I am working on a project in which I need to post a new Course to my API. I tested this with POSTMAN and API works just fine, however when I try to post data using react fetch data is corrupted. While sending single strings like dishName: "pizza" works just fine and is shown in database I cannot manage to send an array of objects. I tried to do it in many ways like: