mallory | Mallory - MiTM TCP and UDP Proxy | Proxy library

Use df.merge with Groupby.agg:

We can disable context menu button(s) for the moment of construction in edit mode (because the button is a reason of issue).

Here is a possible approach - some redesign is required to handle editMode inside context menu (see also comments inline).

Tested with Xcode 13.2 / iOS 15.2

You could try to remove the as_index parameter and make a .reset_index() instead:

Use DataFrame.loc with inverted mask by ~:

The issue is with your return.

if x.dtype == 'object' then you return a Series so your transform aggregation does not reduce (the return is the same length as the original). If it takes the other path the return is the single scalar 0, which pandas sees as a reduction (return is a single value per group).

Because your aggregation differs in reduction whatever internals pandas uses to figure out the path to take and how to bring that back to the original DataFrame gets confused based on your column ordering. When 'Random_Number' is first, it checks the function, sees that the function reduces and takes one path, but if 'Name' comes first it checks, sees the function doesn't reduce and takes another path to compute.

You can fix this by ensuring that both returns do not reduce

Adopting the answer from the linked question in comments with slight modification to suit the use-case of OP

Unfortunatelly this looks like a bug.

I was able to reproduce your issue completely; I fallowed these steps:

• screated a source csv file:

Because your sub runs synchronously, it does not give Access time to display the form, as your code runs before the form gets painted.

To work around this, start your sub with DoEvents(), and repeat it after changing the form contents.

Alternatively, you could use _Timer to count down and close the form without making the application unresponsive.

This has been something I've been looking for consistently as well. Here are links to two methods that other people have written up that have helped me with this problem. Would certainly be interested in other takes as well.

Link 1 Link 2