jardin | A pandas.DataFrame-based ORM | Object-Relational Mapping library

Am encountering a problem when a string contains an apostrophe (single quote). Am developing a vocabulary learning app (French / English). The user must answer quizzes. The phone tells the user if what he/she types is the correct translation. Whenever there is an apostrophe, the string is not recognized.

Ex : "A blade of grass" : "un brin d'herbe" / "A beehive" : "Un nid d'abeilles".

To check the answer, I split the chain into a list : [un,nid,d'abeilles] Even if the user types "d'abeilles", it's never recognized as correct.

I noticed the same problem with the speech to text functionality : if the user says the word "s'habiller" (to get dressed), it is never found by my search function.

Anyone sees why this happens ? Would it be a "flutter" bug ?

In the app, I have a wordbank which was created with Microsoft Excel and then imported into visual studio. The wordbank is made up of WORD objects that have a series of parameters. Here is the one for blade of grass.

...

I am working on a vocabulary quiz app (French to English / English to French). I need to check if what user types is what is expected. Example : "Une machine à laver" --> Expected answer is "A washing machine". The user can make many different sorts of mistakes such as spelling : "A watching machine", a word order mistake : "A machine washing" or a total mistake "A garden tool".

I have managed to deal with the checking when the expected word is just one word : "un jardin : a garden".

But with compound words, the issue of words order comes up. I split the Strings into two lists : _expectedAnswer contains the different elements of the answer : [washing,machine] _typedAnswer contains the different elements of what the user typed : [machine, washing] or [watching,machine] or [washing,machine], or [a,washing,machine] (Here, the user added an article before the noun, which shouldn't be seen as a mistake).

At the end, the algorithm must tell the user what type of mistakes he has done :

1. Word order mistake.
2. Word order is correct, but one or all elements contain spelling problems.
3. word order mistake + spelling problems
4. completely wrong.

For the spelling check I use the levenstein algorithm. And it is satisfactory.

So first I thought I should check if _typedAnswer contains all the elements of _expectedAnswer. -> Should check if the sequence of elements is the same : the order is OK, and no spelling pb.

-> Elements are all present but sequence is not respected : Problem with word order, no spelling mistakes.

-> Elements are not present --> Then we check if "similar elements" are present (which would indicate user made a spelling mistake) .... and check the order of elements too...

Any advice to help me work out this algorithm ?

I have read a lot about all the functions linked to dart lists, but I have to admit, that I kinda got lost on which one would be pertinent to use...

...

I have a question regarding the SQL query. I have this table shown below

Region Rep Item Quebec Jones Pencil Ontario Kivell Binder Ontario Jardine Pencil Ontario Gill Pen Alberta Sorvino Pencil Quebec Jones Binder Ontario Andrews Pencil Ontario Jardine Pencil Alberta Thompson Pencil Quebec Jones Binder Ontario Morgan Pencil Quebec Howard Binder Alberta Sorvino Pen Alberta Thompson Binder Ontario Andrews Pencil Ontario Jardine Binder Ontario Jardine Binder Ontario Andrews Binder

I have to filter for each Region then for each Rep and lastly for each Item. So like one example of a table should look like this:

Region Rep Item Quebec Jones Pencil

And then I have to go back and choose(filter) the other item and the table should look like this:

Region Rep Item Quebec Jones Binder Quebec Jones Binder

After I copied these two tables I have to go back to Rep and chose the other value and again filter item column again the same to get the tables. After I am done with all Rep and Item I have to go back and choose another Region and repeat the same steps

How can I achieve this with a query?

...

My modal does not go completely above all the other components under Android but works well under Ios.

I tried to change hierarchy of my components, play with zIndex and absolute position but my green button is always visible but not touchable when modal show up.

Modal not visible (Android & Ios):

Modal visible (Android) button is still visible:

Modal visible (Ios) button is NOT visible:

My component:

...

I'm a bit new to Python and Pandas and I do not understand how to stack data based on part of the column name.

My data looks like below: (part of sample data)

ID Region Rep Item_Loop1 Units_A_Loop1 Type_col_X_Loop1 Unit_Cost_Type_New_Loop1xyz Total_Loop1ABCD Item_Loop2 Units_A_Loop2 Type_col_X_Loop2 Unit_Cost_Type_New_Loop2xyz Total_Loop2ABCD 1 Central Andrews Pencil 75 A 1,99 149,25 Pencil 66 Q 1,99 131,34 4 Central Jardine Pen Set 50 C 4,99 249,5 Pen Set 50 V 4,99 249,5 5 East Jones Pencil 95 B 1,99 189,05 Binder 60 A 4,99 299,4 6 Central Kivell Binder 50 X 19,99 999,5 Pen Set 96 G 4,99 479,04

Except first 3 columns (ID, Region, Rep) all other columns contain the same substring "Loop" with number of loop, e.g. loop1, loop2, loop3 --> Item_Loop1, Item_Loop2, Item_Loop3

I need to change this data to the one stacked by ID. So for example for ID = 1 there will be 2 additional rows for each loop:

ID Region Rep Loop Item_ Units_A_ Type_col_X_ Unit_Cost_Type_New_xyz Total_ABCD 1 Central Andrews Loop1 Pencil 75 A 1,99 149,25 1 Central Andrews Loop2 Pencil 66 Q 1,99 131,34 1 Central Andrews Loop3 Pencil 14 X 1,29 18,06 4 Central Jardine Loop1 Pen Set 50 C 4,99 249,5 4 Central Jardine Loop2 Pen Set 50 V 4,99 249,5 4 Central Jardine Loop3 Binder 11 Y 4,99 54,89 5 East Jones Loop1 Pencil 95 B 1,99 189,05 5 East Jones Loop2 Binder 60 A 4,99 299,4 5 East Jones Loop3 Pencil 35 Q 4,99 174,65 5 East Jones Loop4 Pen Set 16 A 15,99 255,84 5 East Jones Loop5 Binder 60 G 8,99 539,4

What I've tried doing us to split columns by _ and stacking it with 'loop'. The problem that I found was that my columns have multiple _ in it and after 'loopX' there is additional text. I've tried slicing column names with rfind/slice, but I couldn't execute reasonable results.

My general idea was more or less:

...

Here's the story: I have been in intern in a company for 3 and a half week now (for the end of my first year of programming studies), and my mission is to integrate automated translation in their React web app so that it only translates some of the text (we don't want names or product names to be translated, obviously).

The problem I have isn't the translation part, I already developed a functional REST API ready to be used. The issue I have is that I can't find a way to ONLY access marked parts of a children component from its parent. I managed to do it simply with a document.getElementsByClassName in vanilla js and simple HTML, but not in React.

Here's a quick example of the principle I want to apply:

This is the component that would contain the original text of the app (you will notice I plan on calling the translator component as a wrapper to acces the content of its children).

...

I need concat some column to creat a query, like this

...

I have a table where one column is a json, like this:

...

I have a column named "Trip", in which I have infos such as the hotel, country, and type of trip. The thing is these infos are hand typed, so sometimes instead of typing "HOTEL ABC", the person entering the infos simply enters "ABC", or event "HTL ABC". Also, ABC can also refer to a country.

What I want is to extract all hotel names on each cell. Here's the function I created, but I can't get it to work. (Y2 is the TRIP Column)

...