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







                    Popular posts from this blog

                    Is there a general name for the setup in which payoffs are not known exactly but players try to influence each other's perception of the payoffs?Osborne, Nash equilibria and the correctness of beliefsIs there a name for this family of games (Binomial games?)?Perfect Bayesian EquilibriumCalculating mixed strategy equilibrium in battle of sexesPure Strategy SPNEIs there a commitment mechanism which allows players to achieve pareto optimal solutions?Extensive Form GamesAn $n$-player prisoner's dilemma where a coalition of 2 players is better off defectingTit-For-Stat Strategy Best RepliesPotential solutions of the $n$-player Prisoner's Dilemma

                    Is flight data recorder erased after every flight?When are black boxes used?What protects the location beacon (pinger) of a flight data recorder?Is there anywhere I can pick up raw flight data recorder information?Who legally owns the Flight Data Recorder?Constructing flight recorder dataWhy are FDRs and CVRs still two separate physical devices?What are the data elements shown on the GE235 flight data recorder (FDR) plot?Are CVR and FDR reset after every flight?What is the format of data stored by a Flight Data Recorder?How much data is stored in the flight data recorder per hour in a typical flight of an A380?Is a smart flight data recorder possible?

                    Rank groups within a grouped sequence of TRUE/FALSE and NAGrouping functions (tapply, by, aggregate) and the *apply familyCharacters counting and subletting specific patternsWhat is the purpose of setting a key in data.table?data.table vs dplyr: can one do something well the other can't or does poorly?how to make a bar plot for a list of dataframes?How to group by unique values in a list in RPandas - Alternative to rank() function that gives unique ordinal ranks for a columnRank within group in for loop in RData transformation: from dyadic to observational data in RGetting map from purrr to work with paste0