What is the best way to organize the datasets for my task?












2












$begingroup$


I am working on a task — geolocation estimation of Twitter users by using tweets only. I collected tweets (and users) from more than 6000 people in Twitter. Each user is associated with a city.



In the dataset, number of samples (or users) for each city depends on the city size. (i.e. If the city A is more populous than the city B, the city A has more users in the dataset.) This seems fair, but it creates an unbalanced dataset.



Right now, I am planing to collect another dataset; a dataset that is more balanced (i.e. there will be the almost the same amount of users for each city although there will still be more users in big cities). Doing this makes sense or should I continue with the unbalanced dataset? What approach would it be good for that task?










share|improve this question







New contributor




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







$endgroup$

















    2












    $begingroup$


    I am working on a task — geolocation estimation of Twitter users by using tweets only. I collected tweets (and users) from more than 6000 people in Twitter. Each user is associated with a city.



    In the dataset, number of samples (or users) for each city depends on the city size. (i.e. If the city A is more populous than the city B, the city A has more users in the dataset.) This seems fair, but it creates an unbalanced dataset.



    Right now, I am planing to collect another dataset; a dataset that is more balanced (i.e. there will be the almost the same amount of users for each city although there will still be more users in big cities). Doing this makes sense or should I continue with the unbalanced dataset? What approach would it be good for that task?










    share|improve this question







    New contributor




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







    $endgroup$















      2












      2








      2





      $begingroup$


      I am working on a task — geolocation estimation of Twitter users by using tweets only. I collected tweets (and users) from more than 6000 people in Twitter. Each user is associated with a city.



      In the dataset, number of samples (or users) for each city depends on the city size. (i.e. If the city A is more populous than the city B, the city A has more users in the dataset.) This seems fair, but it creates an unbalanced dataset.



      Right now, I am planing to collect another dataset; a dataset that is more balanced (i.e. there will be the almost the same amount of users for each city although there will still be more users in big cities). Doing this makes sense or should I continue with the unbalanced dataset? What approach would it be good for that task?










      share|improve this question







      New contributor




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







      $endgroup$




      I am working on a task — geolocation estimation of Twitter users by using tweets only. I collected tweets (and users) from more than 6000 people in Twitter. Each user is associated with a city.



      In the dataset, number of samples (or users) for each city depends on the city size. (i.e. If the city A is more populous than the city B, the city A has more users in the dataset.) This seems fair, but it creates an unbalanced dataset.



      Right now, I am planing to collect another dataset; a dataset that is more balanced (i.e. there will be the almost the same amount of users for each city although there will still be more users in big cities). Doing this makes sense or should I continue with the unbalanced dataset? What approach would it be good for that task?







      dataset






      share|improve this question







      New contributor




      Mert Metin 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




      Mert Metin 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




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









      asked 2 days ago









      Mert MetinMert Metin

      111




      111




      New contributor




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





      New contributor





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






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






















          1 Answer
          1






          active

          oldest

          votes


















          0












          $begingroup$

          When you uniformly take samples from a society, definitely chance of selecting from cities is directly related to their population. Therefore, more users will be selected from more populous cities and it's one of the most important characters of the problem you trying to solve. I think if you want to balance the data-set, you ignore one this important character of your data and also your problem.



          I strongly recommend to continue with the unbalanced data-set and handle it by choosing an appropriate loss function and evaluation method.



          Disclaimer:



          If you use python, PyCM module can help you to find out these metrics.



          Here is a simple code to get the recommended parameters from this module:



          >>> from pycm import *

          >>> cm = ConfusionMatrix(matrix={"Class1": {"Class1": 1, "Class2":2}, "Class2": {"Class1": 0, "Class2": 5}})

          >>> print(cm.recommended_list)
          ["Kappa", "SOA1(Landis & Koch)", "SOA2(Fleiss)", "SOA3(Altman)", "SOA4(Cicchetti)", "CEN", "MCEN", "MCC", "J", "Overall J", "Overall MCC", "Overall CEN", "Overall MCEN", "AUC", "AUCI", "G", "DP", "DPI", "GI"]


          After that, each of these parameters you want to use as the loss function can be used as follows:



          >>> y_pred = model.predict      #the prediction of the implemented model

          >>> y_actu = data.target #data labels

          >>> cm = ConfusionMatrix(y_actu, y_pred)

          >>> loss = cm.Kappa #or any other parameter (Example: cm.SOA1)





          share|improve this answer











          $endgroup$













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


            }
            });






            Mert Metin 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%2f47356%2fwhat-is-the-best-way-to-organize-the-datasets-for-my-task%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            1 Answer
            1






            active

            oldest

            votes








            1 Answer
            1






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            0












            $begingroup$

            When you uniformly take samples from a society, definitely chance of selecting from cities is directly related to their population. Therefore, more users will be selected from more populous cities and it's one of the most important characters of the problem you trying to solve. I think if you want to balance the data-set, you ignore one this important character of your data and also your problem.



            I strongly recommend to continue with the unbalanced data-set and handle it by choosing an appropriate loss function and evaluation method.



            Disclaimer:



            If you use python, PyCM module can help you to find out these metrics.



            Here is a simple code to get the recommended parameters from this module:



            >>> from pycm import *

            >>> cm = ConfusionMatrix(matrix={"Class1": {"Class1": 1, "Class2":2}, "Class2": {"Class1": 0, "Class2": 5}})

            >>> print(cm.recommended_list)
            ["Kappa", "SOA1(Landis & Koch)", "SOA2(Fleiss)", "SOA3(Altman)", "SOA4(Cicchetti)", "CEN", "MCEN", "MCC", "J", "Overall J", "Overall MCC", "Overall CEN", "Overall MCEN", "AUC", "AUCI", "G", "DP", "DPI", "GI"]


            After that, each of these parameters you want to use as the loss function can be used as follows:



            >>> y_pred = model.predict      #the prediction of the implemented model

            >>> y_actu = data.target #data labels

            >>> cm = ConfusionMatrix(y_actu, y_pred)

            >>> loss = cm.Kappa #or any other parameter (Example: cm.SOA1)





            share|improve this answer











            $endgroup$


















              0












              $begingroup$

              When you uniformly take samples from a society, definitely chance of selecting from cities is directly related to their population. Therefore, more users will be selected from more populous cities and it's one of the most important characters of the problem you trying to solve. I think if you want to balance the data-set, you ignore one this important character of your data and also your problem.



              I strongly recommend to continue with the unbalanced data-set and handle it by choosing an appropriate loss function and evaluation method.



              Disclaimer:



              If you use python, PyCM module can help you to find out these metrics.



              Here is a simple code to get the recommended parameters from this module:



              >>> from pycm import *

              >>> cm = ConfusionMatrix(matrix={"Class1": {"Class1": 1, "Class2":2}, "Class2": {"Class1": 0, "Class2": 5}})

              >>> print(cm.recommended_list)
              ["Kappa", "SOA1(Landis & Koch)", "SOA2(Fleiss)", "SOA3(Altman)", "SOA4(Cicchetti)", "CEN", "MCEN", "MCC", "J", "Overall J", "Overall MCC", "Overall CEN", "Overall MCEN", "AUC", "AUCI", "G", "DP", "DPI", "GI"]


              After that, each of these parameters you want to use as the loss function can be used as follows:



              >>> y_pred = model.predict      #the prediction of the implemented model

              >>> y_actu = data.target #data labels

              >>> cm = ConfusionMatrix(y_actu, y_pred)

              >>> loss = cm.Kappa #or any other parameter (Example: cm.SOA1)





              share|improve this answer











              $endgroup$
















                0












                0








                0





                $begingroup$

                When you uniformly take samples from a society, definitely chance of selecting from cities is directly related to their population. Therefore, more users will be selected from more populous cities and it's one of the most important characters of the problem you trying to solve. I think if you want to balance the data-set, you ignore one this important character of your data and also your problem.



                I strongly recommend to continue with the unbalanced data-set and handle it by choosing an appropriate loss function and evaluation method.



                Disclaimer:



                If you use python, PyCM module can help you to find out these metrics.



                Here is a simple code to get the recommended parameters from this module:



                >>> from pycm import *

                >>> cm = ConfusionMatrix(matrix={"Class1": {"Class1": 1, "Class2":2}, "Class2": {"Class1": 0, "Class2": 5}})

                >>> print(cm.recommended_list)
                ["Kappa", "SOA1(Landis & Koch)", "SOA2(Fleiss)", "SOA3(Altman)", "SOA4(Cicchetti)", "CEN", "MCEN", "MCC", "J", "Overall J", "Overall MCC", "Overall CEN", "Overall MCEN", "AUC", "AUCI", "G", "DP", "DPI", "GI"]


                After that, each of these parameters you want to use as the loss function can be used as follows:



                >>> y_pred = model.predict      #the prediction of the implemented model

                >>> y_actu = data.target #data labels

                >>> cm = ConfusionMatrix(y_actu, y_pred)

                >>> loss = cm.Kappa #or any other parameter (Example: cm.SOA1)





                share|improve this answer











                $endgroup$



                When you uniformly take samples from a society, definitely chance of selecting from cities is directly related to their population. Therefore, more users will be selected from more populous cities and it's one of the most important characters of the problem you trying to solve. I think if you want to balance the data-set, you ignore one this important character of your data and also your problem.



                I strongly recommend to continue with the unbalanced data-set and handle it by choosing an appropriate loss function and evaluation method.



                Disclaimer:



                If you use python, PyCM module can help you to find out these metrics.



                Here is a simple code to get the recommended parameters from this module:



                >>> from pycm import *

                >>> cm = ConfusionMatrix(matrix={"Class1": {"Class1": 1, "Class2":2}, "Class2": {"Class1": 0, "Class2": 5}})

                >>> print(cm.recommended_list)
                ["Kappa", "SOA1(Landis & Koch)", "SOA2(Fleiss)", "SOA3(Altman)", "SOA4(Cicchetti)", "CEN", "MCEN", "MCC", "J", "Overall J", "Overall MCC", "Overall CEN", "Overall MCEN", "AUC", "AUCI", "G", "DP", "DPI", "GI"]


                After that, each of these parameters you want to use as the loss function can be used as follows:



                >>> y_pred = model.predict      #the prediction of the implemented model

                >>> y_actu = data.target #data labels

                >>> cm = ConfusionMatrix(y_actu, y_pred)

                >>> loss = cm.Kappa #or any other parameter (Example: cm.SOA1)






                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited 2 days ago

























                answered 2 days ago









                Alireza ZolanvariAlireza Zolanvari

                19114




                19114






















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










                    draft saved

                    draft discarded


















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













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












                    Mert Metin 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%2f47356%2fwhat-is-the-best-way-to-organize-the-datasets-for-my-task%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

                    Callistus I

                    Tabula Rosettana

                    How to label and detect the document text images