k7 | Connect you database with Hapijs made easy vhs | Database library

I have data in devanagari that needs some extraction to be done. This is an example of a few lines

तत् इदम् K7 <<<<K1-अर्थ>T6-सार>T6-संग्रह>T6-भूतम्>T2 K1 <T6-आविष्करणाय>T6 अनेकैः <<T6-T6>Di-न्यायम्>T6>Bs6 अपि <K1-K1>K1 त्वेन लौकिकैः गृह्यमाणम् उपलभ्य अहम् विवेकतः <T6-अर्थम्>T4 संक्षेपतः विवरणम् करिष्यामि

T4 अपि यः Bs6 धर्मः वर्णान् आश्रमान् च उद्दिश्य विहितः सः <<<Bs6-स्थान>T6-प्राप्ति>T6-हेतुः>T6 अपि सन् <T6-बुद्ध्या>T6 अनुष्ठीयमानः T6 भवति <T6-वर्जितः>T3

The alphanumerics are the tags of the text. I need to extract the binary compounds along with their tags (the alphanumerics immediately after the compound) from the line. Binary compounds are the two words hyphenated in the angular brackets.

<<T6-T6>Di-न्यायम्>T6>Bs6

The first two are both examples of binary compounds whereas the last one is not. The simplest way to identify a binary compound is to find two words hyphenated enclosed by one set of angular brackets and followed by a single tag. So after extraction, of say the first line, I should get a list with this in it K7, K1

The code that I tried was this

I need help with ordering the results that are in a list. Below is a reproducible sample that is similar to my data:

I've got a select query in a Google Sheet, for the most part it works. It's selecting a bunch of rows where a column equals a value in another cell. For example:

I am trying to copy data from 1 spreadsheet to another, I have successfully implemented something i found online that works with a specific range

I have saved both errors logs from the browser and IDE console into these 2 pdf files below:

browser error log

IDE console error log

https://imgur.com/a/3IYsVlE

codebase (source code link): https://github.com/ismailalabou/service-mvc.git

I have the following table:

And a macro that loops through the first section of the table (rows 6-7) in order to create the Pie-Charts on the right. My target now is to loop through all other tables automatically as well. The next one would be in row11 and create a new Pie Chart for that row, then the next table (rows 15-16) and so on. The header of each table is always red. The problem is that the length of the tables vary, meaning for example in the table1 ("Build", A5:K7) there can be 2 rows like here or 50, but each time I need one PieChart for each row.

Currently I have the following working code for Table1 ("Build" A6:K79) to create the 2 PieCharts automatically, but Im unsure how to make one loop for all tables on the sheet.

My Question: I want to copy specific cells, from multiple workbooks (Called: Business Case (1) and rising), and within these workbooks, i want to copy data from 2 different worksheets (named "Summary" and "Business Case Input Sheet"). I dont know how to write the code to copy and paste the data correcly?

The place i want to copy from :

Filename:"Business Case (x)"

Sheet: "Summary"

Cells:

My main goal is to be able to autofilter merged cells in one column.
In the picture below I want row 7-9 to disappear when I remove "6" from the autofilter menu.
But as I have figured, I need the value "6" to be held in all the cells "L7:L9" in order for Excel to do so.

The number 6 is calculated by adding "Num1" and "Num2" (2 * 3) by the following function I have placed in "L7":

my problem is closely related to Groupby count only when a certain value is present in one of the column in pandas.

Let's say I have a dataframe which is sorted by not_unique_id and date_of_call.