What is the best way to organize the datasets for my task?Datasets understanding best practicesWhat is the best way to scale a numerical datasetHow to model user's buying behavior on Amazon?What would be the best way to structure and mine this set of data?What's the best way to rank aggregate imdb rating data?How do I determine the best statistical way for data transformation for standardization (like log, sq root) to remove bias between different datasets?The best way to calculate variations between 2 datasets?What are the ranges for number of features and data points for datasets in general?What is the best way to read SQL dataset in to Tensorflow?mlbench synthetic datasets for python

How could an airship be repaired midflight?

Do I need to consider instance restrictions when showing a language is in P?

What should I install to correct "ld: cannot find -lgbm and -linput" so that I can compile a Rust program?

What does "Four-F." mean?

Variable completely messes up echoed string

Do US professors/group leaders only get a salary, but no group budget?

What is the term when voters “dishonestly” choose something that they do not want to choose?

Does .bashrc contain syntax errors?

How to get the n-th line after a grepped one?

Practical application of matrices and determinants

Unfrosted light bulb

Why is indicated airspeed rather than ground speed used during the takeoff roll?

Print a physical multiplication table

Describing a chess game in a novel

Tikz: place node leftmost of two nodes of different widths

Is it true that good novels will automatically sell themselves on Amazon (and so on) and there is no need for one to waste time promoting?

Geography in 3D perspective

Hausdorff dimension of the boundary of fibres of Lipschitz maps

Does the attack bonus from a Masterwork weapon stack with the attack bonus from Masterwork ammunition?

Fewest number of steps to reach 200 using special calculator

Should I use acronyms in dialogues before telling the readers what it stands for in fiction?

Is there a hypothetical scenario that would make Earth uninhabitable for humans, but not for (the majority of) other animals?

Existence of a celestial body big enough for early civilization to be thought of as a second moon

How to terminate ping <dest> &



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


Datasets understanding best practicesWhat is the best way to scale a numerical datasetHow to model user's buying behavior on Amazon?What would be the best way to structure and mine this set of data?What's the best way to rank aggregate imdb rating data?How do I determine the best statistical way for data transformation for standardization (like log, sq root) to remove bias between different datasets?The best way to calculate variations between 2 datasets?What are the ranges for number of features and data points for datasets in general?What is the best way to read SQL dataset in to Tensorflow?mlbench synthetic datasets for python













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