Grouping numeric data into efficient group/pool












1












$begingroup$


I have devices assigned with different data plan. But based on device behaviour amount of data used by device changes during the month. I need to put the device into appropriate data plan based on predicted data usages before end of the month to avoid data overage.



There are 5MB,25MB,50MB,150MB,250MB data pool plans per device. If I put 2 devices into 25MB plan then both device can collectively use 50MB of total data among each, if there are 5 device in 25MB plan then all 5 devices collectively can use 125MB data.



My first simple approach was to based on total data usages of the device, put it into higher data plan. It was not effective because it's shared pool, and pool size varies based on how many devices are in the pool, I need to optimised the grouping of the devices into any particular data plan to optimised pool data usages. I can have any number of group/pool (Max 5 because there are 5 different data plans).



another way I tried was to cluster the device based on data usages and add them into particular group/pool, but with this cluster gets created based on how the usages data is distributed, which is not optimally close to data plan.



Anyone know how to approach this problem to put the devices in a pool to optimally use the pools data limit and not go beyond it.










share|improve this question







New contributor




roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.







$endgroup$

















    1












    $begingroup$


    I have devices assigned with different data plan. But based on device behaviour amount of data used by device changes during the month. I need to put the device into appropriate data plan based on predicted data usages before end of the month to avoid data overage.



    There are 5MB,25MB,50MB,150MB,250MB data pool plans per device. If I put 2 devices into 25MB plan then both device can collectively use 50MB of total data among each, if there are 5 device in 25MB plan then all 5 devices collectively can use 125MB data.



    My first simple approach was to based on total data usages of the device, put it into higher data plan. It was not effective because it's shared pool, and pool size varies based on how many devices are in the pool, I need to optimised the grouping of the devices into any particular data plan to optimised pool data usages. I can have any number of group/pool (Max 5 because there are 5 different data plans).



    another way I tried was to cluster the device based on data usages and add them into particular group/pool, but with this cluster gets created based on how the usages data is distributed, which is not optimally close to data plan.



    Anyone know how to approach this problem to put the devices in a pool to optimally use the pools data limit and not go beyond it.










    share|improve this question







    New contributor




    roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
    Check out our Code of Conduct.







    $endgroup$















      1












      1








      1





      $begingroup$


      I have devices assigned with different data plan. But based on device behaviour amount of data used by device changes during the month. I need to put the device into appropriate data plan based on predicted data usages before end of the month to avoid data overage.



      There are 5MB,25MB,50MB,150MB,250MB data pool plans per device. If I put 2 devices into 25MB plan then both device can collectively use 50MB of total data among each, if there are 5 device in 25MB plan then all 5 devices collectively can use 125MB data.



      My first simple approach was to based on total data usages of the device, put it into higher data plan. It was not effective because it's shared pool, and pool size varies based on how many devices are in the pool, I need to optimised the grouping of the devices into any particular data plan to optimised pool data usages. I can have any number of group/pool (Max 5 because there are 5 different data plans).



      another way I tried was to cluster the device based on data usages and add them into particular group/pool, but with this cluster gets created based on how the usages data is distributed, which is not optimally close to data plan.



      Anyone know how to approach this problem to put the devices in a pool to optimally use the pools data limit and not go beyond it.










      share|improve this question







      New contributor




      roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.







      $endgroup$




      I have devices assigned with different data plan. But based on device behaviour amount of data used by device changes during the month. I need to put the device into appropriate data plan based on predicted data usages before end of the month to avoid data overage.



      There are 5MB,25MB,50MB,150MB,250MB data pool plans per device. If I put 2 devices into 25MB plan then both device can collectively use 50MB of total data among each, if there are 5 device in 25MB plan then all 5 devices collectively can use 125MB data.



      My first simple approach was to based on total data usages of the device, put it into higher data plan. It was not effective because it's shared pool, and pool size varies based on how many devices are in the pool, I need to optimised the grouping of the devices into any particular data plan to optimised pool data usages. I can have any number of group/pool (Max 5 because there are 5 different data plans).



      another way I tried was to cluster the device based on data usages and add them into particular group/pool, but with this cluster gets created based on how the usages data is distributed, which is not optimally close to data plan.



      Anyone know how to approach this problem to put the devices in a pool to optimally use the pools data limit and not go beyond it.







      python clustering k-nn clusters






      share|improve this question







      New contributor




      roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.











      share|improve this question







      New contributor




      roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      share|improve this question




      share|improve this question






      New contributor




      roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.









      asked 13 hours ago









      royroy

      1084




      1084




      New contributor




      roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.





      New contributor





      roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






      roy is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
      Check out our Code of Conduct.






















          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
          });


          }
          });






          roy is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          StackExchange.ready(
          function () {
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f45176%2fgrouping-numeric-data-into-efficient-group-pool%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








          roy is a new contributor. Be nice, and check out our Code of Conduct.










          draft saved

          draft discarded


















          roy is a new contributor. Be nice, and check out our Code of Conduct.













          roy is a new contributor. Be nice, and check out our Code of Conduct.












          roy is a new contributor. Be nice, and check out our Code of Conduct.
















          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%2f45176%2fgrouping-numeric-data-into-efficient-group-pool%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

          How to label and detect the document text images

          Vallis Paradisi

          Tabula Rosettana