NGram | naive ngram implementation with some tools | Regex library

I am trying to formulate a query for a business scenario where we have a nested field type named "types"(i.e like ArrayList of strings). Below are the sample indexed documents with "types" as one of the fields.

Document 1: { "types" : [ { "Label" : "Dialog", }, { "Label" : "Violence", }, { "Label" : "Language", } }

Document 2: { "types" : [ { "Label" : "Dialog", } }

Now, the requirement is that the search query should match at most one value within the field values i.e if a user searches for "Dialog", then it should return only Document 2 and not Document 1 because it has other values present in the field. Basically, it should only get those records that match exactly with the single search query value excluding all the other values present in the field.

Below is the Mapping:

I've been handed a project from a coworker that resigned and without any documentation I'm finding it quite hard to grasp what's wrong with my ElasticSearch results.

If i search the word 'nik' on our e-commerce site i get 4 results:

I'm new to python and trying to get a list of the most popular trigrams for each row in a Pandas dataframe from a column named ['Question'].

I've come close to what I need, but I am unable to get the popularity counts at a row level. Ideally I'd just like to keep the ngrams with a minimum frequency about 1.

Minimum Reproduceable Example:

I built a website with laravel 8. The server is a 6 cores CPU / 6 GB Ram VPS. Server is Linux CentOS with nginx and mysql 8.

At peak period, there is about 500 visits online simultaneously. The CPU become 100% during the peak period and >80% in rest of the time.

I checked the usage and found most resource is used by mysql. Then I located some slow queries and I think this many-to-many relationship query is one of the main cause.

There is a Video model and Genre model with many-to-many relationship setup. In the video table, there is about 800,000 rows. There is 700+ genres in genre table and there is 237,4344 relationships in genre_video table. videos.id and genres.id are primary index of videos and genres table respectively. foreign keys are set up in genre_video

Video model

I have a requirement in the terms query for a nested field in elastic-search where the nested field values should match exactly with the number of values provided in the terms query. For example, consider the below query where we have terms query on the nested field named Types.

GET assets/_search

I am building a model using customized transformers (KeyError: "None of [Index([('A','B','C')] , dtype='object')] are in the [columns]). When I run the below code, I get an error because of .fit:

I have hundreds of chemicals results in my index climate_change

I'm using a ngram research and this is the settings that I'm using for the index.

I am using a function which compares the similarity of each item in a list to each other, like this:

I have this following function that counts character in a string in order the string is written: