radicals | RADKFILE/KRADFILE parsers | Parser library

Both are actually valid JSON objects, although you are looking for a simple manipulation:

• As per seaborn.catplot

1. col_feature and hue_feature are strings, and a string can't be used for . notation when accessing a dataframe column.
   • data.col_feature is equivalent to data.'nationality' and won't work
   • Use data[col_feature] which is equivalent to data['nationality']
2. The col parameter expects a column name, col='nationality', not an array of values from inside the column.
   • data[col_feature].value_counts()[:10].index can't be used
3. The hue parameter also expects a column name, 'hue='group', not an array.
   • data[hue_feature].value_counts()[:10].index can't be used

• Any type of feature selection should happen to the dataframe before it is sent to catplot.

According to your request of solving this using preferrably Google Sheet formulas rather than Apps Script, I have developed a possible solution/workaround in the fewer amount of steps I could.

To achieve what you aimed here (only display unique members according to their names), I was not able to use query but rather a series of formulas that led me to a similar solution as if you would have used query.

1. Filter the names to only display a list of the unique members (no duplicate names) so that we don't have twice the same person (in the image showing the solution, this formula is implemented in B2):

=unique(filter('Championship Data'!B4:B952;NOT(ISBLANK('Championship Data'!O4:O952))))

1. Get the row index of the names obtained (i.e the row numbers they are in) to then get the rest of the column information we are interested in (implemented in A2 and then dragged all the way down until we cover all the names):

=MATCH(B2;'Championship Data'!$B$4:$B$952;0)+3

1. In the columns C, D and E we will use this row index along with the column we want to get the information from in the sheet Championship Data to get the right values from the other sheet (and then just drag all the way down until we cover all the names):

Car number : =INDEX('Championship Data'!$A$1:$O$952;A2;3)

Team : =INDEX('Championship Data'!$A$1:$O$952;A2;4)

Total : =INDEX('Championship Data'!$A$1:$O$952;A2;15)

1. Finally, using the table we just created, we apply two sort functions for the columns of names and total to order them accordingly:

=SORT(SORT(B2:E34;1;TRUE);4;FALSE)

NOTE : To place the right total value to Manuel, I have had to add these points in the first table created as otherwise it would be practically impossible to change his score (unless we change it manually or with a script). To do so I changed the cell E3 to this: =INDEX('Championship Data'!$A$1:$O$952;A3;15)+20

I hope this has helped you. Let me know if you need anything else or if you did not understood something. :)

You can use LIKE (same like contains() method) instead of ==

for example

I'm not sure what you're trying to do with the sqrts variable, you should be calculating each step on the fly in your loop, since you can't possibly know how deep you need to go

I just messed up rational functions with polynomials. What I was searching for was solve_poly_inequalities:

I think you need something like this

What you want is to iterate over each word and remove any defined prefix or suffix. That's it. And since some radicals will be the same, e.g., for fleur and fleuriste, use a set.

Using vpa before concatenation: