C# Класс Gbdx.Aggregations.PivotTableAnalyzer

Показать файл Открыть проект Примеры использования класса

Открытые методы

Метод Описание
CalculateDiffs ( PivotTableEntry a, PivotTableEntry b ) : Double>.Dictionary

Calculates the difference between the values in entry a and b. The resulting distribution is normalized to a value between 0 and 1

DetectChange ( PivotTable ptA, PivotTable ptB, string label, bool diffs ) : PivotTable

Compares two pivot tables. Do not pass in columns that don't make sense to compare. This method encapsulates a cosine similarity calculation on geohash cell pairs, and subsequently, each pair also calculates a diff between each col pair as a quasi percentage diff.

FileToPivotTable ( String file, string rowkeyColumnName ) : PivotTable

Converts a csv file to a pivot table.

GenerateAverageVector ( PivotTable tableWithMoreThanOneRow ) : PivotTable
GetSimilarityGraph ( PivotTable signature ) : Dictionary>
GetSparseSimilarites ( PivotTableEntry baseVector, PivotTable vectors, bool logarithm, bool onlyBase ) : PivotTable
GetSparseSimilarity ( PivotTableEntry a, PivotTableEntry b, bool logarithm, bool onlyBase ) : PivotTableAnalysisResult

Returns a PivotTableAnalysisResult with an empty Data dictionary but with a prob score set to the cosine similarity value of the two input vector spaces. Look here for more info: https://upload.wikimedia.org/math/4/e/4/4e45dc7ae582130813e804f793f24ead.png

PivotTableAnalyzer ( SendAnInt pbarValueUpdate, UpdateAggWindowPbar pbarUpdate ) : System
avg ( List nums ) : double
flattenAndSimplify ( PivotTable withMultipleCompares, String pivCol ) : PivotTable
max ( List nums ) : double
min ( List nums ) : double
stdev ( List list ) : double

Описание методов

CalculateDiffs() публичный Метод

Calculates the difference between the values in entry a and b. The resulting distribution is normalized to a value between 0 and 1
public CalculateDiffs ( PivotTableEntry a, PivotTableEntry b ) : Double>.Dictionary
a PivotTableEntry
b PivotTableEntry
Результат Double>.Dictionary

DetectChange() публичный Метод

Compares two pivot tables. Do not pass in columns that don't make sense to compare. This method encapsulates a cosine similarity calculation on geohash cell pairs, and subsequently, each pair also calculates a diff between each col pair as a quasi percentage diff.
public DetectChange ( PivotTable ptA, PivotTable ptB, string label, bool diffs ) : PivotTable
ptA PivotTable
ptB PivotTable
label string
diffs bool
Результат PivotTable

FileToPivotTable() публичный Метод

Converts a csv file to a pivot table.
public FileToPivotTable ( String file, string rowkeyColumnName ) : PivotTable
file String
rowkeyColumnName string
Результат PivotTable

GenerateAverageVector() публичный Метод

public GenerateAverageVector ( PivotTable tableWithMoreThanOneRow ) : PivotTable
tableWithMoreThanOneRow PivotTable
Результат PivotTable

GetSimilarityGraph() публичный Метод

public GetSimilarityGraph ( PivotTable signature ) : Dictionary>
signature PivotTable
Результат Dictionary>

GetSparseSimilarites() публичный Метод

public GetSparseSimilarites ( PivotTableEntry baseVector, PivotTable vectors, bool logarithm, bool onlyBase ) : PivotTable
baseVector PivotTableEntry
vectors PivotTable
logarithm bool
onlyBase bool
Результат PivotTable

GetSparseSimilarity() публичный Метод

Returns a PivotTableAnalysisResult with an empty Data dictionary but with a prob score set to the cosine similarity value of the two input vector spaces. Look here for more info: https://upload.wikimedia.org/math/4/e/4/4e45dc7ae582130813e804f793f24ead.png
public GetSparseSimilarity ( PivotTableEntry a, PivotTableEntry b, bool logarithm, bool onlyBase ) : PivotTableAnalysisResult
a PivotTableEntry
b PivotTableEntry
logarithm bool
onlyBase bool
Результат PivotTableAnalysisResult

PivotTableAnalyzer() публичный Метод

public PivotTableAnalyzer ( SendAnInt pbarValueUpdate, UpdateAggWindowPbar pbarUpdate ) : System
pbarValueUpdate SendAnInt
pbarUpdate UpdateAggWindowPbar
Результат System

avg() публичный Метод

public avg ( List nums ) : double
nums List
Результат double

flattenAndSimplify() публичный Метод

public flattenAndSimplify ( PivotTable withMultipleCompares, String pivCol ) : PivotTable
withMultipleCompares PivotTable
pivCol String
Результат PivotTable

max() публичный Метод

public max ( List nums ) : double
nums List
Результат double

min() публичный Метод

public min ( List nums ) : double
nums List
Результат double

stdev() публичный Метод

public stdev ( List list ) : double
list List
Результат double