short | High performance short link service

Use sum and count with list comprehension

You could loop through the dataframe and subset the second dataframe as you go.

Assuming what I mentioned in my comment on your question, the fix is just to simplify your FieldWithConfidence type significantly. Right now it is trying to add a number of additional levels of structure beyond what you seem to want. Here is a version of that type that works as I think you intend:

Please don't. Django templates are deliberately restricted, not to do this since business logic belongs in the view, not the template.

In the view, you can zip bar and data, so then the view looks like:

Create DTO class, for example:

Short answer: It's undefined behavior.

Most OpenAPI serialization styles are based on RFC 6570, which provides guidance only for:

• primitive values,
• arrays of primitives,
• simple non-nested objects (with primitive properties).

In case of other types of values (nested objects, objects containing arrays, nested arrays, arrays of objects) the behavior is undefined.

Similarly, OpenAPI's own deepObject style is currently defined only for simple objects but not for arrays or nested objects. Here are some related comments from the OpenAPI Specification authors/maintainers:

By the way, is there a reason we couldn't have deepObject work for arrays too? [...]

Darrel: Supporting arrays as you describe was my intent. I was supposed to find some canonical implementation to use as a guideline for the behavior, but didn't get around to it.

Ron: If we end up supporting the exploded array notation, it needs to be clear that the first index is 0 (or 1, or -1, or whatever).

(source)

Ron: when we defined deepObject in the spec, we explicitly chose to not mention what happens when the object has several levels in it, but in our conversations we went with 'not supported'. ​

(source)

There's an existing feature request to extend deepObject to support arrays and nested structures:
Support deep objects for query parameters with deepObject style

Hint: try the "bitwise and" operator (&)

If data is truly representative and number always preceded by "- No ", then expression in query can be like:

Val(Mid(txtPMTaskDesc, InStr(txtPMTaskDesc, "- No ") + 5))

If there is no match, a 0 will return, however, if field is null, the expression will error.

If string does not have consistent pattern (numbers always in same position or preceded by some distinct character combination that can be used to locate position), don't think can get what you want without VBA. Either loop through string or explore Regular Expressions aka RegEx. Set reference to Microsoft VBScript Regular Expressions x.x library.

Unfortunately doing this directly by attempting to web scrape the search results using UrlFetchApp will not work. You can use third party tools to get the number of search results, however.

I tested this out using an exponential backoff method which sometimes is able to get past 429 errors when a fetch request is invoked by UrlFetchApp.

When using UrlFetchApp to either web scrape or to connect to an API, it can happen that the server denies the request on the grounds of too many requests - or HTTP Error 429.

Google Apps Script runs in the cloud, from a set of IP addresses in a pool that Google own. You can actually see all the IP ranges here. Most websites (especially large companies such as Google) have architecture in place to prevent the use of bots scraping their websites and slowing down traffic.

Sometimes it's possible to get past this error, using a mixture of exponential backoff and random time intervals as shown for the Binance API (Full Disclosure: this GitHub repository was written by me.)

I assume that either Google directly blocks the Apps Script IP pool, or there are simply too many people trying the same thing - because with the same techniques I was unable to get any response that didn't involve entering a captcha as we discussed in the comments above and can be seen in the log of the page string.

There are many third party APIs that you can use to do this, and I suggest searching for one that meets your needs.

I tested out one called Authoritas which returns search engine indexing for different keywords. The API is asynchornous, so can take up to a minute to get a response, so a Web App solution needs to be made.

The flow I used is as follows:

• Obtain API key from Authoritas (free)
• Create a new Apps Script project to make an API call: