breakDown | Model Agnostics breakDown plots | Machine Learning library

I am trying to build a table where I am summing multiple measures and would like to categorise them into dimensions.

To simplify, I have a table in the warehouse with the below schema:

...

I'm trying to create a stacked bar chart where the important sub categories are represented by a label, but the smaller sub categories don't appear (as this would really clutter the chart). I've now made a subset to only display labels where the value is over 20 for that sub category, but some of the labels are not centered correctly even though I've used position = position_stack(vjust = 0.5)

EDIT: for example of labels which are centered correctly, see the 'housing' column, where property rates doesn't sit within its stack - its actually on a line between 2 stacks. Another example is in the 'Miscellaneous' column, where insurance is correct, but 'personal care' should be higher up, in the larger stack.

If anyone has a better way of displaying these labels that would also be appreciated as I'm not really happy with how this chart is going to look even if the labels do center properly, but i just cant think of a better way to do it.

here is my code for the graph;

...

I have made a plot displaying multiple facets of my data. The colour bar created by scale_colour_gradientn is confusing because it shows percentage breakdowns. Could I get rid of these percentage breakdowns and add my own. I have tried using values and breaks parameters but with no luck. I think maybe ggplot is confused because most of the values are either very small or close to 1. I have added a toy dataset, code and image output below.

dput(df)

...

I am trying to filter financial records on a MySQL table A based on mapping constraints stored on two separate tables B and C where: i. Table 1 has Budget and Expenditure amounts by Project Donors, Work Breakdown Structure IDs , and Year

...

In JS, I have a set of strings that need to break down into an array. Each string can be breakdown up to 5 groups (Some have less). I'm using regex to break all.

In the below string sets if it includes aa bb orcc it needs to go into the capture group2.

Im not very familiar with regex unfortunately and stuck at this point.

Is this pattern doable only using regex or do I have to break the from :: to | and explode it later?

My regex pattern ^[ \t]*(?:(?:(\w+)\|)?(?:(\w+):(?:(\w+):)?)?)?(\w+)::(\w+)$ DEMO

String sets (each line run on a loop in JS):

...

I have a Spreadsheet (see link at the bottom of the page) that has 1 row and 3 columns. I want to take the data contained and split it out, resulting in a row by row breakdown.

Is anyone aware of how this could be done using a formula? It would save me a bunch of time doing it manually!

DemoSheet - This shows what the input and the desired outputs are

EDIT:

• The Input sheet shows the data as I have it, using metasyntactic variables as examples (real data will vary, but will always follow the same formatting).

For every email address in the email column, I need to do the following

• Get the list of managers and members and have it output as per the Desired Output 1 sheet. So for each entry in ColA, a row entry for each of the data in B and C, as if they were concatenated, split by " | " and transposed vertically.
• Repeat the above process but only for managers (as per the the Desired Output 2 sheet).

...

I'm trying to create an update view which has a few inline formset's in it but for some reason I'm seeing 'id: This field is required.' & none of the inline formset values being set when I click the update button. The fields themselves actually have values in them in the template so I'm not sure why the inline formsets would be empty when trying to save.

Models.py

...

I've got a unique problem. I'm querying a replicated database table cost_plan_breakdown, and the replication is known to have some duplicates due to issues with deleting records. I'm not the Admin so I'm trying to sidestep these duplicates as efficiently as possible. The table looks like this:

sys_id sys_created_on cost_plan breakdown_start_date axr123 2020-10-01 09:31:15 Outlook KTLO - Lisa Lymon 10-01-2020 pqo100 2020-12-23 05:50:20 Outlook KTLO - Lisa Lymon 10-01-2020 cji985 2020-10-01 09:31:15 Outlook KTLO - Lisa Lymon 11-01-2020 twg795 2020-10-05 13:23:08 DataPyramid CTB - Dave Dods 10-01-2020 jqr820 2020-09-28 16:11:54 Revoluccion CTB - Marcus Vance 11-01-2020 vjo150 2021-01-13 11:10:09 Server KTLO - Tom Smith 10-01-2020

Cost Plans typically have between 1 and 12 breakdowns during their lifespan, but there should only be one breakdown per cost plan per month. Notice that the Outlook Cost Plan has two breakdowns within the same month (October) with differing sys_id and sys_created_on.

So by using a smaller subquery in the where clause, I'm trying to determine the following:

"Group the rows with identical month and year of breakdown_start_date, and identical cost_plan. Of the remaining rows, select the one with the MAX sys_created_on. Take the sys_id of that row and feed it to the parent query to only include these rows."

...

I am receiving a 422 UNPROCESSABLE_ENTITY error from paypal, indicating that my amount->value and breakdown values don't match up, but as far as I can tell they aren't. The request body is as follows:

...