nact | nact ⇒ node.js + actors ⇒ your services | Microservice library

I recently dusted off a script which calls solve.QP from the quadprog package (I currently have version 1.5-5). Now it generates the error "object '.QP_qpgen2' not found". I don't understand why.

This object is not created by me but by the solve.QP function in quadprog. On Github Quadprog.R has the code (line 117):

I have 2 databases on the same server. We will call our first database ActiDB and the second one will be DomiDB. There is a table on DomiDB called DomiActV7 which we will be working on. In DomiActV7 there is a column called Domain and another column that is empty called NumOfClicks.

Now lets take a look at the other database called ActiDB. There are 2 tables there that are important to us. First table is called ActV7 and the second one is called SeV7.

What I need to do is to get the NumOfClicks that is in the table SeV7 (Database ActiDB) in the other database (DomiDB) combined together for each domain and stored in the empty column called NumOfClicks.

Explaining upper text "Combined together for each domain": There is a list of emails in ActV7 and there is a list of domains in DomiActV7. Domain list should check ActV7 emails and find matching domain (ex.: test@testdomain.com is our email and testdomain.com is our domain. The query found the email with same domain in that email and will now use that rows ID that will connect us to the other table in the same database called SeV7) The ID we can get from that row where the email with maching domain is, is called SeV7OID. With this ID we can get into the other table SeV7 where we can find NumOfClicks.

Now that we found our way to NumOfClicks we need to somehow merge them together since there will be more emails with the same domain in previous tables which means that it will give us more IDs that will lead to more NumOfClicks.. I need to imput combined number of clicks back to the 1st table DomiActV7, also there is a specific number 65535 that should be treated as number 1. That is already implemented in the existing query tho.

The query that is made should be updated to look in ActV7 for Email then get the SeV7OID ID and with that ID it should find the NumOfclicks and input them in the other database. I hope I didn't complicate things too hard but I'm trying to explain the situation as good as I can. Also here is a link to older post with a simillar question: Link to the post

Every Columns data type is varchar(50), only SeV7OID and other IDs are INT.

What is wrong with this query that it does direct Email search in SeV7 which is wrong because there is more missing emails than there is written in that table that is why we have to check from ActV7 which has all the emails stored.

Existing query that needs to be modified:

UPDATE DomiDB..DomiActV7 SET NumOfClicks = a.NumOfClicks FROM DomiDB..DomiActV7 d JOIN (SELECT Domain, SUM(CASE WHEN e.NumOfClicks = 65535 THEN 1 ELSE e.NumOfClicks END) AS NumOfClicks FROM DomiDB..DomiActV7 d JOIN ActIDB..nact.SeV7 e ON '@'+d.Domain = right(e.Email,len(d.domain)+1)) a ON a.Domain=d.domain

Example tables: DomiActV7 from DomiDB

I am trying to add image to my Activity through image viewer.

However, I keep receiving Render error that says "Failed to instantiate one or more classes"

I am using scipy.optimize.minimize()to minimise a certain function. I want to compare the performance of different methods, BFGSand L-BFGS-B, and for that, I would like the function to print out its values and error margins as it is optimising.

The L-BFGS-B does this automatically in fact, and it looks like the following:

I use BeautifulSoup to extract a website and I got a the text need. The problem is it has "\n" character in the text which I need to remove.

sample output text:

\nI went to an advance screening of this movie thinking I was about to\nembark on 120 minutes of cheezy lines, mindless plot, and the kind of\nnauseous acting that made "The Postman" one of the most malignant\ndisplays of cinematic blundering of our time. But I was shocked.\nShocked to find a film starring Costner that appealed to the soul of\nthe audience. Shocked that Ashton Kutcher could act in such a serious\nrole. Shocked that a film starring both actually engaged and captured\nmy own emotions. Not since 'Robin Hood' have I seen this Costner: full\nof depth and complex emotion. Kutcher seems to have tweaked the serious\nacting he played with in "Butterfly Effect". These two actors came into\nthis film with a serious, focused attitude that shone through in what I\nthought was one of the best films I've seen this year. No, its not an\nOscar worthy movie. It's not an epic, or a profound social commentary\nfilm. Rather, its a story about a simple topic, illuminated in a way\nthat brings that audience to a higher level of empathy than thought\npossible. That's what I think good film-making is and I for one am\nthroughly impressed by this work. Bravo!\n

I tried the below methods to remove the new line.

method 1 - regex