basis | Basis data , analysis , and visualization | Data Visualization library

Situation: I have two dataframes df1 and df2, where df1 has a datetime index based on days, and df2 has two date columns 'wk start' and 'wk end' that are weekly ranges as well as one data column 'statistic' that stores data corresponding to the week range.

What I would like to do: Add to df1 a column for 'statistic' whereby I lookup each date (on a daily basis, i.e. each row) and try to find the corresponding 'statistic' depending on the week that this date falls into.

I believe the answer would require merging df2 into df1 but I'm lost as to how to proceed after that.

Appreciate any help you might provide! Thanks!

df1: (note: I skipped the rows between 2019-06-12 and 2019-06-16 to keep the example short.)

df2:

Desired output:

code for the dataframes d1 and d2

I made a consumer and producer class using spring. Now I want the consumer to trigger some api based on the messages sent by producer. How to do that? Please provide solution in JAVA SpringBoot. How to trigger an api from application.yml in consumer?

I got the following table to populate (range D6:J15) as I search the data in another sheet, based on a date criteria found in row 4:

This is where I'm to look for the data, considering Col A as the basis for the criteria:

My difficulty is to concatenate the data, as they meet the criteria.

This is the code I'm working on:

I wanted a ArrayFormula at C1 which gives the required result as shown.

Entry sheet:
(Column C is my required column)

Date Entered is the date when the Name is Assigned a group i.e. a, b, c, d, e, f

Criteria:

1. The value of count is purely on basis of Date Entered (if john is assigned a on lowest date(10-Jun) then count value is 1, if rose is assigned a on 2nd lowest date(17-Jun) then count value is 2).
2. The value of count does not change even when the data is sorted in any manner because Date Entered column values is always permanent & does not change.
3. New entry date could be any date not necessarily highest date (If a new entry with name Rydu is assigned a on 9-Jun then the it's count value will become 1, then john's (10-Jun) will become 2 and so on)

Example:

After I sort the data in any random order say like this:

Random ordered sheet:
(Count value remains permanent)

And when I do New entries in between (Row 4th & 14th) and after last row (Row 17th):

Random Ordered sheet:
(Doesn't matter where I do)

1. ={"AF Formula1"; ArrayFormula(IF(B2:B="", "", COUNTIFS(B$2:B, "="&B2:B, D$2:D, <"&D2:D)+1))}
2. ={"AF Formula2";INDEX(IFERROR(1/(1/COUNTIFS(B2:B, B2:B, ROW(B2:B), "<="&ROW(B2:B)))))}

I tried to figure my own ArrayFormula but it's not working:

I got Formula for each cell:
=RANK($D2,FILTER($D$2:$D, $B$2:$B=$B2),1)
I figured out Filter doesn't work with ArrayFormula so I had to take a different approach.

I took help from my previous question answer (Arrayformula at H3) which was similar since in both cases each cell FILTER formula returns more than 1 value. (It was actually answered by player0)

Using the same technique I came up with this Formula which works absolutely fine :

=RANK($D2, ARRAYFORMULA(TRANSPOSE(SPLIT(VLOOKUP($B2, SUBSTITUTE(TRIM(SPLIT(FLATTEN(QUERY(QUERY({$B:$B&"×", $D:$D}, "SELECT MAX(Col2) WHERE Col2 IS NOT NULL GROUP BY Col2 PIVOT Col1", 1),, 9^9)), "×")), " ", ","), 2, 0), ","))), 1)

Now when I tried converting it to ArrayFormula: ($D2 to $D2:$D & $B2 to $B2:$B)

=ARRAYFORMULA(RANK($D2:$D,TRANSPOSE(SPLIT(VLOOKUP($B2:$B, SUBSTITUTE(TRIM(SPLIT(FLATTEN(QUERY(QUERY({$B:$B&"×", $D:$D}, "SELECT MAX(Col2) WHERE Col2 IS NOT NULL GROUP BY Col2 PIVOT Col1", 1),, 9^9)), "×")), " ", ","), 2, 0), ",")), 1))

It gives me an error "Did not find value '' in VLOOKUP evaluation", I figured out that the problem is only in VLOOKUP when I change $B2 to $B2:$B.

I'm sure VLOOKUP works with ArrayFormula, I fail to understand where my formula is going wrong! Please help me correct my ArrayFormula.

Here is the editable sheet link

I am trying to make a script that starts with a secret, then hashes it, and hashes that, written in Javascript w/Node. I need to repeat that process 5 million times. The basis for the code is simple but the execution is what's slowing me down. This is what I have so far.

I am using ViewPager2 with FragmentStateAdapter to create a collection of fragments. I want to access a particular fragment on the basis of its position in the Adapter. How can I achieve the same?

I am working on a simple app where you can retrieve video in viewpager not list view and user can also like video.

But now I want to sort all the videos on the basis of most liked.

Here is my database screenshot -

and her is the code of which I made a video adapter from which I retrieve video

code -

I want to create a new column (MATCH) on the basis of string match between two existing columns. For example -

If there is a match in three or more words between column 1 and column 2 then then column 3(MATCH) should show "MATCH". But if there is less than 3 words matches or no match at all (example row 3) then the result should be "NO MATCH"

How can I do this using R??

I'm trying to make QTableView auto-adjust the height whenever column width is changed, I have sub-classed QHeaderView though I was not able to actually utilize it, I'm using sectionResized signal of QHeaderView whenever column width is changed, and on the basis of new columns and the string length for the column header, I'm trying to estimate the height.