<html dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" id="owaParaStyle">P {margin-top:0;margin-bottom:0;}</style>
</head>
<body fpstyle="1" ocsi="0">
<div style="direction: ltr;font-family: Tahoma;color: #000000;font-size: 10pt;"><font size="3">Hi Corinne,
<br>
<br>
sorry I totally forgot to get back on this. Responding on coding-related questions.</font><br>
<br>
<font size="2"><br>
<span></span></font>
<div style="font-family: Times New Roman; color: #000000; font-size: 16px">
<div>
<div dir="ltr">
<div class="gmail_default" style="">
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font size="2"><i><font face="verdana, sans-serif"> In [6]: top senders over a time period<span></span></font></i></font></p>
<font size="2"></font>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font size="2" face="verdana, sans-serif"> Currently, it gives the absolute numbers, for example, niels ten oever 77.0
<span></span></font></p>
<font size="2"></font>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font face="verdana, sans-serif"><font size="2"> It would be great to know what percentage that represents of the total number of emails sent in the period specified. So, those
77 emails are they 0.5, 5, 50% etc of the total over that period? </font><span></span></font></p>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font face="Tahoma"><span><br>
</span></font></p>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font size="3"><span><font face="Tahoma">Easy peasy</font><br>
</span></font></p>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font size="2"><span><font face="verdana, sans-serif"><br>
</font></span></font></p>
<font size="2"></font>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font size="2"><i><font face="verdana, sans-serif"> In [7]: number of emails in a time frame<span></span></font></i></font></p>
<font size="2"></font>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font size="2" face="verdana, sans-serif"> I was wondering if it would also be possible to indicate the number of threads versus single emails (with no responses) to get a sense of
how responsive a mailing list is in a certain time period.<span></span></font></p>
<font size="2"></font>
<p class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt"><font size="2"><span><font face="verdana, sans-serif"> </font></span></font></p>
<font face="verdana, sans-serif"><font face="Tahoma">Yes</font><br>
</font>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font face="verdana, sans-serif"><br>
</font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font face="verdana, sans-serif"> <font size="2">In [8]: I would be interested in, for instance, the average number of emails per user, across multiple years.</font></font></p>
<font size="2"></font>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"> <font face="verdana, sans-serif">It seems that currently, the numbers presented are not the average across the time specified but the absolute. That might also be because for the test run, I set
<span></span></font></font></p>
<font size="2"></font>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"> </font><span><br>
</span></p>
<span><font face="verdana, sans-serif"><span xmlns="http://www.w3.org/1999/xhtml"><font face="verdana, sans-serif"> </font></span><font size="2">
</font></font></span>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"> <font face="verdana, sans-serif">date_from = pd.datetime(2014,10,1,tzinfo=pytz.utc)<span></span></font></font></p>
<font size="2"></font>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"> <font face="verdana, sans-serif">date_to = pd.datetime(2015,11,30,tzinfo=pytz.utc)<span></span></font></font></p>
<font size="2"></font>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"> <font face="verdana, sans-serif">which is only a little over a year.
<br>
</font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"><font face="verdana, sans-serif"><br>
</font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"><font face="verdana, sans-serif"><font size="3"><font face="Tahoma">OK I think I misunderstood your question before. So you want to do: for each user, count how many emails she sent in a timeframe, divide by number of years? If so, be aware that
if you don't use a round number of years you would get inconsistent results on the tails. Also, do you mean year as in 365 days from date_from, or year as in 2015,2016,2017,...?</font></font></font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2" face="Tahoma"><font size="3"><br>
</font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"><font face="verdana, sans-serif"><font size="3"><font face="Tahoma">I'll try to incorporate these changes tomorrow, hope it's not too late!<br>
</font></font></font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"><font face="verdana, sans-serif"><font size="3"><font face="Tahoma"><br>
</font></font></font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"><font face="verdana, sans-serif"><font size="3"><font face="Tahoma"><br>
</font></font></font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"><font face="verdana, sans-serif"><font size="3"><font face="Tahoma">Cheers,</font></font></font></font></p>
<p xmlns="http://www.w3.org/1999/xhtml" class="MsoNormal" style="text-align:justify; margin:0cm 0cm 0.0001pt">
<font size="2"><font face="verdana, sans-serif"><font size="3"><font face="Tahoma">Davide<br>
</font></font></font></font></p>
<span></span></div>
</div>
</div>
</div>
</div>
</body>
</html>