Clarity | A simple , customisable and scriptable platform game engine | Game Engine library

I'm trying to get a bootstrap datepicker to work to update layer dates in my website. However, the problem that I am getting at the moment is that when I click on the datepicker box, the calendar dropdown isn't working at all and it just continues to display an empty box.

I'm trying to add the datepicker inside a Leaflet textbox control and add the HTML directly into an .innerHTML method. Below is the code for the Leaflet textbox control and the datepicker itself.

Taking the following C code

How to create BottomNavigation with one of the item is larger than the parent, but without using floatingActionButton. For example like this:

I tried to do that by wrapping the icon with Box but it get cut like this:

Then i try to separate that one button and use constraintLayout to position it, but the constraintLayout cover the screen like this. Even when i color it using Color.Transparent, it always feels like Color.White (i dont know why Color.Transparent never work for me). In this picture i give it Red color for clarity reason.

So how to do this kind of bottomNavBar without having to create heavy-custom-composable?

Update: so i try to make the code based on MARSK and Dharman comment (thanks btw). This is what i

I'm looking into using QuestDB for a large amount of financial trade data.

I have read and understood https://questdb.io/docs/guides/importing-data but my case is slightly different.

• I have trade data for multiple instruments.
• For each instrument, the microsecond-timestamped data spans several years.
• The data for each instrument is in a separate CSV file.

My main use case is to query for globally time-ordered sequences of trades for arbitrary subsets of instruments. For clarity, the results of a query would look like

I have 4 arrays of data where I need a some product but with few conditions.

I'm unable to solve that and I'm not good at creating VBA functions as well.

Can anyone please help?

Apologies for the lack of clarity.

I'll try to give more details here. Please refer the below workbook.

https://drive.google.com/file/d/1XVEe4Sjw6ZeAh-7jyeLDs7Tp5RRQD20i/view?usp=sharing

Investment value is Row 2 * Row 3. This value is carried across all the months after amortization given in row 4. 5th row is converting the yearly value into monthly value (1/12).

So, in the first month 50 is invested and the value at the beginning of the month after amort of 100%, So 50 is available for month 1. This is further converted into monthly values with the help of row 5. So, the result for month 1 will be 100 * 50% * 100% * 8.33% = 4.1667 [Cell I9]

For the month 2, the value available is,

Value carried from month 1 after amort (100 * 50% * 99%) + New amount in month 2 (102 * 50% * 100%)

The above value is converted into the monthly value again with the help of row 5.

Result for month 2 => Cell I10 = (100 * 50% * 99% * 8.33%) + (102 * 50% * 100% * 8.33%) = 8.375

Similarly, for month 3 the value will be,

Month 1's investment (100*50%*98%*8.33%) + Month 2's investment (102*50%*99%*8.33%) + Month 3's investment (104*50%*100%*8.33%)

I need the above calculation to happen in single cell for all the months. I tried sumproduct with offset. But I couldn't.

I have a dataframe containing two columns: one filled with a string (irrelevant), and the other one is (a reference to) a dataframe.

Now I want to only keep the rows, where the dataframes in the second column have entries aka len(df.index) > 0 (there should be rows left, I don't care about columns). I know that sorting out rows like this works perfectly fine for me if I use it in a list comprehension and can do it on every entry by its own, like in the following example:

My data is already sorted by groups based on one column. And within each group I am trying to reorder the values in another column. The below example illustrates what I mean:

Currently my data looks like this, its sorted by the carrier name. The 3rd column shows what type of products they're holding. However, I would like chicken to be first on the list for every carrier, so that it looks like the second table below.

The below table is what I am trying to achieve.

Is there a way to do this with pandas? Instinctively I looked at feeding df.sort_value both the Name and Product columns, but realized that it can only sort by ascending and descending order.

Also the order of values in the "Name" column must be preserved for my task. In this example, its already ordered alphabetically, but its not necessarily the case nor my intention in my actual dataset.

Any insight would be appreciated!

Edit: added details for additional clarity

I'm working with some XML data that will ultimately be loaded into a csv. I am experiencing an issue with properly indexing the data when a element doesn't exist in an entry. Below is a simple xml example of what I am working with

I'm creating a machine-learning program to recognize images that are shown on webcam. I've used Google Teachable Machine to generate the model and it works fine.

The matter I'm having issues with is printing the results of a prediction array, when an element of this array achieves a certain value (if it's equal to or more than 0.9 for an element, print a specific message).

Let's say when element prediction[0] >= 0.9 I want to execute print("Up") as it recognizes the image of an arrow facing up or if element prediction[1] >= 0.9 I'd do a print("Down") etc.

But when I try do that using the if statement I am presented with a