extract-values | simple helper to extract values | Runtime Evironment library

You can join the two dataframes and then check for the condition for each value of Ticker.

If awk is your option, would you please try the following:

Using sqldf it would be like this. Add dbname = tempfile() argument if you can't fit it in memory.

Content is dynamically added so will not be present in your current request format; hence your error as you have a nodeList of Length 0. You could try making POST requests as the page does but it doesn't look like a quick and easy bit of coding. I would go with browser automation, if this is a small project, so that js can run on the page and you can click the show more button. You will need a wait condition for the page to have properly loaded. I use the presence of the show more button.

We need to use the right dataset to extract the values. Here, 'y' doesn't have the rows or columns matching. It is 'x'

Maybe:

Invert the matrix, convert it to logical by negating it to get non-zeros and zeros converted to false and true respectively. Now find the indices of the minimum values of each column using min. This will find the indices of the first occurrence of false in each column of the inverted matrix. Note that first occurrences of false in the inverted matrix are same as last occurrences of non-zeros in the original matrix. Now use these indices and diag to extract the required values.

Alternatively, instead of using min and finding false elements after negation, you can also use max and find true elements after applying logical (i.e. converting zeros to false and non-zeros to true).

There are a few things that you need to change in your code.

Firstly, the key here is to reset the line back to the start of the file after every iteration of reading it once. Since you haven't done this, your code never reads the file from the beginning after the first iteration of the nested for loop. You can do this using infile.seek(0).

Secondly, you need to reset the value of your flag "copy" to False once you are done writing to the file. This ensures that you don't write the text that you don't need to the file. Additionally, you also need to empty your bucket to avoid writing the same lines multiple times in your output.

Thirdly, you have included a lot of string checks in the elif statement that are not necessary.

I have made the changes in the code below:

I am assuming You are referring to kde() from the ks package?

If so, use the argument eval.points to compute the density for a vector/matrix of points using the estimate: