This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.
⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.
fstfwd
fstfwd
/ PostgreSQL-EXTENSIONs.md
Created
November 24, 2024 22:37
— forked from joelonsql/PostgreSQL-EXTENSIONs.md
1000+ PostgreSQL EXTENSIONs
fstfwd
/ postgresql_is_enough.md
Created
August 20, 2024 08:42
— forked from cpursley/postgresql_is_enough.md
Postgres is Enough
fstfwd
/ Column.FitlerBy
Created
June 18, 2023 21:00
— forked from aelbaitam/Column.FitlerBy
An Excel function that filters by a predicate lambda.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Filters a column using a predicate. If 'positions' | |
| is set to TRUE, returns the indices of the results | |
| instead of the values */ | |
| FilterBy = | |
| LAMBDA(col, predicate, [positions], | |
| LET(returnPositions, AND(NOT(ISOMITTED(positions)), positions=TRUE), | |
| indices, SEQUENCE(ROWS(col)), | |
| IF(returnPositions, | |
| FILTER(indices, MAP(col, predicate)), | |
| FILTER(col, MAP(col, predicate))))); |
fstfwd
/ Column.MapStack
Created
June 18, 2023 21:00
— forked from aelbaitam/Column.MapStack
Excel Function for Column arrays to avoid Nested Array errors
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* Maps a function on the cells of the given column, | |
| and stacks the resulting arrays. | |
| If the resulting arrays are jagged, rows are | |
| padded with the padding if provided else #NA. | |
| TODO: does not account for the case where the | |
| function application produces an error. | |
| */ | |
| MapStack = LAMBDA(col, fn, [padding], [stack_original], | |
| LET(Thunk, LAMBDA(value, LAMBDA(value)), | |
| UnThunk, LAMBDA(thunk, thunk()), |
fstfwd
/ DataAudit
Created
June 15, 2023 14:59
— forked from aimanyaasin/DataAudit
(Credit Prediction ML)
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # Use a general function that returns multiple values | |
| def var_summary(x): | |
| return pd.Series([x.count(), x.isnull().sum(), x.sum(), x.mean(), x.median(), x.std(), x.var(), x.min(), x.dropna().quantile(0.01), x.dropna().quantile(0.05),x.dropna().quantile(0.10),x.dropna().quantile(0.25),x.dropna().quantile(0.50),x.dropna().quantile(0.75), x.dropna().quantile(0.90),x.dropna().quantile(0.95), x.dropna().quantile(0.99),x.max()], | |
| index=['N', 'NMISS', 'SUM', 'MEAN','MEDIAN', 'STD', 'VAR', 'MIN', 'P1' , 'P5' ,'P10' ,'P25' ,'P50' ,'P75' ,'P90' ,'P95' ,'P99' ,'MAX']) | |
| num_summary=custdata_df_num.apply(lambda x: var_summary(x)).T | |
| num_summary |
fstfwd
/ excel-lambda-substituteMult.txt
Created
June 15, 2023 14:58
— forked from YeeBePrime/excel-lambda-substituteMult.txt
Excel lambda substituteMult ; Substitutes newtext for multiple oldtext in a text string using excel lambda recursive function
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| substituteMult | |
| Description | |
| Substitutes newtext for multiple oldtext in a text string. | |
| Syntax | |
| SUBSTITUTEMULT(text, oldtext, newtext,[oldtextpos]) | |
| The SUBSTITUTE function syntax has the following arguments: |
fstfwd
/ excel-lambda-textsplitArr.txt
Created
June 15, 2023 14:58
— forked from YeeBePrime/excel-lambda-textsplitArr.txt
Excel lambda Splits text strings , support 1 dimension array.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| TEXTSPLITARR | |
| Splits text strings by using column and row delimiters. Support 1 dimension array. | |
| The TEXTSPLITARR function works LIKE the built-in TEXTSPLIT function but support 1 dimension text array | |
| Syntax | |
| =TEXTSPLITARR (text,col_delimiter,[row_delimiter]) |
fstfwd
/ excel-lambda-removeBlankShiftUp.txt
Created
June 15, 2023 14:58
— forked from YeeBePrime/excel-lambda-removeBlankShiftUp.txt
Remove blank cells in array and shift cells in that column up using Excel lambda function
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| removeBlankShiftUp | |
| Description | |
| Remove blank cells in array and shift cells in that column up. | |
| Syntax | |
| removeBlankShiftUp (datarange, [lastresult], [lastCol]) | |
| The removeBlankShiftUp function syntax has the following arguments: |
fstfwd
/ excel-lambda-removeBlankShiftLeft.txt
Created
June 15, 2023 14:58
— forked from YeeBePrime/excel-lambda-removeBlankShiftLeft.txt
Remove blank cells in array and shift cells in that row to the left using Excel lambda function
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| removeBlankShiftLeft | |
| Description | |
| Remove blank cells in array and shift cells in that row to the left. | |
| Syntax | |
| removeBlankShiftLeft (datarange, [lastresult], [lastrow]) | |
| The removeBlankShiftLeft function syntax has the following arguments: |
fstfwd
/ excel-lambda-sortbymonth.txt
Created
June 15, 2023 14:58
— forked from YeeBePrime/excel-lambda-sortbymonth.txt
Sort by month eg. Jan,22 Apr,22 Aug,22 jan23 using Excel lambda function
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| /* | |
| sortByMonth | |
| Description | |
| Sort month range eg. Jan,22 Apr,22 Aug,22 jan23 | |
| Syntax | |
| sortByMonth(monthRange) | |
| The sortByMonth function syntax has the following arguments: |
NewerOlder