Skip to content

Instantly share code, notes, and snippets.

@bkamins

bkamins/Manifest.toml

Last active November 21, 2020 18:44
Show Gist options
  • Save bkamins/c6b7b536aefda6c2be67f133972a62e8 to your computer and use it in GitHub Desktop.
Save bkamins/c6b7b536aefda6c2be67f133972a62e8 to your computer and use it in GitHub Desktop.
Download ZIP
Showcasing DataFrames.jl version 0.22
Display the source blob
Display the rendered blob
Raw
airports.ipynb
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
Display the source blob
Display the rendered blob
Raw
bison.ipynb
{
"cells": [
{
"cell_type": "markdown",
"metadata": {},
"source": [
"# Working with DataFrames.jl v0.22.1\n",
"\n",
"# Part 2\n",
"\n",
"## Bogumił Kamiński"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"In this part of the tutorial we will work with a data set taken from the paper:\n",
"\n",
"D. F. Lott, \"[Dominance relations and breeding rate in mature male American bison](https://onlinelibrary.wiley.com/doi/abs/10.1111/j.1439-0310.1979.tb00302.x)\", Zeitschrift Tierpsychologie, 1979, 49: 418-432\n",
"\n",
"You can find the description of the interpretation of the data [here](http://moreno.ss.uci.edu/data.html#bison).\n",
"In short the data set stores information about dominance encounters and breeding behaviors of 26 males in a herd of American bison.\n",
"\n",
"The data set *bison.json* that we will work with is bundled with this file in a GitHub gist.\n",
"\n",
"Each line in *bison.json* is a JSON entry giving:\n",
"* bison id `:id`\n",
"* bison breeding success `:breeding`\n",
"* a list of pairs giving domination relation between this bison and other bisons in form of pairs: other bison id and domination value\n",
"\n",
"Our objective is to read in this data into a `DataFrame` and then analyze if higher domination relation of a correlates with breeding success."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We start with loading the required packages."
]
},
{
"cell_type": "code",
"execution_count": 1,
"metadata": {},
"outputs": [],
"source": [
"using DataFrames\n",
"using JSON3\n",
"using Statistics"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"and changing the number of columns printed:"
]
},
{
"cell_type": "code",
"execution_count": 2,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"500"
]
},
"execution_count": 2,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"ENV[\"COLUMNS\"] = 500"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"As usual Before we start let us make sure that you have the right versions of packages installed.\n",
"\n",
"The output of the command below should be:\n",
"```\n",
" [6e4b80f9] BenchmarkTools v0.5.0\n",
" [336ed68f] CSV v0.8.0\n",
" [a93c6f00] DataFrames v0.22.1\n",
" [7073ff75] IJulia v1.23.0\n",
" [0f8b85d8] JSON3 v1.5.1\n",
" [b98c9c47] Pipe v1.3.0\n",
" [91a5bcdd] Plots v1.9.1\n",
" ```"
]
},
{
"cell_type": "code",
"execution_count": 3,
"metadata": {},
"outputs": [
{
"name": "stdout",
"output_type": "stream",
"text": [
"\u001b[32m\u001b[1mStatus\u001b[22m\u001b[39m `~/Downloads/c6b7b536aefda6c2be67f133972a62e8-10e8f32fdf4f6e15dea2d883ffd7311f11934e7e/Project.toml`\n",
" \u001b[90m [6e4b80f9] \u001b[39m\u001b[37mBenchmarkTools v0.5.0\u001b[39m\n",
" \u001b[90m [336ed68f] \u001b[39m\u001b[37mCSV v0.8.0\u001b[39m\n",
" \u001b[90m [a93c6f00] \u001b[39m\u001b[37mDataFrames v0.22.1\u001b[39m\n",
" \u001b[90m [7073ff75] \u001b[39m\u001b[37mIJulia v1.23.0\u001b[39m\n",
" \u001b[90m [0f8b85d8] \u001b[39m\u001b[37mJSON3 v1.5.1\u001b[39m\n",
" \u001b[90m [b98c9c47] \u001b[39m\u001b[37mPipe v1.3.0\u001b[39m\n",
" \u001b[90m [91a5bcdd] \u001b[39m\u001b[37mPlots v1.9.1\u001b[39m\n"
]
}
],
"source": [
"] status"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Let us peek into the *bison.json* file:"
]
},
{
"cell_type": "code",
"execution_count": 4,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"26-element Array{String,1}:\n",
" \"{\\\"id\\\":\\\"1\\\", \\\"3\\\":8, \\\"4\\\":5, \\\"2\\\":2, \\\"6\\\":6, \\\"8\\\":11, \\\"9\\\":3, \\\"5\\\":21, \\\"10\\\":5, \\\"7\\\":7, \\\"12\\\":1, \\\"17\\\":3, \\\"18\\\":5, \\\"13\\\":2, \\\"14\\\":3, \\\"21\\\":4, \\\"19\\\":2, \\\"15\\\":1, \\\"20\\\":7, \\\"breeding\\\":4}\"\n",
" \"{\\\"id\\\":\\\"3\\\", \\\"4\\\":4, \\\"6\\\":4, \\\"8\\\":4, \\\"9\\\":8, \\\"5\\\":12, \\\"10\\\":12, \\\"7\\\":3, \\\"12\\\":2, \\\"17\\\":2, \\\"18\\\":7, \\\"13\\\":5, \\\"14\\\":1, \\\"21\\\":3, \\\"19\\\":4, \\\"20\\\":5, \\\"16\\\":1, \\\"breeding\\\":2}\"\n",
" \"{\\\"id\\\":\\\"4\\\", \\\"1\\\":1, \\\"3\\\":1, \\\"2\\\":3, \\\"6\\\":1, \\\"8\\\":4, \\\"9\\\":4, \\\"5\\\":8, \\\"10\\\":10, \\\"7\\\":1, \\\"17\\\":1, \\\"18\\\":4, \\\"13\\\":6, \\\"21\\\":2, \\\"19\\\":2, \\\"15\\\":3, \\\"11\\\":1, \\\"20\\\":4, \\\"22\\\":3, \\\"breeding\\\":3}\"\n",
" \"{\\\"id\\\":\\\"26\\\", \\\"2\\\":7, \\\"25\\\":1, \\\"23\\\":2, \\\"10\\\":3, \\\"21\\\":1, \\\"19\\\":1, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"2\\\", \\\"1\\\":1, \\\"3\\\":2, \\\"4\\\":3, \\\"26\\\":1, \\\"6\\\":1, \\\"8\\\":3, \\\"5\\\":3, \\\"10\\\":3, \\\"7\\\":2, \\\"12\\\":2, \\\"17\\\":1, \\\"18\\\":3, \\\"13\\\":2, \\\"14\\\":4, \\\"21\\\":1, \\\"19\\\":1, \\\"15\\\":1, \\\"20\\\":2, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"25\\\", \\\"1\\\":2, \\\"24\\\":8, \\\"9\\\":12, \\\"23\\\":1, \\\"10\\\":7, \\\"14\\\":8, \\\"21\\\":3, \\\"19\\\":3, \\\"15\\\":2, \\\"breeding\\\":3}\"\n",
" \"{\\\"id\\\":\\\"6\\\", \\\"1\\\":1, \\\"8\\\":5, \\\"9\\\":2, \\\"5\\\":6, \\\"10\\\":5, \\\"7\\\":1, \\\"12\\\":2, \\\"17\\\":1, \\\"18\\\":1, \\\"13\\\":3, \\\"14\\\":1, \\\"19\\\":1, \\\"15\\\":1, \\\"20\\\":4, \\\"breeding\\\":4}\"\n",
" \"{\\\"id\\\":\\\"8\\\", \\\"1\\\":2, \\\"4\\\":1, \\\"2\\\":1, \\\"24\\\":5, \\\"9\\\":11, \\\"5\\\":3, \\\"23\\\":6, \\\"10\\\":6, \\\"17\\\":4, \\\"18\\\":2, \\\"13\\\":2, \\\"14\\\":1, \\\"19\\\":6, \\\"11\\\":1, \\\"20\\\":7, \\\"16\\\":1, \\\"22\\\":1, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"24\\\", \\\"4\\\":1, \\\"8\\\":2, \\\"9\\\":2, \\\"23\\\":1, \\\"10\\\":2, \\\"17\\\":1, \\\"13\\\":1, \\\"14\\\":3, \\\"21\\\":3, \\\"19\\\":2, \\\"15\\\":2, \\\"20\\\":1, \\\"breeding\\\":4}\"\n",
" \"{\\\"id\\\":\\\"9\\\", \\\"1\\\":4, \\\"4\\\":1, \\\"25\\\":1, \\\"6\\\":2, \\\"8\\\":3, \\\"24\\\":1, \\\"23\\\":2, \\\"10\\\":9, \\\"7\\\":1, \\\"17\\\":4, \\\"14\\\":2, \\\"21\\\":4, \\\"19\\\":4, \\\"15\\\":3, \\\"20\\\":3, \\\"16\\\":2, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"5\\\", \\\"1\\\":1, \\\"3\\\":2, \\\"2\\\":1, \\\"6\\\":6, \\\"8\\\":4, \\\"10\\\":17, \\\"7\\\":3, \\\"17\\\":6, \\\"18\\\":5, \\\"13\\\":8, \\\"21\\\":2, \\\"19\\\":5, \\\"15\\\":2, \\\"11\\\":1, \\\"20\\\":4, \\\"22\\\":1, \\\"breeding\\\":3}\"\n",
" \"{\\\"id\\\":\\\"23\\\", \\\"1\\\":2, \\\"2\\\":1, \\\"25\\\":3, \\\"8\\\":1, \\\"9\\\":2, \\\"10\\\":1, \\\"17\\\":1, \\\"13\\\":5, \\\"14\\\":3, \\\"21\\\":3, \\\"19\\\":1, \\\"20\\\":1, \\\"breeding\\\":3}\"\n",
" \"{\\\"id\\\":\\\"10\\\", \\\"1\\\":1, \\\"3\\\":1, \\\"6\\\":1, \\\"8\\\":2, \\\"24\\\":1, \\\"9\\\":2, \\\"5\\\":1, \\\"7\\\":6, \\\"17\\\":3, \\\"18\\\":4, \\\"13\\\":4, \\\"14\\\":7, \\\"21\\\":6, \\\"19\\\":4, \\\"15\\\":5, \\\"20\\\":7, \\\"16\\\":2, \\\"breeding\\\":0}\"\n",
" \"{\\\"id\\\":\\\"7\\\", \\\"1\\\":3, \\\"3\\\":2, \\\"8\\\":1, \\\"5\\\":2, \\\"12\\\":3, \\\"17\\\":1, \\\"18\\\":2, \\\"13\\\":2, \\\"14\\\":3, \\\"21\\\":1, \\\"19\\\":1, \\\"15\\\":1, \\\"20\\\":4, \\\"16\\\":1, \\\"22\\\":1, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"12\\\", \\\"4\\\":1, \\\"6\\\":2, \\\"10\\\":3, \\\"18\\\":1, \\\"13\\\":2, \\\"21\\\":2, \\\"20\\\":4, \\\"breeding\\\":2}\"\n",
" \"{\\\"id\\\":\\\"17\\\", \\\"1\\\":1, \\\"8\\\":2, \\\"9\\\":2, \\\"5\\\":2, \\\"10\\\":1, \\\"7\\\":1, \\\"18\\\":8, \\\"13\\\":2, \\\"14\\\":2, \\\"21\\\":2, \\\"19\\\":3, \\\"20\\\":1, \\\"breeding\\\":0}\"\n",
" \"{\\\"id\\\":\\\"18\\\", \\\"1\\\":1, \\\"4\\\":1, \\\"6\\\":1, \\\"8\\\":5, \\\"9\\\":6, \\\"5\\\":3, \\\"10\\\":1, \\\"7\\\":1, \\\"17\\\":1, \\\"13\\\":1, \\\"14\\\":1, \\\"21\\\":1, \\\"19\\\":1, \\\"15\\\":1, \\\"20\\\":1, \\\"breeding\\\":0}\"\n",
" \"{\\\"id\\\":\\\"13\\\", \\\"1\\\":1, \\\"6\\\":2, \\\"9\\\":1, \\\"5\\\":2, \\\"10\\\":2, \\\"7\\\":1, \\\"12\\\":2, \\\"17\\\":1, \\\"18\\\":1, \\\"14\\\":3, \\\"21\\\":1, \\\"19\\\":3, \\\"15\\\":1, \\\"11\\\":1, \\\"20\\\":12, \\\"16\\\":1, \\\"22\\\":1, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"14\\\", \\\"1\\\":1, \\\"4\\\":1, \\\"23\\\":2, \\\"10\\\":1, \\\"12\\\":1, \\\"17\\\":4, \\\"21\\\":7, \\\"19\\\":3, \\\"16\\\":1, \\\"breeding\\\":0}\"\n",
" \"{\\\"id\\\":\\\"21\\\", \\\"25\\\":7, \\\"24\\\":1, \\\"10\\\":2, \\\"7\\\":1, \\\"14\\\":1, \\\"19\\\":5, \\\"15\\\":2, \\\"11\\\":1, \\\"16\\\":1, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"19\\\", \\\"4\\\":2, \\\"9\\\":2, \\\"5\\\":1, \\\"10\\\":1, \\\"7\\\":4, \\\"17\\\":1, \\\"13\\\":1, \\\"14\\\":1, \\\"21\\\":3, \\\"15\\\":5, \\\"11\\\":1, \\\"20\\\":3, \\\"breeding\\\":2}\"\n",
" \"{\\\"id\\\":\\\"15\\\", \\\"10\\\":1, \\\"18\\\":1, \\\"13\\\":1, \\\"21\\\":2, \\\"20\\\":9, \\\"16\\\":2, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"11\\\", \\\"3\\\":2, \\\"2\\\":1, \\\"5\\\":1, \\\"13\\\":4, \\\"16\\\":1, \\\"22\\\":9, \\\"breeding\\\":0}\"\n",
" \"{\\\"id\\\":\\\"20\\\", \\\"6\\\":1, \\\"5\\\":1, \\\"7\\\":2, \\\"12\\\":3, \\\"17\\\":3, \\\"13\\\":1, \\\"14\\\":2, \\\"21\\\":2, \\\"19\\\":1, \\\"15\\\":1, \\\"breeding\\\":1}\"\n",
" \"{\\\"id\\\":\\\"16\\\", \\\"3\\\":1, \\\"6\\\":2, \\\"8\\\":1, \\\"5\\\":1, \\\"10\\\":1, \\\"18\\\":1, \\\"breeding\\\":0}\"\n",
" \"{\\\"id\\\":\\\"22\\\", \\\"10\\\":1, \\\"breeding\\\":0}\""
]
},
"execution_count": 4,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"readlines(\"bison.json\")"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Indeed we see that we have 26 lines in the file. We immediately notice that bison id is numeric, which might be a challenge if we want to use it as a column name (fortunately for DataFrames.jl v0.21 it is not a problem)."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"First we populate the data frame with the data stored in the file:"
]
},
{
"cell_type": "code",
"execution_count": 5,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<table class=\"data-frame\"><thead><tr><th></th></tr><tr><th></th></tr></thead><tbody><p>0 rows × 0 columns</p></tbody></table>"
],
"text/latex": [
"\\begin{tabular}{r|}\n",
"\t& \\\\\n",
"\t\\hline\n",
"\t& \\\\\n",
"\t\\hline\n",
"\\end{tabular}\n"
],
"text/plain": [
"\u001b[1m0×0 DataFrame\u001b[0m"
]
},
"execution_count": 5,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df = DataFrame()"
]
},
{
"cell_type": "code",
"execution_count": 6,
"metadata": {},
"outputs": [],
"source": [
"foreach(JSON3.read.(readlines(\"bison.json\"))) do row\n",
" push!(df, row, cols=:union)\n",
"end"
]
},
{
"cell_type": "code",
"execution_count": 7,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<table class=\"data-frame\"><thead><tr><th></th><th>breeding</th><th>17</th><th>20</th><th>8</th><th>7</th><th>2</th><th>12</th><th>18</th><th>13</th><th>21</th><th>9</th><th>6</th><th>14</th><th>19</th><th>id</th><th>10</th><th>4</th><th>3</th><th>5</th><th>15</th><th>16</th><th>1</th><th>22</th><th>11</th><th>25</th><th>23</th><th>26</th><th>24</th></tr><tr><th></th><th>Int64</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>String</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th></tr></thead><tbody><p>26 rows × 28 columns</p><tr><th>1</th><td>4</td><td>3</td><td>7</td><td>11</td><td>7</td><td>2</td><td>1</td><td>5</td><td>2</td><td>4</td><td>3</td><td>6</td><td>3</td><td>2</td><td>1</td><td>5</td><td>5</td><td>8</td><td>21</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>2</th><td>2</td><td>2</td><td>5</td><td>4</td><td>3</td><td><em>missing</em></td><td>2</td><td>7</td><td>5</td><td>3</td><td>8</td><td>4</td><td>1</td><td>4</td><td>3</td><td>12</td><td>4</td><td><em>missing</em></td><td>12</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>3</th><td>3</td><td>1</td><td>4</td><td>4</td><td>1</td><td>3</td><td><em>missing</em></td><td>4</td><td>6</td><td>2</td><td>4</td><td>1</td><td><em>missing</em></td><td>2</td><td>4</td><td>10</td><td><em>missing</em></td><td>1</td><td>8</td><td>3</td><td><em>missing</em></td><td>1</td><td>3</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>4</th><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>26</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>5</th><td>1</td><td>1</td><td>2</td><td>3</td><td>2</td><td><em>missing</em></td><td>2</td><td>3</td><td>2</td><td>1</td><td><em>missing</em></td><td>1</td><td>4</td><td>1</td><td>2</td><td>3</td><td>3</td><td>2</td><td>3</td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td></tr><tr><th>6</th><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>12</td><td><em>missing</em></td><td>8</td><td>3</td><td>25</td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>8</td></tr><tr><th>7</th><td>4</td><td>1</td><td>4</td><td>5</td><td>1</td><td><em>missing</em></td><td>2</td><td>1</td><td>3</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>1</td><td>1</td><td>6</td><td>5</td><td><em>missing</em></td><td><em>missing</em></td><td>6</td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>8</th><td>1</td><td>4</td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>2</td><td>2</td><td><em>missing</em></td><td>11</td><td><em>missing</em></td><td>1</td><td>6</td><td>8</td><td>6</td><td>1</td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>1</td><td>2</td><td>1</td><td>1</td><td><em>missing</em></td><td>6</td><td><em>missing</em></td><td>5</td></tr><tr><th>9</th><td>4</td><td>1</td><td>1</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>3</td><td>2</td><td><em>missing</em></td><td>3</td><td>2</td><td>24</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>10</th><td>1</td><td>4</td><td>3</td><td>3</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>4</td><td><em>missing</em></td><td>2</td><td>2</td><td>4</td><td>9</td><td>9</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>2</td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>2</td><td><em>missing</em></td><td>1</td></tr><tr><th>11</th><td>3</td><td>6</td><td>4</td><td>4</td><td>3</td><td>1</td><td><em>missing</em></td><td>5</td><td>8</td><td>2</td><td><em>missing</em></td><td>6</td><td><em>missing</em></td><td>5</td><td>5</td><td>17</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>1</td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>12</th><td>3</td><td>1</td><td>1</td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>5</td><td>3</td><td>2</td><td><em>missing</em></td><td>3</td><td>1</td><td>23</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>13</th><td>0</td><td>3</td><td>7</td><td>2</td><td>6</td><td><em>missing</em></td><td><em>missing</em></td><td>4</td><td>4</td><td>6</td><td>2</td><td>1</td><td>7</td><td>4</td><td>10</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>1</td><td>5</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td></tr><tr><th>14</th><td>1</td><td>1</td><td>4</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>2</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>1</td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>2</td><td>1</td><td>1</td><td>3</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>15</th><td>2</td><td><em>missing</em></td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>2</td><td>2</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>12</td><td>3</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>16</th><td>0</td><td><em>missing</em></td><td>1</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>8</td><td>2</td><td>2</td><td>2</td><td><em>missing</em></td><td>2</td><td>3</td><td>17</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>17</th><td>0</td><td>1</td><td>1</td><td>5</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>1</td><td>6</td><td>1</td><td>1</td><td>1</td><td>18</td><td>1</td><td>1</td><td><em>missing</em></td><td>3</td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>18</th><td>1</td><td>1</td><td>12</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>2</td><td>1</td><td><em>missing</em></td><td>1</td><td>1</td><td>2</td><td>3</td><td>3</td><td>13</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>1</td><td>1</td><td>1</td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>19</th><td>0</td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>14</td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>20</th><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>5</td><td>21</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td></tr><tr><th>21</th><td>2</td><td>1</td><td>3</td><td><em>missing</em></td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>3</td><td>2</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>19</td><td>1</td><td>2</td><td><em>missing</em></td><td>1</td><td>5</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>22</th><td>1</td><td><em>missing</em></td><td>9</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>1</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>15</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>23</th><td>0</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>11</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>9</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>24</th><td>1</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>1</td><td>2</td><td><em>missing</em></td><td>1</td><td>2</td><td>1</td><td>20</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>25</th><td>0</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>16</td><td>1</td><td><em>missing</em></td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>26</th><td>0</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>22</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr></tbody></table>"
],
"text/latex": [
"\\begin{tabular}{r|cccccccccccccccccccccccccccc}\n",
"\t& breeding & 17 & 20 & 8 & 7 & 2 & 12 & 18 & 13 & 21 & 9 & 6 & 14 & 19 & id & 10 & 4 & 3 & 5 & 15 & 16 & 1 & 22 & 11 & 25 & 23 & 26 & 24\\\\\n",
"\t\\hline\n",
"\t& Int64 & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & String & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64?\\\\\n",
"\t\\hline\n",
"\t1 & 4 & 3 & 7 & 11 & 7 & 2 & 1 & 5 & 2 & 4 & 3 & 6 & 3 & 2 & 1 & 5 & 5 & 8 & 21 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t2 & 2 & 2 & 5 & 4 & 3 & \\emph{missing} & 2 & 7 & 5 & 3 & 8 & 4 & 1 & 4 & 3 & 12 & 4 & \\emph{missing} & 12 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t3 & 3 & 1 & 4 & 4 & 1 & 3 & \\emph{missing} & 4 & 6 & 2 & 4 & 1 & \\emph{missing} & 2 & 4 & 10 & \\emph{missing} & 1 & 8 & 3 & \\emph{missing} & 1 & 3 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t4 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 7 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 26 & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 2 & \\emph{missing} & \\emph{missing} \\\\\n",
"\t5 & 1 & 1 & 2 & 3 & 2 & \\emph{missing} & 2 & 3 & 2 & 1 & \\emph{missing} & 1 & 4 & 1 & 2 & 3 & 3 & 2 & 3 & 1 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} \\\\\n",
"\t6 & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & 12 & \\emph{missing} & 8 & 3 & 25 & 7 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 8 \\\\\n",
"\t7 & 4 & 1 & 4 & 5 & 1 & \\emph{missing} & 2 & 1 & 3 & \\emph{missing} & 2 & \\emph{missing} & 1 & 1 & 6 & 5 & \\emph{missing} & \\emph{missing} & 6 & 1 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t8 & 1 & 4 & 7 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 2 & 2 & \\emph{missing} & 11 & \\emph{missing} & 1 & 6 & 8 & 6 & 1 & \\emph{missing} & 3 & \\emph{missing} & 1 & 2 & 1 & 1 & \\emph{missing} & 6 & \\emph{missing} & 5 \\\\\n",
"\t9 & 4 & 1 & 1 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 3 & 2 & \\emph{missing} & 3 & 2 & 24 & 2 & 1 & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} \\\\\n",
"\t10 & 1 & 4 & 3 & 3 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 4 & \\emph{missing} & 2 & 2 & 4 & 9 & 9 & 1 & \\emph{missing} & \\emph{missing} & 3 & 2 & 4 & \\emph{missing} & \\emph{missing} & 1 & 2 & \\emph{missing} & 1 \\\\\n",
"\t11 & 3 & 6 & 4 & 4 & 3 & 1 & \\emph{missing} & 5 & 8 & 2 & \\emph{missing} & 6 & \\emph{missing} & 5 & 5 & 17 & \\emph{missing} & 2 & \\emph{missing} & 2 & \\emph{missing} & 1 & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t12 & 3 & 1 & 1 & 1 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & 5 & 3 & 2 & \\emph{missing} & 3 & 1 & 23 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t13 & 0 & 3 & 7 & 2 & 6 & \\emph{missing} & \\emph{missing} & 4 & 4 & 6 & 2 & 1 & 7 & 4 & 10 & \\emph{missing} & \\emph{missing} & 1 & 1 & 5 & 2 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 \\\\\n",
"\t14 & 1 & 1 & 4 & 1 & \\emph{missing} & \\emph{missing} & 3 & 2 & 2 & 1 & \\emph{missing} & \\emph{missing} & 3 & 1 & 7 & \\emph{missing} & \\emph{missing} & 2 & 2 & 1 & 1 & 3 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t15 & 2 & \\emph{missing} & 4 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 2 & 2 & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & 12 & 3 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t16 & 0 & \\emph{missing} & 1 & 2 & 1 & \\emph{missing} & \\emph{missing} & 8 & 2 & 2 & 2 & \\emph{missing} & 2 & 3 & 17 & 1 & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t17 & 0 & 1 & 1 & 5 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 1 & 6 & 1 & 1 & 1 & 18 & 1 & 1 & \\emph{missing} & 3 & 1 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t18 & 1 & 1 & 12 & \\emph{missing} & 1 & \\emph{missing} & 2 & 1 & \\emph{missing} & 1 & 1 & 2 & 3 & 3 & 13 & 2 & \\emph{missing} & \\emph{missing} & 2 & 1 & 1 & 1 & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t19 & 0 & 4 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & 7 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & 14 & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} \\\\\n",
"\t20 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 5 & 21 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & 1 & \\emph{missing} & \\emph{missing} & 1 & 7 & \\emph{missing} & \\emph{missing} & 1 \\\\\n",
"\t21 & 2 & 1 & 3 & \\emph{missing} & 4 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 3 & 2 & \\emph{missing} & 1 & \\emph{missing} & 19 & 1 & 2 & \\emph{missing} & 1 & 5 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t22 & 1 & \\emph{missing} & 9 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 1 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 15 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t23 & 0 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & 4 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 11 & \\emph{missing} & \\emph{missing} & 2 & 1 & \\emph{missing} & 1 & \\emph{missing} & 9 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t24 & 1 & 3 & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & 3 & \\emph{missing} & 1 & 2 & \\emph{missing} & 1 & 2 & 1 & 20 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t25 & 0 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & 16 & 1 & \\emph{missing} & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t26 & 0 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 22 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\\end{tabular}\n"
],
"text/plain": [
"\u001b[1m26×28 DataFrame\u001b[0m\n",
"\u001b[1m Row \u001b[0m│\u001b[1m breeding \u001b[0m\u001b[1m 17 \u001b[0m\u001b[1m 20 \u001b[0m\u001b[1m 8 \u001b[0m\u001b[1m 7 \u001b[0m\u001b[1m 2 \u001b[0m\u001b[1m 12 \u001b[0m\u001b[1m 18 \u001b[0m\u001b[1m 13 \u001b[0m\u001b[1m 21 \u001b[0m\u001b[1m 9 \u001b[0m\u001b[1m 6 \u001b[0m\u001b[1m 14 \u001b[0m\u001b[1m 19 \u001b[0m\u001b[1m id \u001b[0m\u001b[1m 10 \u001b[0m\u001b[1m 4 \u001b[0m\u001b[1m 3 \u001b[0m\u001b[1m 5 \u001b[0m\u001b[1m 15 \u001b[0m\u001b[1m 16 \u001b[0m\u001b[1m 1 \u001b[0m\u001b[1m 22 \u001b[0m\u001b[1m 11 \u001b[0m\u001b[1m 25 \u001b[0m\u001b[1m 23 \u001b[0m\u001b[1m 26 \u001b[0m\u001b[1m 24 \u001b[0m\n",
"\u001b[1m \u001b[0m│\u001b[90m Int64 \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m String \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\n",
"─────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────\n",
" 1 │ 4 3 7 11 7 2 1 5 2 4 3 6 3 2 1 5 5 8 21 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 2 │ 2 2 5 4 3 \u001b[90m missing \u001b[0m 2 7 5 3 8 4 1 4 3 12 4 \u001b[90m missing \u001b[0m 12 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 3 │ 3 1 4 4 1 3 \u001b[90m missing \u001b[0m 4 6 2 4 1 \u001b[90m missing \u001b[0m 2 4 10 \u001b[90m missing \u001b[0m 1 8 3 \u001b[90m missing \u001b[0m 1 3 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 4 │ 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 7 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 26 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 5 │ 1 1 2 3 2 \u001b[90m missing \u001b[0m 2 3 2 1 \u001b[90m missing \u001b[0m 1 4 1 2 3 3 2 3 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\n",
" 6 │ 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 3 12 \u001b[90m missing \u001b[0m 8 3 25 7 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 8\n",
" 7 │ 4 1 4 5 1 \u001b[90m missing \u001b[0m 2 1 3 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 1 1 6 5 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 6 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 8 │ 1 4 7 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 2 2 \u001b[90m missing \u001b[0m 11 \u001b[90m missing \u001b[0m 1 6 8 6 1 \u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 1 2 1 1 \u001b[90m missing \u001b[0m 6 \u001b[90m missing \u001b[0m 5\n",
" 9 │ 4 1 1 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 3 2 \u001b[90m missing \u001b[0m 3 2 24 2 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 10 │ 1 4 3 3 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 4 \u001b[90m missing \u001b[0m 2 2 4 9 9 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 3 2 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 2 \u001b[90m missing \u001b[0m 1\n",
" 11 │ 3 6 4 4 3 1 \u001b[90m missing \u001b[0m 5 8 2 \u001b[90m missing \u001b[0m 6 \u001b[90m missing \u001b[0m 5 5 17 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 1 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" ⋮ │ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮\n",
" 17 │ 0 1 1 5 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 1 6 1 1 1 18 1 1 \u001b[90m missing \u001b[0m 3 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 18 │ 1 1 12 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 2 1 \u001b[90m missing \u001b[0m 1 1 2 3 3 13 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 1 1 1 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 19 │ 0 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 7 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 3 14 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 20 │ 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 5 21 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 7 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1\n",
" 21 │ 2 1 3 \u001b[90m missing \u001b[0m 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 3 2 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 19 1 2 \u001b[90m missing \u001b[0m 1 5 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 22 │ 1 \u001b[90m missing \u001b[0m 9 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 1 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 15 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 23 │ 0 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 11 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 9 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 24 │ 1 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 1 2 \u001b[90m missing \u001b[0m 1 2 1 20 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 25 │ 0 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 16 1 \u001b[90m missing \u001b[0m 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 26 │ 0 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 22 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
"\u001b[31m 5 rows omitted\u001b[0m"
]
},
"execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"First note that we have used `cols=:union` in the `push!` command when piping the JSON data into `df` data frame. If we do this then by default:\n",
"* new columns are automatically added (i.e. if the next JSON contains the column that was not present in the data frame already it will be added and previously existing rows are filled with `missing` for this column), you see this case e.g. in column with name `\"26\"` (last column of `df`)\n",
"* if some JSON does not have some column then again it is not a problem, simply `missing` will be put in respective column in the corresponding row, you see this case e.g. in column with name `\"17\"` in row 4\n",
"* columns automatically get promoted to an appropriate type (in this case columns containing missing values were promoted in this way)\n",
"\n",
"So as you can see with `push!` you can add data to a data frame without knowing its schema upfront. The same functionality is provided by `append!` and `vcat`."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We note that the order of columns of our data frame is not very nice. This is due to the fact that JSON3 does not give guarantees on ordering of columns. Fortunately this is easily fixed:"
]
},
{
"cell_type": "code",
"execution_count": 8,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<table class=\"data-frame\"><thead><tr><th></th><th>id</th><th>breeding</th><th>1</th><th>2</th><th>3</th><th>4</th><th>5</th><th>6</th><th>7</th><th>8</th><th>9</th><th>10</th><th>11</th><th>12</th><th>13</th><th>14</th><th>15</th><th>16</th><th>17</th><th>18</th><th>19</th><th>20</th><th>21</th><th>22</th><th>23</th><th>24</th><th>25</th><th>26</th></tr><tr><th></th><th>String</th><th>Int64</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th><th>Int64?</th></tr></thead><tbody><p>26 rows × 28 columns</p><tr><th>1</th><td>1</td><td>4</td><td><em>missing</em></td><td>2</td><td>8</td><td>5</td><td>21</td><td>6</td><td>7</td><td>11</td><td>3</td><td>5</td><td><em>missing</em></td><td>1</td><td>2</td><td>3</td><td>1</td><td><em>missing</em></td><td>3</td><td>5</td><td>2</td><td>7</td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>2</th><td>3</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>4</td><td>12</td><td>4</td><td>3</td><td>4</td><td>8</td><td>12</td><td><em>missing</em></td><td>2</td><td>5</td><td>1</td><td><em>missing</em></td><td>1</td><td>2</td><td>7</td><td>4</td><td>5</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>3</th><td>4</td><td>3</td><td>1</td><td>3</td><td>1</td><td><em>missing</em></td><td>8</td><td>1</td><td>1</td><td>4</td><td>4</td><td>10</td><td>1</td><td><em>missing</em></td><td>6</td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>1</td><td>4</td><td>2</td><td>4</td><td>2</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>4</th><td>26</td><td>1</td><td><em>missing</em></td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td></tr><tr><th>5</th><td>2</td><td>1</td><td>1</td><td><em>missing</em></td><td>2</td><td>3</td><td>3</td><td>1</td><td>2</td><td>3</td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>2</td><td>2</td><td>4</td><td>1</td><td><em>missing</em></td><td>1</td><td>3</td><td>1</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td></tr><tr><th>6</th><td>25</td><td>3</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>12</td><td>7</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>8</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>1</td><td>8</td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>7</th><td>6</td><td>4</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>6</td><td><em>missing</em></td><td>1</td><td>5</td><td>2</td><td>5</td><td><em>missing</em></td><td>2</td><td>3</td><td>1</td><td>1</td><td><em>missing</em></td><td>1</td><td>1</td><td>1</td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>8</th><td>8</td><td>1</td><td>2</td><td>1</td><td><em>missing</em></td><td>1</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>11</td><td>6</td><td>1</td><td><em>missing</em></td><td>2</td><td>1</td><td><em>missing</em></td><td>1</td><td>4</td><td>2</td><td>6</td><td>7</td><td><em>missing</em></td><td>1</td><td>6</td><td>5</td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>9</th><td>24</td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>2</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>3</td><td>2</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>2</td><td>1</td><td>3</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>10</th><td>9</td><td>1</td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>2</td><td>1</td><td>3</td><td><em>missing</em></td><td>9</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>3</td><td>2</td><td>4</td><td><em>missing</em></td><td>4</td><td>3</td><td>4</td><td><em>missing</em></td><td>2</td><td>1</td><td>1</td><td><em>missing</em></td></tr><tr><th>11</th><td>5</td><td>3</td><td>1</td><td>1</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>6</td><td>3</td><td>4</td><td><em>missing</em></td><td>17</td><td>1</td><td><em>missing</em></td><td>8</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>6</td><td>5</td><td>5</td><td>4</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>12</th><td>23</td><td>3</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>5</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>1</td><td>1</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td><em>missing</em></td></tr><tr><th>13</th><td>10</td><td>0</td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>1</td><td>1</td><td>6</td><td>2</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>4</td><td>7</td><td>5</td><td>2</td><td>3</td><td>4</td><td>4</td><td>7</td><td>6</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>14</th><td>7</td><td>1</td><td>3</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>2</td><td>3</td><td>1</td><td>1</td><td>1</td><td>2</td><td>1</td><td>4</td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>15</th><td>12</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>4</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>16</th><td>17</td><td>0</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>1</td><td>2</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>8</td><td>3</td><td>1</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>17</th><td>18</td><td>0</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>3</td><td>1</td><td>1</td><td>5</td><td>6</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>1</td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>1</td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>18</th><td>13</td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>2</td><td>1</td><td><em>missing</em></td><td>1</td><td>2</td><td>1</td><td>2</td><td><em>missing</em></td><td>3</td><td>1</td><td>1</td><td>1</td><td>1</td><td>3</td><td>12</td><td>1</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>19</th><td>14</td><td>0</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>4</td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>7</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>20</th><td>21</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>2</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>5</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>7</td><td><em>missing</em></td></tr><tr><th>21</th><td>19</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td>1</td><td><em>missing</em></td><td>4</td><td><em>missing</em></td><td>2</td><td>1</td><td>1</td><td><em>missing</em></td><td>1</td><td>1</td><td>5</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>3</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>22</th><td>15</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>9</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>23</th><td>11</td><td>0</td><td><em>missing</em></td><td>1</td><td>2</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>4</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>9</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>24</th><td>20</td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td>1</td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>3</td><td>1</td><td>2</td><td>1</td><td><em>missing</em></td><td>3</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>2</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>25</th><td>16</td><td>0</td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>1</td><td>2</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr><tr><th>26</th><td>22</td><td>0</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td>1</td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td><td><em>missing</em></td></tr></tbody></table>"
],
"text/latex": [
"\\begin{tabular}{r|cccccccccccccccccccccccccccc}\n",
"\t& id & breeding & 1 & 2 & 3 & 4 & 5 & 6 & 7 & 8 & 9 & 10 & 11 & 12 & 13 & 14 & 15 & 16 & 17 & 18 & 19 & 20 & 21 & 22 & 23 & 24 & 25 & 26\\\\\n",
"\t\\hline\n",
"\t& String & Int64 & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64? & Int64?\\\\\n",
"\t\\hline\n",
"\t1 & 1 & 4 & \\emph{missing} & 2 & 8 & 5 & 21 & 6 & 7 & 11 & 3 & 5 & \\emph{missing} & 1 & 2 & 3 & 1 & \\emph{missing} & 3 & 5 & 2 & 7 & 4 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t2 & 3 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 4 & 12 & 4 & 3 & 4 & 8 & 12 & \\emph{missing} & 2 & 5 & 1 & \\emph{missing} & 1 & 2 & 7 & 4 & 5 & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t3 & 4 & 3 & 1 & 3 & 1 & \\emph{missing} & 8 & 1 & 1 & 4 & 4 & 10 & 1 & \\emph{missing} & 6 & \\emph{missing} & 3 & \\emph{missing} & 1 & 4 & 2 & 4 & 2 & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t4 & 26 & 1 & \\emph{missing} & 7 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 1 & \\emph{missing} & 2 & \\emph{missing} & 1 & \\emph{missing} \\\\\n",
"\t5 & 2 & 1 & 1 & \\emph{missing} & 2 & 3 & 3 & 1 & 2 & 3 & \\emph{missing} & 3 & \\emph{missing} & 2 & 2 & 4 & 1 & \\emph{missing} & 1 & 3 & 1 & 2 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 \\\\\n",
"\t6 & 25 & 3 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 12 & 7 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 8 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & \\emph{missing} & 3 & \\emph{missing} & 1 & 8 & \\emph{missing} & \\emph{missing} \\\\\n",
"\t7 & 6 & 4 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 6 & \\emph{missing} & 1 & 5 & 2 & 5 & \\emph{missing} & 2 & 3 & 1 & 1 & \\emph{missing} & 1 & 1 & 1 & 4 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t8 & 8 & 1 & 2 & 1 & \\emph{missing} & 1 & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 11 & 6 & 1 & \\emph{missing} & 2 & 1 & \\emph{missing} & 1 & 4 & 2 & 6 & 7 & \\emph{missing} & 1 & 6 & 5 & \\emph{missing} & \\emph{missing} \\\\\n",
"\t9 & 24 & 4 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & 2 & 2 & \\emph{missing} & \\emph{missing} & 1 & 3 & 2 & \\emph{missing} & 1 & \\emph{missing} & 2 & 1 & 3 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t10 & 9 & 1 & 4 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 2 & 1 & 3 & \\emph{missing} & 9 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & 3 & 2 & 4 & \\emph{missing} & 4 & 3 & 4 & \\emph{missing} & 2 & 1 & 1 & \\emph{missing} \\\\\n",
"\t11 & 5 & 3 & 1 & 1 & 2 & \\emph{missing} & \\emph{missing} & 6 & 3 & 4 & \\emph{missing} & 17 & 1 & \\emph{missing} & 8 & \\emph{missing} & 2 & \\emph{missing} & 6 & 5 & 5 & 4 & 2 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t12 & 23 & 3 & 2 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 2 & 1 & \\emph{missing} & \\emph{missing} & 5 & 3 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 1 & 1 & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & \\emph{missing} \\\\\n",
"\t13 & 10 & 0 & 1 & \\emph{missing} & 1 & \\emph{missing} & 1 & 1 & 6 & 2 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 4 & 7 & 5 & 2 & 3 & 4 & 4 & 7 & 6 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} \\\\\n",
"\t14 & 7 & 1 & 3 & \\emph{missing} & 2 & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & 2 & 3 & 1 & 1 & 1 & 2 & 1 & 4 & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t15 & 12 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 4 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t16 & 17 & 0 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & 1 & 2 & 2 & 1 & \\emph{missing} & \\emph{missing} & 2 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 8 & 3 & 1 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t17 & 18 & 0 & 1 & \\emph{missing} & \\emph{missing} & 1 & 3 & 1 & 1 & 5 & 6 & 1 & \\emph{missing} & \\emph{missing} & 1 & 1 & 1 & \\emph{missing} & 1 & \\emph{missing} & 1 & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t18 & 13 & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & 2 & 1 & \\emph{missing} & 1 & 2 & 1 & 2 & \\emph{missing} & 3 & 1 & 1 & 1 & 1 & 3 & 12 & 1 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t19 & 14 & 0 & 1 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 4 & \\emph{missing} & 3 & \\emph{missing} & 7 & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t20 & 21 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & 2 & 1 & \\emph{missing} & \\emph{missing} & 1 & 2 & 1 & \\emph{missing} & \\emph{missing} & 5 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 7 & \\emph{missing} \\\\\n",
"\t21 & 19 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & 2 & 1 & \\emph{missing} & 4 & \\emph{missing} & 2 & 1 & 1 & \\emph{missing} & 1 & 1 & 5 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & 3 & 3 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t22 & 15 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & 2 & \\emph{missing} & 1 & \\emph{missing} & 9 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t23 & 11 & 0 & \\emph{missing} & 1 & 2 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 4 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 9 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t24 & 20 & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & 1 & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 3 & 1 & 2 & 1 & \\emph{missing} & 3 & \\emph{missing} & 1 & \\emph{missing} & 2 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t25 & 16 & 0 & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & 1 & 2 & \\emph{missing} & 1 & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\t26 & 22 & 0 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & 1 & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} & \\emph{missing} \\\\\n",
"\\end{tabular}\n"
],
"text/plain": [
"\u001b[1m26×28 DataFrame\u001b[0m\n",
"\u001b[1m Row \u001b[0m│\u001b[1m id \u001b[0m\u001b[1m breeding \u001b[0m\u001b[1m 1 \u001b[0m\u001b[1m 2 \u001b[0m\u001b[1m 3 \u001b[0m\u001b[1m 4 \u001b[0m\u001b[1m 5 \u001b[0m\u001b[1m 6 \u001b[0m\u001b[1m 7 \u001b[0m\u001b[1m 8 \u001b[0m\u001b[1m 9 \u001b[0m\u001b[1m 10 \u001b[0m\u001b[1m 11 \u001b[0m\u001b[1m 12 \u001b[0m\u001b[1m 13 \u001b[0m\u001b[1m 14 \u001b[0m\u001b[1m 15 \u001b[0m\u001b[1m 16 \u001b[0m\u001b[1m 17 \u001b[0m\u001b[1m 18 \u001b[0m\u001b[1m 19 \u001b[0m\u001b[1m 20 \u001b[0m\u001b[1m 21 \u001b[0m\u001b[1m 22 \u001b[0m\u001b[1m 23 \u001b[0m\u001b[1m 24 \u001b[0m\u001b[1m 25 \u001b[0m\u001b[1m 26 \u001b[0m\n",
"\u001b[1m \u001b[0m│\u001b[90m String \u001b[0m\u001b[90m Int64 \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\u001b[90m Int64? \u001b[0m\n",
"─────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────────\n",
" 1 │ 1 4 \u001b[90m missing \u001b[0m 2 8 5 21 6 7 11 3 5 \u001b[90m missing \u001b[0m 1 2 3 1 \u001b[90m missing \u001b[0m 3 5 2 7 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 2 │ 3 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 4 12 4 3 4 8 12 \u001b[90m missing \u001b[0m 2 5 1 \u001b[90m missing \u001b[0m 1 2 7 4 5 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 3 │ 4 3 1 3 1 \u001b[90m missing \u001b[0m 8 1 1 4 4 10 1 \u001b[90m missing \u001b[0m 6 \u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 1 4 2 4 2 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 4 │ 26 1 \u001b[90m missing \u001b[0m 7 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\n",
" 5 │ 2 1 1 \u001b[90m missing \u001b[0m 2 3 3 1 2 3 \u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 2 2 4 1 \u001b[90m missing \u001b[0m 1 3 1 2 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1\n",
" 6 │ 25 3 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 12 7 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 8 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 1 8 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 7 │ 6 4 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 6 \u001b[90m missing \u001b[0m 1 5 2 5 \u001b[90m missing \u001b[0m 2 3 1 1 \u001b[90m missing \u001b[0m 1 1 1 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 8 │ 8 1 2 1 \u001b[90m missing \u001b[0m 1 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 11 6 1 \u001b[90m missing \u001b[0m 2 1 \u001b[90m missing \u001b[0m 1 4 2 6 7 \u001b[90m missing \u001b[0m 1 6 5 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 9 │ 24 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 2 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 3 2 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 2 1 3 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 10 │ 9 1 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 2 1 3 \u001b[90m missing \u001b[0m 9 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 3 2 4 \u001b[90m missing \u001b[0m 4 3 4 \u001b[90m missing \u001b[0m 2 1 1 \u001b[90m missing \u001b[0m\n",
" 11 │ 5 3 1 1 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 6 3 4 \u001b[90m missing \u001b[0m 17 1 \u001b[90m missing \u001b[0m 8 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 6 5 5 4 2 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" ⋮ │ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮ ⋮\n",
" 17 │ 18 0 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 3 1 1 5 6 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 1 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 1 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 18 │ 13 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 2 1 \u001b[90m missing \u001b[0m 1 2 1 2 \u001b[90m missing \u001b[0m 3 1 1 1 1 3 12 1 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 19 │ 14 0 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 4 \u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 7 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 20 │ 21 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 2 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 5 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 7 \u001b[90m missing \u001b[0m\n",
" 21 │ 19 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 1 \u001b[90m missing \u001b[0m 4 \u001b[90m missing \u001b[0m 2 1 1 \u001b[90m missing \u001b[0m 1 1 5 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 3 3 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 22 │ 15 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 9 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 23 │ 11 0 \u001b[90m missing \u001b[0m 1 2 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 4 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 9 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 24 │ 20 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 1 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 3 1 2 1 \u001b[90m missing \u001b[0m 3 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 2 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 25 │ 16 0 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 1 2 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
" 26 │ 22 0 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m 1 \u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\u001b[90m missing \u001b[0m\n",
"\u001b[31m 5 rows omitted\u001b[0m"
]
},
"execution_count": 8,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"select!(df, :id, :breeding, sort(names(df, r\"\\d\"), by=x -> parse(Int, x)))"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Again, note how expressive DataFrames.jl release 0.21 is. With `names(df, r\"\\d\")` we selected all column names that contain a digit as strings, and then we have sorted them using their numeric value.\n",
"\n",
"The same selection could have been written as `names(df, Not([:id, :breeding]))`. If we wanted to be more cautious with our regex we could have written `names(df, r\"^\\d+$\")`. In this case all variants we described give exactly the same result."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Before we move forward let me highlight that it is very easy to access the columns with non-standard names (like strings consisting of numbers) in the following way:"
]
},
{
"cell_type": "code",
"execution_count": 9,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"26-element Array{Union{Missing, Int64},1}:\n",
" missing\n",
" missing\n",
" 1\n",
" missing\n",
" 1\n",
" 2\n",
" 1\n",
" 2\n",
" missing\n",
" 4\n",
" 1\n",
" 2\n",
" 1\n",
" 3\n",
" missing\n",
" 1\n",
" 1\n",
" 1\n",
" 1\n",
" missing\n",
" missing\n",
" missing\n",
" missing\n",
" missing\n",
" missing\n",
" missing"
]
},
"execution_count": 9,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df.\"1\""
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"or e.g.:"
]
},
{
"cell_type": "code",
"execution_count": 10,
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
"26-element Array{Union{Missing, Int64},1}:\n",
" missing\n",
" missing\n",
" 1\n",
" missing\n",
" 1\n",
" 2\n",
" 1\n",
" 2\n",
" missing\n",
" 4\n",
" 1\n",
" 2\n",
" 1\n",
" 3\n",
" missing\n",
" 1\n",
" 1\n",
" 1\n",
" 1\n",
" missing\n",
" missing\n",
" missing\n",
" missing\n",
" missing\n",
" missing\n",
" missing"
]
},
"execution_count": 10,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df[:, \"1\"]"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Now for each bison let us calculate an aggregate of domination values:"
]
},
{
"cell_type": "code",
"execution_count": 11,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<table class=\"data-frame\"><thead><tr><th></th><th>breeding</th><th>score</th></tr><tr><th></th><th>Int64</th><th>Int64</th></tr></thead><tbody><p>26 rows × 2 columns</p><tr><th>1</th><td>4</td><td>96</td></tr><tr><th>2</th><td>2</td><td>77</td></tr><tr><th>3</th><td>3</td><td>59</td></tr><tr><th>4</th><td>1</td><td>15</td></tr><tr><th>5</th><td>1</td><td>36</td></tr><tr><th>6</th><td>3</td><td>46</td></tr><tr><th>7</th><td>4</td><td>34</td></tr><tr><th>8</th><td>1</td><td>60</td></tr><tr><th>9</th><td>4</td><td>21</td></tr><tr><th>10</th><td>1</td><td>46</td></tr><tr><th>11</th><td>3</td><td>68</td></tr><tr><th>12</th><td>3</td><td>24</td></tr><tr><th>13</th><td>0</td><td>57</td></tr><tr><th>14</th><td>1</td><td>28</td></tr><tr><th>15</th><td>2</td><td>15</td></tr><tr><th>16</th><td>0</td><td>27</td></tr><tr><th>17</th><td>0</td><td>26</td></tr><tr><th>18</th><td>1</td><td>36</td></tr><tr><th>19</th><td>0</td><td>21</td></tr><tr><th>20</th><td>1</td><td>21</td></tr><tr><th>21</th><td>2</td><td>25</td></tr><tr><th>22</th><td>1</td><td>16</td></tr><tr><th>23</th><td>0</td><td>18</td></tr><tr><th>24</th><td>1</td><td>17</td></tr><tr><th>25</th><td>0</td><td>7</td></tr><tr><th>26</th><td>0</td><td>1</td></tr></tbody></table>"
],
"text/latex": [
"\\begin{tabular}{r|cc}\n",
"\t& breeding & score\\\\\n",
"\t\\hline\n",
"\t& Int64 & Int64\\\\\n",
"\t\\hline\n",
"\t1 & 4 & 96 \\\\\n",
"\t2 & 2 & 77 \\\\\n",
"\t3 & 3 & 59 \\\\\n",
"\t4 & 1 & 15 \\\\\n",
"\t5 & 1 & 36 \\\\\n",
"\t6 & 3 & 46 \\\\\n",
"\t7 & 4 & 34 \\\\\n",
"\t8 & 1 & 60 \\\\\n",
"\t9 & 4 & 21 \\\\\n",
"\t10 & 1 & 46 \\\\\n",
"\t11 & 3 & 68 \\\\\n",
"\t12 & 3 & 24 \\\\\n",
"\t13 & 0 & 57 \\\\\n",
"\t14 & 1 & 28 \\\\\n",
"\t15 & 2 & 15 \\\\\n",
"\t16 & 0 & 27 \\\\\n",
"\t17 & 0 & 26 \\\\\n",
"\t18 & 1 & 36 \\\\\n",
"\t19 & 0 & 21 \\\\\n",
"\t20 & 1 & 21 \\\\\n",
"\t21 & 2 & 25 \\\\\n",
"\t22 & 1 & 16 \\\\\n",
"\t23 & 0 & 18 \\\\\n",
"\t24 & 1 & 17 \\\\\n",
"\t25 & 0 & 7 \\\\\n",
"\t26 & 0 & 1 \\\\\n",
"\\end{tabular}\n"
],
"text/plain": [
"\u001b[1m26×2 DataFrame\u001b[0m\n",
"\u001b[1m Row \u001b[0m│\u001b[1m breeding \u001b[0m\u001b[1m score \u001b[0m\n",
"\u001b[1m \u001b[0m│\u001b[90m Int64 \u001b[0m\u001b[90m Int64 \u001b[0m\n",
"─────┼─────────────────\n",
" 1 │ 4 96\n",
" 2 │ 2 77\n",
" 3 │ 3 59\n",
" 4 │ 1 15\n",
" 5 │ 1 36\n",
" 6 │ 3 46\n",
" 7 │ 4 34\n",
" 8 │ 1 60\n",
" 9 │ 4 21\n",
" 10 │ 1 46\n",
" 11 │ 3 68\n",
" ⋮ │ ⋮ ⋮\n",
" 17 │ 0 26\n",
" 18 │ 1 36\n",
" 19 │ 0 21\n",
" 20 │ 1 21\n",
" 21 │ 2 25\n",
" 22 │ 1 16\n",
" 23 │ 0 18\n",
" 24 │ 1 17\n",
" 25 │ 0 7\n",
" 26 │ 0 1\n",
"\u001b[31m 5 rows omitted\u001b[0m"
]
},
"execution_count": 11,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"df2 = select(df, :breeding, AsTable(r\"\\d\") => ByRow(sum∘skipmissing) => :score)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"an equivalent way to achieve this would be to replace `missing` with `0` using `coalesce` on `df` and then just use `+` on whole columns:"
]
},
{
"cell_type": "code",
"execution_count": 12,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<table class=\"data-frame\"><thead><tr><th></th><th>breeding</th><th>score</th></tr><tr><th></th><th>Int64</th><th>Int64</th></tr></thead><tbody><p>26 rows × 2 columns</p><tr><th>1</th><td>4</td><td>96</td></tr><tr><th>2</th><td>2</td><td>77</td></tr><tr><th>3</th><td>3</td><td>59</td></tr><tr><th>4</th><td>1</td><td>15</td></tr><tr><th>5</th><td>1</td><td>36</td></tr><tr><th>6</th><td>3</td><td>46</td></tr><tr><th>7</th><td>4</td><td>34</td></tr><tr><th>8</th><td>1</td><td>60</td></tr><tr><th>9</th><td>4</td><td>21</td></tr><tr><th>10</th><td>1</td><td>46</td></tr><tr><th>11</th><td>3</td><td>68</td></tr><tr><th>12</th><td>3</td><td>24</td></tr><tr><th>13</th><td>0</td><td>57</td></tr><tr><th>14</th><td>1</td><td>28</td></tr><tr><th>15</th><td>2</td><td>15</td></tr><tr><th>16</th><td>0</td><td>27</td></tr><tr><th>17</th><td>0</td><td>26</td></tr><tr><th>18</th><td>1</td><td>36</td></tr><tr><th>19</th><td>0</td><td>21</td></tr><tr><th>20</th><td>1</td><td>21</td></tr><tr><th>21</th><td>2</td><td>25</td></tr><tr><th>22</th><td>1</td><td>16</td></tr><tr><th>23</th><td>0</td><td>18</td></tr><tr><th>24</th><td>1</td><td>17</td></tr><tr><th>25</th><td>0</td><td>7</td></tr><tr><th>26</th><td>0</td><td>1</td></tr></tbody></table>"
],
"text/latex": [
"\\begin{tabular}{r|cc}\n",
"\t& breeding & score\\\\\n",
"\t\\hline\n",
"\t& Int64 & Int64\\\\\n",
"\t\\hline\n",
"\t1 & 4 & 96 \\\\\n",
"\t2 & 2 & 77 \\\\\n",
"\t3 & 3 & 59 \\\\\n",
"\t4 & 1 & 15 \\\\\n",
"\t5 & 1 & 36 \\\\\n",
"\t6 & 3 & 46 \\\\\n",
"\t7 & 4 & 34 \\\\\n",
"\t8 & 1 & 60 \\\\\n",
"\t9 & 4 & 21 \\\\\n",
"\t10 & 1 & 46 \\\\\n",
"\t11 & 3 & 68 \\\\\n",
"\t12 & 3 & 24 \\\\\n",
"\t13 & 0 & 57 \\\\\n",
"\t14 & 1 & 28 \\\\\n",
"\t15 & 2 & 15 \\\\\n",
"\t16 & 0 & 27 \\\\\n",
"\t17 & 0 & 26 \\\\\n",
"\t18 & 1 & 36 \\\\\n",
"\t19 & 0 & 21 \\\\\n",
"\t20 & 1 & 21 \\\\\n",
"\t21 & 2 & 25 \\\\\n",
"\t22 & 1 & 16 \\\\\n",
"\t23 & 0 & 18 \\\\\n",
"\t24 & 1 & 17 \\\\\n",
"\t25 & 0 & 7 \\\\\n",
"\t26 & 0 & 1 \\\\\n",
"\\end{tabular}\n"
],
"text/plain": [
"\u001b[1m26×2 DataFrame\u001b[0m\n",
"\u001b[1m Row \u001b[0m│\u001b[1m breeding \u001b[0m\u001b[1m score \u001b[0m\n",
"\u001b[1m \u001b[0m│\u001b[90m Int64 \u001b[0m\u001b[90m Int64 \u001b[0m\n",
"─────┼─────────────────\n",
" 1 │ 4 96\n",
" 2 │ 2 77\n",
" 3 │ 3 59\n",
" 4 │ 1 15\n",
" 5 │ 1 36\n",
" 6 │ 3 46\n",
" 7 │ 4 34\n",
" 8 │ 1 60\n",
" 9 │ 4 21\n",
" 10 │ 1 46\n",
" 11 │ 3 68\n",
" ⋮ │ ⋮ ⋮\n",
" 17 │ 0 26\n",
" 18 │ 1 36\n",
" 19 │ 0 21\n",
" 20 │ 1 21\n",
" 21 │ 2 25\n",
" 22 │ 1 16\n",
" 23 │ 0 18\n",
" 24 │ 1 17\n",
" 25 │ 0 7\n",
" 26 │ 0 1\n",
"\u001b[31m 5 rows omitted\u001b[0m"
]
},
"execution_count": 12,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"select(coalesce.(df, 0), :breeding, r\"\\d\" => (+) => :score)"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"We finish by aggregating `:score` column by `:breeding` column:"
]
},
{
"cell_type": "code",
"execution_count": 13,
"metadata": {},
"outputs": [
{
"data": {
"text/html": [
"<table class=\"data-frame\"><thead><tr><th></th><th>breeding</th><th>score_mean</th><th>score_std</th><th>score_minimum</th><th>score_median</th><th>score_maximum</th></tr><tr><th></th><th>Int64</th><th>Float64</th><th>Float64</th><th>Int64</th><th>Float64</th><th>Int64</th></tr></thead><tbody><p>5 rows × 6 columns</p><tr><th>1</th><td>0</td><td>22.4286</td><td>18.0172</td><td>1</td><td>21.0</td><td>57</td></tr><tr><th>2</th><td>1</td><td>30.5556</td><td>15.4119</td><td>15</td><td>28.0</td><td>60</td></tr><tr><th>3</th><td>2</td><td>39.0</td><td>33.2866</td><td>15</td><td>25.0</td><td>77</td></tr><tr><th>4</th><td>3</td><td>49.25</td><td>19.1028</td><td>24</td><td>52.5</td><td>68</td></tr><tr><th>5</th><td>4</td><td>50.3333</td><td>40.0791</td><td>21</td><td>34.0</td><td>96</td></tr></tbody></table>"
],
"text/latex": [
"\\begin{tabular}{r|cccccc}\n",
"\t& breeding & score\\_mean & score\\_std & score\\_minimum & score\\_median & score\\_maximum\\\\\n",
"\t\\hline\n",
"\t& Int64 & Float64 & Float64 & Int64 & Float64 & Int64\\\\\n",
"\t\\hline\n",
"\t1 & 0 & 22.4286 & 18.0172 & 1 & 21.0 & 57 \\\\\n",
"\t2 & 1 & 30.5556 & 15.4119 & 15 & 28.0 & 60 \\\\\n",
"\t3 & 2 & 39.0 & 33.2866 & 15 & 25.0 & 77 \\\\\n",
"\t4 & 3 & 49.25 & 19.1028 & 24 & 52.5 & 68 \\\\\n",
"\t5 & 4 & 50.3333 & 40.0791 & 21 & 34.0 & 96 \\\\\n",
"\\end{tabular}\n"
],
"text/plain": [
"\u001b[1m5×6 DataFrame\u001b[0m\n",
"\u001b[1m Row \u001b[0m│\u001b[1m breeding \u001b[0m\u001b[1m score_mean \u001b[0m\u001b[1m score_std \u001b[0m\u001b[1m score_minimum \u001b[0m\u001b[1m score_median \u001b[0m\u001b[1m score_maximum \u001b[0m\n",
"\u001b[1m \u001b[0m│\u001b[90m Int64 \u001b[0m\u001b[90m Float64 \u001b[0m\u001b[90m Float64 \u001b[0m\u001b[90m Int64 \u001b[0m\u001b[90m Float64 \u001b[0m\u001b[90m Int64 \u001b[0m\n",
"─────┼─────────────────────────────────────────────────────────────────────────────\n",
" 1 │ 0 22.4286 18.0172 1 21.0 57\n",
" 2 │ 1 30.5556 15.4119 15 28.0 60\n",
" 3 │ 2 39.0 33.2866 15 25.0 77\n",
" 4 │ 3 49.25 19.1028 24 52.5 68\n",
" 5 │ 4 50.3333 40.0791 21 34.0 96"
]
},
"execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
],
"source": [
"combine(groupby(df2, :breeding, sort=true), :score .=> [mean, std, minimum, median, maximum])"
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Note that it is very easy to apply multiple transformations at the same time using broadcasting."
]
},
{
"cell_type": "markdown",
"metadata": {},
"source": [
"Looking at the data indeed it seems that `:breeding` and `:score` are positively correlated."
]
}
],
"metadata": {
"kernelspec": {
"display_name": "Julia 1.5.3",
"language": "julia",
"name": "julia-1.5"
},
"language_info": {
"file_extension": ".jl",
"mimetype": "application/julia",
"name": "julia",
"version": "1.5.3"
}
},
"nbformat": 4,
"nbformat_minor": 4
}
Raw
bison.json
{"id":"1", "3":8, "4":5, "2":2, "6":6, "8":11, "9":3, "5":21, "10":5, "7":7, "12":1, "17":3, "18":5, "13":2, "14":3, "21":4, "19":2, "15":1, "20":7, "breeding":4}
{"id":"3", "4":4, "6":4, "8":4, "9":8, "5":12, "10":12, "7":3, "12":2, "17":2, "18":7, "13":5, "14":1, "21":3, "19":4, "20":5, "16":1, "breeding":2}
{"id":"4", "1":1, "3":1, "2":3, "6":1, "8":4, "9":4, "5":8, "10":10, "7":1, "17":1, "18":4, "13":6, "21":2, "19":2, "15":3, "11":1, "20":4, "22":3, "breeding":3}
{"id":"26", "2":7, "25":1, "23":2, "10":3, "21":1, "19":1, "breeding":1}
{"id":"2", "1":1, "3":2, "4":3, "26":1, "6":1, "8":3, "5":3, "10":3, "7":2, "12":2, "17":1, "18":3, "13":2, "14":4, "21":1, "19":1, "15":1, "20":2, "breeding":1}
{"id":"25", "1":2, "24":8, "9":12, "23":1, "10":7, "14":8, "21":3, "19":3, "15":2, "breeding":3}
{"id":"6", "1":1, "8":5, "9":2, "5":6, "10":5, "7":1, "12":2, "17":1, "18":1, "13":3, "14":1, "19":1, "15":1, "20":4, "breeding":4}
{"id":"8", "1":2, "4":1, "2":1, "24":5, "9":11, "5":3, "23":6, "10":6, "17":4, "18":2, "13":2, "14":1, "19":6, "11":1, "20":7, "16":1, "22":1, "breeding":1}
{"id":"24", "4":1, "8":2, "9":2, "23":1, "10":2, "17":1, "13":1, "14":3, "21":3, "19":2, "15":2, "20":1, "breeding":4}
{"id":"9", "1":4, "4":1, "25":1, "6":2, "8":3, "24":1, "23":2, "10":9, "7":1, "17":4, "14":2, "21":4, "19":4, "15":3, "20":3, "16":2, "breeding":1}
{"id":"5", "1":1, "3":2, "2":1, "6":6, "8":4, "10":17, "7":3, "17":6, "18":5, "13":8, "21":2, "19":5, "15":2, "11":1, "20":4, "22":1, "breeding":3}
{"id":"23", "1":2, "2":1, "25":3, "8":1, "9":2, "10":1, "17":1, "13":5, "14":3, "21":3, "19":1, "20":1, "breeding":3}
{"id":"10", "1":1, "3":1, "6":1, "8":2, "24":1, "9":2, "5":1, "7":6, "17":3, "18":4, "13":4, "14":7, "21":6, "19":4, "15":5, "20":7, "16":2, "breeding":0}
{"id":"7", "1":3, "3":2, "8":1, "5":2, "12":3, "17":1, "18":2, "13":2, "14":3, "21":1, "19":1, "15":1, "20":4, "16":1, "22":1, "breeding":1}
{"id":"12", "4":1, "6":2, "10":3, "18":1, "13":2, "21":2, "20":4, "breeding":2}
{"id":"17", "1":1, "8":2, "9":2, "5":2, "10":1, "7":1, "18":8, "13":2, "14":2, "21":2, "19":3, "20":1, "breeding":0}
{"id":"18", "1":1, "4":1, "6":1, "8":5, "9":6, "5":3, "10":1, "7":1, "17":1, "13":1, "14":1, "21":1, "19":1, "15":1, "20":1, "breeding":0}
{"id":"13", "1":1, "6":2, "9":1, "5":2, "10":2, "7":1, "12":2, "17":1, "18":1, "14":3, "21":1, "19":3, "15":1, "11":1, "20":12, "16":1, "22":1, "breeding":1}
{"id":"14", "1":1, "4":1, "23":2, "10":1, "12":1, "17":4, "21":7, "19":3, "16":1, "breeding":0}
{"id":"21", "25":7, "24":1, "10":2, "7":1, "14":1, "19":5, "15":2, "11":1, "16":1, "breeding":1}
{"id":"19", "4":2, "9":2, "5":1, "10":1, "7":4, "17":1, "13":1, "14":1, "21":3, "15":5, "11":1, "20":3, "breeding":2}
{"id":"15", "10":1, "18":1, "13":1, "21":2, "20":9, "16":2, "breeding":1}
{"id":"11", "3":2, "2":1, "5":1, "13":4, "16":1, "22":9, "breeding":0}
{"id":"20", "6":1, "5":1, "7":2, "12":3, "17":3, "13":1, "14":2, "21":2, "19":1, "15":1, "breeding":1}
{"id":"16", "3":1, "6":2, "8":1, "5":1, "10":1, "18":1, "breeding":0}
{"id":"22", "10":1, "breeding":0}
Raw
Manifest.toml
# This file is machine-generated - editing it directly is not advised
[[Adapt]]
deps = ["LinearAlgebra"]
git-tree-sha1 = "42c42f2221906892ceb765dbcb1a51deeffd86d7"
uuid = "79e6a3ab-5dfb-504d-930d-738a2a938a0e"
version = "2.3.0"
[[Artifacts]]
deps = ["Pkg"]
git-tree-sha1 = "c30985d8821e0cd73870b17b0ed0ce6dc44cb744"
uuid = "56f22d72-fd6d-98f1-02f0-08ddc0907c33"
version = "1.3.0"
[[Base64]]
uuid = "2a0f44e3-6c83-55bd-87e4-b1978d98bd5f"
[[BenchmarkTools]]
deps = ["JSON", "Logging", "Printf", "Statistics", "UUIDs"]
git-tree-sha1 = "9e62e66db34540a0c919d72172cc2f642ac71260"
uuid = "6e4b80f9-dd63-53aa-95a3-0cdb28fa8baf"
version = "0.5.0"
[[Bzip2_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "c3598e525718abcc440f69cc6d5f60dda0a1b61e"
uuid = "6e34b625-4abd-537c-b88f-471c36dfa7a0"
version = "1.0.6+5"
[[CSV]]
deps = ["Dates", "Mmap", "Parsers", "PooledArrays", "SentinelArrays", "Tables", "Unicode"]
git-tree-sha1 = "5f3ed063da881e9f309b0a8d543d8d1e4f5710fb"
uuid = "336ed68f-0bac-5ca0-87d4-7b16caf5d00b"
version = "0.8.0"
[[Cairo_jll]]
deps = ["Artifacts", "Bzip2_jll", "Fontconfig_jll", "FreeType2_jll", "Glib_jll", "JLLWrappers", "LZO_jll", "Libdl", "Pixman_jll", "Pkg", "Xorg_libXext_jll", "Xorg_libXrender_jll", "Zlib_jll", "libpng_jll"]
git-tree-sha1 = "e2f47f6d8337369411569fd45ae5753ca10394c6"
uuid = "83423d85-b0ee-5818-9007-b63ccbeb887a"
version = "1.16.0+6"
[[CategoricalArrays]]
deps = ["DataAPI", "Future", "JSON", "Missings", "Printf", "Statistics", "StructTypes", "Unicode"]
git-tree-sha1 = "5861101791fa76fafe8dddefd70ffbfe4e33ecae"
uuid = "324d7699-5711-5eae-9e2f-1d82baa6b597"
version = "0.9.0"
[[ColorSchemes]]
deps = ["ColorTypes", "Colors", "FixedPointNumbers", "Random", "StaticArrays"]
git-tree-sha1 = "5d472aa8908568bc198564db06983913a6c2c8e7"
uuid = "35d6a980-a343-548e-a6ea-1d62b119f2f4"
version = "3.10.1"
[[ColorTypes]]
deps = ["FixedPointNumbers", "Random"]
git-tree-sha1 = "4bffea7ed1a9f0f3d1a131bbcd4b925548d75288"
uuid = "3da002f7-5984-5a60-b8a6-cbb66c0b333f"
version = "0.10.9"
[[Colors]]
deps = ["ColorTypes", "FixedPointNumbers", "InteractiveUtils", "Reexport"]
git-tree-sha1 = "008d6bc68dea6beb6303fdc37188cb557391ebf2"
uuid = "5ae59095-9a9b-59fe-a467-6f913c188581"
version = "0.12.4"
[[Compat]]
deps = ["Base64", "Dates", "DelimitedFiles", "Distributed", "InteractiveUtils", "LibGit2", "Libdl", "LinearAlgebra", "Markdown", "Mmap", "Pkg", "Printf", "REPL", "Random", "SHA", "Serialization", "SharedArrays", "Sockets", "SparseArrays", "Statistics", "Test", "UUIDs", "Unicode"]
git-tree-sha1 = "a706ff10f1cd8dab94f59fd09c0e657db8e77ff0"
uuid = "34da2185-b29b-5c13-b0c7-acf172513d20"
version = "3.23.0"
[[Conda]]
deps = ["JSON", "VersionParsing"]
git-tree-sha1 = "c0647249d785f1d5139c0cc96db8f6b32f7ec416"
uuid = "8f4d0f93-b110-5947-807f-2305c1781a2d"
version = "1.5.0"
[[Contour]]
deps = ["StaticArrays"]
git-tree-sha1 = "0d128f9c2d9560349dc46f60c42036e244271d72"
uuid = "d38c429a-6771-53c6-b99e-75d170b6e991"
version = "0.5.6"
[[Crayons]]
git-tree-sha1 = "3f71217b538d7aaee0b69ab47d9b7724ca8afa0d"
uuid = "a8cc5b0e-0ffa-5ad4-8c14-923d3ee1735f"
version = "4.0.4"
[[DataAPI]]
git-tree-sha1 = "ad84f52c0b8f05aa20839484dbaf01690b41ff84"
uuid = "9a962f9c-6df0-11e9-0e5d-c546b8b5ee8a"
version = "1.4.0"
[[DataFrames]]
deps = ["CategoricalArrays", "Compat", "DataAPI", "Future", "InvertedIndices", "IteratorInterfaceExtensions", "LinearAlgebra", "Markdown", "Missings", "PooledArrays", "PrettyTables", "Printf", "REPL", "Reexport", "SortingAlgorithms", "Statistics", "TableTraits", "Tables", "Unicode"]
git-tree-sha1 = "20159837c2e5e196793a313cd700b8199fd8f985"
uuid = "a93c6f00-e57d-5684-b7b6-d8193f3e46c0"
version = "0.22.1"
[[DataStructures]]
deps = ["Compat", "InteractiveUtils", "OrderedCollections"]
git-tree-sha1 = "fb0aa371da91c1ff9dc7fbed6122d3e411420b9c"
uuid = "864edb3b-99cc-5e75-8d2d-829cb0a9cfe8"
version = "0.18.8"
[[DataValueInterfaces]]
git-tree-sha1 = "bfc1187b79289637fa0ef6d4436ebdfe6905cbd6"
uuid = "e2d170a0-9d28-54be-80f0-106bbe20a464"
version = "1.0.0"
[[Dates]]
deps = ["Printf"]
uuid = "ade2ca70-3891-5945-98fb-dc099432e06a"
[[DelimitedFiles]]
deps = ["Mmap"]
uuid = "8bb1440f-4735-579b-a4ab-409b98df4dab"
[[Distributed]]
deps = ["Random", "Serialization", "Sockets"]
uuid = "8ba89e20-285c-5b6f-9357-94700520ee1b"
[[EarCut_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "92d8f9f208637e8d2d28c664051a00569c01493d"
uuid = "5ae413db-bbd1-5e63-b57d-d24a61df00f5"
version = "2.1.5+1"
[[Expat_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "1402e52fcda25064f51c77a9655ce8680b76acf0"
uuid = "2e619515-83b5-522b-bb60-26c02a35a201"
version = "2.2.7+6"
[[FFMPEG]]
deps = ["FFMPEG_jll", "x264_jll"]
git-tree-sha1 = "9a73ffdc375be61b0e4516d83d880b265366fe1f"
uuid = "c87230d0-a227-11e9-1b43-d7ebe4e7570a"
version = "0.4.0"
[[FFMPEG_jll]]
deps = ["Artifacts", "Bzip2_jll", "FreeType2_jll", "FriBidi_jll", "JLLWrappers", "LAME_jll", "LibVPX_jll", "Libdl", "Ogg_jll", "OpenSSL_jll", "Opus_jll", "Pkg", "Zlib_jll", "libass_jll", "libfdk_aac_jll", "libvorbis_jll", "x264_jll", "x265_jll"]
git-tree-sha1 = "3cc57ad0a213808473eafef4845a74766242e05f"
uuid = "b22a6f82-2f65-5046-a5b2-351ab43fb4e5"
version = "4.3.1+4"
[[FileWatching]]
uuid = "7b1f6079-737a-58dc-b8bc-7a2ca5c1b5ee"
[[FixedPointNumbers]]
deps = ["Statistics"]
git-tree-sha1 = "335bfdceacc84c5cdf16aadc768aa5ddfc5383cc"
uuid = "53c48c17-4a7d-5ca2-90c5-79b7896eea93"
version = "0.8.4"
[[Fontconfig_jll]]
deps = ["Artifacts", "Bzip2_jll", "Expat_jll", "FreeType2_jll", "JLLWrappers", "Libdl", "Libuuid_jll", "Pkg", "Zlib_jll"]
git-tree-sha1 = "35895cf184ceaab11fd778b4590144034a167a2f"
uuid = "a3f928ae-7b40-5064-980b-68af3947d34b"
version = "2.13.1+14"
[[Formatting]]
deps = ["Printf"]
git-tree-sha1 = "a0c901c29c0e7c763342751c0a94211d56c0de5c"
uuid = "59287772-0a20-5a39-b81b-1366585eb4c0"
version = "0.4.1"
[[FreeType2_jll]]
deps = ["Artifacts", "Bzip2_jll", "JLLWrappers", "Libdl", "Pkg", "Zlib_jll"]
git-tree-sha1 = "cbd58c9deb1d304f5a245a0b7eb841a2560cfec6"
uuid = "d7e528f0-a631-5988-bf34-fe36492bcfd7"
version = "2.10.1+5"
[[FriBidi_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "0d20aed5b14dd4c9a2453c1b601d08e1149679cc"
uuid = "559328eb-81f9-559d-9380-de523a88c83c"
version = "1.0.5+6"
[[Future]]
deps = ["Random"]
uuid = "9fa8497b-333b-5362-9e8d-4d0656e87820"
[[GLFW_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Libglvnd_jll", "Pkg", "Xorg_libXcursor_jll", "Xorg_libXi_jll", "Xorg_libXinerama_jll", "Xorg_libXrandr_jll"]
git-tree-sha1 = "a1bbf700b5388bffc3d882f4f4d625cf1c714fd7"
uuid = "0656b61e-2033-5cc2-a64a-77c0f6c09b89"
version = "3.3.2+1"
[[GR]]
deps = ["Base64", "DelimitedFiles", "GR_jll", "HTTP", "JSON", "LinearAlgebra", "Pkg", "Printf", "Random", "Serialization", "Sockets", "Test", "UUIDs"]
git-tree-sha1 = "b90b826782cb3ac5b7a7f41b3fd0113180257ed4"
uuid = "28b8d3ca-fb5f-59d9-8090-bfdbd6d07a71"
version = "0.53.0"
[[GR_jll]]
deps = ["Bzip2_jll", "Cairo_jll", "FFMPEG_jll", "Fontconfig_jll", "GLFW_jll", "JpegTurbo_jll", "Libdl", "Libtiff_jll", "Pixman_jll", "Pkg", "Qhull_jll", "Qt_jll", "Zlib_jll", "libpng_jll"]
git-tree-sha1 = "daaccb414719ae63625b9b5e0eb4b1ec5b194590"
uuid = "d2c73de3-f751-5644-a686-071e5b155ba9"
version = "0.52.0+0"
[[GeometryBasics]]
deps = ["EarCut_jll", "IterTools", "LinearAlgebra", "StaticArrays", "StructArrays", "Tables"]
git-tree-sha1 = "876a906eab3be990fdcbfe1e43bb3a76f4776f72"
uuid = "5c1252a2-5f33-56bf-86c9-59e7332b4326"
version = "0.3.3"
[[Gettext_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Libiconv_jll", "Pkg", "XML2_jll"]
git-tree-sha1 = "8c14294a079216000a0bdca5ec5a447f073ddc9d"
uuid = "78b55507-aeef-58d4-861c-77aaff3498b1"
version = "0.20.1+7"
[[Glib_jll]]
deps = ["Artifacts", "Gettext_jll", "JLLWrappers", "Libdl", "Libffi_jll", "Libiconv_jll", "Libmount_jll", "PCRE_jll", "Pkg", "Zlib_jll"]
git-tree-sha1 = "04690cc5008b38ecbdfede949220bc7d9ba26397"
uuid = "7746bdde-850d-59dc-9ae8-88ece973131d"
version = "2.59.0+4"
[[Grisu]]
git-tree-sha1 = "03d381f65183cb2d0af8b3425fde97263ce9a995"
uuid = "42e2da0e-8278-4e71-bc24-59509adca0fe"
version = "1.0.0"
[[HTTP]]
deps = ["Base64", "Dates", "IniFile", "MbedTLS", "Sockets"]
git-tree-sha1 = "c7ec02c4c6a039a98a15f955462cd7aea5df4508"
uuid = "cd3eb016-35fb-5094-929b-558a96fad6f3"
version = "0.8.19"
[[IJulia]]
deps = ["Base64", "Conda", "Dates", "InteractiveUtils", "JSON", "Markdown", "MbedTLS", "Pkg", "Printf", "REPL", "Random", "SoftGlobalScope", "Test", "UUIDs", "ZMQ"]
git-tree-sha1 = "68e1792f3ca9a0df3b4e59d03a3aca828726917e"
uuid = "7073ff75-c697-5162-941a-fcdaad2a7d2a"
version = "1.23.0"
[[IniFile]]
deps = ["Test"]
git-tree-sha1 = "098e4d2c533924c921f9f9847274f2ad89e018b8"
uuid = "83e8ac13-25f8-5344-8a64-a9f2b223428f"
version = "0.5.0"
[[InteractiveUtils]]
deps = ["Markdown"]
uuid = "b77e0a4c-d291-57a0-90e8-8db25a27a240"
[[InvertedIndices]]
deps = ["Test"]
git-tree-sha1 = "15732c475062348b0165684ffe28e85ea8396afc"
uuid = "41ab1584-1d38-5bbf-9106-f11c6c58b48f"
version = "1.0.0"
[[IterTools]]
git-tree-sha1 = "05110a2ab1fc5f932622ffea2a003221f4782c18"
uuid = "c8e1da08-722c-5040-9ed9-7db0dc04731e"
version = "1.3.0"
[[IteratorInterfaceExtensions]]
git-tree-sha1 = "a3f24677c21f5bbe9d2a714f95dcd58337fb2856"
uuid = "82899510-4779-5014-852e-03e436cf321d"
version = "1.0.0"
[[JLLWrappers]]
git-tree-sha1 = "c70593677bbf2c3ccab4f7500d0f4dacfff7b75c"
uuid = "692b3bcd-3c85-4b1f-b108-f13ce0eb3210"
version = "1.1.3"
[[JSON]]
deps = ["Dates", "Mmap", "Parsers", "Unicode"]
git-tree-sha1 = "81690084b6198a2e1da36fcfda16eeca9f9f24e4"
uuid = "682c06a0-de6a-54ab-a142-c8b1cf79cde6"
version = "0.21.1"
[[JSON3]]
deps = ["Dates", "Mmap", "Parsers", "StructTypes", "UUIDs"]
git-tree-sha1 = "961ef1c3e5c8a595d5bec270a9007429ef12ed10"
uuid = "0f8b85d8-7281-11e9-16c2-39a750bddbf1"
version = "1.5.1"
[[JpegTurbo_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "9aff0587d9603ea0de2c6f6300d9f9492bbefbd3"
uuid = "aacddb02-875f-59d6-b918-886e6ef4fbf8"
version = "2.0.1+3"
[[LAME_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "df381151e871f41ee86cee4f5f6fd598b8a68826"
uuid = "c1c5ebd0-6772-5130-a774-d5fcae4a789d"
version = "3.100.0+3"
[[LZO_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "f128cd6cd05ffd6d3df0523ed99b90ff6f9b349a"
uuid = "dd4b983a-f0e5-5f8d-a1b7-129d4a5fb1ac"
version = "2.10.0+3"
[[LaTeXStrings]]
git-tree-sha1 = "c7aebfecb1a60d59c0fe023a68ec947a208b1e6b"
uuid = "b964fa9f-0449-5b57-a5c2-d3ea65f4040f"
version = "1.2.0"
[[Latexify]]
deps = ["Formatting", "InteractiveUtils", "LaTeXStrings", "MacroTools", "Markdown", "Printf", "Requires"]
git-tree-sha1 = "8771ad2b1464aa6188899ca0c3e432341e35f96a"
uuid = "23fbe1c1-3f47-55db-b15f-69d7ec21a316"
version = "0.14.5"
[[LibGit2]]
deps = ["Printf"]
uuid = "76f85450-5226-5b5a-8eaa-529ad045b433"
[[LibVPX_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "85fcc80c3052be96619affa2fe2e6d2da3908e11"
uuid = "dd192d2f-8180-539f-9fb4-cc70b1dcf69a"
version = "1.9.0+1"
[[Libdl]]
uuid = "8f399da3-3557-5675-b5ff-fb832c97cbdb"
[[Libffi_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "a2cd088a88c0d37eef7d209fd3d8712febce0d90"
uuid = "e9f186c6-92d2-5b65-8a66-fee21dc1b490"
version = "3.2.1+4"
[[Libgcrypt_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Libgpg_error_jll", "Pkg"]
git-tree-sha1 = "b391a18ab1170a2e568f9fb8d83bc7c780cb9999"
uuid = "d4300ac3-e22c-5743-9152-c294e39db1e4"
version = "1.8.5+4"
[[Libglvnd_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libX11_jll", "Xorg_libXext_jll"]
git-tree-sha1 = "7739f837d6447403596a75d19ed01fd08d6f56bf"
uuid = "7e76a0d4-f3c7-5321-8279-8d96eeed0f29"
version = "1.3.0+3"
[[Libgpg_error_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "ec7f2e8ad5c9fa99fc773376cdbc86d9a5a23cb7"
uuid = "7add5ba3-2f88-524e-9cd5-f83b8a55f7b8"
version = "1.36.0+3"
[[Libiconv_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "8e924324b2e9275a51407a4e06deb3455b1e359f"
uuid = "94ce4f54-9a6c-5748-9c1c-f9c7231a4531"
version = "1.16.0+7"
[[Libmount_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "51ad0c01c94c1ce48d5cad629425035ad030bfd5"
uuid = "4b2f31a3-9ecc-558c-b454-b3730dcb73e9"
version = "2.34.0+3"
[[Libtiff_jll]]
deps = ["Artifacts", "JLLWrappers", "JpegTurbo_jll", "Libdl", "Pkg", "Zlib_jll", "Zstd_jll"]
git-tree-sha1 = "291dd857901f94d683973cdf679984cdf73b56d0"
uuid = "89763e89-9b03-5906-acba-b20f662cd828"
version = "4.1.0+2"
[[Libuuid_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "f879ae9edbaa2c74c922e8b85bb83cc84ea1450b"
uuid = "38a345b3-de98-5d2b-a5d3-14cd9215e700"
version = "2.34.0+7"
[[LinearAlgebra]]
deps = ["Libdl"]
uuid = "37e2e46d-f89d-539d-b4ee-838fcccc9c8e"
[[Logging]]
uuid = "56ddb016-857b-54e1-b83d-db4d58db5568"
[[MacroTools]]
deps = ["Markdown", "Random"]
git-tree-sha1 = "6a8a2a625ab0dea913aba95c11370589e0239ff0"
uuid = "1914dd2f-81c6-5fcd-8719-6d5c9610ff09"
version = "0.5.6"
[[Markdown]]
deps = ["Base64"]
uuid = "d6f4376e-aef5-505a-96c1-9c027394607a"
[[MbedTLS]]
deps = ["Dates", "MbedTLS_jll", "Random", "Sockets"]
git-tree-sha1 = "1c38e51c3d08ef2278062ebceade0e46cefc96fe"
uuid = "739be429-bea8-5141-9913-cc70e7f3736d"
version = "1.0.3"
[[MbedTLS_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "0eef589dd1c26a3ac9d753fe1a8bcad63f956fa6"
uuid = "c8ffd9c3-330d-5841-b78e-0817d7145fa1"
version = "2.16.8+1"
[[Measures]]
git-tree-sha1 = "e498ddeee6f9fdb4551ce855a46f54dbd900245f"
uuid = "442fdcdd-2543-5da2-b0f3-8c86c306513e"
version = "0.3.1"
[[Missings]]
deps = ["DataAPI"]
git-tree-sha1 = "ed61674a0864832495ffe0a7e889c0da76b0f4c8"
uuid = "e1d29d7a-bbdc-5cf2-9ac0-f12de2c33e28"
version = "0.4.4"
[[Mmap]]
uuid = "a63ad114-7e13-5084-954f-fe012c677804"
[[NaNMath]]
git-tree-sha1 = "bfe47e760d60b82b66b61d2d44128b62e3a369fb"
uuid = "77ba4419-2d1f-58cd-9bb1-8ffee604a2e3"
version = "0.3.5"
[[Ogg_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "a42c0f138b9ebe8b58eba2271c5053773bde52d0"
uuid = "e7412a2a-1a6e-54c0-be00-318e2571c051"
version = "1.3.4+2"
[[OpenSSL_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "71bbbc616a1d710879f5a1021bcba65ffba6ce58"
uuid = "458c3c95-2e84-50aa-8efc-19380b2a3a95"
version = "1.1.1+6"
[[Opus_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "f9d57f4126c39565e05a2b0264df99f497fc6f37"
uuid = "91d4177d-7536-5919-b921-800302f37372"
version = "1.3.1+3"
[[OrderedCollections]]
git-tree-sha1 = "cf59cfed2e2c12e8a2ff0a4f1e9b2cd8650da6db"
uuid = "bac558e1-5e72-5ebc-8fee-abe8a469f55d"
version = "1.3.2"
[[PCRE_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "1b556ad51dceefdbf30e86ffa8f528b73c7df2bb"
uuid = "2f80f16e-611a-54ab-bc61-aa92de5b98fc"
version = "8.42.0+4"
[[Parsers]]
deps = ["Dates"]
git-tree-sha1 = "b417be52e8be24e916e34b3d70ec2da7bdf56a68"
uuid = "69de0a69-1ddd-5017-9359-2bf0b02dc9f0"
version = "1.0.12"
[[Pipe]]
git-tree-sha1 = "6842804e7867b115ca9de748a0cf6b364523c16d"
uuid = "b98c9c47-44ae-5843-9183-064241ee97a0"
version = "1.3.0"
[[Pixman_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "392d85fe2fd2c613442f9694dd566c0d5641d58c"
uuid = "30392449-352a-5448-841d-b1acce4e97dc"
version = "0.38.4+5"
[[Pkg]]
deps = ["Dates", "LibGit2", "Libdl", "Logging", "Markdown", "Printf", "REPL", "Random", "SHA", "UUIDs"]
uuid = "44cfe95a-1eb2-52ea-b672-e2afdf69b78f"
[[PlotThemes]]
deps = ["PlotUtils", "Requires", "Statistics"]
git-tree-sha1 = "c6f5ea535551b3b16835134697f0c65d06c94b91"
uuid = "ccf2f8ad-2431-5c83-bf29-c5338b663b6a"
version = "2.0.0"
[[PlotUtils]]
deps = ["ColorSchemes", "Colors", "Dates", "Printf", "Random", "Reexport", "Statistics"]
git-tree-sha1 = "4e098f88dad9a2b518b83124a116be1c49e2b2bf"
uuid = "995b91a9-d308-5afd-9ec6-746e21dbc043"
version = "1.0.7"
[[Plots]]
deps = ["Base64", "Contour", "Dates", "FFMPEG", "FixedPointNumbers", "GR", "GeometryBasics", "JSON", "Latexify", "LinearAlgebra", "Measures", "NaNMath", "PlotThemes", "PlotUtils", "Printf", "REPL", "Random", "RecipesBase", "RecipesPipeline", "Reexport", "Requires", "Scratch", "Showoff", "SparseArrays", "Statistics", "StatsBase", "UUIDs"]
git-tree-sha1 = "173c7250ccd7c98615b04c669eb13fa7fab494b0"
uuid = "91a5bcdd-55d7-5caf-9e0b-520d859cae80"
version = "1.9.1"
[[PooledArrays]]
deps = ["DataAPI"]
git-tree-sha1 = "b1333d4eced1826e15adbdf01a4ecaccca9d353c"
uuid = "2dfb63ee-cc39-5dd5-95bd-886bf059d720"
version = "0.5.3"
[[PrettyTables]]
deps = ["Crayons", "Formatting", "Markdown", "Reexport", "Tables"]
git-tree-sha1 = "237170206bf38a66fee4d845f4ae57f63788eeb0"
uuid = "08abe8d2-0d0c-5749-adfa-8a2ac140af0d"
version = "0.10.1"
[[Printf]]
deps = ["Unicode"]
uuid = "de0858da-6303-5e67-8744-51eddeeeb8d7"
[[Qhull_jll]]
deps = ["Libdl", "Pkg"]
git-tree-sha1 = "585989201bf8741e165ae52df54de79c5299daa7"
uuid = "784f63db-0788-585a-bace-daefebcd302b"
version = "2019.1.0+2"
[[Qt_jll]]
deps = ["Artifacts", "Fontconfig_jll", "Glib_jll", "JLLWrappers", "Libdl", "Pkg", "Xorg_libXext_jll", "Xorg_libxcb_jll", "Xorg_xcb_util_image_jll", "Xorg_xcb_util_keysyms_jll", "Xorg_xcb_util_renderutil_jll", "Xorg_xcb_util_wm_jll", "Zlib_jll", "xkbcommon_jll"]
git-tree-sha1 = "72244a8e084251aea25968c61bbf5c001aaa7d5a"
uuid = "ede63266-ebff-546c-83e0-1c6fb6d0efc8"
version = "5.15.1+0"
[[REPL]]
deps = ["InteractiveUtils", "Markdown", "Sockets"]
uuid = "3fa0cd96-eef1-5676-8a61-b3b8758bbffb"
[[Random]]
deps = ["Serialization"]
uuid = "9a3f8284-a2c9-5f02-9a11-845980a1fd5c"
[[RecipesBase]]
git-tree-sha1 = "b3fb709f3c97bfc6e948be68beeecb55a0b340ae"
uuid = "3cdcf5f2-1ef4-517c-9805-6587b60abb01"
version = "1.1.1"
[[RecipesPipeline]]
deps = ["Dates", "NaNMath", "PlotUtils", "RecipesBase"]
git-tree-sha1 = "9ea2f5bf1b26918b16e9f885bb8e05206bfc2144"
uuid = "01d81517-befc-4cb6-b9ec-a95719d0359c"
version = "0.2.1"
[[Reexport]]
deps = ["Pkg"]
git-tree-sha1 = "7b1d07f411bc8ddb7977ec7f377b97b158514fe0"
uuid = "189a3867-3050-52da-a836-e630ba90ab69"
version = "0.2.0"
[[Requires]]
deps = ["UUIDs"]
git-tree-sha1 = "e05c53ebc86933601d36212a93b39144a2733493"
uuid = "ae029012-a4dd-5104-9daa-d747884805df"
version = "1.1.1"
[[SHA]]
uuid = "ea8e919c-243c-51af-8825-aaa63cd721ce"
[[Scratch]]
deps = ["Dates"]
git-tree-sha1 = "ad4b278adb62d185bbcb6864dc24959ab0627bf6"
uuid = "6c6a2e73-6563-6170-7368-637461726353"
version = "1.0.3"
[[SentinelArrays]]
deps = ["Dates", "Random"]
git-tree-sha1 = "6ccde405cf0759eba835eb613130723cb8f10ff9"
uuid = "91c51154-3ec4-41a3-a24f-3f23e20d615c"
version = "1.2.16"
[[Serialization]]
uuid = "9e88b42a-f829-5b0c-bbe9-9e923198166b"
[[SharedArrays]]
deps = ["Distributed", "Mmap", "Random", "Serialization"]
uuid = "1a1011a3-84de-559e-8e89-a11a2f7dc383"
[[Showoff]]
deps = ["Dates", "Grisu"]
git-tree-sha1 = "ee010d8f103468309b8afac4abb9be2e18ff1182"
uuid = "992d4aef-0814-514b-bc4d-f2e9a6c4116f"
version = "0.3.2"
[[Sockets]]
uuid = "6462fe0b-24de-5631-8697-dd941f90decc"
[[SoftGlobalScope]]
deps = ["REPL"]
git-tree-sha1 = "986ec2b6162ccb95de5892ed17832f95badf770c"
uuid = "b85f4697-e234-5449-a836-ec8e2f98b302"
version = "1.1.0"
[[SortingAlgorithms]]
deps = ["DataStructures", "Random", "Test"]
git-tree-sha1 = "03f5898c9959f8115e30bc7226ada7d0df554ddd"
uuid = "a2af1166-a08f-5f64-846c-94a0d3cef48c"
version = "0.3.1"
[[SparseArrays]]
deps = ["LinearAlgebra", "Random"]
uuid = "2f01184e-e22b-5df5-ae63-d93ebab69eaf"
[[StaticArrays]]
deps = ["LinearAlgebra", "Random", "Statistics"]
git-tree-sha1 = "da4cf579416c81994afd6322365d00916c79b8ae"
uuid = "90137ffa-7385-5640-81b9-e52037218182"
version = "0.12.5"
[[Statistics]]
deps = ["LinearAlgebra", "SparseArrays"]
uuid = "10745b16-79ce-11e8-11f9-7d13ad32a3b2"
[[StatsBase]]
deps = ["DataAPI", "DataStructures", "LinearAlgebra", "Missings", "Printf", "Random", "SortingAlgorithms", "SparseArrays", "Statistics"]
git-tree-sha1 = "7bab7d4eb46b225b35179632852b595a3162cb61"
uuid = "2913bbd2-ae8a-5f71-8c99-4fb6c76f3a91"
version = "0.33.2"
[[StructArrays]]
deps = ["Adapt", "DataAPI", "Tables"]
git-tree-sha1 = "8099ed9fb90b6e754d6ba8c6ed8670f010eadca0"
uuid = "09ab397b-f2b6-538f-b94a-2f83cf4a842a"
version = "0.4.4"
[[StructTypes]]
deps = ["Dates", "UUIDs"]
git-tree-sha1 = "1ed04f622a39d2e5a6747c3a70be040c00333933"
uuid = "856f2bd8-1eba-4b0a-8007-ebc267875bd4"
version = "1.1.0"
[[TableTraits]]
deps = ["IteratorInterfaceExtensions"]
git-tree-sha1 = "b1ad568ba658d8cbb3b892ed5380a6f3e781a81e"
uuid = "3783bdb8-4a98-5b6b-af9a-565f29a5fe9c"
version = "1.0.0"
[[Tables]]
deps = ["DataAPI", "DataValueInterfaces", "IteratorInterfaceExtensions", "LinearAlgebra", "TableTraits", "Test"]
git-tree-sha1 = "5131a624173d532299d1c7eb05341c18112b21b8"
uuid = "bd369af6-aec1-5ad0-b16a-f7cc5008161c"
version = "1.2.1"
[[Test]]
deps = ["Distributed", "InteractiveUtils", "Logging", "Random"]
uuid = "8dfed614-e22c-5e08-85e1-65c5234f0b40"
[[UUIDs]]
deps = ["Random", "SHA"]
uuid = "cf7118a7-6976-5b1a-9a39-7adc72f591a4"
[[Unicode]]
uuid = "4ec0a83e-493e-50e2-b9ac-8f72acf5a8f5"
[[VersionParsing]]
git-tree-sha1 = "80229be1f670524750d905f8fc8148e5a8c4537f"
uuid = "81def892-9a0e-5fdd-b105-ffc91e053289"
version = "1.2.0"
[[Wayland_jll]]
deps = ["Artifacts", "Expat_jll", "JLLWrappers", "Libdl", "Libffi_jll", "Pkg", "XML2_jll"]
git-tree-sha1 = "dc643a9b774da1c2781413fd7b6dcd2c56bb8056"
uuid = "a2964d1f-97da-50d4-b82a-358c7fce9d89"
version = "1.17.0+4"
[[Wayland_protocols_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Wayland_jll"]
git-tree-sha1 = "2839f1c1296940218e35df0bbb220f2a79686670"
uuid = "2381bf8a-dfd0-557d-9999-79630e7b1b91"
version = "1.18.0+4"
[[XML2_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Libiconv_jll", "Pkg", "Zlib_jll"]
git-tree-sha1 = "be0db24f70aae7e2b89f2f3092e93b8606d659a6"
uuid = "02c8fc9c-b97f-50b9-bbe4-9be30ff0a78a"
version = "2.9.10+3"
[[XSLT_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Libgcrypt_jll", "Pkg", "XML2_jll"]
git-tree-sha1 = "2b3eac39df218762d2d005702d601cd44c997497"
uuid = "aed1982a-8fda-507f-9586-7b0439959a61"
version = "1.1.33+4"
[[Xorg_libX11_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libxcb_jll", "Xorg_xtrans_jll"]
git-tree-sha1 = "5be649d550f3f4b95308bf0183b82e2582876527"
uuid = "4f6342f7-b3d2-589e-9d20-edeb45f2b2bc"
version = "1.6.9+4"
[[Xorg_libXau_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "4e490d5c960c314f33885790ed410ff3a94ce67e"
uuid = "0c0b7dd1-d40b-584c-a123-a41640f87eec"
version = "1.0.9+4"
[[Xorg_libXcursor_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libXfixes_jll", "Xorg_libXrender_jll"]
git-tree-sha1 = "12e0eb3bc634fa2080c1c37fccf56f7c22989afd"
uuid = "935fb764-8cf2-53bf-bb30-45bb1f8bf724"
version = "1.2.0+4"
[[Xorg_libXdmcp_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "4fe47bd2247248125c428978740e18a681372dd4"
uuid = "a3789734-cfe1-5b06-b2d0-1dd0d9d62d05"
version = "1.1.3+4"
[[Xorg_libXext_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libX11_jll"]
git-tree-sha1 = "b7c0aa8c376b31e4852b360222848637f481f8c3"
uuid = "1082639a-0dae-5f34-9b06-72781eeb8cb3"
version = "1.3.4+4"
[[Xorg_libXfixes_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libX11_jll"]
git-tree-sha1 = "0e0dc7431e7a0587559f9294aeec269471c991a4"
uuid = "d091e8ba-531a-589c-9de9-94069b037ed8"
version = "5.0.3+4"
[[Xorg_libXi_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libXext_jll", "Xorg_libXfixes_jll"]
git-tree-sha1 = "89b52bc2160aadc84d707093930ef0bffa641246"
uuid = "a51aa0fd-4e3c-5386-b890-e753decda492"
version = "1.7.10+4"
[[Xorg_libXinerama_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libXext_jll"]
git-tree-sha1 = "26be8b1c342929259317d8b9f7b53bf2bb73b123"
uuid = "d1454406-59df-5ea1-beac-c340f2130bc3"
version = "1.1.4+4"
[[Xorg_libXrandr_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libXext_jll", "Xorg_libXrender_jll"]
git-tree-sha1 = "34cea83cb726fb58f325887bf0612c6b3fb17631"
uuid = "ec84b674-ba8e-5d96-8ba1-2a689ba10484"
version = "1.5.2+4"
[[Xorg_libXrender_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libX11_jll"]
git-tree-sha1 = "19560f30fd49f4d4efbe7002a1037f8c43d43b96"
uuid = "ea2f1a96-1ddc-540d-b46f-429655e07cfa"
version = "0.9.10+4"
[[Xorg_libpthread_stubs_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "6783737e45d3c59a4a4c4091f5f88cdcf0908cbb"
uuid = "14d82f49-176c-5ed1-bb49-ad3f5cbd8c74"
version = "0.1.0+3"
[[Xorg_libxcb_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "XSLT_jll", "Xorg_libXau_jll", "Xorg_libXdmcp_jll", "Xorg_libpthread_stubs_jll"]
git-tree-sha1 = "daf17f441228e7a3833846cd048892861cff16d6"
uuid = "c7cfdc94-dc32-55de-ac96-5a1b8d977c5b"
version = "1.13.0+3"
[[Xorg_libxkbfile_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libX11_jll"]
git-tree-sha1 = "926af861744212db0eb001d9e40b5d16292080b2"
uuid = "cc61e674-0454-545c-8b26-ed2c68acab7a"
version = "1.1.0+4"
[[Xorg_xcb_util_image_jll]]
deps = ["Libdl", "Pkg", "Xorg_xcb_util_jll"]
git-tree-sha1 = "16eb9a5aa027fb877207bf9915686366c2d5c064"
uuid = "12413925-8142-5f55-bb0e-6d7ca50bb09b"
version = "0.4.0+0"
[[Xorg_xcb_util_jll]]
deps = ["Libdl", "Pkg", "Xorg_libxcb_jll"]
git-tree-sha1 = "6b47a94261a67078fe3d3922363bd9fd83b6eb1d"
uuid = "2def613f-5ad1-5310-b15b-b15d46f528f5"
version = "0.4.0+0"
[[Xorg_xcb_util_keysyms_jll]]
deps = ["Libdl", "Pkg", "Xorg_xcb_util_jll"]
git-tree-sha1 = "40771f688e17baa121136b649e631e1868a6678e"
uuid = "975044d2-76e6-5fbe-bf08-97ce7c6574c7"
version = "0.4.0+0"
[[Xorg_xcb_util_renderutil_jll]]
deps = ["Libdl", "Pkg", "Xorg_xcb_util_jll"]
git-tree-sha1 = "72c9b59211a97f763a9ca82351d37ebc04a6858a"
uuid = "0d47668e-0667-5a69-a72c-f761630bfb7e"
version = "0.3.9+0"
[[Xorg_xcb_util_wm_jll]]
deps = ["Libdl", "Pkg", "Xorg_xcb_util_jll"]
git-tree-sha1 = "6ed52e9bfb2421f01ee62e1a5a30eba5f3f29c74"
uuid = "c22f9ab0-d5fe-5066-847c-f4bb1cd4e361"
version = "0.4.1+0"
[[Xorg_xkbcomp_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_libxkbfile_jll"]
git-tree-sha1 = "4bcbf660f6c2e714f87e960a171b119d06ee163b"
uuid = "35661453-b289-5fab-8a00-3d9160c6a3a4"
version = "1.4.2+4"
[[Xorg_xkeyboard_config_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Xorg_xkbcomp_jll"]
git-tree-sha1 = "5c8424f8a67c3f2209646d4425f3d415fee5931d"
uuid = "33bec58e-1273-512f-9401-5d533626f822"
version = "2.27.0+4"
[[Xorg_xtrans_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "79c31e7844f6ecf779705fbc12146eb190b7d845"
uuid = "c5fb5394-a638-5e4d-96e5-b29de1b5cf10"
version = "1.4.0+3"
[[ZMQ]]
deps = ["FileWatching", "Sockets", "ZeroMQ_jll"]
git-tree-sha1 = "fc68e8a3719166950a0f3e390a14c7302c48f8de"
uuid = "c2297ded-f4af-51ae-bb23-16f91089e4e1"
version = "1.2.1"
[[ZeroMQ_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "bba617292e040408cb72baa03c20f43583bf239f"
uuid = "8f1865be-045e-5c20-9c9f-bfbfb0764568"
version = "4.3.2+5"
[[Zlib_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "320228915c8debb12cb434c59057290f0834dbf6"
uuid = "83775a58-1f1d-513f-b197-d71354ab007a"
version = "1.2.11+18"
[[Zstd_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "6f1abcb0c44f184690912aa4b0ba861dd64f11b9"
uuid = "3161d3a3-bdf6-5164-811a-617609db77b4"
version = "1.4.5+2"
[[libass_jll]]
deps = ["Artifacts", "Bzip2_jll", "FreeType2_jll", "FriBidi_jll", "JLLWrappers", "Libdl", "Pkg", "Zlib_jll"]
git-tree-sha1 = "acc685bcf777b2202a904cdcb49ad34c2fa1880c"
uuid = "0ac62f75-1d6f-5e53-bd7c-93b484bb37c0"
version = "0.14.0+4"
[[libfdk_aac_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "7a5780a0d9c6864184b3a2eeeb833a0c871f00ab"
uuid = "f638f0a6-7fb0-5443-88ba-1cc74229b280"
version = "0.1.6+4"
[[libpng_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Zlib_jll"]
git-tree-sha1 = "6abbc424248097d69c0c87ba50fcb0753f93e0ee"
uuid = "b53b4c65-9356-5827-b1ea-8c7a1a84506f"
version = "1.6.37+6"
[[libvorbis_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Ogg_jll", "Pkg"]
git-tree-sha1 = "fa14ac25af7a4b8a7f61b287a124df7aab601bcd"
uuid = "f27f6e37-5d2b-51aa-960f-b287f2bc3b7a"
version = "1.3.6+6"
[[x264_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "d713c1ce4deac133e3334ee12f4adff07f81778f"
uuid = "1270edf5-f2f9-52d2-97e9-ab00b5d0237a"
version = "2020.7.14+2"
[[x265_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg"]
git-tree-sha1 = "487da2f8f2f0c8ee0e83f39d13037d6bbf0a45ab"
uuid = "dfaa095f-4041-5dcd-9319-2fabd8486b76"
version = "3.0.0+3"
[[xkbcommon_jll]]
deps = ["Artifacts", "JLLWrappers", "Libdl", "Pkg", "Wayland_jll", "Wayland_protocols_jll", "Xorg_libxcb_jll", "Xorg_xkeyboard_config_jll"]
git-tree-sha1 = "ece2350174195bb31de1a63bea3a41ae1aa593b6"
uuid = "d8fb68d0-12a3-5cfd-a85a-d49703b185fd"
version = "0.9.1+5"
Raw
Project.toml
[deps]
BenchmarkTools = "6e4b80f9-dd63-53aa-95a3-0cdb28fa8baf"
CSV = "336ed68f-0bac-5ca0-87d4-7b16caf5d00b"
DataFrames = "a93c6f00-e57d-5684-b7b6-d8193f3e46c0"
IJulia = "7073ff75-c697-5162-941a-fcdaad2a7d2a"
JSON3 = "0f8b85d8-7281-11e9-16c2-39a750bddbf1"
Pipe = "b98c9c47-44ae-5843-9183-064241ee97a0"
Plots = "91a5bcdd-55d7-5caf-9e0b-520d859cae80"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment