Group data without losing information The Next CEO of Stack Overflow2019 Community Moderator ElectionEfficient solution of fmincg without providing gradient?Getting GitHub repository information by different criteriaIs it ethical to claim experience with big data when the data isn't a part of the new advertising/social media/retail fad?Optimizing Weka for large data setsWhat's an efficient way to compare and group millions of store names?Memory efficient structure for membership checking without false positiveUser activity representation for Prediction/MLHow to preprocess Acoustic DataDoes discretization of continuous features also lose information about distance?Loading Data into DW: Direct Insert from PreProcessing vs PreProcess and then loading from CSV files

What is a typical Mizrachi Seder like?

Gauss' Posthumous Publications?

Why does freezing point matter when picking cooler ice packs?

How can the PCs determine if an item is a phylactery?

How to coordinate airplane tickets?

How does a dynamic QR code work?

Could you use a laser beam as a modulated carrier wave for radio signal?

Is it okay to majorly distort historical facts while writing a fiction story?

Physiological effects of huge anime eyes

Is it possible to create a QR code using text?

Can you teleport closer to a creature you are Frightened of?

How to show a landlord what we have in savings?

How to implement Comparable so it is consistent with identity-equality

Upgrading From a 9 Speed Sora Derailleur?

Does int main() need a declaration on C++?

How can I replace x-axis labels with pre-determined symbols?

Why doesn't Shulchan Aruch include the laws of destroying fruit trees?

Creating a script with console commands

Is it possible to make a 9x9 table fit within the default margins?

Avoiding the "not like other girls" trope?

What steps are necessary to read a Modern SSD in Medieval Europe?

Could a dragon use its wings to swim?

Is the offspring between a demon and a celestial possible? If so what is it called and is it in a book somewhere?

Calculate the Mean mean of two numbers



Group data without losing information



The Next CEO of Stack Overflow
2019 Community Moderator ElectionEfficient solution of fmincg without providing gradient?Getting GitHub repository information by different criteriaIs it ethical to claim experience with big data when the data isn't a part of the new advertising/social media/retail fad?Optimizing Weka for large data setsWhat's an efficient way to compare and group millions of store names?Memory efficient structure for membership checking without false positiveUser activity representation for Prediction/MLHow to preprocess Acoustic DataDoes discretization of continuous features also lose information about distance?Loading Data into DW: Direct Insert from PreProcessing vs PreProcess and then loading from CSV files










1












$begingroup$


Context



Imagine that I have a dataset about sending messages. Each row as user_id, a batch_id, a is_open field (boolean) and a is_clicked field (boolean).



So one row means that one message was sent. It might have been open (is_open is true) or not (is_open is false). Same for clicked.



For this question, all corner use cases (what if a message is clicked without being opened?) are not relevant.



I want to graph open rate vs. click rate.



Question



How can I group these rows in a valid way, without discarding most of them?



Long version



The crux of my problem is that every single message has an open (and click) rate of exactly 0 or 100%.



I could first group messages per user, but then I would have to discard users having received less than at least 5 or 10 messages, to not have a peak a 0/20/40/60/80/100 %. This is a lot of data to drop, which is perfectly valid (and furthermore, I would like to compute things like median time to open, which does not lend itself well to multi-step calculation). It would take as well a while to get have enough historical data.



I could group by batch. But I could have for instance one batch per month, of 500k users. After a year, I would only have 12 points on my graph, whereas I already sent 6M messages.



My naive idea would be to just take rows by bunches of eg. 1000, and compute the open and click rate for this random bunch. It does not seem intellectually correct to me.



The actual language/implementation does not matter. I want to understand how to do this, actually doing it will come later.










share|improve this question











$endgroup$
















    1












    $begingroup$


    Context



    Imagine that I have a dataset about sending messages. Each row as user_id, a batch_id, a is_open field (boolean) and a is_clicked field (boolean).



    So one row means that one message was sent. It might have been open (is_open is true) or not (is_open is false). Same for clicked.



    For this question, all corner use cases (what if a message is clicked without being opened?) are not relevant.



    I want to graph open rate vs. click rate.



    Question



    How can I group these rows in a valid way, without discarding most of them?



    Long version



    The crux of my problem is that every single message has an open (and click) rate of exactly 0 or 100%.



    I could first group messages per user, but then I would have to discard users having received less than at least 5 or 10 messages, to not have a peak a 0/20/40/60/80/100 %. This is a lot of data to drop, which is perfectly valid (and furthermore, I would like to compute things like median time to open, which does not lend itself well to multi-step calculation). It would take as well a while to get have enough historical data.



    I could group by batch. But I could have for instance one batch per month, of 500k users. After a year, I would only have 12 points on my graph, whereas I already sent 6M messages.



    My naive idea would be to just take rows by bunches of eg. 1000, and compute the open and click rate for this random bunch. It does not seem intellectually correct to me.



    The actual language/implementation does not matter. I want to understand how to do this, actually doing it will come later.










    share|improve this question











    $endgroup$














      1












      1








      1





      $begingroup$


      Context



      Imagine that I have a dataset about sending messages. Each row as user_id, a batch_id, a is_open field (boolean) and a is_clicked field (boolean).



      So one row means that one message was sent. It might have been open (is_open is true) or not (is_open is false). Same for clicked.



      For this question, all corner use cases (what if a message is clicked without being opened?) are not relevant.



      I want to graph open rate vs. click rate.



      Question



      How can I group these rows in a valid way, without discarding most of them?



      Long version



      The crux of my problem is that every single message has an open (and click) rate of exactly 0 or 100%.



      I could first group messages per user, but then I would have to discard users having received less than at least 5 or 10 messages, to not have a peak a 0/20/40/60/80/100 %. This is a lot of data to drop, which is perfectly valid (and furthermore, I would like to compute things like median time to open, which does not lend itself well to multi-step calculation). It would take as well a while to get have enough historical data.



      I could group by batch. But I could have for instance one batch per month, of 500k users. After a year, I would only have 12 points on my graph, whereas I already sent 6M messages.



      My naive idea would be to just take rows by bunches of eg. 1000, and compute the open and click rate for this random bunch. It does not seem intellectually correct to me.



      The actual language/implementation does not matter. I want to understand how to do this, actually doing it will come later.










      share|improve this question











      $endgroup$




      Context



      Imagine that I have a dataset about sending messages. Each row as user_id, a batch_id, a is_open field (boolean) and a is_clicked field (boolean).



      So one row means that one message was sent. It might have been open (is_open is true) or not (is_open is false). Same for clicked.



      For this question, all corner use cases (what if a message is clicked without being opened?) are not relevant.



      I want to graph open rate vs. click rate.



      Question



      How can I group these rows in a valid way, without discarding most of them?



      Long version



      The crux of my problem is that every single message has an open (and click) rate of exactly 0 or 100%.



      I could first group messages per user, but then I would have to discard users having received less than at least 5 or 10 messages, to not have a peak a 0/20/40/60/80/100 %. This is a lot of data to drop, which is perfectly valid (and furthermore, I would like to compute things like median time to open, which does not lend itself well to multi-step calculation). It would take as well a while to get have enough historical data.



      I could group by batch. But I could have for instance one batch per month, of 500k users. After a year, I would only have 12 points on my graph, whereas I already sent 6M messages.



      My naive idea would be to just take rows by bunches of eg. 1000, and compute the open and click rate for this random bunch. It does not seem intellectually correct to me.



      The actual language/implementation does not matter. I want to understand how to do this, actually doing it will come later.







      bigdata preprocessing






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Mar 26 at 6:04







      Guillaume

















      asked Mar 25 at 13:45









      GuillaumeGuillaume

      1063




      1063




















          0






          active

          oldest

          votes












          Your Answer





          StackExchange.ifUsing("editor", function ()
          return StackExchange.using("mathjaxEditing", function ()
          StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix)
          StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
          );
          );
          , "mathjax-editing");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "557"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: false,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: null,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f47943%2fgroup-data-without-losing-information%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          0






          active

          oldest

          votes








          0






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Data Science Stack Exchange!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          Use MathJax to format equations. MathJax reference.


          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f47943%2fgroup-data-without-losing-information%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Adding axes to figuresAdding axes labels to LaTeX figuresLaTeX equivalent of ConTeXt buffersRotate a node but not its content: the case of the ellipse decorationHow to define the default vertical distance between nodes?TikZ scaling graphic and adjust node position and keep font sizeNumerical conditional within tikz keys?adding axes to shapesAlign axes across subfiguresAdding figures with a certain orderLine up nested tikz enviroments or how to get rid of themAdding axes labels to LaTeX figures

          Tähtien Talli Jäsenet | Lähteet | NavigointivalikkoSuomen Hippos – Tähtien Talli

          Do these cracks on my tires look bad? The Next CEO of Stack OverflowDry rot tire should I replace?Having to replace tiresFishtailed so easily? Bad tires? ABS?Filling the tires with something other than air, to avoid puncture hassles?Used Michelin tires safe to install?Do these tyre cracks necessitate replacement?Rumbling noise: tires or mechanicalIs it possible to fix noisy feathered tires?Are bad winter tires still better than summer tires in winter?Torque converter failure - Related to replacing only 2 tires?Why use snow tires on all 4 wheels on 2-wheel-drive cars?