c2 | Declarative data visualization in Clojure | Data Visualization library

First time actually using anything to do with swing - sorry for the poor code and crude visuals!
Using swing for a massively over-complicated password checker school project, and when I came to loading in a JMenuBar, it doesn't render properly the first time. Once I run through one of the options first, it reloads correctly, but the first time it comes out like this: First render attempt
But after I run one of the methods, either by clicking one of the buttons that I added to check if it was just the JFrame that was broken or using one of the broken menu options, it reloads correctly, but has a little grey bar above where the JMenuBar actually renders: Post-method render

The code for the visuals is as follows:

I have a given, unmodifiable table design which resembles:

So the dictionary I got is as below:

Basically there are rectangles (buildings) and circles (people).

The task I need to do is basically, when a function "fg" is called, every circle that is inside a given radius needs to run to the closest rectangle, and after all the circles inside the radius finds a rectangle, I need to report on a .txt file the names of the circles that run to each rectangle sorted alphabetically.

Such as:

Rectangle A: c1 c2 c3

Rectangle B: c7 c11 c20

...

And so on...

I need to store the addresses of the circles that run, on a vector of each rectangle. I tried to use qsort from stdlib.h, but maybe the function that i use to compare is wrong

(EDIT - full code to better understand):

In R, I can take a df and get a list of frequency tables for each sample/group by doing the following:

I am wondering how I can use A-frame (https://aframe.io) to fade out my gltf model after around 3 seconds. I'm not sure exactly how I'd be able to do this. My current code is below:

I am having issues with my eBAY Scraper and can not work out why. Although it is pulling the data off fine, it misses SOME of the data OFF for the first row and then for each first row of every Loop and therefore the data is not in the correct row.

Q) Why is it missing the data at the start and then for each loop?

I think It may have something to do with the title extracting slower that the rest of the items, however I can not work it out as I am very limited with vba. I have attached a demo, for your viewing.

I am not looking for a full rewite of the code, just pointing in the right direction or a SLIGHT change to MY code. As I stated I and very limited in vba, I can understand my code, anything more advanced will be out of my depth.

Demo Download - Download Excel File

WebSite - Ebay.co.uk

Ebay Product Page - Prodcts Shown may vary browser to browser

I have colour coded it so you can see better

This is what it is doing

When It Should be This

For some reason it misses out Price, Condition, Former Price & Discount for the first item on start and EVERY Loop. For every loop that it misses the items out the Price, Condition, Former Price & Discount become MORE out of line

1st Loop - Items are NOW 2 rows out of line

2nd Loop - Items are NOW 3 rows out of line

As I searched 3 pages (2 pages + 1 extra) and it looped 3 time it has missed the first row on each loop. I am 3 rows out. I think this may have too do with the Title of the item as it extracts a bit slower then the rest of the items

End Of Extraction

This is my code

I have a Google Sheet which is being populated by a Google Form. I am using Google Apps Script to add some extra functionality. Please feel free to access and modify these as needed in order to help.

Based on answers from the Form, I need to return a new date that factors in the time stamp at form submission.

This is a dumbed down example of what I need to do, but let's think of it like ordering a new car and its color determines how long it is going to take.

I need to write a conditional IF statement that determines how many weeks it will take to get the car based on the ordered color.

So if you order a Toyota in Red, it will take one week. If you order a Toyota in Green, it will take 5 weeks. If you order a Tesla, it will be really in one week no matter what color. Etc...

I started by writing some language in Sheets to take the Timestamp which is in Column A and add the appropriate amount of time to that:

I have put example dataset (df), expected output (df2) and my code so far below. I have a df where some rows in column i2 contain a list - in the json format, which need exploding and reinserting back into the df, from the row in which they were extracted. But the need to be inputted into a different column (i1). i need to extract a unique identifier (the 'id_2' value) from the string and insert that into the id_2 column.

in my code so far i am parsing the json-like data with pd.normalize, and then inserting the original string from the column i1 onto the top of the extracted strings (it should be much more clear if you take a look below) and then reinsert them based on the index. But I have to specify the index, which is not good. I would like it to be less dependent on manual input of indices in case it changes in the future with more of these nested cells or somehow the index changes.

Any suggestions are very welcome, thanks so much

example data