goofy | Spotify Playlist Builder | REST library

Below are the tables and the SQL query. I'm doing left join on 3 tables and trying to get sum of the specific columns in each middle table. but the result is wrong.

products table :

...

I have data that looks like this:

Date Vendor Revenue 2021-01-01 Mickey Mouse 100 2021-01-15 Mickey Mouse 150 2021-01-01 Donald Duck 100 2021-01-01 Goofy 100 2021-02-01 Mickey Mouse 200 2021-02-01 Donald Duck 200 2021-02-01 Goofy 200

And have some more data like this:

Month Vendor Snack Percentage January 2021 Mickey Mouse Churros 0.5 January 2021 Mickey Mouse Funnel Cake 0.25 January 2021 Mickey Mouse Apples 0.25 January 2021 Goofy Churros 0.34 January 2021 Goofy Funnel Cake 0.33 January 2021 Goofy Water 0.33

I would like to perform an operation using Pandas that yields the following:

Date Vendor Snack Revenue 2021-01-01 Mickey Mouse Churros 50 2021-01-01 Mickey Mouse Funnel Cake 25 2021-01-01 Mickey Mouse Apples 25 2021-01-15 Mickey Mouse Churros 75 2021-01-15 Mickey Mouse Funnel Cake 37.5 2021-01-15 Mickey Mouse Apples 37.5 2021-01-01 Goofy Churros 34 2021-01-01 Goofy Funnel Cake 33 2021-01-01 Goofy Water 33 2021-01-01 Donald Duck 100 2021-02-01 Donald Duck 200 2021-02-01 Mickey Mouse 200 2021-02-01 Goofy 200

I know how to do this using cross joins in Redshift but can't quite nail down the syntax here using either pd.merge or np.dot. Here are the sample data frames:

...

I am not able to get the inputRef.current.focus() to fire without using setTimeout. This seems like a bug, but I'm not sure if it is in React or MaterialUI.

See a demo here: https://codesandbox.io/s/goofy-gareth-lkmq3?file=/src/App.js

...

I wanted to implement custom play/pause buttons on youtube iframe in a React project but, couldn't achieve it! It returns all type of errors like: When I press my custom mute button, it gives: player.mute is not a function and so on.
Here is the code I am using:

...

I've got several thousand JSON files. Most of them can have a single JSON array with as many as 10,000 elements inside the array ... and to make things even more interesting, the data structure of the elements can vary from element to element ... sometimes with just a simple single property deviation from the norm to deviations that add even more arrays within each element. But it's this "items" array that I need to extract from each of these files.

The method of attack on this problem - in my logic that is - is to first extract each of the different data structures from all of the files, so that I understand what I'm going after when I try to get the data. If I can't name the elements that I want, then how could I get them? Though there might actually be a way of doing that, I'm just not knowledgeable enough on JSON and GSON, etc. to know one way or the other.

This will be my first real JSON project as well ... I've not ever played with JSON before so I've spent a lot of time Googling and reading and I definitely understand - NOW - how JSON works ... I'm just ill-equipped to wield it with any kind of effectiveness. I've spent the last couple of days on these files, and although I've gained some ground, I'm smart enough to know when I've gotten to the point where I need some help from people who have done this before.

These examples are not cut and paste from these files. I made them generic for simplicity. But here is what I've seen so far as an example of the differences in structures from one file to the next. The first file is by far the most common ... where the "items" array will have that static structure with the exact same element names but there will be 10,000 of them within a file ... while the next file won't be so clean.

Most common JSON file that I am seeing among these files:

...

I have a div with style="text-align:justify" and inside it is a list of hyperlinks. In Firefox, only the white space ~between~ hyperlinks expands, which looks good. But in Chrome, the white space ~within~ the links also expands, which looks strange.

I tried changing those spaces to  , but they expand too.

Currently my solution is to make all link spaces into spans containing a transparent character, but that's a bit goofy:

...

I'm getting this goofy error which looks to be related to query size. My working query takes around 3 mins. If I add another few lines (which should take ~3 secs if I have results from previous query), kusto throws partial query error due to query size.

I didn't realize that there was such a limit in https://docs.microsoft.com/en-us/azure/data-explorer/kusto/concepts/resulttruncation. I've removed comments/tweaked some queries to spit out lesser fields but still running into same error.

Any idea about what's going on here?

Here's the error trace

...

Most people are searching for how to get rid of react act() errors in testing. I'm wondering the opposite. I have code that induces a state change. That state change should trigger a re-render in react (and it does). However, I did not act() wrap that state change, and an act() error was not emitted. Why is this?

Consider the following goofy component:

...

If we have

...