程序包 io.github.burukeyou.dataframe.iframe

接口 WindowJDFrame<T>

类型参数:

T -

所有超级接口:

IFrame<T>, Iterable<T>, JDFrame<T>

所有已知实现类:

WindowJDFrameImpl

public interface WindowJDFrame<T>
extends JDFrame<T>

作者:

caizhihao

方法概要

修饰符和类型	方法	说明
<F> JDFrame<FI2<T,BigDecimal>>	overAvg(java.util.function.Function<T,F> field)	avg window function calculate the avg value within the window range
<F> WindowJDFrame<T>	overAvgS(SetFunction<T,BigDecimal> setFunction, java.util.function.Function<T,F> field)	avg window function calculate the avg value within the window range
JDFrame<FI2<T,Integer>>	overCount()	count window function calculate the count within the window range
WindowJDFrame<T>	overCountS(SetFunction<T,Integer> setFunction)	count window function calculate the count within the window range
JDFrame<FI2<T,BigDecimal>>	overCumeDist()	Cume Dist window function set the function result to the setFunction
WindowJDFrame<T>	overCumeDistS(SetFunction<T,BigDecimal> setFunction)	Cume Dist window function set the function result to the setFunction
JDFrame<FI2<T,Integer>>	overDenseRank()	dense rank window function set the function result to the setFunction
WindowJDFrame<T>	overDenseRankS(SetFunction<T,Integer> setFunction)	dense rank window function set the function result to the setFunction
<F> JDFrame<FI2<T,F>>	overFirstValue(java.util.function.Function<T,F> field)	FirstValue window function get the first row within the window range
<F> WindowJDFrame<T>	overFirstValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field)	FirstValue window function get the first row within the window range
<F> JDFrame<FI2<T,F>>	overLag(java.util.function.Function<T,F> field, int n)	Lag window function get the value of the first n rows of the current row
<F> WindowJDFrame<T>	overLagS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field, int n)	Lag window function get the value of the first n rows of the current row
<F> JDFrame<FI2<T,F>>	overLastValue(java.util.function.Function<T,F> field)	LastValue window function get the last row within the window range
<F> WindowJDFrame<T>	overLastValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field)	LastValue window function get the last row within the window range
<F> JDFrame<FI2<T,F>>	overLead(java.util.function.Function<T,F> field, int n)	lead window function get the value of the last n rows of the current row
<F> WindowJDFrame<T>	overLeadS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field, int n)	lead window function get the value of the last n rows of the current row
<F extends Comparable<? super F>> JDFrame<FI2<T,F>>	overMaxValue(java.util.function.Function<T,F> field)	max window function calculate the max value within the window range
<F extends Comparable<? super F>> WindowJDFrame<T>	overMaxValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field)	max window function calculate the max value within the window range
<F extends Comparable<? super F>> JDFrame<FI2<T,F>>	overMinValue(java.util.function.Function<T,F> field)	min window function calculate the min value within the window range
<F extends Comparable<? super F>> WindowJDFrame<T>	overMinValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field)	min window function calculate the min value within the window range
<F> JDFrame<FI2<T,F>>	overNthValue(java.util.function.Function<T,F> field, int n)	NthValue window function get the Nth row within the window range
<F> WindowJDFrame<T>	overNthValueS(SetFunction<T,F> setFunction, java.util.function.Function<T,F> field, int n)	NthValue window function get the Nth row within the window range
JDFrame<FI2<T,Integer>>	overNtile(int n)	Ntile window function assign bucket numbers evenly to windows, starting from 1
WindowJDFrame<T>	overNtileS(SetFunction<T,Integer> setFunction, int n)	Ntile window function assign bucket numbers evenly to windows, starting from 1
JDFrame<FI2<T,BigDecimal>>	overPercentRank()	Percent rank window function set the function result to the setFunction
WindowJDFrame<T>	overPercentRankS(SetFunction<T,BigDecimal> setFunction)	Percent rank window function set the function result to the setFunction
JDFrame<FI2<T,Integer>>	overRank()	rank window function
WindowJDFrame<T>	overRankS(SetFunction<T,Integer> setFunction)	rank window function set the function result to the setFunction
JDFrame<FI2<T,Integer>>	overRowNumber()	rowNumber window function
WindowJDFrame<T>	overRowNumberS(SetFunction<T,Integer> setFunction)	rowNumber window function set the function result to the setFunction
<F> JDFrame<FI2<T,BigDecimal>>	overSum(java.util.function.Function<T,F> field)	sum window function calculate the sum value within the window range
<F> WindowJDFrame<T>	overSumS(SetFunction<T,BigDecimal> setFunction, java.util.function.Function<T,F> field)	sum window function calculate the sum value within the window range

从接口继承的方法 io.github.burukeyou.dataframe.iframe.IFrame

page, stream, subList, toLists

从接口继承的方法 java.lang.Iterable

forEach, iterator, spliterator

从接口继承的方法 io.github.burukeyou.dataframe.iframe.JDFrame

addRankCol, addRankCol, addRowNumberCol, addRowNumberCol, addRowNumberCol, addRowNumberCol, append, avg, col, columns, count, countDistinct, countDistinct, cut, cutFirst, cutFirstRank, cutLast, cutPage, defaultScale, defaultScale, distinct, distinct, distinct, forEachDo, from, group, groupByAvg, groupByAvg, groupByAvg, groupByCount, groupByCount, groupByCount, groupByMax, groupByMax, groupByMaxMin, groupByMaxMin, groupByMaxMinValue, groupByMaxMinValue, groupByMaxValue, groupByMaxValue, groupByMin, groupByMin, groupByMinValue, groupByMinValue, groupBySum, groupBySum, groupBySum, groupBySumCount, groupBySumCount, head, head, join, join, leftJoin, leftJoin, map, mapPercent, mapPercent, max, maxMin, maxMinValue, maxValue, min, minValue, overAvg, overAvgS, overCount, overCountS, overCumeDist, overCumeDistS, overDenseRank, overDenseRankS, overFirstValue, overFirstValueS, overLag, overLagS, overLastValue, overLastValueS, overLead, overLeadS, overMaxValue, overMaxValueS, overMinValue, overMinValueS, overNthValue, overNthValueS, overNtile, overNtileS, overPercentRank, overPercentRankS, overRank, overRankS, overRowNumber, overRowNumberS, overSum, overSumS, partition, replenish, replenish, replenish, rightJoin, rightJoin, show, show, sortAsc, sortAsc, sortDesc, sortDesc, sum, tail, tail, union, where, whereBetween, whereBetweenL, whereBetweenN, whereBetweenR, whereEq, whereGe, whereGt, whereIn, whereLe, whereLike, whereLikeLeft, whereLikeRight, whereLt, whereNotBetween, whereNotBetweenN, whereNotEq, whereNotIn, whereNotLike, whereNotNull, whereNotTrue, whereNull, whereTrue, window, window

方法详细资料

overRowNumber

JDFrame<FI2<T,Integer>> overRowNumber()

rowNumber window function

指定者:

overRowNumber 在接口中 JDFrame<T>

overRowNumberS

WindowJDFrame<T> overRowNumberS(SetFunction<T,Integer> setFunction)

rowNumber window function set the function result to the setFunction

指定者:

overRowNumberS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

overRank

JDFrame<FI2<T,Integer>> overRank()

rank window function

overRankS

WindowJDFrame<T> overRankS(SetFunction<T,Integer> setFunction)

rank window function set the function result to the setFunction

参数:

setFunction - function result accept

overDenseRank

JDFrame<FI2<T,Integer>> overDenseRank()

dense rank window function set the function result to the setFunction

overDenseRankS

WindowJDFrame<T> overDenseRankS(SetFunction<T,Integer> setFunction)

dense rank window function set the function result to the setFunction

参数:

setFunction - function result accept

overPercentRank

JDFrame<FI2<T,BigDecimal>> overPercentRank()

Percent rank window function set the function result to the setFunction

overPercentRankS

WindowJDFrame<T> overPercentRankS(SetFunction<T,BigDecimal> setFunction)

Percent rank window function set the function result to the setFunction

参数:

setFunction - function result accept

overCumeDist

JDFrame<FI2<T,BigDecimal>> overCumeDist()

Cume Dist window function set the function result to the setFunction

overCumeDistS

WindowJDFrame<T> overCumeDistS(SetFunction<T,BigDecimal> setFunction)

Cume Dist window function set the function result to the setFunction

参数:

setFunction - function result accept

overLag

<F> JDFrame<FI2<T,F>> overLag(java.util.function.Function<T,F> field,
                                    int n)

Lag window function get the value of the first n rows of the current row

指定者:

overLag 在接口中 JDFrame<T>

参数:

field - field value

n - first n rows

overLagS

<F> WindowJDFrame<T> overLagS(SetFunction<T,F> setFunction,
                              java.util.function.Function<T,F> field,
                              int n)

Lag window function get the value of the first n rows of the current row

指定者:

overLagS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

n - first n rows

overLead

<F> JDFrame<FI2<T,F>> overLead(java.util.function.Function<T,F> field,
                                     int n)

lead window function get the value of the last n rows of the current row

指定者:

overLead 在接口中 JDFrame<T>

参数:

field - field value

n - last n rows

overLeadS

<F> WindowJDFrame<T> overLeadS(SetFunction<T,F> setFunction,
                               java.util.function.Function<T,F> field,
                               int n)

lead window function get the value of the last n rows of the current row

指定者:

overLeadS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

n - last n rows

overNthValue

<F> JDFrame<FI2<T,F>> overNthValue(java.util.function.Function<T,F> field,
                                         int n)

NthValue window function get the Nth row within the window range

指定者:

overNthValue 在接口中 JDFrame<T>

参数:

field - field value

n - last n rows

overNthValueS

<F> WindowJDFrame<T> overNthValueS(SetFunction<T,F> setFunction,
                                   java.util.function.Function<T,F> field,
                                   int n)

NthValue window function get the Nth row within the window range

指定者:

overNthValueS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

n - last n rows

overFirstValue

<F> JDFrame<FI2<T,F>> overFirstValue(java.util.function.Function<T,F> field)

FirstValue window function get the first row within the window range

指定者:

overFirstValue 在接口中 JDFrame<T>

参数:

field - field value

overFirstValueS

<F> WindowJDFrame<T> overFirstValueS(SetFunction<T,F> setFunction,
                                     java.util.function.Function<T,F> field)

FirstValue window function get the first row within the window range

指定者:

overFirstValueS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

overLastValue

<F> JDFrame<FI2<T,F>> overLastValue(java.util.function.Function<T,F> field)

LastValue window function get the last row within the window range

指定者:

overLastValue 在接口中 JDFrame<T>

参数:

field - field value

overLastValueS

<F> WindowJDFrame<T> overLastValueS(SetFunction<T,F> setFunction,
                                    java.util.function.Function<T,F> field)

LastValue window function get the last row within the window range

指定者:

overLastValueS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

overSum

<F> JDFrame<FI2<T,BigDecimal>> overSum(java.util.function.Function<T,F> field)

sum window function calculate the sum value within the window range

指定者:

overSum 在接口中 JDFrame<T>

参数:

field - field value

overSumS

<F> WindowJDFrame<T> overSumS(SetFunction<T,BigDecimal> setFunction,
                              java.util.function.Function<T,F> field)

sum window function calculate the sum value within the window range

指定者:

overSumS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

overAvg

<F> JDFrame<FI2<T,BigDecimal>> overAvg(java.util.function.Function<T,F> field)

avg window function calculate the avg value within the window range

指定者:

overAvg 在接口中 JDFrame<T>

参数:

field - field value

overAvgS

<F> WindowJDFrame<T> overAvgS(SetFunction<T,BigDecimal> setFunction,
                              java.util.function.Function<T,F> field)

avg window function calculate the avg value within the window range

指定者:

overAvgS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

overMaxValue

<F extends Comparable<? super F>> JDFrame<FI2<T,F>> overMaxValue(java.util.function.Function<T,F> field)

max window function calculate the max value within the window range

指定者:

overMaxValue 在接口中 JDFrame<T>

参数:

field - field value

overMaxValueS

<F extends Comparable<? super F>> WindowJDFrame<T> overMaxValueS(SetFunction<T,F> setFunction,
                                                                 java.util.function.Function<T,F> field)

max window function calculate the max value within the window range

指定者:

overMaxValueS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

overMinValue

<F extends Comparable<? super F>> JDFrame<FI2<T,F>> overMinValue(java.util.function.Function<T,F> field)

min window function calculate the min value within the window range

指定者:

overMinValue 在接口中 JDFrame<T>

参数:

field - field value

overMinValueS

<F extends Comparable<? super F>> WindowJDFrame<T> overMinValueS(SetFunction<T,F> setFunction,
                                                                 java.util.function.Function<T,F> field)

min window function calculate the min value within the window range

指定者:

overMinValueS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

field - field value

overCount

JDFrame<FI2<T,Integer>> overCount()

count window function calculate the count within the window range

指定者:

overCount 在接口中 JDFrame<T>

overCountS

WindowJDFrame<T> overCountS(SetFunction<T,Integer> setFunction)

count window function calculate the count within the window range

指定者:

overCountS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

overNtile

JDFrame<FI2<T,Integer>> overNtile(int n)

Ntile window function assign bucket numbers evenly to windows, starting from 1

指定者:

overNtile 在接口中 JDFrame<T>

参数:

n - size of buckets

overNtileS

WindowJDFrame<T> overNtileS(SetFunction<T,Integer> setFunction,
                            int n)

Ntile window function assign bucket numbers evenly to windows, starting from 1

指定者:

overNtileS 在接口中 JDFrame<T>

参数:

setFunction - function result accept

n - size of buckets