Google Git
Sign in
eclipse / gerrit / www.eclipse.org / dataeggs / ce9f9dbca939ca75fc7d5b9b656796581dacba51 / . / eclipse_mls / mbox_csv_analysis / index.html
blob: 0effb4bf1ad9f8788a03d2b863e7889ed3cc8a12 [file] [log] [blame]
<!DOCTYPE html>
<html lang='en' dir='auto'><head>
<meta charset='utf-8'>
<meta name='viewport' content='width=device-width, initial-scale=1'>
<meta name='description' content='About this dataset This dataset is a dump of all posts sent on all mailing lists hosted at the Eclipse Forge. Although this is public data (the mailing lists can be browsed on the official mailman page) all data has been anonymised to prevent any misuse. The privacy issues identified, along with the anonymisation process, have been covered in a dedicated document.'>
<meta name='theme-color' content='#ffcd00'>
<meta property='og:title' content='Mbox Analysis • Eclipse DataEggs'>
<meta property='og:description' content='About this dataset This dataset is a dump of all posts sent on all mailing lists hosted at the Eclipse Forge. Although this is public data (the mailing lists can be browsed on the official mailman page) all data has been anonymised to prevent any misuse. The privacy issues identified, along with the anonymisation process, have been covered in a dedicated document.'>
<meta property='og:url' content='https://download.eclipse.org/dataeggs/eclipse_mls/mbox_csv_analysis/'>
<meta property='og:site_name' content='Eclipse DataEggs'>
<meta property='og:type' content='article'><meta property='article:section' content='eclipse_mls'><meta name='twitter:card' content='summary'>
<meta name="generator" content="Hugo 0.80.0" />
<title>Mbox Analysis • Eclipse DataEggs</title>
<link rel='canonical' href='https://download.eclipse.org/dataeggs/eclipse_mls/mbox_csv_analysis/'>
<link rel='icon' href='/dataeggs/favicon.ico'>
<link rel='stylesheet' href='/dataeggs/assets/css/main.ab98e12b.css'><link rel='stylesheet' href='/dataeggs/css/custom.css'><style>
:root{--color-accent:#ffcd00;}
</style>
<script type="application/javascript">
var doNotTrack = false;
if (!doNotTrack) {
window.ga=window.ga||function(){(ga.q=ga.q||[]).push(arguments)};ga.l=+new Date;
ga('create', 'UA-3675452-15', 'auto');
ga('send', 'pageview');
}
</script>
<script async src='https://www.google-analytics.com/analytics.js'></script>
</head>
<body class='page type-eclipse_mls has-sidebar'>
<div class='site'><div id='sidebar' class='sidebar'>
<a class='screen-reader-text' href='#main-menu'>Skip to Main Menu</a>
<div class='container'><section class='widget widget-about sep-after'>
<header>
<div class='logo'>
<a href='/dataeggs/'>
<img src='/dataeggs/images/dataeggs-menu.png'>
</a>
</div>
<div class='desc'>
Open. Safe. Easy.
</div>
</header>
</section>
<section class='widget widget-search sep-after'>
<header>
<h4 class='title widget-title'>Search</h4>
</header>
<form action='/dataeggs/search' id='search-form' class='search-form'>
<label>
<span class='screen-reader-text'>Search</span>
<input id='search-term' class='search-term' type='search' name='q' placeholder='Search&hellip;'>
</label></form>
</section>
<section class='widget widget-sidebar_menu sep-after'><nav id='sidebar-menu' class='menu sidebar-menu' aria-label='Sidebar Menu'>
<div class='container'>
<ul><li class='item'>
<a href='/dataeggs/'>Home</a></li><li class='item'>
<a href='/dataeggs/privacy/'>Privacy</a></li><li class='item'>
<a href='/dataeggs/aeri_stacktraces/'>AERI</a></li><li class='item'>
<a href='/dataeggs/eclipse_mls/'>MLS</a></li><li class='item has-children'>
<a href=''>projects</a><button class='sub-menu-toggler'>
<span class='screen-reader-text'>expand sub menu</span>
<span class='sign'></span>
</button>
<ul class='sub-menu'><li class='item'>
<a href='/dataeggs/projects/ecd.che/datasets_report/'>ecd.che</a></li><li class='item'>
<a href='/dataeggs/projects/ee4j.glassfish/datasets_report/'>ee4j.glassfish</a></li><li class='item'>
<a href='/dataeggs/projects/modeling.emf-parsley/datasets_report/'>modeling.emf-parsley</a></li><li class='item'>
<a href='/dataeggs/projects/modeling.emfcompare/datasets_report/'>modeling.emfcompare</a></li><li class='item'>
<a href='/dataeggs/projects/modeling.epsilon/datasets_report/'>modeling.epsilon</a></li><li class='item'>
<a href='/dataeggs/projects/modeling.gendoc/datasets_report/'>modeling.gendoc</a></li><li class='item'>
<a href='/dataeggs/projects/modeling.m2t.acceleo/datasets_report/'>modeling.m2t.acceleo</a></li><li class='item'>
<a href='/dataeggs/projects/modeling.mdt.ocl/datasets_report/'>modeling.mdt.ocl</a></li><li class='item'>
<a href='/dataeggs/projects/modeling.sirius/datasets_report/'>modeling.sirius</a></li><li class='item'>
<a href='/dataeggs/projects/technology.apogy/datasets_report/'>technology.apogy</a></li><li class='item'>
<a href='/dataeggs/projects/technology.app4mc/datasets_report/'>technology.app4mc</a></li><li class='item'>
<a href='/dataeggs/projects/technology.collections/datasets_report/'>technology.collections</a></li><li class='item'>
<a href='/dataeggs/projects/technology.ease/datasets_report/'>technology.ease</a></li><li class='item'>
<a href='/dataeggs/projects/technology.egit/datasets_report/'>technology.egit</a></li><li class='item'>
<a href='/dataeggs/projects/technology.epf/datasets_report/'>technology.epf</a></li><li class='item'>
<a href='/dataeggs/projects/technology.jgit/datasets_report/'>technology.jgit</a></li><li class='item'>
<a href='/dataeggs/projects/technology.paho/datasets_report/'>technology.paho</a></li><li class='item'>
<a href='/dataeggs/projects/technology.scout/datasets_report/'>technology.scout</a></li><li class='item'>
<a href='/dataeggs/projects/tools.cdt/datasets_report/'>tools.cdt</a></li><li class='item'>
<a href='/dataeggs/projects/tools.tracecompass/datasets_report/'>tools.tracecompass</a></li></ul></li></ul>
</div>
</nav>
</section><section class='widget widget-social_menu sep-after'><nav aria-label='Social Menu'>
<ul><li>
<a href='https://gitlab.eclipse.org/dataeggs/dataeggs' target='_blank' rel='noopener me'>
<span class='screen-reader-text'>Open Gitlab account in new tab</span><svg class='icon' xmlns='http://www.w3.org/2000/svg' viewbox='0 0 24 24' stroke-linecap='round' stroke-linejoin='round' stroke-width='2' aria-hidden='true'>
<title>GitLab icon</title> <path d="M22.65 14.39L12 22.13 1.35 14.39a.84.84 0 0 1-.3-.94l1.22-3.78 2.44-7.51A.42.42 0 0 1 4.82 2a.43.43 0 0 1 .58 0 .42.42 0 0 1 .11.18l2.44 7.49h8.1l2.44-7.51A.42.42 0 0 1 18.6 2a.43.43 0 0 1 .58 0 .42.42 0 0 1 .11.18l2.44 7.51L23 13.45a.84.84 0 0 1-.35.94z"/>
</svg>
</a>
</li><li>
<a href='mailto:boris@chrysalice.org' target='_blank' rel='noopener me'>
<span class='screen-reader-text'>Contact via Email</span><svg class='icon' xmlns='http://www.w3.org/2000/svg' viewbox='0 0 24 24' stroke-linecap='round' stroke-linejoin='round' stroke-width='2' aria-hidden='true'>
<path d="M4 4h16c1.1 0 2 .9 2 2v12c0 1.1-.9 2-2 2H4c-1.1 0-2-.9-2-2V6c0-1.1.9-2 2-2z"></path><polyline points="22,6 12,13 2,6"></polyline>
</svg>
</a>
</li></ul>
</nav>
</section></div>
<div class='sidebar-overlay'></div>
</div><div class='main'><a class='screen-reader-text' href='#content'>Skip to Content</a>
<button id='sidebar-toggler' class='sidebar-toggler' aria-controls='sidebar'>
<span class='screen-reader-text'>Toggle Sidebar</span>
<span class='open'><svg class='icon' xmlns='http://www.w3.org/2000/svg' viewbox='0 0 24 24' stroke-linecap='round' stroke-linejoin='round' stroke-width='2' aria-hidden='true'>
<line x1="3" y1="12" x2="21" y2="12" />
<line x1="3" y1="6" x2="21" y2="6" />
<line x1="3" y1="18" x2="21" y2="18" />
</svg>
</span>
<span class='close'><svg class='icon' xmlns='http://www.w3.org/2000/svg' viewbox='0 0 24 24' stroke-linecap='round' stroke-linejoin='round' stroke-width='2' aria-hidden='true'>
<line x1="18" y1="6" x2="6" y2="18" />
<line x1="6" y1="6" x2="18" y2="18" />
</svg>
</span>
</button><div class='header-widgets'>
<div class='container'>
<style>.widget-breadcrumbs li:after{content:'\2f '}</style>
<section class='widget widget-breadcrumbs sep-after'>
<nav id='breadcrumbs'>
<ol><li><a href='/dataeggs/'>Home</a></li><li><a href='/dataeggs/eclipse_mls/'>MailingLists</a></li><li><span>Mbox Analysis</span></li></ol>
</nav>
</section></div>
</div>
<header id='header' class='header site-header'>
<div class='container sep-after'>
<div class='header-info'><p class='site-title title'>Eclipse DataEggs</p><p class='desc site-desc'></p>
</div>
</div>
</header>
<main id='content'>
<article lang='en' class='entry'>
<header class='header entry-header'>
<div class='container sep-after'>
<div class='header-info'>
<h1 class='title'>Mbox Analysis</h1>
</div>
</div>
</header>
<div class='container entry-content'>
<script src="/dataeggs/rmarkdown-libs/htmlwidgets/htmlwidgets.js"></script>
<script src="/dataeggs/rmarkdown-libs/plotly-binding/plotly.js"></script>
<script src="/dataeggs/rmarkdown-libs/typedarray/typedarray.min.js"></script>
<script src="/dataeggs/rmarkdown-libs/jquery/jquery.min.js"></script>
<link href="/dataeggs/rmarkdown-libs/crosstalk/css/crosstalk.css" rel="stylesheet" />
<script src="/dataeggs/rmarkdown-libs/crosstalk/js/crosstalk.min.js"></script>
<link href="/dataeggs/rmarkdown-libs/plotly-htmlwidgets-css/plotly-htmlwidgets.css" rel="stylesheet" />
<script src="/dataeggs/rmarkdown-libs/plotly-main/plotly-latest.min.js"></script>
<script src="/dataeggs/rmarkdown-libs/htmlwidgets/htmlwidgets.js"></script>
<script src="/dataeggs/rmarkdown-libs/plotly-binding/plotly.js"></script>
<script src="/dataeggs/rmarkdown-libs/typedarray/typedarray.min.js"></script>
<script src="/dataeggs/rmarkdown-libs/jquery/jquery.min.js"></script>
<link href="/dataeggs/rmarkdown-libs/crosstalk/css/crosstalk.css" rel="stylesheet" />
<script src="/dataeggs/rmarkdown-libs/crosstalk/js/crosstalk.min.js"></script>
<link href="/dataeggs/rmarkdown-libs/plotly-htmlwidgets-css/plotly-htmlwidgets.css" rel="stylesheet" />
<script src="/dataeggs/rmarkdown-libs/plotly-main/plotly-latest.min.js"></script>
<h2 id="about-this-dataset">About this dataset</h2>
<p>This dataset is a dump of all posts sent on all mailing lists hosted at the Eclipse Forge. Although this is public data (the mailing lists can be browsed on the <a href="https://accounts.eclipse.org/mailing-list">official mailman page</a>) all data has been anonymised to prevent any misuse. The privacy issues identified, along with the anonymisation process, have been covered in a <a href="../../privacy/">dedicated document</a>.</p>
<p>These files are published under the <a href="https://creativecommons.org/licenses/by-sa/4.0/">Creative Commons BY-Attribution-Share Alike 4.0 (International) licence</a>.</p>
<p>The dataset is composed of two parts:</p>
<ul>
<li><strong>eclipse_mls_full.csv</strong> contains an extract of all the messages exchanged on the various mailing lists. The present document uses this CSV as input data.</li>
<li>The <strong>full list of mboxes</strong>, one file per mailing list. They are listed in the <a href="../#project-mboxes">dataset main page</a> and can be downloaded directly from the <a href="../mboxes/">mboxes subdirectory</a>.</li>
</ul>
<p>All of them are updated weekly at 2am on Sunday.</p>
<h2 id="privacy-concerns">Privacy concerns</h2>
<p>We value privacy and intend to make everything we can to prevent misuse of the dataset. If you think we failed somewhere in the process, please <a href="mailto:boris@chrysalice.org">let us know</a> so we can do better.</p>
<p>All personally identifiable information has been scrambled using the <a href="https://github.com/borisbaldassari/data-anonymiser">data anonymiser</a> Perl module. As a result there is <strong>no clear email address</strong> in this dataset, <strong>nor any UUID or name</strong>. However all identical information produces the same encrypted string, which means that one can still identify identical data without knowing what it actually is. As an example email addresses are split (name, company) and encoded separately, which enables one to e.g. identify posters from the same company without knowing the company.</p>
<p>The anonymisation technique used basically encrypts information and then throws away the private key. Please refer to the <a href="https://github.com/borisbaldassari/data-anonymiser">documentation published on github</a> for more details.</p>
<h2 id="about-this-document">About this document</h2>
<p>This document is a <a href="http://rmarkdown.rstudio.com">R Markdown document</a> and is composed of both text (like this one) and dynamically computed information (mostly in the sections below) executed on the data itself. This ensures that the documentation is always synchronised with the data, and serves as a test suite for the dataset.</p>
<h2 id="basic-summary">Basic summary</h2>
<ul>
<li><strong>Generated date</strong>: Sun May 23 04:57:44 2021</li>
<li><strong>First date</strong>: 2001-11-05 19:14:58</li>
<li><strong>Last date</strong>: 2021-05-22 18:14:29</li>
<li><strong>Number of posts</strong>: 684759</li>
<li><strong>Number of attributes</strong>: 7</li>
</ul>
<h1 id="structure-of-data">Structure of data</h1>
<p>This dataset is composed of a single big CSV file. Attributes are: <code>list, messageid, subject, sent_at, sender_name, sender_addr</code>.</p>
<p>Examples are provided at the end of this file to demonstrate how to use it in R.</p>
<h2 id="list">list</h2>
<ul>
<li>Description: The mailing list and project of the post.</li>
<li>Type: String</li>
</ul>
<p>Examples:</p>
<table>
<caption>
(\#tab:list.sample)Sample of list names
</caption>
<thead>
<tr>
<th style="text-align:left;">
Project list names
</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left;">
tinydtls-dev
</td>
</tr>
<tr>
<td style="text-align:left;">
dsdp-mtj-dev
</td>
</tr>
<tr>
<td style="text-align:left;">
cloud-dev
</td>
</tr>
<tr>
<td style="text-align:left;">
alf-events
</td>
</tr>
<tr>
<td style="text-align:left;">
aspectj-users
</td>
</tr>
</tbody>
</table>
<h2 id="messageid">messageId</h2>
<ul>
<li>Description: A unique identifier for the post.</li>
<li>Type: String (Scrambled Base64)</li>
</ul>
<p>Examples:</p>
<table>
<caption>
(\#tab:messageid.sample)Sample of message IDs
</caption>
<thead>
<tr>
<th style="text-align:left;">
Message ID
</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left;">
I5jLJ0vBbysuWNlS@p7FfhSjmi1K1cCsy
</td>
</tr>
<tr>
<td style="text-align:left;">
Mpx07qatRf5Qb33G@aeYqzii8bNGD16jk
</td>
</tr>
<tr>
<td style="text-align:left;">
e6GjLvIei3izOXE7@X/Oz8tNAh0X6ljKo
</td>
</tr>
<tr>
<td style="text-align:left;">
d6Pl+7jA1c1+dSEF@KSDcE+JE/NIopp4C
</td>
</tr>
<tr>
<td style="text-align:left;">
Ui6ZJD3sOK3mSQUb@U/yV8B15rf/qhaYX
</td>
</tr>
</tbody>
</table>
<h2 id="subject">Subject</h2>
<ul>
<li>Description: The subject of the post as sent on the mailing list.</li>
<li>Type: String</li>
</ul>
<p>Examples:</p>
<table>
<caption>
(\#tab:subject.sample)Sample of email subjects
</caption>
<thead>
<tr>
<th style="text-align:left;">
Subject
</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left;">
\[microprofile-dev\] Build failed in Jenkins: Health-maven-snapshots \#807
</td>
</tr>
<tr>
<td style="text-align:left;">
\[platform-releng-dev\] 4.12.0 I-Build: I20190501-1800: 6 failures from ep412I-unit-cen64-gtk3-java12
</td>
</tr>
<tr>
<td style="text-align:left;">
\[orion-dev\] “open resource” is now bound to “T” on all pages
</td>
</tr>
<tr>
<td style="text-align:left;">
\[virgo-build\] Hudson build is back to normal : virgo.snaps.snapshot \#694
</td>
</tr>
<tr>
<td style="text-align:left;">
RE: \[cdt-patch\] Fix for CDT MBS bugzilla \#80185
</td>
</tr>
</tbody>
</table>
<h2 id="sent-at">Sent at</h2>
<ul>
<li>Description: The time of sending for the post.</li>
<li>Type: Date (ISO 8601)</li>
</ul>
<p>Main characteristics:</p>
<ul>
<li><strong>First date</strong>: 2001-11-05 19:14:58</li>
<li><strong>Last date</strong>: 2021-05-22 18:14:29</li>
</ul>
<p>Examples:</p>
<table>
<caption>
(\#tab:sentat.sample)Sample of sent dates
</caption>
<thead>
<tr>
<th style="text-align:left;">
Sent date
</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left;">
2014-04-08 20:24:02
</td>
</tr>
<tr>
<td style="text-align:left;">
2011-05-19 17:07:33
</td>
</tr>
<tr>
<td style="text-align:left;">
2010-04-06 07:12:06
</td>
</tr>
<tr>
<td style="text-align:left;">
2014-04-20 09:34:49
</td>
</tr>
<tr>
<td style="text-align:left;">
2012-09-05 13:21:20
</td>
</tr>
</tbody>
</table>
<h2 id="sender-name">Sender name</h2>
<ul>
<li>Description: The name of the sender of the post.</li>
<li>Type: String (Scrambled Base64)</li>
<li>Number of unique entries: 24364</li>
</ul>
<p>Examples:</p>
<table>
<caption>
(\#tab:sendername.sample)Sample of sender names
</caption>
<thead>
<tr>
<th style="text-align:left;">
Sender names
</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left;">
dhgike1/s9Hlmf07
</td>
</tr>
<tr>
<td style="text-align:left;">
CADIMQDifCp18gyX
</td>
</tr>
<tr>
<td style="text-align:left;">
WSDuEyQjQ62f8Oui
</td>
</tr>
<tr>
<td style="text-align:left;">
jtlEFf6iqBCHOWkb
</td>
</tr>
<tr>
<td style="text-align:left;">
piiX5VyKpzNEjKHJ
</td>
</tr>
</tbody>
</table>
<p>Note: A single name repeated several times will always result in the same scrambled ID. This way it is possible to identify same-author posts without actually knowing the name of the sender.</p>
<h2 id="sender-address">Sender address</h2>
<ul>
<li>Description: The email address of the sender, encoded.</li>
<li>Type: String (Scrambled Base64)</li>
<li>Number of unique entries: 24710</li>
</ul>
<p>Examples:</p>
<table>
<caption>
(\#tab:senderaddr.sample)Sample of sender addresses
</caption>
<thead>
<tr>
<th style="text-align:left;">
Sender addresses
</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left;">
Z/95Hx/ABipA+JEs@U/yV8B15rf/qhaYX
</td>
</tr>
<tr>
<td style="text-align:left;">
blMwSTvAMXIKh7w/(**XXq/4x4pQnv5SyJL?**)
</td>
</tr>
<tr>
<td style="text-align:left;">
sB6QZ8mXdbvy/Sxc@l2fF8D1T4c01keMG
</td>
</tr>
<tr>
<td style="text-align:left;">
rZQYZF414P1TBkbL@XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
tHZTzZqYlfpeYmAf@Tos4yebGV9Eoeo2I
</td>
</tr>
</tbody>
</table>
<p>Note: A single email address repeated several times will always result in the same scrambled email address. Furthermore both parts of the email (name, company) are individually scrambled, which means that one can identify email addresses from the same company without actually knowing the real company or name of the sender.</p>
<h1 id="using-the-dataset">Using the dataset</h1>
<h2 id="reading-csv-file">Reading CSV file</h2>
<p>Reading file from eclipse_mls_full.csv.</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r">project.csv <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">read.csv</span>(file.in, header<span style="color:#f92672">=</span>T)
</code></pre></div><p>We add a column for the Company, which we extract from the email address (i.e. the domain name):</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r">project.csv<span style="color:#f92672">$</span>Company <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">substr</span>(x <span style="color:#f92672">=</span> project.csv<span style="color:#f92672">$</span>sender_addr, <span style="color:#ae81ff">18</span>, <span style="color:#ae81ff">33</span>)
</code></pre></div><p>Number of columns in this dataset:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r"><span style="color:#a6e22e">ncol</span>(project.csv)
</code></pre></div><pre><code>## [1] 7
</code></pre>
<p>Number of entries in this dataset:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r"><span style="color:#a6e22e">nrow</span>(project.csv)
</code></pre></div><pre><code>## [1] 684759
</code></pre>
<p>Names of columns:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r"><span style="color:#a6e22e">names</span>(project.csv)
</code></pre></div><pre><code>## [1] &quot;list&quot; &quot;messageid&quot; &quot;subject&quot; &quot;sent_at&quot; &quot;sender_name&quot;
## [6] &quot;sender_addr&quot; &quot;Company&quot;
</code></pre>
<h2 id="using-time-series-xts">Using time series (xts)</h2>
<p>The dataset needs to be converted to a <code>xts</code> object. We can use the <code>sent_at</code> attribute as a time index.</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r"><span style="color:#a6e22e">require</span>(xts)
project.xts <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">xts</span>(x <span style="color:#f92672">=</span> project.csv, order.by <span style="color:#f92672">=</span> <span style="color:#a6e22e">parse_iso_8601</span>(project.csv<span style="color:#f92672">$</span>sent_at))
</code></pre></div><h2 id="plotting-number-of-monthly-posts">Plotting number of monthly posts</h2>
<p>When considering the timeline of the dataset, it can be misleading when there several submissions on a short period of time, compared to sparse time ranges. We’ll use the <code>apply.monthly</code> function from <code>xts</code> to normalise the total number of monthly submissions.</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r">project.monthly <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">apply.monthly</span>(x<span style="color:#f92672">=</span>project.xts<span style="color:#f92672">$</span>sent_at, FUN<span style="color:#f92672">=</span>nrow)
<span style="color:#a6e22e">autoplot</span>(project.monthly, geom<span style="color:#f92672">=</span><span style="color:#e6db74">&#39;line&#39;</span>) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">theme_minimal</span>() <span style="color:#f92672">+</span> <span style="color:#a6e22e">ylab</span>(<span style="color:#e6db74">&#34;Number of posts&#34;</span>) <span style="color:#f92672">+</span> <span style="color:#a6e22e">xlab</span>(<span style="color:#e6db74">&#34;Time&#34;</span>) <span style="color:#f92672">+</span> <span style="color:#a6e22e">ggtitle</span>(<span style="color:#e6db74">&#34;Number of monthly posts&#34;</span>)
</code></pre></div><p><img src="/dataeggs/eclipse_mls/mbox_csv_analysis_files/figure-html/examples.xts.plot-1.png" width="672" /></p>
<h2 id="plotting-number-of-monthly-reporters">Plotting number of monthly reporters</h2>
<p>One author can post several emails on the mailing list. Let’s plot the monthly number of distinct authors on the mailing list. For this we need to count the number of unique occurrences of the email address (attribute <code>sender_attr</code>).</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r">count_unique <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">function</span>(x) { <span style="color:#a6e22e">length</span>(<span style="color:#a6e22e">unique</span>(x)) }
project.monthly <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">apply.monthly</span>(x<span style="color:#f92672">=</span>project.xts<span style="color:#f92672">$</span>sender_addr, FUN<span style="color:#f92672">=</span>count_unique)
<span style="color:#a6e22e">autoplot</span>(project.monthly, geom<span style="color:#f92672">=</span><span style="color:#e6db74">&#39;line&#39;</span>) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">theme_minimal</span>() <span style="color:#f92672">+</span> <span style="color:#a6e22e">ylab</span>(<span style="color:#e6db74">&#34;Number of authors&#34;</span>) <span style="color:#f92672">+</span> <span style="color:#a6e22e">xlab</span>(<span style="color:#e6db74">&#34;Time&#34;</span>) <span style="color:#f92672">+</span> <span style="color:#a6e22e">ggtitle</span>(<span style="color:#e6db74">&#34;Number of monthly distinct authors&#34;</span>)
</code></pre></div><p><img src="/dataeggs/eclipse_mls/mbox_csv_analysis_files/figure-html/xts.monthly.reporters-1.png" width="672" /></p>
<h2 id="plotting-activity-of-authors">Plotting activity of authors</h2>
<p>We want to plot the number of emails sent by each author regardless of the mailing list they were sent on. We display only the 10 top posters:</p>
<table>
<caption>
(\#tab:reporters.sample)Top 10 senders on mailing lists
</caption>
<thead>
<tr>
<th style="text-align:left;">
Sender address
</th>
<th style="text-align:right;">
Number of posts
</th>
<th style="text-align:left;">
Company
</th>
</tr>
</thead>
<tbody>
<tr>
<td style="text-align:left;">
ojtwVo+v2ZZi9I/d@XXq/4x4pQnv5SyJL
</td>
<td style="text-align:right;">
38007
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
uVEUf/DDjKHwW02k@XXq/4x4pQnv5SyJL
</td>
<td style="text-align:right;">
19956
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
oT7WcdIqjfiVTwiH@XXq/4x4pQnv5SyJL
</td>
<td style="text-align:right;">
15720
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
jX19wAV/H1/9xdfl@XXq/4x4pQnv5SyJL
</td>
<td style="text-align:right;">
9889
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
blMwSTvAMXIKh7w/(**XXq/4x4pQnv5SyJL?**)
</td>
<td style="text-align:right;">
8828
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
NfM9V7FChHtIKXPC@p7FfhSjmi1K1cCsy
</td>
<td style="text-align:right;">
8428
</td>
<td style="text-align:left;">
p7FfhSjmi1K1cCsy
</td>
</tr>
<tr>
<td style="text-align:left;">
FmeVKsho+S4tiQJb@XXq/4x4pQnv5SyJL
</td>
<td style="text-align:right;">
6969
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
tKzZzh64XMTzGaDY@XXq/4x4pQnv5SyJL
</td>
<td style="text-align:right;">
5327
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
O+IcZVRKqMVdAek1@XXq/4x4pQnv5SyJL
</td>
<td style="text-align:right;">
5012
</td>
<td style="text-align:left;">
XXq/4x4pQnv5SyJL
</td>
</tr>
<tr>
<td style="text-align:left;">
tHqj5uKwK8gpgsPJ@U/yV8B15rf/qhaYX
</td>
<td style="text-align:right;">
4945
</td>
<td style="text-align:left;">
U/yV8B15rf/qhaYX
</td>
</tr>
</tbody>
</table>
<p>Now plot these 50 top posters with ggplot and use the company (i.e. second part of the email address) for the colour:</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r">authors.subset <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">head</span>( authors, n <span style="color:#f92672">=</span> n)
authors.subset.df <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">as.data.frame</span>(authors.subset)
<span style="color:#a6e22e">names</span>(authors.subset.df) <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">c</span>(<span style="color:#e6db74">&#39;ID&#39;</span>, <span style="color:#e6db74">&#39;Posts&#39;</span>)
authors.subset.df<span style="color:#f92672">$</span>Author <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">substr</span>(x <span style="color:#f92672">=</span> authors.subset.df<span style="color:#f92672">$</span>ID, <span style="color:#ae81ff">1</span>, <span style="color:#ae81ff">16</span>)
authors.subset.df<span style="color:#f92672">$</span>Company <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">substr</span>(x <span style="color:#f92672">=</span> authors.subset.df<span style="color:#f92672">$</span>ID, <span style="color:#ae81ff">18</span>, <span style="color:#ae81ff">33</span>)
p <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">ggplot</span>(data<span style="color:#f92672">=</span>authors.subset.df, <span style="color:#a6e22e">aes</span>(x<span style="color:#f92672">=</span><span style="color:#a6e22e">reorder</span>(Author, <span style="color:#f92672">-</span>Posts), y <span style="color:#f92672">=</span> Posts, fill <span style="color:#f92672">=</span> Company)) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">geom_bar</span>(stat<span style="color:#f92672">=</span><span style="color:#e6db74">&#34;identity&#34;</span>) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">theme_minimal</span>() <span style="color:#f92672">+</span> <span style="color:#a6e22e">ylab</span>(<span style="color:#e6db74">&#34;Number of posts&#34;</span>) <span style="color:#f92672">+</span> <span style="color:#a6e22e">xlab</span>(<span style="color:#e6db74">&#39;Posters&#39;</span>) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">ggtitle</span>(<span style="color:#a6e22e">paste</span>(n, <span style="color:#e6db74">&#34; overall top posters on Eclipse mailing lists&#34;</span>, sep<span style="color:#f92672">=</span><span style="color:#e6db74">&#34;&#34;</span>)) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">theme</span>( axis.text.x <span style="color:#f92672">=</span> <span style="color:#a6e22e">element_text</span>(angle<span style="color:#f92672">=</span><span style="color:#ae81ff">60</span>, size <span style="color:#f92672">=</span> <span style="color:#ae81ff">7</span>, hjust <span style="color:#f92672">=</span> <span style="color:#ae81ff">1</span>))
g <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">ggplotly</span>(p)
g
</code></pre></div><div id="htmlwidget-1" style="width:672px;height:480px;" class="plotly html-widget"></div>
<script type="application/json" data-for="htmlwidget-1">{"x":{"data":[{"orientation":"v","width":[0.900000000000006,0.900000000000006],"base":[0,0],"x":[46,49],"y":[1908,1782],"text":["reorder(Author, -Posts): WTwaqvbVPH7qhdci<br />Posts: 1908<br />Company: aMKlWkfBM3/S0K/4","reorder(Author, -Posts): K9Kq8hVteztamdkM<br />Posts: 1782<br />Company: aMKlWkfBM3/S0K/4"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(248,118,109,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"aMKlWkfBM3/S0K/4","legendgroup":"aMKlWkfBM3/S0K/4","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[38],"y":[2263],"text":"reorder(Author, -Posts): V+ec77IR1R50w7F0<br />Posts: 2263<br />Company: CmDjQQCMhSoZhbXW","type":"bar","marker":{"autocolorscale":false,"color":"rgba(237,129,62,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"CmDjQQCMhSoZhbXW","legendgroup":"CmDjQQCMhSoZhbXW","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[28],"y":[2637],"text":"reorder(Author, -Posts): dE45pqVHx0u/qqNK<br />Posts: 2637<br />Company: CPf4ybvCnvOAY6O4","type":"bar","marker":{"autocolorscale":false,"color":"rgba(222,140,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"CPf4ybvCnvOAY6O4","legendgroup":"CPf4ybvCnvOAY6O4","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[18],"y":[3801],"text":"reorder(Author, -Posts): ODPKcbYVJErWkDj+<br />Posts: 3801<br />Company: KfzP7SfGKkAPVzsX","type":"bar","marker":{"autocolorscale":false,"color":"rgba(205,150,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"KfzP7SfGKkAPVzsX","legendgroup":"KfzP7SfGKkAPVzsX","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[45],"y":[1921],"text":"reorder(Author, -Posts): sB6QZ8mXdbvy/Sxc<br />Posts: 1921<br />Company: l2fF8D1T4c01keMG","type":"bar","marker":{"autocolorscale":false,"color":"rgba(183,159,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"l2fF8D1T4c01keMG","legendgroup":"l2fF8D1T4c01keMG","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[19],"y":[3595],"text":"reorder(Author, -Posts): pn9ooZUfHzlhszm+<br />Posts: 3595<br />Company: LB/neluuDC8qgd6k","type":"bar","marker":{"autocolorscale":false,"color":"rgba(157,167,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"LB/neluuDC8qgd6k","legendgroup":"LB/neluuDC8qgd6k","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[41],"y":[2156],"text":"reorder(Author, -Posts): heyNZxXi8e70C/ye<br />Posts: 2156<br />Company: mZJO2XF7OZ29Bd9s","type":"bar","marker":{"autocolorscale":false,"color":"rgba(124,174,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"mZJO2XF7OZ29Bd9s","legendgroup":"mZJO2XF7OZ29Bd9s","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[39],"y":[2201],"text":"reorder(Author, -Posts): pL1A8MDz4ZHMHf7u<br />Posts: 2201<br />Company: o08PtRL4VOy89OEn","type":"bar","marker":{"autocolorscale":false,"color":"rgba(73,181,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"o08PtRL4VOy89OEn","legendgroup":"o08PtRL4VOy89OEn","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[20],"y":[3539],"text":"reorder(Author, -Posts): kqqwmXxzYd2ztxhO<br />Posts: 3539<br />Company: OtxrBMsOX+C/id8n","type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,186,56,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"OtxrBMsOX+C/id8n","legendgroup":"OtxrBMsOX+C/id8n","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.899999999999999,0.900000000000006],"base":[0,0,0],"x":[5,29,47],"y":[8428,2634,1902],"text":["reorder(Author, -Posts): NfM9V7FChHtIKXPC<br />Posts: 8428<br />Company: p7FfhSjmi1K1cCsy","reorder(Author, -Posts): aKBYHaPjoWiGJkta<br />Posts: 2634<br />Company: p7FfhSjmi1K1cCsy","reorder(Author, -Posts): hNboYEFnN+sS0n5m<br />Posts: 1902<br />Company: p7FfhSjmi1K1cCsy"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,190,103,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"p7FfhSjmi1K1cCsy","legendgroup":"p7FfhSjmi1K1cCsy","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[37],"y":[2269],"text":"reorder(Author, -Posts): U4DC+IoHHASnw0yg<br />Posts: 2269<br />Company: qcj3hNCC+rWXSs1U","type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,192,139,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"qcj3hNCC+rWXSs1U","legendgroup":"qcj3hNCC+rWXSs1U","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.899999999999999,0.899999999999999],"base":[0,0],"x":[10,24],"y":[4945,3121],"text":["reorder(Author, -Posts): tHqj5uKwK8gpgsPJ<br />Posts: 4945<br />Company: U/yV8B15rf/qhaYX","reorder(Author, -Posts): cFBlz/bz8XfgeNC1<br />Posts: 3121<br />Company: U/yV8B15rf/qhaYX"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,193,169,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"U/yV8B15rf/qhaYX","legendgroup":"U/yV8B15rf/qhaYX","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[40],"y":[2196],"text":"reorder(Author, -Posts): Cdo4mjjhKOMXcb+C<br />Posts: 2196<br />Company: UbUgWbC4rn7rd7TY","type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,191,196,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"UbUgWbC4rn7rd7TY","legendgroup":"UbUgWbC4rn7rd7TY","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[36],"y":[2275],"text":"reorder(Author, -Posts): v+L+u1gJNmhsiIJO<br />Posts: 2275<br />Company: UFdfTcYSqZpL39QZ","type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,187,220,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"UFdfTcYSqZpL39QZ","legendgroup":"UFdfTcYSqZpL39QZ","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[42],"y":[2111],"text":"reorder(Author, -Posts): dX+XpOHeO/abxqPI<br />Posts: 2111<br />Company: upbvRpaU5jEmq8na","type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,180,240,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"upbvRpaU5jEmq8na","legendgroup":"upbvRpaU5jEmq8na","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[16],"y":[4016],"text":"reorder(Author, -Posts): kwVarrUkYKk7ChBA<br />Posts: 4016<br />Company: us4y0oeKhpAMAgvi","type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,169,255,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"us4y0oeKhpAMAgvi","legendgroup":"us4y0oeKhpAMAgvi","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.899999999999999,0.899999999999999,0.899999999999999,0.900000000000006,0.900000000000006],"base":[0,0,0,0,0],"x":[25,27,31,33,44],"y":[2863,2679,2549,2370,1928],"text":["reorder(Author, -Posts): hJQjyPTTPMK5h9I7<br />Posts: 2863<br />Company: vH/XPrDYizaBV+Cg","reorder(Author, -Posts): I9J8pr84c+xn51oX<br />Posts: 2679<br />Company: vH/XPrDYizaBV+Cg","reorder(Author, -Posts): KQSl5b0WSoqyzzm8<br />Posts: 2549<br />Company: vH/XPrDYizaBV+Cg","reorder(Author, -Posts): Ow87clYijo5oVGd2<br />Posts: 2370<br />Company: vH/XPrDYizaBV+Cg","reorder(Author, -Posts): Tclpo5xagL1YVoSK<br />Posts: 1928<br />Company: vH/XPrDYizaBV+Cg"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(97,156,255,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"vH/XPrDYizaBV+Cg","legendgroup":"vH/XPrDYizaBV+Cg","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[35],"y":[2315],"text":"reorder(Author, -Posts): SMl41aX21FmAr2G2<br />Posts: 2315<br />Company: w/whAo1TX1ID3hTl","type":"bar","marker":{"autocolorscale":false,"color":"rgba(159,140,255,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"w/whAo1TX1ID3hTl","legendgroup":"w/whAo1TX1ID3hTl","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[12],"y":[4389],"text":"reorder(Author, -Posts): qjsqCegnjmeITuTk<br />Posts: 4389<br />Company: xNJUwi/CriFmzaXv","type":"bar","marker":{"autocolorscale":false,"color":"rgba(199,124,255,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"xNJUwi/CriFmzaXv","legendgroup":"xNJUwi/CriFmzaXv","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.9,"base":8828,"x":[7],"y":[3354],"text":"reorder(Author, -Posts): blMwSTvAMXIKh7w/<br />Posts: 3354<br />Company: xTaCVMWKHYfTtM8A","type":"bar","marker":{"autocolorscale":false,"color":"rgba(227,110,246,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"xTaCVMWKHYfTtM8A","legendgroup":"xTaCVMWKHYfTtM8A","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[23],"y":[3154],"text":"reorder(Author, -Posts): gCjIceRLeQfD1ZRZ<br />Posts: 3154<br />Company: XTefLoCyKH0NP2Zc","type":"bar","marker":{"autocolorscale":false,"color":"rgba(245,100,227,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"XTefLoCyKH0NP2Zc","legendgroup":"XTefLoCyKH0NP2Zc","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.900000000000002,0.900000000000006,0.900000000000006],"base":[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0],"x":[1,2,3,4,7,6,8,9,13,14,15,17,21,22,26,30,32,34,43],"y":[38007,19956,15720,9889,8828,6969,5327,5012,4287,4252,4146,3912,3530,3209,2807,2578,2409,2342,1942],"text":["reorder(Author, -Posts): ojtwVo+v2ZZi9I/d<br />Posts: 38007<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): uVEUf/DDjKHwW02k<br />Posts: 19956<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): oT7WcdIqjfiVTwiH<br />Posts: 15720<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): jX19wAV/H1/9xdfl<br />Posts: 9889<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): blMwSTvAMXIKh7w/<br />Posts: 8828<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): FmeVKsho+S4tiQJb<br />Posts: 6969<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): tKzZzh64XMTzGaDY<br />Posts: 5327<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): O+IcZVRKqMVdAek1<br />Posts: 5012<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): XadRHoxxXP7L4p9F<br />Posts: 4287<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): iPoU0mMXQko2ei7U<br />Posts: 4252<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): PPiu761j23dBiuSV<br />Posts: 4146<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): rZQYZF414P1TBkbL<br />Posts: 3912<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): IKQi9ZrUwe9WGKbI<br />Posts: 3530<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): LYm2kQHv4qP4q4Du<br />Posts: 3209<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): SJHPhUZmKx69aXzj<br />Posts: 2807<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): oQOqAs9diUvBJZjk<br />Posts: 2578<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): crXqlucQk0DoVfXI<br />Posts: 2409<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): WZDV3Usx+ePoeOH3<br />Posts: 2342<br />Company: XXq/4x4pQnv5SyJL","reorder(Author, -Posts): NPDkJuacOceEi+WO<br />Posts: 1942<br />Company: XXq/4x4pQnv5SyJL"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(255,97,204,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"XXq/4x4pQnv5SyJL","legendgroup":"XXq/4x4pQnv5SyJL","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.899999999999999,"base":0,"x":[11],"y":[4641],"text":"reorder(Author, -Posts): wwHXOq/HLRwjBcdL<br />Posts: 4641<br />Company: YIUpmKVOSlWPXlKy","type":"bar","marker":{"autocolorscale":false,"color":"rgba(255,100,176,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"YIUpmKVOSlWPXlKy","legendgroup":"YIUpmKVOSlWPXlKy","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":0.900000000000006,"base":0,"x":[48],"y":[1860],"text":"reorder(Author, -Posts): t5552lPNTptnkvD/<br />Posts: 1860<br />Company: YYty1pb7CXXRjAGP","type":"bar","marker":{"autocolorscale":false,"color":"rgba(255,108,145,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"YYty1pb7CXXRjAGP","legendgroup":"YYty1pb7CXXRjAGP","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null}],"layout":{"margin":{"t":43.7625570776256,"r":7.30593607305936,"b":40.0568596155048,"l":54.7945205479452},"font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187},"title":{"text":"50 overall top posters on Eclipse mailing lists","font":{"color":"rgba(0,0,0,1)","family":"","size":17.5342465753425},"x":0,"xref":"paper"},"xaxis":{"domain":[0,1],"automargin":true,"type":"linear","autorange":false,"range":[0.4,49.6],"tickmode":"array","ticktext":["ojtwVo+v2ZZi9I/d","uVEUf/DDjKHwW02k","oT7WcdIqjfiVTwiH","jX19wAV/H1/9xdfl","NfM9V7FChHtIKXPC","FmeVKsho+S4tiQJb","blMwSTvAMXIKh7w/","tKzZzh64XMTzGaDY","O+IcZVRKqMVdAek1","tHqj5uKwK8gpgsPJ","wwHXOq/HLRwjBcdL","qjsqCegnjmeITuTk","XadRHoxxXP7L4p9F","iPoU0mMXQko2ei7U","PPiu761j23dBiuSV","kwVarrUkYKk7ChBA","rZQYZF414P1TBkbL","ODPKcbYVJErWkDj+","pn9ooZUfHzlhszm+","kqqwmXxzYd2ztxhO","IKQi9ZrUwe9WGKbI","LYm2kQHv4qP4q4Du","gCjIceRLeQfD1ZRZ","cFBlz/bz8XfgeNC1","hJQjyPTTPMK5h9I7","SJHPhUZmKx69aXzj","I9J8pr84c+xn51oX","dE45pqVHx0u/qqNK","aKBYHaPjoWiGJkta","oQOqAs9diUvBJZjk","KQSl5b0WSoqyzzm8","crXqlucQk0DoVfXI","Ow87clYijo5oVGd2","WZDV3Usx+ePoeOH3","SMl41aX21FmAr2G2","v+L+u1gJNmhsiIJO","U4DC+IoHHASnw0yg","V+ec77IR1R50w7F0","pL1A8MDz4ZHMHf7u","Cdo4mjjhKOMXcb+C","heyNZxXi8e70C/ye","dX+XpOHeO/abxqPI","NPDkJuacOceEi+WO","Tclpo5xagL1YVoSK","sB6QZ8mXdbvy/Sxc","WTwaqvbVPH7qhdci","hNboYEFnN+sS0n5m","t5552lPNTptnkvD/","K9Kq8hVteztamdkM"],"tickvals":[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,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49],"categoryorder":"array","categoryarray":["ojtwVo+v2ZZi9I/d","uVEUf/DDjKHwW02k","oT7WcdIqjfiVTwiH","jX19wAV/H1/9xdfl","NfM9V7FChHtIKXPC","FmeVKsho+S4tiQJb","blMwSTvAMXIKh7w/","tKzZzh64XMTzGaDY","O+IcZVRKqMVdAek1","tHqj5uKwK8gpgsPJ","wwHXOq/HLRwjBcdL","qjsqCegnjmeITuTk","XadRHoxxXP7L4p9F","iPoU0mMXQko2ei7U","PPiu761j23dBiuSV","kwVarrUkYKk7ChBA","rZQYZF414P1TBkbL","ODPKcbYVJErWkDj+","pn9ooZUfHzlhszm+","kqqwmXxzYd2ztxhO","IKQi9ZrUwe9WGKbI","LYm2kQHv4qP4q4Du","gCjIceRLeQfD1ZRZ","cFBlz/bz8XfgeNC1","hJQjyPTTPMK5h9I7","SJHPhUZmKx69aXzj","I9J8pr84c+xn51oX","dE45pqVHx0u/qqNK","aKBYHaPjoWiGJkta","oQOqAs9diUvBJZjk","KQSl5b0WSoqyzzm8","crXqlucQk0DoVfXI","Ow87clYijo5oVGd2","WZDV3Usx+ePoeOH3","SMl41aX21FmAr2G2","v+L+u1gJNmhsiIJO","U4DC+IoHHASnw0yg","V+ec77IR1R50w7F0","pL1A8MDz4ZHMHf7u","Cdo4mjjhKOMXcb+C","heyNZxXi8e70C/ye","dX+XpOHeO/abxqPI","NPDkJuacOceEi+WO","Tclpo5xagL1YVoSK","sB6QZ8mXdbvy/Sxc","WTwaqvbVPH7qhdci","hNboYEFnN+sS0n5m","t5552lPNTptnkvD/","K9Kq8hVteztamdkM"],"nticks":null,"ticks":"","tickcolor":null,"ticklen":3.65296803652968,"tickwidth":0,"showticklabels":true,"tickfont":{"color":"rgba(77,77,77,1)","family":"","size":9.29846409298464},"tickangle":-60,"showline":false,"linecolor":null,"linewidth":0,"showgrid":true,"gridcolor":"rgba(235,235,235,1)","gridwidth":0.66417600664176,"zeroline":false,"anchor":"y","title":{"text":"Posters","font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187}},"hoverformat":".2f"},"yaxis":{"domain":[0,1],"automargin":true,"type":"linear","autorange":false,"range":[-1900.35,39907.35],"tickmode":"array","ticktext":["0","10000","20000","30000"],"tickvals":[0,10000,20000,30000],"categoryorder":"array","categoryarray":["0","10000","20000","30000"],"nticks":null,"ticks":"","tickcolor":null,"ticklen":3.65296803652968,"tickwidth":0,"showticklabels":true,"tickfont":{"color":"rgba(77,77,77,1)","family":"","size":11.689497716895},"tickangle":-0,"showline":false,"linecolor":null,"linewidth":0,"showgrid":true,"gridcolor":"rgba(235,235,235,1)","gridwidth":0.66417600664176,"zeroline":false,"anchor":"x","title":{"text":"Number of posts","font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187}},"hoverformat":".2f"},"shapes":[{"type":"rect","fillcolor":null,"line":{"color":null,"width":0,"linetype":[]},"yref":"paper","xref":"paper","x0":0,"x1":1,"y0":0,"y1":1}],"showlegend":true,"legend":{"bgcolor":null,"bordercolor":null,"borderwidth":0,"font":{"color":"rgba(0,0,0,1)","family":"","size":11.689497716895},"y":0.96751968503937},"annotations":[{"text":"Company","x":1.02,"y":1,"showarrow":false,"ax":0,"ay":0,"font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187},"xref":"paper","yref":"paper","textangle":-0,"xanchor":"left","yanchor":"bottom","legendTitle":true}],"hovermode":"closest","barmode":"relative"},"config":{"doubleClick":"reset","showSendToCloud":false},"source":"A","attrs":{"33f33e8b0ca5":{"x":{},"y":{},"fill":{},"type":"bar"}},"cur_data":"33f33e8b0ca5","visdat":{"33f33e8b0ca5":["function (y) ","x"]},"highlight":{"on":"plotly_click","persistent":false,"dynamic":false,"selectize":false,"opacityDim":0.2,"selected":{"opacity":1},"debounce":0},"shinyEvents":["plotly_hover","plotly_click","plotly_selected","plotly_relayout","plotly_brushed","plotly_brushing","plotly_clickannotation","plotly_doubleclick","plotly_deselect","plotly_afterplot","plotly_sunburstclick"],"base_url":"https://plot.ly"},"evals":[],"jsHooks":[]}</script>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r"><span style="color:#75715e">#api_create(g, filename = &#34;r-eclipse_mls_authors&#34;)</span>
</code></pre></div><h2 id="posts-by-company">Posts by Company</h2>
<p>We want to know what companies posted the most messages in mailing listsacross years. To that end we select the 20 companies that have the larger number of posts and plot the number of messages by company year after year.</p>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r">comps_list <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">head</span>( <span style="color:#a6e22e">sort</span>( x <span style="color:#f92672">=</span> <span style="color:#a6e22e">table</span>(project.csv<span style="color:#f92672">$</span>Company), decreasing <span style="color:#f92672">=</span> T ), n<span style="color:#f92672">=</span><span style="color:#ae81ff">20</span> )
df <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">data.frame</span>(Company<span style="color:#f92672">=</span><span style="color:#a6e22e">character</span>(),
Year<span style="color:#f92672">=</span><span style="color:#a6e22e">character</span>(),
Posts<span style="color:#f92672">=</span><span style="color:#a6e22e">integer</span>(),
stringsAsFactors<span style="color:#f92672">=</span><span style="color:#66d9ef">FALSE</span>)
<span style="color:#a6e22e">for </span>(i in <span style="color:#a6e22e">seq_along</span>(<span style="color:#ae81ff">1</span><span style="color:#f92672">:</span><span style="color:#ae81ff">20</span>)) {
project.comp.xts <span style="color:#f92672">&lt;-</span> project.xts[project.xts<span style="color:#f92672">$</span>Company <span style="color:#f92672">==</span> <span style="color:#a6e22e">names</span>(comps_list)[[i]],]
project.comp.yearly <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">apply.yearly</span>(x<span style="color:#f92672">=</span>project.comp.xts<span style="color:#f92672">$</span>Company, FUN<span style="color:#f92672">=</span>nrow)
<span style="color:#a6e22e">for </span>(j in <span style="color:#a6e22e">seq_along</span>(<span style="color:#ae81ff">1</span><span style="color:#f92672">:</span><span style="color:#a6e22e">nrow</span>(project.comp.yearly))) {
year <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">format</span>(<span style="color:#a6e22e">index</span>(project.comp.yearly)[[j]],<span style="color:#e6db74">&#34;%Y&#34;</span>)
comp <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">as.data.frame</span>(<span style="color:#a6e22e">t</span>(<span style="color:#a6e22e">c</span>(<span style="color:#a6e22e">names</span>(comps_list)[[i]], year, <span style="color:#a6e22e">as.integer</span>(project.comp.yearly[[j]]))))
<span style="color:#a6e22e">names</span>(comp) <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">c</span>(<span style="color:#e6db74">&#34;Company&#34;</span>, <span style="color:#e6db74">&#34;Year&#34;</span>, <span style="color:#e6db74">&#34;Posts&#34;</span>)
df <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">rbind</span>(df, comp)
}
}
df<span style="color:#f92672">$</span>Company <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">as.character</span>(df<span style="color:#f92672">$</span>Company)
df <span style="color:#f92672">&lt;-</span> df<span style="color:#a6e22e">[order</span>(df<span style="color:#f92672">$</span>Company),]
p <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">ggplot</span>(data<span style="color:#f92672">=</span>df, <span style="color:#a6e22e">aes</span>(x<span style="color:#f92672">=</span>Year, y <span style="color:#f92672">=</span> Posts, fill <span style="color:#f92672">=</span> Company)) <span style="color:#f92672">+</span> <span style="color:#a6e22e">geom_bar</span>(stat<span style="color:#f92672">=</span><span style="color:#e6db74">&#34;identity&#34;</span>) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">theme_minimal</span>() <span style="color:#f92672">+</span> <span style="color:#a6e22e">ylab</span>(<span style="color:#e6db74">&#34;Number of posts&#34;</span>) <span style="color:#f92672">+</span> <span style="color:#a6e22e">xlab</span>(<span style="color:#e6db74">&#39;Years&#39;</span>) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">ggtitle</span>(<span style="color:#e6db74">&#34;Top 20 Companies involved in Eclipse mailing lists across years&#34;</span>) <span style="color:#f92672">+</span>
<span style="color:#a6e22e">theme</span>( axis.text.x <span style="color:#f92672">=</span> <span style="color:#a6e22e">element_text</span>(angle<span style="color:#f92672">=</span><span style="color:#ae81ff">60</span>, size <span style="color:#f92672">=</span> <span style="color:#ae81ff">7</span>, hjust <span style="color:#f92672">=</span> <span style="color:#ae81ff">1</span>))
g <span style="color:#f92672">&lt;-</span> <span style="color:#a6e22e">ggplotly</span>(p)
g
</code></pre></div><div id="htmlwidget-2" style="width:672px;height:480px;" class="plotly html-widget"></div>
<script type="application/json" data-for="htmlwidget-2">{"x":{"data":[{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1019,1290,883,1700,2002,1297,1130,860,1112,1325,1343,1860],"x":[5,6,7,8,9,10,11,12,13,14,15,16],"y":[172,173,174,162,126,175,176,177,178,179,180,131],"text":["Year: 2005<br />Posts: 172<br />Company: aMKlWkfBM3/S0K/4","Year: 2006<br />Posts: 173<br />Company: aMKlWkfBM3/S0K/4","Year: 2007<br />Posts: 174<br />Company: aMKlWkfBM3/S0K/4","Year: 2008<br />Posts: 162<br />Company: aMKlWkfBM3/S0K/4","Year: 2009<br />Posts: 126<br />Company: aMKlWkfBM3/S0K/4","Year: 2010<br />Posts: 175<br />Company: aMKlWkfBM3/S0K/4","Year: 2011<br />Posts: 176<br />Company: aMKlWkfBM3/S0K/4","Year: 2012<br />Posts: 177<br />Company: aMKlWkfBM3/S0K/4","Year: 2013<br />Posts: 178<br />Company: aMKlWkfBM3/S0K/4","Year: 2014<br />Posts: 179<br />Company: aMKlWkfBM3/S0K/4","Year: 2015<br />Posts: 180<br />Company: aMKlWkfBM3/S0K/4","Year: 2016<br />Posts: 131<br />Company: aMKlWkfBM3/S0K/4"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(248,118,109,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"aMKlWkfBM3/S0K/4","legendgroup":"aMKlWkfBM3/S0K/4","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[920,1379,1158,1162,920,937,666,917,1129,960,1377,932,683,1176,747,485],"x":[6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[189,154,190,191,192,193,194,195,196,197,175,198,199,200,201,202],"text":["Year: 2006<br />Posts: 189<br />Company: bHaWiLS2OaFHryiE","Year: 2007<br />Posts: 154<br />Company: bHaWiLS2OaFHryiE","Year: 2008<br />Posts: 190<br />Company: bHaWiLS2OaFHryiE","Year: 2009<br />Posts: 191<br />Company: bHaWiLS2OaFHryiE","Year: 2010<br />Posts: 192<br />Company: bHaWiLS2OaFHryiE","Year: 2011<br />Posts: 193<br />Company: bHaWiLS2OaFHryiE","Year: 2012<br />Posts: 194<br />Company: bHaWiLS2OaFHryiE","Year: 2013<br />Posts: 195<br />Company: bHaWiLS2OaFHryiE","Year: 2014<br />Posts: 196<br />Company: bHaWiLS2OaFHryiE","Year: 2015<br />Posts: 197<br />Company: bHaWiLS2OaFHryiE","Year: 2016<br />Posts: 175<br />Company: bHaWiLS2OaFHryiE","Year: 2017<br />Posts: 198<br />Company: bHaWiLS2OaFHryiE","Year: 2018<br />Posts: 199<br />Company: bHaWiLS2OaFHryiE","Year: 2019<br />Posts: 200<br />Company: bHaWiLS2OaFHryiE","Year: 2020<br />Posts: 201<br />Company: bHaWiLS2OaFHryiE","Year: 2021<br />Posts: 202<br />Company: bHaWiLS2OaFHryiE"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(234,131,49,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"bHaWiLS2OaFHryiE","legendgroup":"bHaWiLS2OaFHryiE","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[242,498,1683,734,736,492,507,234,483,485,2252,751,491,240,504,517,254],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[217,218,143,219,220,221,222,223,224,225,51,226,227,228,229,230,231],"text":["Year: 2005<br />Posts: 217<br />Company: JqNFSdLjOCBruzUE","Year: 2006<br />Posts: 218<br />Company: JqNFSdLjOCBruzUE","Year: 2007<br />Posts: 143<br />Company: JqNFSdLjOCBruzUE","Year: 2008<br />Posts: 219<br />Company: JqNFSdLjOCBruzUE","Year: 2009<br />Posts: 220<br />Company: JqNFSdLjOCBruzUE","Year: 2010<br />Posts: 221<br />Company: JqNFSdLjOCBruzUE","Year: 2011<br />Posts: 222<br />Company: JqNFSdLjOCBruzUE","Year: 2012<br />Posts: 223<br />Company: JqNFSdLjOCBruzUE","Year: 2013<br />Posts: 224<br />Company: JqNFSdLjOCBruzUE","Year: 2014<br />Posts: 225<br />Company: JqNFSdLjOCBruzUE","Year: 2015<br />Posts: 51<br />Company: JqNFSdLjOCBruzUE","Year: 2016<br />Posts: 226<br />Company: JqNFSdLjOCBruzUE","Year: 2017<br />Posts: 227<br />Company: JqNFSdLjOCBruzUE","Year: 2018<br />Posts: 228<br />Company: JqNFSdLjOCBruzUE","Year: 2019<br />Posts: 229<br />Company: JqNFSdLjOCBruzUE","Year: 2020<br />Posts: 230<br />Company: JqNFSdLjOCBruzUE","Year: 2021<br />Posts: 231<br />Company: JqNFSdLjOCBruzUE"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(216,144,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"JqNFSdLjOCBruzUE","legendgroup":"JqNFSdLjOCBruzUE","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[459,716,500,953,956,713,729,457,707,710,748,977,718,468,960,948],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20],"y":[203,204,201,205,206,207,208,209,210,211,212,213,214,215,216,190],"text":["Year: 2005<br />Posts: 203<br />Company: KfzP7SfGKkAPVzsX","Year: 2006<br />Posts: 204<br />Company: KfzP7SfGKkAPVzsX","Year: 2007<br />Posts: 201<br />Company: KfzP7SfGKkAPVzsX","Year: 2008<br />Posts: 205<br />Company: KfzP7SfGKkAPVzsX","Year: 2009<br />Posts: 206<br />Company: KfzP7SfGKkAPVzsX","Year: 2010<br />Posts: 207<br />Company: KfzP7SfGKkAPVzsX","Year: 2011<br />Posts: 208<br />Company: KfzP7SfGKkAPVzsX","Year: 2012<br />Posts: 209<br />Company: KfzP7SfGKkAPVzsX","Year: 2013<br />Posts: 210<br />Company: KfzP7SfGKkAPVzsX","Year: 2014<br />Posts: 211<br />Company: KfzP7SfGKkAPVzsX","Year: 2015<br />Posts: 212<br />Company: KfzP7SfGKkAPVzsX","Year: 2016<br />Posts: 213<br />Company: KfzP7SfGKkAPVzsX","Year: 2017<br />Posts: 214<br />Company: KfzP7SfGKkAPVzsX","Year: 2018<br />Posts: 215<br />Company: KfzP7SfGKkAPVzsX","Year: 2019<br />Posts: 216<br />Company: KfzP7SfGKkAPVzsX","Year: 2020<br />Posts: 190<br />Company: KfzP7SfGKkAPVzsX"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(192,155,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"KfzP7SfGKkAPVzsX","legendgroup":"KfzP7SfGKkAPVzsX","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[2017,1863,1780,1635,1505,1621,1836,1523,1714,1478,1225,1547,1491,1229],"x":[8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[138,139,140,141,142,143,144,145,146,147,148,149,150,151],"text":["Year: 2008<br />Posts: 138<br />Company: l2fF8D1T4c01keMG","Year: 2009<br />Posts: 139<br />Company: l2fF8D1T4c01keMG","Year: 2010<br />Posts: 140<br />Company: l2fF8D1T4c01keMG","Year: 2011<br />Posts: 141<br />Company: l2fF8D1T4c01keMG","Year: 2012<br />Posts: 142<br />Company: l2fF8D1T4c01keMG","Year: 2013<br />Posts: 143<br />Company: l2fF8D1T4c01keMG","Year: 2014<br />Posts: 144<br />Company: l2fF8D1T4c01keMG","Year: 2015<br />Posts: 145<br />Company: l2fF8D1T4c01keMG","Year: 2016<br />Posts: 146<br />Company: l2fF8D1T4c01keMG","Year: 2017<br />Posts: 147<br />Company: l2fF8D1T4c01keMG","Year: 2018<br />Posts: 148<br />Company: l2fF8D1T4c01keMG","Year: 2019<br />Posts: 149<br />Company: l2fF8D1T4c01keMG","Year: 2020<br />Posts: 150<br />Company: l2fF8D1T4c01keMG","Year: 2021<br />Posts: 151<br />Company: l2fF8D1T4c01keMG"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(163,165,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"l2fF8D1T4c01keMG","legendgroup":"l2fF8D1T4c01keMG","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1640,1783,1826,2155,2128,1920,1908,1647,1764,1980,1668,1991,1758,1831,1777,1517],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,19,20,21],"y":[117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132],"text":["Year: 2005<br />Posts: 117<br />Company: OtxrBMsOX+C/id8n","Year: 2006<br />Posts: 118<br />Company: OtxrBMsOX+C/id8n","Year: 2007<br />Posts: 119<br />Company: OtxrBMsOX+C/id8n","Year: 2008<br />Posts: 120<br />Company: OtxrBMsOX+C/id8n","Year: 2009<br />Posts: 121<br />Company: OtxrBMsOX+C/id8n","Year: 2010<br />Posts: 122<br />Company: OtxrBMsOX+C/id8n","Year: 2011<br />Posts: 123<br />Company: OtxrBMsOX+C/id8n","Year: 2012<br />Posts: 124<br />Company: OtxrBMsOX+C/id8n","Year: 2013<br />Posts: 125<br />Company: OtxrBMsOX+C/id8n","Year: 2014<br />Posts: 126<br />Company: OtxrBMsOX+C/id8n","Year: 2015<br />Posts: 127<br />Company: OtxrBMsOX+C/id8n","Year: 2016<br />Posts: 128<br />Company: OtxrBMsOX+C/id8n","Year: 2017<br />Posts: 129<br />Company: OtxrBMsOX+C/id8n","Year: 2019<br />Posts: 130<br />Company: OtxrBMsOX+C/id8n","Year: 2020<br />Posts: 131<br />Company: OtxrBMsOX+C/id8n","Year: 2021<br />Posts: 132<br />Company: OtxrBMsOX+C/id8n"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(124,174,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"OtxrBMsOX+C/id8n","legendgroup":"OtxrBMsOX+C/id8n","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[2025,2172,2219,2552,2529,2325,2411,2060,2249,2401,2186,2303,2146,1953,2228,2099,1842],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72],"text":["Year: 2005<br />Posts: 56<br />Company: p7FfhSjmi1K1cCsy","Year: 2006<br />Posts: 57<br />Company: p7FfhSjmi1K1cCsy","Year: 2007<br />Posts: 58<br />Company: p7FfhSjmi1K1cCsy","Year: 2008<br />Posts: 59<br />Company: p7FfhSjmi1K1cCsy","Year: 2009<br />Posts: 60<br />Company: p7FfhSjmi1K1cCsy","Year: 2010<br />Posts: 61<br />Company: p7FfhSjmi1K1cCsy","Year: 2011<br />Posts: 62<br />Company: p7FfhSjmi1K1cCsy","Year: 2012<br />Posts: 63<br />Company: p7FfhSjmi1K1cCsy","Year: 2013<br />Posts: 64<br />Company: p7FfhSjmi1K1cCsy","Year: 2014<br />Posts: 65<br />Company: p7FfhSjmi1K1cCsy","Year: 2015<br />Posts: 66<br />Company: p7FfhSjmi1K1cCsy","Year: 2016<br />Posts: 67<br />Company: p7FfhSjmi1K1cCsy","Year: 2017<br />Posts: 68<br />Company: p7FfhSjmi1K1cCsy","Year: 2018<br />Posts: 69<br />Company: p7FfhSjmi1K1cCsy","Year: 2019<br />Posts: 70<br />Company: p7FfhSjmi1K1cCsy","Year: 2020<br />Posts: 71<br />Company: p7FfhSjmi1K1cCsy","Year: 2021<br />Posts: 72<br />Company: p7FfhSjmi1K1cCsy"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(57,182,0,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"p7FfhSjmi1K1cCsy","legendgroup":"p7FfhSjmi1K1cCsy","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[0,255,256,257,258,2386,260,1037,0,0,261,262,0,1507,733,264,0],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[242,243,244,245,246,53,247,165,248,249,250,251,252,130,227,253,254],"text":["Year: 2005<br />Posts: 242<br />Company: rMRbIsYXR1n96epC","Year: 2006<br />Posts: 243<br />Company: rMRbIsYXR1n96epC","Year: 2007<br />Posts: 244<br />Company: rMRbIsYXR1n96epC","Year: 2008<br />Posts: 245<br />Company: rMRbIsYXR1n96epC","Year: 2009<br />Posts: 246<br />Company: rMRbIsYXR1n96epC","Year: 2010<br />Posts: 53<br />Company: rMRbIsYXR1n96epC","Year: 2011<br />Posts: 247<br />Company: rMRbIsYXR1n96epC","Year: 2012<br />Posts: 165<br />Company: rMRbIsYXR1n96epC","Year: 2013<br />Posts: 248<br />Company: rMRbIsYXR1n96epC","Year: 2014<br />Posts: 249<br />Company: rMRbIsYXR1n96epC","Year: 2015<br />Posts: 250<br />Company: rMRbIsYXR1n96epC","Year: 2016<br />Posts: 251<br />Company: rMRbIsYXR1n96epC","Year: 2017<br />Posts: 252<br />Company: rMRbIsYXR1n96epC","Year: 2018<br />Posts: 130<br />Company: rMRbIsYXR1n96epC","Year: 2019<br />Posts: 227<br />Company: rMRbIsYXR1n96epC","Year: 2020<br />Posts: 253<br />Company: rMRbIsYXR1n96epC","Year: 2021<br />Posts: 254<br />Company: rMRbIsYXR1n96epC"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,187,78,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"rMRbIsYXR1n96epC","legendgroup":"rMRbIsYXR1n96epC","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[2081,2283,2277,2611,2589,2439,2473,2123,2313,2466,2303,2370,2214,2022,2298,2170,1914],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55],"text":["Year: 2005<br />Posts: 39<br />Company: U/yV8B15rf/qhaYX","Year: 2006<br />Posts: 40<br />Company: U/yV8B15rf/qhaYX","Year: 2007<br />Posts: 41<br />Company: U/yV8B15rf/qhaYX","Year: 2008<br />Posts: 42<br />Company: U/yV8B15rf/qhaYX","Year: 2009<br />Posts: 43<br />Company: U/yV8B15rf/qhaYX","Year: 2010<br />Posts: 44<br />Company: U/yV8B15rf/qhaYX","Year: 2011<br />Posts: 45<br />Company: U/yV8B15rf/qhaYX","Year: 2012<br />Posts: 46<br />Company: U/yV8B15rf/qhaYX","Year: 2013<br />Posts: 47<br />Company: U/yV8B15rf/qhaYX","Year: 2014<br />Posts: 48<br />Company: U/yV8B15rf/qhaYX","Year: 2015<br />Posts: 49<br />Company: U/yV8B15rf/qhaYX","Year: 2016<br />Posts: 50<br />Company: U/yV8B15rf/qhaYX","Year: 2017<br />Posts: 51<br />Company: U/yV8B15rf/qhaYX","Year: 2018<br />Posts: 52<br />Company: U/yV8B15rf/qhaYX","Year: 2019<br />Posts: 53<br />Company: U/yV8B15rf/qhaYX","Year: 2020<br />Posts: 54<br />Company: U/yV8B15rf/qhaYX","Year: 2021<br />Posts: 55<br />Company: U/yV8B15rf/qhaYX"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,191,125,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"U/yV8B15rf/qhaYX","legendgroup":"U/yV8B15rf/qhaYX","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1191,1463,1057,1531,1537,1629,1306],"x":[5,6,7,8,9,10,11],"y":[166,167,168,169,170,151,171],"text":["Year: 2005<br />Posts: 166<br />Company: UbUgWbC4rn7rd7TY","Year: 2006<br />Posts: 167<br />Company: UbUgWbC4rn7rd7TY","Year: 2007<br />Posts: 168<br />Company: UbUgWbC4rn7rd7TY","Year: 2008<br />Posts: 169<br />Company: UbUgWbC4rn7rd7TY","Year: 2009<br />Posts: 170<br />Company: UbUgWbC4rn7rd7TY","Year: 2010<br />Posts: 151<br />Company: UbUgWbC4rn7rd7TY","Year: 2011<br />Posts: 171<br />Company: UbUgWbC4rn7rd7TY"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,193,163,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"UbUgWbC4rn7rd7TY","legendgroup":"UbUgWbC4rn7rd7TY","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1509,2229,1533,502,504,259,2238,0,248,249,511,513,252,0,263,1138,687],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[131,54,150,232,232,233,94,234,235,236,237,238,239,240,241,189,189],"text":["Year: 2005<br />Posts: 131<br />Company: UFdfTcYSqZpL39QZ","Year: 2006<br />Posts: 54<br />Company: UFdfTcYSqZpL39QZ","Year: 2007<br />Posts: 150<br />Company: UFdfTcYSqZpL39QZ","Year: 2008<br />Posts: 232<br />Company: UFdfTcYSqZpL39QZ","Year: 2009<br />Posts: 232<br />Company: UFdfTcYSqZpL39QZ","Year: 2010<br />Posts: 233<br />Company: UFdfTcYSqZpL39QZ","Year: 2011<br />Posts: 94<br />Company: UFdfTcYSqZpL39QZ","Year: 2012<br />Posts: 234<br />Company: UFdfTcYSqZpL39QZ","Year: 2013<br />Posts: 235<br />Company: UFdfTcYSqZpL39QZ","Year: 2014<br />Posts: 236<br />Company: UFdfTcYSqZpL39QZ","Year: 2015<br />Posts: 237<br />Company: UFdfTcYSqZpL39QZ","Year: 2016<br />Posts: 238<br />Company: UFdfTcYSqZpL39QZ","Year: 2017<br />Posts: 239<br />Company: UFdfTcYSqZpL39QZ","Year: 2018<br />Posts: 240<br />Company: UFdfTcYSqZpL39QZ","Year: 2019<br />Posts: 241<br />Company: UFdfTcYSqZpL39QZ","Year: 2020<br />Posts: 189<br />Company: UFdfTcYSqZpL39QZ","Year: 2021<br />Posts: 189<br />Company: UFdfTcYSqZpL39QZ"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,191,196,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"UFdfTcYSqZpL39QZ","legendgroup":"UFdfTcYSqZpL39QZ","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[662,0,0,0,0,0,0,1361,2181,921,0,0,2073,1637,0,0,876],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[181,255,256,257,258,259,260,144,68,208,261,262,73,128,263,264,188],"text":["Year: 2005<br />Posts: 181<br />Company: us4y0oeKhpAMAgvi","Year: 2006<br />Posts: 255<br />Company: us4y0oeKhpAMAgvi","Year: 2007<br />Posts: 256<br />Company: us4y0oeKhpAMAgvi","Year: 2008<br />Posts: 257<br />Company: us4y0oeKhpAMAgvi","Year: 2009<br />Posts: 258<br />Company: us4y0oeKhpAMAgvi","Year: 2010<br />Posts: 259<br />Company: us4y0oeKhpAMAgvi","Year: 2011<br />Posts: 260<br />Company: us4y0oeKhpAMAgvi","Year: 2012<br />Posts: 144<br />Company: us4y0oeKhpAMAgvi","Year: 2013<br />Posts: 68<br />Company: us4y0oeKhpAMAgvi","Year: 2014<br />Posts: 208<br />Company: us4y0oeKhpAMAgvi","Year: 2015<br />Posts: 261<br />Company: us4y0oeKhpAMAgvi","Year: 2016<br />Posts: 262<br />Company: us4y0oeKhpAMAgvi","Year: 2017<br />Posts: 73<br />Company: us4y0oeKhpAMAgvi","Year: 2018<br />Posts: 128<br />Company: us4y0oeKhpAMAgvi","Year: 2019<br />Posts: 263<br />Company: us4y0oeKhpAMAgvi","Year: 2020<br />Posts: 264<br />Company: us4y0oeKhpAMAgvi","Year: 2021<br />Posts: 188<br />Company: us4y0oeKhpAMAgvi"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,186,224,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"us4y0oeKhpAMAgvi","legendgroup":"us4y0oeKhpAMAgvi","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[2120,2323,2318,2653,2632,2483,2518,2169,2360,2514,2352,2420,2265,2074,2351,2224,1969],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38],"text":["Year: 2005<br />Posts: 22<br />Company: vH/XPrDYizaBV+Cg","Year: 2006<br />Posts: 23<br />Company: vH/XPrDYizaBV+Cg","Year: 2007<br />Posts: 24<br />Company: vH/XPrDYizaBV+Cg","Year: 2008<br />Posts: 25<br />Company: vH/XPrDYizaBV+Cg","Year: 2009<br />Posts: 26<br />Company: vH/XPrDYizaBV+Cg","Year: 2010<br />Posts: 27<br />Company: vH/XPrDYizaBV+Cg","Year: 2011<br />Posts: 28<br />Company: vH/XPrDYizaBV+Cg","Year: 2012<br />Posts: 29<br />Company: vH/XPrDYizaBV+Cg","Year: 2013<br />Posts: 30<br />Company: vH/XPrDYizaBV+Cg","Year: 2014<br />Posts: 31<br />Company: vH/XPrDYizaBV+Cg","Year: 2015<br />Posts: 32<br />Company: vH/XPrDYizaBV+Cg","Year: 2016<br />Posts: 33<br />Company: vH/XPrDYizaBV+Cg","Year: 2017<br />Posts: 34<br />Company: vH/XPrDYizaBV+Cg","Year: 2018<br />Posts: 35<br />Company: vH/XPrDYizaBV+Cg","Year: 2019<br />Posts: 36<br />Company: vH/XPrDYizaBV+Cg","Year: 2020<br />Posts: 37<br />Company: vH/XPrDYizaBV+Cg","Year: 2021<br />Posts: 38<br />Company: vH/XPrDYizaBV+Cg"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(0,176,246,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"vH/XPrDYizaBV+Cg","legendgroup":"vH/XPrDYizaBV+Cg","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1357,1630,1225,1862,1707,1472,1477,1202,1461,1675,2010,1552,1315,1070,2064,1327,1064],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[152,153,154,155,156,157,158,159,160,161,93,162,163,155,90,164,165],"text":["Year: 2005<br />Posts: 152<br />Company: xLQTXOW0PEJox2Sq","Year: 2006<br />Posts: 153<br />Company: xLQTXOW0PEJox2Sq","Year: 2007<br />Posts: 154<br />Company: xLQTXOW0PEJox2Sq","Year: 2008<br />Posts: 155<br />Company: xLQTXOW0PEJox2Sq","Year: 2009<br />Posts: 156<br />Company: xLQTXOW0PEJox2Sq","Year: 2010<br />Posts: 157<br />Company: xLQTXOW0PEJox2Sq","Year: 2011<br />Posts: 158<br />Company: xLQTXOW0PEJox2Sq","Year: 2012<br />Posts: 159<br />Company: xLQTXOW0PEJox2Sq","Year: 2013<br />Posts: 160<br />Company: xLQTXOW0PEJox2Sq","Year: 2014<br />Posts: 161<br />Company: xLQTXOW0PEJox2Sq","Year: 2015<br />Posts: 93<br />Company: xLQTXOW0PEJox2Sq","Year: 2016<br />Posts: 162<br />Company: xLQTXOW0PEJox2Sq","Year: 2017<br />Posts: 163<br />Company: xLQTXOW0PEJox2Sq","Year: 2018<br />Posts: 155<br />Company: xLQTXOW0PEJox2Sq","Year: 2019<br />Posts: 90<br />Company: xLQTXOW0PEJox2Sq","Year: 2020<br />Posts: 164<br />Company: xLQTXOW0PEJox2Sq","Year: 2021<br />Posts: 165<br />Company: xLQTXOW0PEJox2Sq"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(53,162,255,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"xLQTXOW0PEJox2Sq","legendgroup":"xLQTXOW0PEJox2Sq","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1863,2008,2053,2384,2359,2153,2143,1884,2003,2221,1911,2119,1887,1765,1961,1908,1649],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105],"text":["Year: 2005<br />Posts: 89<br />Company: xNJUwi/CriFmzaXv","Year: 2006<br />Posts: 90<br />Company: xNJUwi/CriFmzaXv","Year: 2007<br />Posts: 91<br />Company: xNJUwi/CriFmzaXv","Year: 2008<br />Posts: 92<br />Company: xNJUwi/CriFmzaXv","Year: 2009<br />Posts: 93<br />Company: xNJUwi/CriFmzaXv","Year: 2010<br />Posts: 94<br />Company: xNJUwi/CriFmzaXv","Year: 2011<br />Posts: 95<br />Company: xNJUwi/CriFmzaXv","Year: 2012<br />Posts: 96<br />Company: xNJUwi/CriFmzaXv","Year: 2013<br />Posts: 97<br />Company: xNJUwi/CriFmzaXv","Year: 2014<br />Posts: 98<br />Company: xNJUwi/CriFmzaXv","Year: 2015<br />Posts: 99<br />Company: xNJUwi/CriFmzaXv","Year: 2016<br />Posts: 100<br />Company: xNJUwi/CriFmzaXv","Year: 2017<br />Posts: 101<br />Company: xNJUwi/CriFmzaXv","Year: 2018<br />Posts: 102<br />Company: xNJUwi/CriFmzaXv","Year: 2019<br />Posts: 103<br />Company: xNJUwi/CriFmzaXv","Year: 2020<br />Posts: 104<br />Company: xNJUwi/CriFmzaXv","Year: 2021<br />Posts: 105<br />Company: xNJUwi/CriFmzaXv"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(149,144,255,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"xNJUwi/CriFmzaXv","legendgroup":"xNJUwi/CriFmzaXv","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1757,1901,1945,2275,2249,2042,2031,1771,1889,2106,1795],"x":[5,6,7,8,9,10,11,12,13,14,15],"y":[106,107,108,109,110,111,112,113,114,115,116],"text":["Year: 2005<br />Posts: 106<br />Company: XOcayqcggitkWOM+","Year: 2006<br />Posts: 107<br />Company: XOcayqcggitkWOM+","Year: 2007<br />Posts: 108<br />Company: XOcayqcggitkWOM+","Year: 2008<br />Posts: 109<br />Company: XOcayqcggitkWOM+","Year: 2009<br />Posts: 110<br />Company: XOcayqcggitkWOM+","Year: 2010<br />Posts: 111<br />Company: XOcayqcggitkWOM+","Year: 2011<br />Posts: 112<br />Company: XOcayqcggitkWOM+","Year: 2012<br />Posts: 113<br />Company: XOcayqcggitkWOM+","Year: 2013<br />Posts: 114<br />Company: XOcayqcggitkWOM+","Year: 2014<br />Posts: 115<br />Company: XOcayqcggitkWOM+","Year: 2015<br />Posts: 116<br />Company: XOcayqcggitkWOM+"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(199,124,255,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"XOcayqcggitkWOM+","legendgroup":"XOcayqcggitkWOM+","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1625,1373,1696,1641,1380],"x":[17,18,19,20,21],"y":[133,134,135,136,137],"text":["Year: 2017<br />Posts: 133<br />Company: xTaCVMWKHYfTtM8A","Year: 2018<br />Posts: 134<br />Company: xTaCVMWKHYfTtM8A","Year: 2019<br />Posts: 135<br />Company: xTaCVMWKHYfTtM8A","Year: 2020<br />Posts: 136<br />Company: xTaCVMWKHYfTtM8A","Year: 2021<br />Posts: 137<br />Company: xTaCVMWKHYfTtM8A"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(231,107,243,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"xTaCVMWKHYfTtM8A","legendgroup":"xTaCVMWKHYfTtM8A","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[0,0,0,0,2142,2346,2342,2678,2658,2510,2546,2198,2390,2545,2384,2453,2299,2109,2387,2261,2007],"x":[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"text":["Year: 2001<br />Posts: 1<br />Company: XXq/4x4pQnv5SyJL","Year: 2002<br />Posts: 2<br />Company: XXq/4x4pQnv5SyJL","Year: 2003<br />Posts: 3<br />Company: XXq/4x4pQnv5SyJL","Year: 2004<br />Posts: 4<br />Company: XXq/4x4pQnv5SyJL","Year: 2005<br />Posts: 5<br />Company: XXq/4x4pQnv5SyJL","Year: 2006<br />Posts: 6<br />Company: XXq/4x4pQnv5SyJL","Year: 2007<br />Posts: 7<br />Company: XXq/4x4pQnv5SyJL","Year: 2008<br />Posts: 8<br />Company: XXq/4x4pQnv5SyJL","Year: 2009<br />Posts: 9<br />Company: XXq/4x4pQnv5SyJL","Year: 2010<br />Posts: 10<br />Company: XXq/4x4pQnv5SyJL","Year: 2011<br />Posts: 11<br />Company: XXq/4x4pQnv5SyJL","Year: 2012<br />Posts: 12<br />Company: XXq/4x4pQnv5SyJL","Year: 2013<br />Posts: 13<br />Company: XXq/4x4pQnv5SyJL","Year: 2014<br />Posts: 14<br />Company: XXq/4x4pQnv5SyJL","Year: 2015<br />Posts: 15<br />Company: XXq/4x4pQnv5SyJL","Year: 2016<br />Posts: 16<br />Company: XXq/4x4pQnv5SyJL","Year: 2017<br />Posts: 17<br />Company: XXq/4x4pQnv5SyJL","Year: 2018<br />Posts: 18<br />Company: XXq/4x4pQnv5SyJL","Year: 2019<br />Posts: 19<br />Company: XXq/4x4pQnv5SyJL","Year: 2020<br />Posts: 20<br />Company: XXq/4x4pQnv5SyJL","Year: 2021<br />Posts: 21<br />Company: XXq/4x4pQnv5SyJL"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(250,98,219,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"XXq/4x4pQnv5SyJL","legendgroup":"XXq/4x4pQnv5SyJL","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[843,1109,701,1348,1353,1112,1776,1290,1504,1157,1190,1130,882,1376],"x":[5,6,7,8,9,10,11,13,14,15,16,17,18,19],"y":[176,181,182,183,184,185,132,171,171,186,187,185,188,171],"text":["Year: 2005<br />Posts: 176<br />Company: YIUpmKVOSlWPXlKy","Year: 2006<br />Posts: 181<br />Company: YIUpmKVOSlWPXlKy","Year: 2007<br />Posts: 182<br />Company: YIUpmKVOSlWPXlKy","Year: 2008<br />Posts: 183<br />Company: YIUpmKVOSlWPXlKy","Year: 2009<br />Posts: 184<br />Company: YIUpmKVOSlWPXlKy","Year: 2010<br />Posts: 185<br />Company: YIUpmKVOSlWPXlKy","Year: 2011<br />Posts: 132<br />Company: YIUpmKVOSlWPXlKy","Year: 2013<br />Posts: 171<br />Company: YIUpmKVOSlWPXlKy","Year: 2014<br />Posts: 171<br />Company: YIUpmKVOSlWPXlKy","Year: 2015<br />Posts: 186<br />Company: YIUpmKVOSlWPXlKy","Year: 2016<br />Posts: 187<br />Company: YIUpmKVOSlWPXlKy","Year: 2017<br />Posts: 185<br />Company: YIUpmKVOSlWPXlKy","Year: 2018<br />Posts: 188<br />Company: YIUpmKVOSlWPXlKy","Year: 2019<br />Posts: 171<br />Company: YIUpmKVOSlWPXlKy"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(255,98,188,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"YIUpmKVOSlWPXlKy","legendgroup":"YIUpmKVOSlWPXlKy","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null},{"orientation":"v","width":[0.9,0.9,0.9,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999,0.899999999999999],"base":[1952,2098,2144,2476,2452,2247,2332,1980,2100,2319,2103,2219,1988,1867,2154,2012,1754],"x":[5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"y":[73,74,75,76,77,78,79,80,81,82,83,84,85,86,74,87,88],"text":["Year: 2005<br />Posts: 73<br />Company: YYty1pb7CXXRjAGP","Year: 2006<br />Posts: 74<br />Company: YYty1pb7CXXRjAGP","Year: 2007<br />Posts: 75<br />Company: YYty1pb7CXXRjAGP","Year: 2008<br />Posts: 76<br />Company: YYty1pb7CXXRjAGP","Year: 2009<br />Posts: 77<br />Company: YYty1pb7CXXRjAGP","Year: 2010<br />Posts: 78<br />Company: YYty1pb7CXXRjAGP","Year: 2011<br />Posts: 79<br />Company: YYty1pb7CXXRjAGP","Year: 2012<br />Posts: 80<br />Company: YYty1pb7CXXRjAGP","Year: 2013<br />Posts: 81<br />Company: YYty1pb7CXXRjAGP","Year: 2014<br />Posts: 82<br />Company: YYty1pb7CXXRjAGP","Year: 2015<br />Posts: 83<br />Company: YYty1pb7CXXRjAGP","Year: 2016<br />Posts: 84<br />Company: YYty1pb7CXXRjAGP","Year: 2017<br />Posts: 85<br />Company: YYty1pb7CXXRjAGP","Year: 2018<br />Posts: 86<br />Company: YYty1pb7CXXRjAGP","Year: 2019<br />Posts: 74<br />Company: YYty1pb7CXXRjAGP","Year: 2020<br />Posts: 87<br />Company: YYty1pb7CXXRjAGP","Year: 2021<br />Posts: 88<br />Company: YYty1pb7CXXRjAGP"],"type":"bar","marker":{"autocolorscale":false,"color":"rgba(255,106,152,1)","line":{"width":1.88976377952756,"color":"transparent"}},"name":"YYty1pb7CXXRjAGP","legendgroup":"YYty1pb7CXXRjAGP","showlegend":true,"xaxis":"x","yaxis":"y","hoverinfo":"text","frame":null}],"layout":{"margin":{"t":43.7625570776256,"r":7.30593607305936,"b":37.7916147779162,"l":54.7945205479452},"font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187},"title":{"text":"Top 20 Companies involved in Eclipse mailing lists across years","font":{"color":"rgba(0,0,0,1)","family":"","size":17.5342465753425},"x":0,"xref":"paper"},"xaxis":{"domain":[0,1],"automargin":true,"type":"linear","autorange":false,"range":[0.4,21.6],"tickmode":"array","ticktext":["2001","2002","2003","2004","2005","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020","2021"],"tickvals":[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21],"categoryorder":"array","categoryarray":["2001","2002","2003","2004","2005","2006","2007","2008","2009","2010","2011","2012","2013","2014","2015","2016","2017","2018","2019","2020","2021"],"nticks":null,"ticks":"","tickcolor":null,"ticklen":3.65296803652968,"tickwidth":0,"showticklabels":true,"tickfont":{"color":"rgba(77,77,77,1)","family":"","size":9.29846409298464},"tickangle":-60,"showline":false,"linecolor":null,"linewidth":0,"showgrid":true,"gridcolor":"rgba(235,235,235,1)","gridwidth":0.66417600664176,"zeroline":false,"anchor":"y","title":{"text":"Years","font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187}},"hoverformat":".2f"},"yaxis":{"domain":[0,1],"automargin":true,"type":"linear","autorange":false,"range":[0,2686],"tickmode":"array","ticktext":["1113","6891","14669","18032","6054","4276","3948","6572","5193","7471","10811","10877","7950","8953","12068","15242","15170","11507","8451","3775","992","1231","2950","3974","6396","9173","8980","8010","8491","7809","6809","6190","6614","4640","5863","5796","6522","2526","3884","6803","7044","7248","4894","3608","3355","1414","858","579","440","265","143","186","52","34","6","1668","4093","4818","3827","2341","2301","2133","2053","2009","1371","1202","772","362","410","541","883","305","97","789","1081","2332","2358","2759","1930","1230","857","403","431","124","235","1015","1058","314","27","133","245","191","460","353","787","835","986","683","926","1479","1663","2297","1783","2656","917","1634","5479","3126","436","225","165","104","71","83","75","31","95","1206","1445","2604","1216","618","897","510","427","230","268","119","72","9","2","4","881","2675","2274","2559","994","63","1824","853","509","409","450","351","371","289","319","183","126","57","8","32","79","142","222","323","671","1129","734","606","340","247","195","117","24","753","2668","1037","568","176","1","634","1029","815","54","19","251","514","540","597","23","486","2140","2052","3","18","11","7","12","220","273","922","715","631","254","330","111","264","312","98","226","140","211","223","201","153","179","210","207","224","267","372","538","590","461","308","228","250","764","885","629","380","238","92","70","87","45","89","40","56","64","194","472","329","429","520","636","718","304","120","105","694","1482","798","425","100","25","33","35","41","112","61","102","22","192","355","382","451","493","458","170","172","151","26"],"tickvals":[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,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261,262,263,264],"categoryorder":"array","categoryarray":["1113","6891","14669","18032","6054","4276","3948","6572","5193","7471","10811","10877","7950","8953","12068","15242","15170","11507","8451","3775","992","1231","2950","3974","6396","9173","8980","8010","8491","7809","6809","6190","6614","4640","5863","5796","6522","2526","3884","6803","7044","7248","4894","3608","3355","1414","858","579","440","265","143","186","52","34","6","1668","4093","4818","3827","2341","2301","2133","2053","2009","1371","1202","772","362","410","541","883","305","97","789","1081","2332","2358","2759","1930","1230","857","403","431","124","235","1015","1058","314","27","133","245","191","460","353","787","835","986","683","926","1479","1663","2297","1783","2656","917","1634","5479","3126","436","225","165","104","71","83","75","31","95","1206","1445","2604","1216","618","897","510","427","230","268","119","72","9","2","4","881","2675","2274","2559","994","63","1824","853","509","409","450","351","371","289","319","183","126","57","8","32","79","142","222","323","671","1129","734","606","340","247","195","117","24","753","2668","1037","568","176","1","634","1029","815","54","19","251","514","540","597","23","486","2140","2052","3","18","11","7","12","220","273","922","715","631","254","330","111","264","312","98","226","140","211","223","201","153","179","210","207","224","267","372","538","590","461","308","228","250","764","885","629","380","238","92","70","87","45","89","40","56","64","194","472","329","429","520","636","718","304","120","105","694","1482","798","425","100","25","33","35","41","112","61","102","22","192","355","382","451","493","458","170","172","151","26"],"nticks":null,"ticks":"","tickcolor":null,"ticklen":3.65296803652968,"tickwidth":0,"showticklabels":true,"tickfont":{"color":"rgba(77,77,77,1)","family":"","size":11.689497716895},"tickangle":-0,"showline":false,"linecolor":null,"linewidth":0,"showgrid":true,"gridcolor":"rgba(235,235,235,1)","gridwidth":0.66417600664176,"zeroline":false,"anchor":"x","title":{"text":"Number of posts","font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187}},"hoverformat":".2f"},"shapes":[{"type":"rect","fillcolor":null,"line":{"color":null,"width":0,"linetype":[]},"yref":"paper","xref":"paper","x0":0,"x1":1,"y0":0,"y1":1}],"showlegend":true,"legend":{"bgcolor":null,"bordercolor":null,"borderwidth":0,"font":{"color":"rgba(0,0,0,1)","family":"","size":11.689497716895},"y":0.96751968503937},"annotations":[{"text":"Company","x":1.02,"y":1,"showarrow":false,"ax":0,"ay":0,"font":{"color":"rgba(0,0,0,1)","family":"","size":14.6118721461187},"xref":"paper","yref":"paper","textangle":-0,"xanchor":"left","yanchor":"bottom","legendTitle":true}],"hovermode":"closest","barmode":"relative"},"config":{"doubleClick":"reset","showSendToCloud":false},"source":"A","attrs":{"33f348405ade":{"x":{},"y":{},"fill":{},"type":"bar"}},"cur_data":"33f348405ade","visdat":{"33f348405ade":["function (y) ","x"]},"highlight":{"on":"plotly_click","persistent":false,"dynamic":false,"selectize":false,"opacityDim":0.2,"selected":{"opacity":1},"debounce":0},"shinyEvents":["plotly_hover","plotly_click","plotly_selected","plotly_relayout","plotly_brushed","plotly_brushing","plotly_clickannotation","plotly_doubleclick","plotly_deselect","plotly_afterplot","plotly_sunburstclick"],"base_url":"https://plot.ly"},"evals":[],"jsHooks":[]}</script>
<div class="highlight"><pre style="color:#f8f8f2;background-color:#272822;-moz-tab-size:4;-o-tab-size:4;tab-size:4"><code class="language-r" data-lang="r"><span style="color:#75715e">#api_create(g, filename = &#34;r-eclipse_mls_companies&#34;)</span>
</code></pre></div>
</div>
<footer class='entry-footer'>
<div class='container sep-before'>
</div>
</footer>
</article>
</main>
<footer id='footer' class='footer'>
<div class='container sep-before'><div class="row">
<div class="column">
<a href="http://www.eclipse.org/" target="_blank"><img src="/dataeggs/images/logo-eclipse-foundation.png" alt="Eclipse Foundation logo"></a>
</div>
<div class="column">
<p></p>
<p id="copyright">Copyright © 2021 Eclipse Foundation, Inc.<br>All Rights Reserved.</p>
</div>
</div>
<div class="row">
<p><a href="http://www.eclipse.org/legal/privacy.php" target="_blank">Privacy Policy</a> /
<a href="http://eclipse.org/" target="_blank">Eclipse</a> /
<a href="http://www.eclipse.org/legal/termsofuse.php" target="_blank">Terms of Use</a> /
<a href="http://www.eclipse.org/legal/copyright.php" target="_blank">Copyright Agent</a> /
<a href="http://www.eclipse.org/legal/" target="_blank">Legal</a> /
<a href="http://www.eclipse.org/org/foundation/contact.php" target="_blank"> Contact Us</a></p>
</div>
</div>
</footer>
</div>
</div><script>window.__assets_js_src="/dataeggs/assets/js/"</script>
<script src='/dataeggs/assets/js/main.c3bcf2df.js'></script><script src='/dataeggs/js/custom.js'></script>
</body>
</html>