info-rchitect

Is it possible for users to highlight list items?

3

Hi, I would like to use this library to re-order a list but also allow users to select multiple items and then hit another widget button to delete them from...

How to get multiple AS statements with a WITH statement?

1

Hi, First let me say that I am not a SQL expert so I apologize ahead of time. I went through the unit tests and did not find an example...

How to implement 'LIKE ANY' and 'NOT REGEXP'?

1

Hi, I checked the [ENUMS](https://github.com/kayak/pypika/blob/2e33a57d549a9c094f0707f51dd2315bf1d428ae/pypika/enums.py) and it seems these would be new features correct? thx

How to set Snowflake dialect for all method calls

2

Hi, I use the `SnowflakeQuery` dialect to make queries. However, if I use any other field-based methods, double-quotes will show up in the final query: ``` groupby = [ 'lot_id'...

lateral flatten possible?

1

Hi, Is this possible? ~~~sql FROM public.MYTABLE t, lateral flatten(input => get(t.scan_results, 0):failingTiles, OUTER => TRUE) tiles ~~~ Based on this [Snowflake documentation](https://community.snowflake.com/s/article/Dynamically-extracting-JSON-using-LATERAL-FLATTEN) (updated doc link). thx

Ability pivot table and keep the group_by columns in the DataFrame

3

Hi, I noticed the pivot_table method removes group_by columns and uses them as the index in the newly created DF. Is there a way to do the pivot table and...

Hi, I use dataframes that are typically indexed from 0 to N with no special need to index with non-numeric labels. So, when I `filter` a dataframe, the index then...

Hi, When I use `Vector#rename` I expect that the vectors method would show the new vector name but it doesn't. ~~~ruby [1] pry(main)> ws_yld_per_wafer_stacked_bins.vectors.to_a.grep(/^wafer_num/) => [:wafer_number] [2] pry(main)> ws_yld_per_wafer_stacked_bins[:wafer_number].rename(:wafer_num) =>...

Hi, I see that the dataframe[ can do a rolling median](https://www.rubydoc.info/gems/daru/0.1.1/Daru/Maths/Statistics/DataFrame#rolling_median-instance_method) but what about performing the median calculation on a group of columns? thx

Loss of DF multi-index when joining a DF without multi-index

12

Hi, I am seeing a multi-index DF lose its multi-index (goes to 0,1,2,3...) when doing a left join with a DF without a multi-index. Is that the expected behavior? ~~~ruby...