clustering with heterogeneous (quantitative and qualitative)data?












0












$begingroup$


I'm a Phd student and I have the results of some approaches (algorithms) that I would like to analyze. Data (results) are stored in csv files as follows: - the lines describe each algorithm with its parameters and the result obtained. - Some columns (characteristics) are quantitative and others are qualitative (enumerated types) and the last column is the results which presents the efficiency of the algorithm and it is a numerical value that I can convert in classes (of intervals of values). I would like to highlight at first what is the tendency of the good and worse algorithmes. Then, what are the features that contributed to obtain these results I'm beginner in machine learning and I searched a lot on the net but i didn't find the appropriate method . Could you point me to a clustering/ learning method for this purpose.
I would be very greatful.
Best regards.










share|improve this question







New contributor




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







$endgroup$

















    0












    $begingroup$


    I'm a Phd student and I have the results of some approaches (algorithms) that I would like to analyze. Data (results) are stored in csv files as follows: - the lines describe each algorithm with its parameters and the result obtained. - Some columns (characteristics) are quantitative and others are qualitative (enumerated types) and the last column is the results which presents the efficiency of the algorithm and it is a numerical value that I can convert in classes (of intervals of values). I would like to highlight at first what is the tendency of the good and worse algorithmes. Then, what are the features that contributed to obtain these results I'm beginner in machine learning and I searched a lot on the net but i didn't find the appropriate method . Could you point me to a clustering/ learning method for this purpose.
    I would be very greatful.
    Best regards.










    share|improve this question







    New contributor




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







    $endgroup$















      0












      0








      0





      $begingroup$


      I'm a Phd student and I have the results of some approaches (algorithms) that I would like to analyze. Data (results) are stored in csv files as follows: - the lines describe each algorithm with its parameters and the result obtained. - Some columns (characteristics) are quantitative and others are qualitative (enumerated types) and the last column is the results which presents the efficiency of the algorithm and it is a numerical value that I can convert in classes (of intervals of values). I would like to highlight at first what is the tendency of the good and worse algorithmes. Then, what are the features that contributed to obtain these results I'm beginner in machine learning and I searched a lot on the net but i didn't find the appropriate method . Could you point me to a clustering/ learning method for this purpose.
      I would be very greatful.
      Best regards.










      share|improve this question







      New contributor




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







      $endgroup$




      I'm a Phd student and I have the results of some approaches (algorithms) that I would like to analyze. Data (results) are stored in csv files as follows: - the lines describe each algorithm with its parameters and the result obtained. - Some columns (characteristics) are quantitative and others are qualitative (enumerated types) and the last column is the results which presents the efficiency of the algorithm and it is a numerical value that I can convert in classes (of intervals of values). I would like to highlight at first what is the tendency of the good and worse algorithmes. Then, what are the features that contributed to obtain these results I'm beginner in machine learning and I searched a lot on the net but i didn't find the appropriate method . Could you point me to a clustering/ learning method for this purpose.
      I would be very greatful.
      Best regards.







      machine-learning clustering data-analysis






      share|improve this question







      New contributor




      sara zohra AHMED BACHA 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




      sara zohra AHMED BACHA 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




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









      asked 9 hours ago









      sara zohra AHMED BACHAsara zohra AHMED BACHA

      1




      1




      New contributor




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





      New contributor





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






      sara zohra AHMED BACHA 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$

          K-means algorithm cannot be directly used for data with both numerical and categorical values because of its objective function. K-means uses Euclidean distance, which cannot be defined for categorical data.



          However, there is a simple method which combines Euclidean distance and Hamming distance for the finding the similarity between instances that include both numerical and categorical features. In this method Euclidean distance is used as a metric for computing the similarity between numerical data and hamming distance for computing the similarity between categorical data. Both of them with the appropirate weights form an objective function that can handle mixed data.



          For more information check the relevant paper



          https://grid.cs.gsu.edu/~wkim/index_files/papers/kprototype.pdf






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


            }
            });






            sara zohra AHMED BACHA 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%2f45348%2fclustering-with-heterogeneous-quantitative-and-qualitativedata%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$

            K-means algorithm cannot be directly used for data with both numerical and categorical values because of its objective function. K-means uses Euclidean distance, which cannot be defined for categorical data.



            However, there is a simple method which combines Euclidean distance and Hamming distance for the finding the similarity between instances that include both numerical and categorical features. In this method Euclidean distance is used as a metric for computing the similarity between numerical data and hamming distance for computing the similarity between categorical data. Both of them with the appropirate weights form an objective function that can handle mixed data.



            For more information check the relevant paper



            https://grid.cs.gsu.edu/~wkim/index_files/papers/kprototype.pdf






            share|improve this answer









            $endgroup$


















              0












              $begingroup$

              K-means algorithm cannot be directly used for data with both numerical and categorical values because of its objective function. K-means uses Euclidean distance, which cannot be defined for categorical data.



              However, there is a simple method which combines Euclidean distance and Hamming distance for the finding the similarity between instances that include both numerical and categorical features. In this method Euclidean distance is used as a metric for computing the similarity between numerical data and hamming distance for computing the similarity between categorical data. Both of them with the appropirate weights form an objective function that can handle mixed data.



              For more information check the relevant paper



              https://grid.cs.gsu.edu/~wkim/index_files/papers/kprototype.pdf






              share|improve this answer









              $endgroup$
















                0












                0








                0





                $begingroup$

                K-means algorithm cannot be directly used for data with both numerical and categorical values because of its objective function. K-means uses Euclidean distance, which cannot be defined for categorical data.



                However, there is a simple method which combines Euclidean distance and Hamming distance for the finding the similarity between instances that include both numerical and categorical features. In this method Euclidean distance is used as a metric for computing the similarity between numerical data and hamming distance for computing the similarity between categorical data. Both of them with the appropirate weights form an objective function that can handle mixed data.



                For more information check the relevant paper



                https://grid.cs.gsu.edu/~wkim/index_files/papers/kprototype.pdf






                share|improve this answer









                $endgroup$



                K-means algorithm cannot be directly used for data with both numerical and categorical values because of its objective function. K-means uses Euclidean distance, which cannot be defined for categorical data.



                However, there is a simple method which combines Euclidean distance and Hamming distance for the finding the similarity between instances that include both numerical and categorical features. In this method Euclidean distance is used as a metric for computing the similarity between numerical data and hamming distance for computing the similarity between categorical data. Both of them with the appropirate weights form an objective function that can handle mixed data.



                For more information check the relevant paper



                https://grid.cs.gsu.edu/~wkim/index_files/papers/kprototype.pdf







                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered 8 hours ago









                Christos KaratsalosChristos Karatsalos

                49718




                49718






















                    sara zohra AHMED BACHA is a new contributor. Be nice, and check out our Code of Conduct.










                    draft saved

                    draft discarded


















                    sara zohra AHMED BACHA is a new contributor. Be nice, and check out our Code of Conduct.













                    sara zohra AHMED BACHA is a new contributor. Be nice, and check out our Code of Conduct.












                    sara zohra AHMED BACHA 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%2f45348%2fclustering-with-heterogeneous-quantitative-and-qualitativedata%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