Distribution

Introduction

This command is useful when you want to discover what data do you have in your tables. I mean what values are most or least frequent in specific column in the table.

Arguments

• input - path to folder with tables exported from dbmaster
• fifa - version of FIFA for that tables
• table - selected table
• column - selected column

Examples

This command can be used in two different ways.

Distribution in the table

If you want to know distribution of 3 most frequent values in the table "leagues", you can use this command.

dbmaster distribution 
  --input 'C:\Users\username\Desktop\fifa16' 
  --fifa fifa16 
  --table leagues

Output

┌────────────────────────┬───────────────────┬──────────────┬─────────────────────────┬────────────┬──────────────────────────────────┬─────────────┬──────────────────────────┬────────────┐
│        (index)         │ mostFreqIsDefault │ defaultValue │       firstValue        │ firstCount │           secondValue            │ secondCount │        thirdValue        │ thirdCount │
├────────────────────────┼───────────────────┼──────────────┼─────────────────────────┼────────────┼──────────────────────────────────┼─────────────┼──────────────────────────┼────────────┤
│       countryid        │       false       │      1       │           14            │     4      │                0                 │      3      │            18            │     2      │
│       leaguename       │       false       │      ''      │ 'Denmark Superliga (1)' │     1      │ 'Belgium Jupiler Pro League (1)' │      1      │ 'Holland Eredivisie (1)' │     1      │
│         level          │       true        │      1       │            1            │     29     │                2                 │      5      │            4             │     3      │
│        leagueid        │       true        │      1       │            1            │     1      │                4                 │      1      │            10            │     1      │
│    leaguetimeslice     │       false       │      0       │            6            │     9      │                5                 │      8      │            0             │     8      │
│ iswithintransferwindow │       false       │      0       │            1            │     25     │                0                 │     17      │        undefined         │ undefined  │
└────────────────────────┴───────────────────┴──────────────┴─────────────────────────┴────────────┴──────────────────────────────────┴─────────────┴──────────────────────────┴────────────┘

Distribution of specific column

If you want to kno distribution of values in column "leaguetimeslice" in table "league", you can use this command.

dbmaster distribution 
  --input 'C:\Users\username\Desktop\fifa16' 
  --fifa fifa16 
  --table leagues 
  --column leaguetimeslice

Output

┌─────────┬───────┬───────┐
│ (index) │ value │ count │
├─────────┼───────┼───────┤
│    0    │   6   │   9   │
│    1    │   5   │   8   │
│    2    │   0   │   8   │
│    3    │   3   │   6   │
│    4    │   8   │   5   │
│    5    │   4   │   3   │
│    6    │   7   │   2   │
│    7    │   9   │   1   │
└─────────┴───────┴───────┘