pinto | lightweight framework for mapping Java Beans | User Interface library

I've been trying to standardize the "Address" field of a table with 400k lines. Problem is, this field was made to be a free form field, meaning that users (upon registering) could just enter anything they wanted into it. I've already managed to split this address field into 14 others with each word of the adress line in order.

Now i need to concatenate some of these fields back together into different fields such as:

• Street Name
• House Number

I wish it could be as easy as grabbing the first 3 fields and calling that the street name and the 4th field as House number but due to different street name lengths, the field with the "house number" is usually fields #4, #5 and rarely ever #3 or #6.

I've already thought of an approach that could work in this case and that would be concatenating these fields in a loop and using the first occurence of a field where its first digit is a number as a break point.(due to some houses being numbered "10C", "1A", "1B" and so on)

Due to not being not very good at PL/SQL, i don't know how to put this idea into code.

All that i've managed to do so far was writing a function to check if a string starts with a digit or not, so it could be used in an IF function.

How can i dynamically "traverse" the fields in a loop using PL/SQL? Would i use an array? Is it even possible?

EDIT: Examples of what this address field contains (in portuguese):

Avenida Doutor Theomário Pinto da Costa 450 Condominio Renaissance, rua 1, casa 1

Rua Álvaro Peres Filho 60 Casa azul em frente ao orelhão

Travessa Delegado Zé Lima 61 antiga Praça Rio Branco

Rua Finlândia 28 Qd 111

Alameda Áustria 107 Condomí­nio Jardim Europa I

There is a clear pattern in the data, which leads me to believe that this address data was colected in a segmented format, but then concatenated into a single table field. What i need to do is the reverse, basically.

The pattern goes:

I am currently working with a large dataset I retrieved from the crossref API in which I retrieved information on scientific papers based on a DOI search.

Currently the large list contains of ~3500 elements. Each of these elements is a list of their own consisting of the metadata 'meta', the actual relevant data 'data' and an irrelevant list 'facets'.

This is an example of two of the lists based on two DOI's:

I want to do LDA (linear discriminant analysis) with the Auto dataset of the ISLR package. To start off, I am trying to take the cars with year = 75 and use it as a "test set", where cars of all other years will be used as a "training set". However, it seems that I've made a mess of things. For instance, in my code below, sequentially using the replace function for the values of mpg.year75 just results in everything being set to high:

I am trying to use the rename() function of the dplyr package to change the variable mpg to mpgclass:

So the problem is that at option 6 of the switch. When I need to load a file, currently it just reads the file and displays it's content, but I need to load the .txt file as in option 3, to create different things on the class for it to be different cars.

I converted the original u2net model weight file u2net.pth to tensorflow lite by following these instructructions, and it is converted successfully.

However I'm having trouble using it in android in tensrflow lite, I was not being able to add the image segmenter metadata to this model with tflite-support script, so I changed the model and returned only 1 output d0 (which is a combination of all i.e d1,d2,...,d7). Then metadata was added successfully and I was able to use the model, but its not giving any output and returning the same image .

So any help would be much appreciated, in letting me know where I messed up, and how can I use this use this u2net model properly in tensorflow lite with android, thanks in advance ..

I have the following dataframe

I have a dataframe with prices in $. I want to do calculations on it but the $ makes it impossible. I'm trying to remove it using df.iloc[:, 4].replace("$", " ", regex=True) but unfortunately nothing changes. If I add inplace=True then whe whole word disappears. What am I doing wrong? Tried many stackoverflow posts but nothing works. I cant use str.replace() because its about the whole column not one word.

My code:

So I made that code, it get a in file for reading, read it into a temporary variable of a object then push_back it to a vector as container. But... its not working, after the last one, all variables get the information of the last one object read in file!

setObject class: