NERO | Source Code for paper NERO : A Neural Rule | Machine Learning library

The text lined up before I added the the the links to them and now they do not. Any help is much apreciated. I will post my css and html below. I will also provide a screen shot of the specifec problem. Not exactly sure what cause the shift. Everything is broken down into classes and the footer class is at the bottom of the HTML.

HTML

I was trying to scrape a website for some university project. The website is https://www.bonprix.it/prodotto/leggings-a-pinocchietto-pacco-da-2-leggings-a-pinocchietto-pacco-da-2-bianco-nero-956015/?itemOptionId=12211813. I have a problem with my python code. What I want to obtain is all the reviews for the pages from 1 to 5, but instead I get all [].Any help would be appreciated!

Here is the code:

Problem

I have a large JSON file (~700.000 lines, 1.2GB filesize) containing twitter data that I need to preprocess for data and network analysis. During the data collection an error happend: Instead of using " as a seperator ' was used. As this does not conform with the JSON standard, the file can not be processed by R or Python.

Information about the dataset: Every about 500 lines start with meta info + meta information for the users, etc. then there are the tweets in json (order of fields not stable) starting with a space, one tweet per line.

This is what I tried so far:

1. A simple data.replace('\'', '\"') is not possible, as the "text" fields contain tweets which may contain ' or " themselves.
2. Using regex, I was able to catch some of the instances, but it does not catch everything: re.compile(r'"[^"]*"(*SKIP)(*FAIL)|\'')
3. Using literal.eval(data) from the ast package also throws an error.

As the order of the fields and the legth for each field is not stable I am stuck on how to reformat that file in order to conform to JSON.

Normal sample line of the data (for this options one and two would work, but note that the tweets are also in non-english languages, which use " or ' in their tweets):

I'm working with the movie DB API (https://developers.themoviedb.org/3/genres/get-movie-list this one) and I print with VUE the results of my call in my page. The API provides me all data I need to have to achieve my goal, that is this

As you can see, under the show name there are the genres associated with that name. Let's take for example the object I obtain when the API gives me A-Team

I have a request for you.

I wanna to scrape the following product https://www.decathlon.it/p/kit-manubri-e-bilanciere-bodybuilding-93kg/_/R-p-10804?mc=4687932&c=NERO#

The prodcuts have two possible status:

1. "ATTUALMENTE INDISPONIBILE"
2. "Disponibile"

In a nutshell I wanna to create a script that monitors for all minutes if the product is available, recording all data in the shell.

The output could be the following:

I wanna to scrape the following product https://www.decathlon.it/p/disco-ghisa-bodybuilding-28mm/_/R-p-7278?mc=1042303&c=NERO

But for the product we could select different weight (from 0.5 to 20kg). I have created the following code, but It give me only the first weight (0,5kg) and not the other one.

I wanna to scrape from the following html code a list of all products and if they are "instock" or "outofstock".

Long Story short. I have data that I'm trying to identify duplicate records by address. The address can be matched on the [Address] or [Remit_Address] fields. I use a JOIN and UNION to get the records, but I need the matched records to appear with each other in the results.

I can't sort by any of the existing fields, so a typical 'ORDER BY' won't work. I looked into RANK as suggested by someone and it looks like it might work, but I don't know how to do the Partition, and I think the Order gives me the same issue with ORDER BY.

If RANK is not the best option I'm open to other ideas. The goal ultimately is to group the matched records someway.

• SSMS 18
• SQL Server 2019

Here is the setup:

Backstory: I have created a bunch of stored procedures that analyze my client's data. I am reviewing a list of vendors and trying to identify possible duplicates. It works pretty well, but each record has 2 possible addresses, and I'm getting duplicate results when matches are found in both addresses. Ideally I'd just need the records to appear in the results once.

Process: I created a "clean" version of the address where I remove special characters and normalize to USPS standards. This helps me match West v W v W. or PO Box v P.O. Box v P O Box etc. I then take all of the distinct address values from both addresses ([cleanAddress] and [cleanRemit_Address]) and put into a master list. I then compare to the source table with a HAVING COUNT(*) > 1 to determine which addresses appear more than once. Lastly I take that final list of addresses that appear more than once and combine it with the source data for output.

Problem: If you view the results near the bottom you'll see that I have 2 sets of dupes that are nearly identical except for some slight differences in the addresses. Both the Address and Remit_Address are essentially the same so it finds a match on BOTH the [cleanAddress] and [cleanRemit_Address] values for "SouthWestern Medical" and "NERO CO" so both sets of dupes appear twice in the list instead of once (see the desired results at the bottom). I need to match [cleanAddress] OR [cleanRemit_Address] but I don't know how to limit each record appearing once in the results.

• SSMS 18
• SQL Server 2019

Queries: