Categorical vs continuous feature selection/engineering Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) 2019 Moderator Election Q&A - Questionnaire 2019 Community Moderator Election ResultsVisualizing Support Vector Machines (SVM) with Multiple Explanatory VariablesPredicting a Continuous output in a dataset with categoriesHow to perform Logistic Regression with a large number of features?Data balance -before or after feature selection/engineeringLSTM Feature selection processChi-squared for continuous variablesBest practices for selecting categorical featuresHierarchical Clustering and Variable SelectionTarget Encoding: missing value imputation before or after encodingManual feature engineering based on the output

Withdrew £2800, but only £2000 shows as withdrawn on online banking; what are my obligations?

Using Random Forest variable importance for feature selection

How discoverable are IPv6 addresses and AAAA names by potential attackers?

Can I cast Passwall to drop an enemy into a 20-foot pit?

Identifying polygons that intersect with another layer using QGIS?

Should I discuss the type of campaign with my players?

Sci-Fi book where patients in a coma ward all live in a subconscious world linked together

How to tell that you are a giant?

Why am I getting the error "non-boolean type specified in a context where a condition is expected" for this request?

How does the particle を relate to the verb 行く in the structure「A を + B に行く」?

Using audio cues to encourage good posture

Can a non-EU citizen traveling with me come with me through the EU passport line?

Why do people hide their license plates in the EU?

Bete Noir -- no dairy

Is there a node or combination of nodes that can take an average colour out of a single image?

How can I (re)show post-installation notes?

Single word antonym of "flightless"

String `!23` is replaced with `docker` in command line

What's the purpose of writing one's academic biography in the third person?

Book where humans were engineered with genes from animal species to survive hostile planets

porting install scripts : can rpm replace apt?

How to react to hostile behavior from a senior developer?

What is the meaning of the new sigil in Game of Thrones Season 8 intro?

Is pollution the main cause of Notre Dame Cathedral's deterioration?



Categorical vs continuous feature selection/engineering



Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)
2019 Moderator Election Q&A - Questionnaire
2019 Community Moderator Election ResultsVisualizing Support Vector Machines (SVM) with Multiple Explanatory VariablesPredicting a Continuous output in a dataset with categoriesHow to perform Logistic Regression with a large number of features?Data balance -before or after feature selection/engineeringLSTM Feature selection processChi-squared for continuous variablesBest practices for selecting categorical featuresHierarchical Clustering and Variable SelectionTarget Encoding: missing value imputation before or after encodingManual feature engineering based on the output










3












$begingroup$


I'm working with a dataset with a number of potential predictors like :



Age : continuous



Number of children : discrete and numerical



Marital Situation : Categorical ( Married/Single/Divorced.. )



Id_User : Categorical ( an id of the user who conducted the first interview with this person )



I'm stopping at four potential predictors, there are more, but for the sake of shortness, these would be enough to ask my question.



Question : Continuous features are easy to deal with, normalize, and feed it to the model, what about categorical and independant ?



Note : I get that categorical features that follow a certain pattern can be encoded as integers and fed to the model, but what if those categorical features have no meaning as integers ( 1 for single, 2 for married , 3 for divorced ; for the model that treats it as a quantitative predictor it doesn't make sense to feed it to it like that)



Any ways to deal with these different types of features?










share|improve this question











$endgroup$
















    3












    $begingroup$


    I'm working with a dataset with a number of potential predictors like :



    Age : continuous



    Number of children : discrete and numerical



    Marital Situation : Categorical ( Married/Single/Divorced.. )



    Id_User : Categorical ( an id of the user who conducted the first interview with this person )



    I'm stopping at four potential predictors, there are more, but for the sake of shortness, these would be enough to ask my question.



    Question : Continuous features are easy to deal with, normalize, and feed it to the model, what about categorical and independant ?



    Note : I get that categorical features that follow a certain pattern can be encoded as integers and fed to the model, but what if those categorical features have no meaning as integers ( 1 for single, 2 for married , 3 for divorced ; for the model that treats it as a quantitative predictor it doesn't make sense to feed it to it like that)



    Any ways to deal with these different types of features?










    share|improve this question











    $endgroup$














      3












      3








      3





      $begingroup$


      I'm working with a dataset with a number of potential predictors like :



      Age : continuous



      Number of children : discrete and numerical



      Marital Situation : Categorical ( Married/Single/Divorced.. )



      Id_User : Categorical ( an id of the user who conducted the first interview with this person )



      I'm stopping at four potential predictors, there are more, but for the sake of shortness, these would be enough to ask my question.



      Question : Continuous features are easy to deal with, normalize, and feed it to the model, what about categorical and independant ?



      Note : I get that categorical features that follow a certain pattern can be encoded as integers and fed to the model, but what if those categorical features have no meaning as integers ( 1 for single, 2 for married , 3 for divorced ; for the model that treats it as a quantitative predictor it doesn't make sense to feed it to it like that)



      Any ways to deal with these different types of features?










      share|improve this question











      $endgroup$




      I'm working with a dataset with a number of potential predictors like :



      Age : continuous



      Number of children : discrete and numerical



      Marital Situation : Categorical ( Married/Single/Divorced.. )



      Id_User : Categorical ( an id of the user who conducted the first interview with this person )



      I'm stopping at four potential predictors, there are more, but for the sake of shortness, these would be enough to ask my question.



      Question : Continuous features are easy to deal with, normalize, and feed it to the model, what about categorical and independant ?



      Note : I get that categorical features that follow a certain pattern can be encoded as integers and fed to the model, but what if those categorical features have no meaning as integers ( 1 for single, 2 for married , 3 for divorced ; for the model that treats it as a quantitative predictor it doesn't make sense to feed it to it like that)



      Any ways to deal with these different types of features?







      machine-learning feature-selection feature-engineering






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited Apr 12 at 10:57







      Blenzus

















      asked Apr 12 at 10:17









      BlenzusBlenzus

      16910




      16910




















          5 Answers
          5






          active

          oldest

          votes


















          4












          $begingroup$

          What you are looking for are called dummy variables, they convert your categorical data into a matrix where the column is 1 if the person belongs to a category or 0 otherwise.



          The variable ID is not convertible because you don't want your model to overfit over your ID data (meaning: You don't want your model to remember the result for every ID, you want your model to be general).



          import pandas as pd
          dataset2 = pd.get_dummies(dataset)





          share|improve this answer










          New contributor




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






          $endgroup$




















            3












            $begingroup$

            For encoding categorical features, there is two common ways:




            Ordinal encoder




            This is the way you mentioned as 'encoded as integers'. In this method, an integer starting from 0 is assigned to each category. The problem of this method is that it randomly prioritize categories. So in cases when there is no priority among categories, this encoding is meaningless as you mentioned. The only case it work is when assigning larger integer to some categories is meaningful.




            One-hot encoder




            This method makes a feature vector (one-hot vector) for each categorical feature which is the same size as the number of categories. The method assigns each component of the vector to one of the categories. For each data sample, it assigns 1 to component which its corresponding category is present at the sample and assigns 0 to other components. The benefit of this method is that unlike ordinal encoder it does not prioritize any category.



            So in your case, I highly recommend that you use one-hot encoder.






            share|improve this answer









            $endgroup$












            • $begingroup$
              The number of columns 'One-Hot' adds to the dataset doesn't affect in anyway the outcome of my model right?
              $endgroup$
              – Blenzus
              Apr 12 at 13:46










            • $begingroup$
              Are you afraid of overfitting?
              $endgroup$
              – pythinker
              Apr 12 at 13:51










            • $begingroup$
              aren't we all?! I'm under the impression that ,on the contrary, this method doesn't 'encourage' overfitting
              $endgroup$
              – Blenzus
              Apr 12 at 13:53










            • $begingroup$
              Yes, you are right. We all are afraid of over-fitting. By over-fitting I meant, when we increase the number of inputs the model have to learn more weights to map this inputs to outputs. So, I should say, it somehow affects the outcome of your model but it's not a serious concern.
              $endgroup$
              – pythinker
              Apr 12 at 13:59







            • 1




              $begingroup$
              I believe that in the context of machine learning, "dummy variable" is more commonly used for what you are referring to as "one-hot".
              $endgroup$
              – Acccumulation
              Apr 12 at 15:21


















            1












            $begingroup$

            One possibility to deal with categorical inputs is to introduce the category input vector $boldsymbolt$. The category input vector of the $n^textth$ observation is given by



            $boldsymbolt_n=[t_1n, t_2n,...,t_Kn],$ in which $K$ is the number of categories. If the continuous input vector $boldsymbolx_n$ is belonging to category $k$, then $t_1i=1$ for $i=k$ and $t_1i=0$ for $ineq k$.



            This type of encoding is called one hot encoding for classification.






            share|improve this answer









            $endgroup$








            • 1




              $begingroup$
              I have a lot of possible values 100+ in let's say Id_User, wouldn't that add 100 additional columns to my dataset?
              $endgroup$
              – Blenzus
              Apr 12 at 11:08






            • 1




              $begingroup$
              @Blenzus: Yes you are right, but the columns are sparse. You have to remember that having so many categories is only feasible if you have a lot of data such that your data set is representative.
              $endgroup$
              – MachineLearner
              Apr 12 at 12:49


















            1












            $begingroup$

            As others have said, dummy variables is one method. Another method is to take quantitative statistics from the populations having that property. For instance, you can create a "marital situation average" column, and populate it with the average value of the target variable among people with the same marital situation as that subject.



            If you are using a tree method, simply assigning integers to each category will approximate dummy variables, especially if there are only a few categories. For instance, if the only categories for marital situation are Married, Single, Divorced, and Widowed, and you assign them 0, 1, 2, 3 respectively, then the only possible splits are Married vs. Everything else, Widowed vs. Everything else, or Married/Single vs Divorced/Widowed. So two thirds of the splits are effectively dummy variables, and the last one will turn into a dummy variable as soon as you split on that variable again.






            share|improve this answer









            $endgroup$




















              1












              $begingroup$

              There could be a number of ways of handling categorical data but what I have seen so far is to create a numeral mapping of the categorical data and then one-hot-encode the mappings to feed into the neural network.



              If you are working with Keras, you can use the to_categorical function to transform your mappings accordingly.



              >>> from keras.utils import to_categorical

              >>> y = [0,1,0,1,1]
              >>> oh_y = to_categorial(y, num_classes=2)
              >>> print(oh_y)

              [[1,0],[0,1],[1,0],[0,1],[0,1]]
              ```





              share|improve this answer









              $endgroup$












              • $begingroup$
                Thanks for the answer, no , actually i'm using "regular" classification algorithms , but yes i've used the to_categorical method while testing an ANN.
                $endgroup$
                – Blenzus
                yesterday











              Your Answer








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



              );













              draft saved

              draft discarded


















              StackExchange.ready(
              function ()
              StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdatascience.stackexchange.com%2fquestions%2f49185%2fcategorical-vs-continuous-feature-selection-engineering%23new-answer', 'question_page');

              );

              Post as a guest















              Required, but never shown

























              5 Answers
              5






              active

              oldest

              votes








              5 Answers
              5






              active

              oldest

              votes









              active

              oldest

              votes






              active

              oldest

              votes









              4












              $begingroup$

              What you are looking for are called dummy variables, they convert your categorical data into a matrix where the column is 1 if the person belongs to a category or 0 otherwise.



              The variable ID is not convertible because you don't want your model to overfit over your ID data (meaning: You don't want your model to remember the result for every ID, you want your model to be general).



              import pandas as pd
              dataset2 = pd.get_dummies(dataset)





              share|improve this answer










              New contributor




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






              $endgroup$

















                4












                $begingroup$

                What you are looking for are called dummy variables, they convert your categorical data into a matrix where the column is 1 if the person belongs to a category or 0 otherwise.



                The variable ID is not convertible because you don't want your model to overfit over your ID data (meaning: You don't want your model to remember the result for every ID, you want your model to be general).



                import pandas as pd
                dataset2 = pd.get_dummies(dataset)





                share|improve this answer










                New contributor




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






                $endgroup$















                  4












                  4








                  4





                  $begingroup$

                  What you are looking for are called dummy variables, they convert your categorical data into a matrix where the column is 1 if the person belongs to a category or 0 otherwise.



                  The variable ID is not convertible because you don't want your model to overfit over your ID data (meaning: You don't want your model to remember the result for every ID, you want your model to be general).



                  import pandas as pd
                  dataset2 = pd.get_dummies(dataset)





                  share|improve this answer










                  New contributor




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






                  $endgroup$



                  What you are looking for are called dummy variables, they convert your categorical data into a matrix where the column is 1 if the person belongs to a category or 0 otherwise.



                  The variable ID is not convertible because you don't want your model to overfit over your ID data (meaning: You don't want your model to remember the result for every ID, you want your model to be general).



                  import pandas as pd
                  dataset2 = pd.get_dummies(dataset)






                  share|improve this answer










                  New contributor




                  Juan Esteban de la Calle 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 answer



                  share|improve this answer








                  edited Apr 13 at 13:12









                  Stephen Rauch

                  1,52551330




                  1,52551330






                  New contributor




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









                  answered Apr 12 at 12:19









                  Juan Esteban de la CalleJuan Esteban de la Calle

                  34811




                  34811




                  New contributor




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





                  New contributor





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






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





















                      3












                      $begingroup$

                      For encoding categorical features, there is two common ways:




                      Ordinal encoder




                      This is the way you mentioned as 'encoded as integers'. In this method, an integer starting from 0 is assigned to each category. The problem of this method is that it randomly prioritize categories. So in cases when there is no priority among categories, this encoding is meaningless as you mentioned. The only case it work is when assigning larger integer to some categories is meaningful.




                      One-hot encoder




                      This method makes a feature vector (one-hot vector) for each categorical feature which is the same size as the number of categories. The method assigns each component of the vector to one of the categories. For each data sample, it assigns 1 to component which its corresponding category is present at the sample and assigns 0 to other components. The benefit of this method is that unlike ordinal encoder it does not prioritize any category.



                      So in your case, I highly recommend that you use one-hot encoder.






                      share|improve this answer









                      $endgroup$












                      • $begingroup$
                        The number of columns 'One-Hot' adds to the dataset doesn't affect in anyway the outcome of my model right?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:46










                      • $begingroup$
                        Are you afraid of overfitting?
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:51










                      • $begingroup$
                        aren't we all?! I'm under the impression that ,on the contrary, this method doesn't 'encourage' overfitting
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:53










                      • $begingroup$
                        Yes, you are right. We all are afraid of over-fitting. By over-fitting I meant, when we increase the number of inputs the model have to learn more weights to map this inputs to outputs. So, I should say, it somehow affects the outcome of your model but it's not a serious concern.
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:59







                      • 1




                        $begingroup$
                        I believe that in the context of machine learning, "dummy variable" is more commonly used for what you are referring to as "one-hot".
                        $endgroup$
                        – Acccumulation
                        Apr 12 at 15:21















                      3












                      $begingroup$

                      For encoding categorical features, there is two common ways:




                      Ordinal encoder




                      This is the way you mentioned as 'encoded as integers'. In this method, an integer starting from 0 is assigned to each category. The problem of this method is that it randomly prioritize categories. So in cases when there is no priority among categories, this encoding is meaningless as you mentioned. The only case it work is when assigning larger integer to some categories is meaningful.




                      One-hot encoder




                      This method makes a feature vector (one-hot vector) for each categorical feature which is the same size as the number of categories. The method assigns each component of the vector to one of the categories. For each data sample, it assigns 1 to component which its corresponding category is present at the sample and assigns 0 to other components. The benefit of this method is that unlike ordinal encoder it does not prioritize any category.



                      So in your case, I highly recommend that you use one-hot encoder.






                      share|improve this answer









                      $endgroup$












                      • $begingroup$
                        The number of columns 'One-Hot' adds to the dataset doesn't affect in anyway the outcome of my model right?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:46










                      • $begingroup$
                        Are you afraid of overfitting?
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:51










                      • $begingroup$
                        aren't we all?! I'm under the impression that ,on the contrary, this method doesn't 'encourage' overfitting
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:53










                      • $begingroup$
                        Yes, you are right. We all are afraid of over-fitting. By over-fitting I meant, when we increase the number of inputs the model have to learn more weights to map this inputs to outputs. So, I should say, it somehow affects the outcome of your model but it's not a serious concern.
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:59







                      • 1




                        $begingroup$
                        I believe that in the context of machine learning, "dummy variable" is more commonly used for what you are referring to as "one-hot".
                        $endgroup$
                        – Acccumulation
                        Apr 12 at 15:21













                      3












                      3








                      3





                      $begingroup$

                      For encoding categorical features, there is two common ways:




                      Ordinal encoder




                      This is the way you mentioned as 'encoded as integers'. In this method, an integer starting from 0 is assigned to each category. The problem of this method is that it randomly prioritize categories. So in cases when there is no priority among categories, this encoding is meaningless as you mentioned. The only case it work is when assigning larger integer to some categories is meaningful.




                      One-hot encoder




                      This method makes a feature vector (one-hot vector) for each categorical feature which is the same size as the number of categories. The method assigns each component of the vector to one of the categories. For each data sample, it assigns 1 to component which its corresponding category is present at the sample and assigns 0 to other components. The benefit of this method is that unlike ordinal encoder it does not prioritize any category.



                      So in your case, I highly recommend that you use one-hot encoder.






                      share|improve this answer









                      $endgroup$



                      For encoding categorical features, there is two common ways:




                      Ordinal encoder




                      This is the way you mentioned as 'encoded as integers'. In this method, an integer starting from 0 is assigned to each category. The problem of this method is that it randomly prioritize categories. So in cases when there is no priority among categories, this encoding is meaningless as you mentioned. The only case it work is when assigning larger integer to some categories is meaningful.




                      One-hot encoder




                      This method makes a feature vector (one-hot vector) for each categorical feature which is the same size as the number of categories. The method assigns each component of the vector to one of the categories. For each data sample, it assigns 1 to component which its corresponding category is present at the sample and assigns 0 to other components. The benefit of this method is that unlike ordinal encoder it does not prioritize any category.



                      So in your case, I highly recommend that you use one-hot encoder.







                      share|improve this answer












                      share|improve this answer



                      share|improve this answer










                      answered Apr 12 at 11:29









                      pythinkerpythinker

                      8291213




                      8291213











                      • $begingroup$
                        The number of columns 'One-Hot' adds to the dataset doesn't affect in anyway the outcome of my model right?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:46










                      • $begingroup$
                        Are you afraid of overfitting?
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:51










                      • $begingroup$
                        aren't we all?! I'm under the impression that ,on the contrary, this method doesn't 'encourage' overfitting
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:53










                      • $begingroup$
                        Yes, you are right. We all are afraid of over-fitting. By over-fitting I meant, when we increase the number of inputs the model have to learn more weights to map this inputs to outputs. So, I should say, it somehow affects the outcome of your model but it's not a serious concern.
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:59







                      • 1




                        $begingroup$
                        I believe that in the context of machine learning, "dummy variable" is more commonly used for what you are referring to as "one-hot".
                        $endgroup$
                        – Acccumulation
                        Apr 12 at 15:21
















                      • $begingroup$
                        The number of columns 'One-Hot' adds to the dataset doesn't affect in anyway the outcome of my model right?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:46










                      • $begingroup$
                        Are you afraid of overfitting?
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:51










                      • $begingroup$
                        aren't we all?! I'm under the impression that ,on the contrary, this method doesn't 'encourage' overfitting
                        $endgroup$
                        – Blenzus
                        Apr 12 at 13:53










                      • $begingroup$
                        Yes, you are right. We all are afraid of over-fitting. By over-fitting I meant, when we increase the number of inputs the model have to learn more weights to map this inputs to outputs. So, I should say, it somehow affects the outcome of your model but it's not a serious concern.
                        $endgroup$
                        – pythinker
                        Apr 12 at 13:59







                      • 1




                        $begingroup$
                        I believe that in the context of machine learning, "dummy variable" is more commonly used for what you are referring to as "one-hot".
                        $endgroup$
                        – Acccumulation
                        Apr 12 at 15:21















                      $begingroup$
                      The number of columns 'One-Hot' adds to the dataset doesn't affect in anyway the outcome of my model right?
                      $endgroup$
                      – Blenzus
                      Apr 12 at 13:46




                      $begingroup$
                      The number of columns 'One-Hot' adds to the dataset doesn't affect in anyway the outcome of my model right?
                      $endgroup$
                      – Blenzus
                      Apr 12 at 13:46












                      $begingroup$
                      Are you afraid of overfitting?
                      $endgroup$
                      – pythinker
                      Apr 12 at 13:51




                      $begingroup$
                      Are you afraid of overfitting?
                      $endgroup$
                      – pythinker
                      Apr 12 at 13:51












                      $begingroup$
                      aren't we all?! I'm under the impression that ,on the contrary, this method doesn't 'encourage' overfitting
                      $endgroup$
                      – Blenzus
                      Apr 12 at 13:53




                      $begingroup$
                      aren't we all?! I'm under the impression that ,on the contrary, this method doesn't 'encourage' overfitting
                      $endgroup$
                      – Blenzus
                      Apr 12 at 13:53












                      $begingroup$
                      Yes, you are right. We all are afraid of over-fitting. By over-fitting I meant, when we increase the number of inputs the model have to learn more weights to map this inputs to outputs. So, I should say, it somehow affects the outcome of your model but it's not a serious concern.
                      $endgroup$
                      – pythinker
                      Apr 12 at 13:59





                      $begingroup$
                      Yes, you are right. We all are afraid of over-fitting. By over-fitting I meant, when we increase the number of inputs the model have to learn more weights to map this inputs to outputs. So, I should say, it somehow affects the outcome of your model but it's not a serious concern.
                      $endgroup$
                      – pythinker
                      Apr 12 at 13:59





                      1




                      1




                      $begingroup$
                      I believe that in the context of machine learning, "dummy variable" is more commonly used for what you are referring to as "one-hot".
                      $endgroup$
                      – Acccumulation
                      Apr 12 at 15:21




                      $begingroup$
                      I believe that in the context of machine learning, "dummy variable" is more commonly used for what you are referring to as "one-hot".
                      $endgroup$
                      – Acccumulation
                      Apr 12 at 15:21











                      1












                      $begingroup$

                      One possibility to deal with categorical inputs is to introduce the category input vector $boldsymbolt$. The category input vector of the $n^textth$ observation is given by



                      $boldsymbolt_n=[t_1n, t_2n,...,t_Kn],$ in which $K$ is the number of categories. If the continuous input vector $boldsymbolx_n$ is belonging to category $k$, then $t_1i=1$ for $i=k$ and $t_1i=0$ for $ineq k$.



                      This type of encoding is called one hot encoding for classification.






                      share|improve this answer









                      $endgroup$








                      • 1




                        $begingroup$
                        I have a lot of possible values 100+ in let's say Id_User, wouldn't that add 100 additional columns to my dataset?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 11:08






                      • 1




                        $begingroup$
                        @Blenzus: Yes you are right, but the columns are sparse. You have to remember that having so many categories is only feasible if you have a lot of data such that your data set is representative.
                        $endgroup$
                        – MachineLearner
                        Apr 12 at 12:49















                      1












                      $begingroup$

                      One possibility to deal with categorical inputs is to introduce the category input vector $boldsymbolt$. The category input vector of the $n^textth$ observation is given by



                      $boldsymbolt_n=[t_1n, t_2n,...,t_Kn],$ in which $K$ is the number of categories. If the continuous input vector $boldsymbolx_n$ is belonging to category $k$, then $t_1i=1$ for $i=k$ and $t_1i=0$ for $ineq k$.



                      This type of encoding is called one hot encoding for classification.






                      share|improve this answer









                      $endgroup$








                      • 1




                        $begingroup$
                        I have a lot of possible values 100+ in let's say Id_User, wouldn't that add 100 additional columns to my dataset?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 11:08






                      • 1




                        $begingroup$
                        @Blenzus: Yes you are right, but the columns are sparse. You have to remember that having so many categories is only feasible if you have a lot of data such that your data set is representative.
                        $endgroup$
                        – MachineLearner
                        Apr 12 at 12:49













                      1












                      1








                      1





                      $begingroup$

                      One possibility to deal with categorical inputs is to introduce the category input vector $boldsymbolt$. The category input vector of the $n^textth$ observation is given by



                      $boldsymbolt_n=[t_1n, t_2n,...,t_Kn],$ in which $K$ is the number of categories. If the continuous input vector $boldsymbolx_n$ is belonging to category $k$, then $t_1i=1$ for $i=k$ and $t_1i=0$ for $ineq k$.



                      This type of encoding is called one hot encoding for classification.






                      share|improve this answer









                      $endgroup$



                      One possibility to deal with categorical inputs is to introduce the category input vector $boldsymbolt$. The category input vector of the $n^textth$ observation is given by



                      $boldsymbolt_n=[t_1n, t_2n,...,t_Kn],$ in which $K$ is the number of categories. If the continuous input vector $boldsymbolx_n$ is belonging to category $k$, then $t_1i=1$ for $i=k$ and $t_1i=0$ for $ineq k$.



                      This type of encoding is called one hot encoding for classification.







                      share|improve this answer












                      share|improve this answer



                      share|improve this answer










                      answered Apr 12 at 11:02









                      MachineLearnerMachineLearner

                      399110




                      399110







                      • 1




                        $begingroup$
                        I have a lot of possible values 100+ in let's say Id_User, wouldn't that add 100 additional columns to my dataset?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 11:08






                      • 1




                        $begingroup$
                        @Blenzus: Yes you are right, but the columns are sparse. You have to remember that having so many categories is only feasible if you have a lot of data such that your data set is representative.
                        $endgroup$
                        – MachineLearner
                        Apr 12 at 12:49












                      • 1




                        $begingroup$
                        I have a lot of possible values 100+ in let's say Id_User, wouldn't that add 100 additional columns to my dataset?
                        $endgroup$
                        – Blenzus
                        Apr 12 at 11:08






                      • 1




                        $begingroup$
                        @Blenzus: Yes you are right, but the columns are sparse. You have to remember that having so many categories is only feasible if you have a lot of data such that your data set is representative.
                        $endgroup$
                        – MachineLearner
                        Apr 12 at 12:49







                      1




                      1




                      $begingroup$
                      I have a lot of possible values 100+ in let's say Id_User, wouldn't that add 100 additional columns to my dataset?
                      $endgroup$
                      – Blenzus
                      Apr 12 at 11:08




                      $begingroup$
                      I have a lot of possible values 100+ in let's say Id_User, wouldn't that add 100 additional columns to my dataset?
                      $endgroup$
                      – Blenzus
                      Apr 12 at 11:08




                      1




                      1




                      $begingroup$
                      @Blenzus: Yes you are right, but the columns are sparse. You have to remember that having so many categories is only feasible if you have a lot of data such that your data set is representative.
                      $endgroup$
                      – MachineLearner
                      Apr 12 at 12:49




                      $begingroup$
                      @Blenzus: Yes you are right, but the columns are sparse. You have to remember that having so many categories is only feasible if you have a lot of data such that your data set is representative.
                      $endgroup$
                      – MachineLearner
                      Apr 12 at 12:49











                      1












                      $begingroup$

                      As others have said, dummy variables is one method. Another method is to take quantitative statistics from the populations having that property. For instance, you can create a "marital situation average" column, and populate it with the average value of the target variable among people with the same marital situation as that subject.



                      If you are using a tree method, simply assigning integers to each category will approximate dummy variables, especially if there are only a few categories. For instance, if the only categories for marital situation are Married, Single, Divorced, and Widowed, and you assign them 0, 1, 2, 3 respectively, then the only possible splits are Married vs. Everything else, Widowed vs. Everything else, or Married/Single vs Divorced/Widowed. So two thirds of the splits are effectively dummy variables, and the last one will turn into a dummy variable as soon as you split on that variable again.






                      share|improve this answer









                      $endgroup$

















                        1












                        $begingroup$

                        As others have said, dummy variables is one method. Another method is to take quantitative statistics from the populations having that property. For instance, you can create a "marital situation average" column, and populate it with the average value of the target variable among people with the same marital situation as that subject.



                        If you are using a tree method, simply assigning integers to each category will approximate dummy variables, especially if there are only a few categories. For instance, if the only categories for marital situation are Married, Single, Divorced, and Widowed, and you assign them 0, 1, 2, 3 respectively, then the only possible splits are Married vs. Everything else, Widowed vs. Everything else, or Married/Single vs Divorced/Widowed. So two thirds of the splits are effectively dummy variables, and the last one will turn into a dummy variable as soon as you split on that variable again.






                        share|improve this answer









                        $endgroup$















                          1












                          1








                          1





                          $begingroup$

                          As others have said, dummy variables is one method. Another method is to take quantitative statistics from the populations having that property. For instance, you can create a "marital situation average" column, and populate it with the average value of the target variable among people with the same marital situation as that subject.



                          If you are using a tree method, simply assigning integers to each category will approximate dummy variables, especially if there are only a few categories. For instance, if the only categories for marital situation are Married, Single, Divorced, and Widowed, and you assign them 0, 1, 2, 3 respectively, then the only possible splits are Married vs. Everything else, Widowed vs. Everything else, or Married/Single vs Divorced/Widowed. So two thirds of the splits are effectively dummy variables, and the last one will turn into a dummy variable as soon as you split on that variable again.






                          share|improve this answer









                          $endgroup$



                          As others have said, dummy variables is one method. Another method is to take quantitative statistics from the populations having that property. For instance, you can create a "marital situation average" column, and populate it with the average value of the target variable among people with the same marital situation as that subject.



                          If you are using a tree method, simply assigning integers to each category will approximate dummy variables, especially if there are only a few categories. For instance, if the only categories for marital situation are Married, Single, Divorced, and Widowed, and you assign them 0, 1, 2, 3 respectively, then the only possible splits are Married vs. Everything else, Widowed vs. Everything else, or Married/Single vs Divorced/Widowed. So two thirds of the splits are effectively dummy variables, and the last one will turn into a dummy variable as soon as you split on that variable again.







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered Apr 12 at 15:36









                          AcccumulationAcccumulation

                          1311




                          1311





















                              1












                              $begingroup$

                              There could be a number of ways of handling categorical data but what I have seen so far is to create a numeral mapping of the categorical data and then one-hot-encode the mappings to feed into the neural network.



                              If you are working with Keras, you can use the to_categorical function to transform your mappings accordingly.



                              >>> from keras.utils import to_categorical

                              >>> y = [0,1,0,1,1]
                              >>> oh_y = to_categorial(y, num_classes=2)
                              >>> print(oh_y)

                              [[1,0],[0,1],[1,0],[0,1],[0,1]]
                              ```





                              share|improve this answer









                              $endgroup$












                              • $begingroup$
                                Thanks for the answer, no , actually i'm using "regular" classification algorithms , but yes i've used the to_categorical method while testing an ANN.
                                $endgroup$
                                – Blenzus
                                yesterday















                              1












                              $begingroup$

                              There could be a number of ways of handling categorical data but what I have seen so far is to create a numeral mapping of the categorical data and then one-hot-encode the mappings to feed into the neural network.



                              If you are working with Keras, you can use the to_categorical function to transform your mappings accordingly.



                              >>> from keras.utils import to_categorical

                              >>> y = [0,1,0,1,1]
                              >>> oh_y = to_categorial(y, num_classes=2)
                              >>> print(oh_y)

                              [[1,0],[0,1],[1,0],[0,1],[0,1]]
                              ```





                              share|improve this answer









                              $endgroup$












                              • $begingroup$
                                Thanks for the answer, no , actually i'm using "regular" classification algorithms , but yes i've used the to_categorical method while testing an ANN.
                                $endgroup$
                                – Blenzus
                                yesterday













                              1












                              1








                              1





                              $begingroup$

                              There could be a number of ways of handling categorical data but what I have seen so far is to create a numeral mapping of the categorical data and then one-hot-encode the mappings to feed into the neural network.



                              If you are working with Keras, you can use the to_categorical function to transform your mappings accordingly.



                              >>> from keras.utils import to_categorical

                              >>> y = [0,1,0,1,1]
                              >>> oh_y = to_categorial(y, num_classes=2)
                              >>> print(oh_y)

                              [[1,0],[0,1],[1,0],[0,1],[0,1]]
                              ```





                              share|improve this answer









                              $endgroup$



                              There could be a number of ways of handling categorical data but what I have seen so far is to create a numeral mapping of the categorical data and then one-hot-encode the mappings to feed into the neural network.



                              If you are working with Keras, you can use the to_categorical function to transform your mappings accordingly.



                              >>> from keras.utils import to_categorical

                              >>> y = [0,1,0,1,1]
                              >>> oh_y = to_categorial(y, num_classes=2)
                              >>> print(oh_y)

                              [[1,0],[0,1],[1,0],[0,1],[0,1]]
                              ```






                              share|improve this answer












                              share|improve this answer



                              share|improve this answer










                              answered Apr 13 at 9:27









                              thanatozthanatoz

                              643421




                              643421











                              • $begingroup$
                                Thanks for the answer, no , actually i'm using "regular" classification algorithms , but yes i've used the to_categorical method while testing an ANN.
                                $endgroup$
                                – Blenzus
                                yesterday
















                              • $begingroup$
                                Thanks for the answer, no , actually i'm using "regular" classification algorithms , but yes i've used the to_categorical method while testing an ANN.
                                $endgroup$
                                – Blenzus
                                yesterday















                              $begingroup$
                              Thanks for the answer, no , actually i'm using "regular" classification algorithms , but yes i've used the to_categorical method while testing an ANN.
                              $endgroup$
                              – Blenzus
                              yesterday




                              $begingroup$
                              Thanks for the answer, no , actually i'm using "regular" classification algorithms , but yes i've used the to_categorical method while testing an ANN.
                              $endgroup$
                              – Blenzus
                              yesterday

















                              draft saved

                              draft discarded
















































                              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%2f49185%2fcategorical-vs-continuous-feature-selection-engineering%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

                              Àrd-bhaile Cathair chruinne/Baile mòr cruinne | Artagailean ceangailte | Clàr-taice na seòladaireachd

                              대한민국 목차 국명 지리 역사 정치 국방 경제 사회 문화 국제 순위 관련 항목 각주 외부 링크 둘러보기 메뉴북위 37° 34′ 08″ 동경 126° 58′ 36″ / 북위 37.568889° 동경 126.976667°  / 37.568889; 126.976667ehThe Korean Repository문단을 편집문단을 편집추가해Clarkson PLC 사Report for Selected Countries and Subjects-Korea“Human Development Index and its components: P.198”“http://www.law.go.kr/%EB%B2%95%EB%A0%B9/%EB%8C%80%ED%95%9C%EB%AF%BC%EA%B5%AD%EA%B5%AD%EA%B8%B0%EB%B2%95”"한국은 국제법상 한반도 유일 합법정부 아니다" - 오마이뉴스 모바일Report for Selected Countries and Subjects: South Korea격동의 역사와 함께한 조선일보 90년 : 조선일보 인수해 혁신시킨 신석우, 임시정부 때는 '대한민국' 국호(國號) 정해《우리가 몰랐던 우리 역사: 나라 이름의 비밀을 찾아가는 역사 여행》“남북 공식호칭 ‘남한’‘북한’으로 쓴다”“Corea 대 Korea, 누가 이긴 거야?”국내기후자료 - 한국[김대중 前 대통령 서거] 과감한 구조개혁 'DJ노믹스'로 최단기간 환란극복 :: 네이버 뉴스“이라크 "韓-쿠르드 유전개발 MOU 승인 안해"(종합)”“해외 우리국민 추방사례 43%가 일본”차기전차 K2'흑표'의 세계 최고 전력 분석, 쿠키뉴스 엄기영, 2007-03-02두산인프라, 헬기잡는 장갑차 'K21'...내년부터 공급, 고뉴스 이대준, 2008-10-30과거 내용 찾기mk 뉴스 - 구매력 기준으로 보면 한국 1인당 소득 3만弗과거 내용 찾기"The N-11: More Than an Acronym"Archived조선일보 최우석, 2008-11-01Global 500 2008: Countries - South Korea“몇년째 '시한폭탄'... 가계부채, 올해는 터질까”가구당 부채 5000만원 처음 넘어서“‘빚’으로 내몰리는 사회.. 위기의 가계대출”“[경제365] 공공부문 부채 급증…800조 육박”“"소득 양극화 다소 완화...불평등은 여전"”“공정사회·공생발전 한참 멀었네”iSuppli,08年2QのDRAMシェア・ランキングを発表(08/8/11)South Korea dominates shipbuilding industry | Stock Market News & Stocks to Watch from StraightStocks한국 자동차 생산, 3년 연속 세계 5위자동차수출 '현대-삼성 웃고 기아-대우-쌍용은 울고' 과거 내용 찾기동반성장위 창립 1주년 맞아Archived"중기적합 3개업종 합의 무시한 채 선정"李대통령, 사업 무분별 확장 소상공인 생계 위협 질타삼성-LG, 서민업종인 빵·분식사업 잇따라 철수상생은 뒷전…SSM ‘몸집 불리기’ 혈안Archived“경부고속도에 '아시안하이웨이' 표지판”'철의 실크로드' 앞서 '말(言)의 실크로드'부터, 프레시안 정창현, 2008-10-01“'서울 지하철은 안전한가?'”“서울시 “올해 안에 모든 지하철역 스크린도어 설치””“부산지하철 1,2호선 승강장 안전펜스 설치 완료”“전교조, 정부 노조 통계서 처음 빠져”“[Weekly BIZ] 도요타 '제로 이사회'가 리콜 사태 불러들였다”“S Korea slams high tuition costs”““정치가 여론 양극화 부채질… 합리주의 절실””“〈"`촛불집회'는 민주주의의 질적 변화 상징"〉”““촛불집회가 민주주의 왜곡 초래””“국민 65%, "한국 노사관계 대립적"”“한국 국가경쟁력 27위‥노사관계 '꼴찌'”“제대로 형성되지 않은 대한민국 이념지형”“[신년기획-갈등의 시대] 갈등지수 OECD 4위…사회적 손실 GDP 27% 무려 300조”“2012 총선-대선의 키워드는 '국민과 소통'”“한국 삶의 질 27위, 2000년과 2008년 연속 하위권 머물러”“[해피 코리아] 행복점수 68점…해외 평가선 '낙제점'”“한국 어린이·청소년 행복지수 3년 연속 OECD ‘꼴찌’”“한국 이혼율 OECD중 8위”“[통계청] 한국 이혼율 OECD 4위”“오피니언 [이렇게 생각한다] `부부의 날` 에 돌아본 이혼율 1위 한국”“Suicide Rates by Country, Global Health Observatory Data Repository.”“1. 또 다른 차별”“오피니언 [편집자에게] '왕따'와 '패거리 정치' 심리는 닮은꼴”“[미래한국리포트] 무한경쟁에 빠진 대한민국”“대학생 98% "외모가 경쟁력이라는 말 동의"”“특급호텔 웨딩·200만원대 유모차… "남보다 더…" 호화病, 고질병 됐다”“[스트레스 공화국] ① 경쟁사회, 스트레스 쌓인다”““매일 30여명 자살 한국, 의사보다 무속인에…””“"자살 부르는 '우울증', 환자 중 85% 치료 안 받아"”“정신병원을 가다”“대한민국도 ‘묻지마 범죄’,안전지대 아니다”“유엔 "학생 '성적 지향'에 따른 차별 금지하라"”“유엔아동권리위원회 보고서 및 번역본 원문”“고졸 성공스토리 담은 '제빵왕 김탁구' 드라마 나온다”“‘빛 좋은 개살구’ 고졸 취업…실습 대신 착취”원본 문서“정신건강, 사회적 편견부터 고쳐드립니다”‘소통’과 ‘행복’에 목 마른 사회가 잠들어 있던 ‘심리학’ 깨웠다“[포토] 사유리-곽금주 교수의 유쾌한 심리상담”“"올해 한국인 평균 영화관람횟수 세계 1위"(종합)”“[게임연중기획] 게임은 문화다-여가활동 1순위 게임”“영화속 ‘영어 지상주의’ …“왠지 씁쓸한데””“2월 `신문 부수 인증기관` 지정..방송법 후속작업”“무료신문 성장동력 ‘차별성’과 ‘갈등해소’”대한민국 국회 법률지식정보시스템"Pew Research Center's Religion & Public Life Project: South Korea"“amp;vwcd=MT_ZTITLE&path=인구·가구%20>%20인구총조사%20>%20인구부문%20>%20 총조사인구(2005)%20>%20전수부문&oper_YN=Y&item=&keyword=종교별%20인구& amp;lang_mode=kor&list_id= 2005년 통계청 인구 총조사”원본 문서“한국인이 좋아하는 취미와 운동 (2004-2009)”“한국인이 좋아하는 취미와 운동 (2004-2014)”Archived“한국, `부분적 언론자유국' 강등〈프리덤하우스〉”“국경없는기자회 "한국, 인터넷감시 대상국"”“한국, 조선산업 1위 유지(S. Korea Stays Top Shipbuilding Nation) RZD-Partner Portal”원본 문서“한국, 4년 만에 ‘선박건조 1위’”“옛 마산시,인터넷속도 세계 1위”“"한국 초고속 인터넷망 세계1위"”“인터넷·휴대폰 요금, 외국보다 훨씬 비싸”“한국 관세행정 6년 연속 세계 '1위'”“한국 교통사고 사망자 수 OECD 회원국 중 2위”“결핵 후진국' 한국, 환자가 급증한 이유는”“수술은 신중해야… 자칫하면 생명 위협”대한민국분류대한민국의 지도대한민국 정부대표 다국어포털대한민국 전자정부대한민국 국회한국방송공사about korea and information korea브리태니커 백과사전(한국편)론리플래닛의 정보(한국편)CIA의 세계 정보(한국편)마리암 부디아 (Mariam Budia),『한국: 하늘이 내린 한 폭의 그림』, 서울: 트랜스라틴 19호 (2012년 3월)대한민국ehehehehehehehehehehehehehehWorldCat132441370n791268020000 0001 2308 81034078029-6026373548cb11863345f(데이터)00573706ge128495

                              Cannot Extend partition with GParted The 2019 Stack Overflow Developer Survey Results Are In Announcing the arrival of Valued Associate #679: Cesar Manara Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern) 2019 Community Moderator Election ResultsCan't increase partition size with GParted?GParted doesn't recognize the unallocated space after my current partitionWhat is the best way to add unallocated space located before to Ubuntu 12.04 partition with GParted live?I can't figure out how to extend my Arch home partition into free spaceGparted Linux Mint 18.1 issueTrying to extend but swap partition is showing as Unknown in Gparted, shows proper from fdiskRearrange partitions in gparted to extend a partitionUnable to extend partition even though unallocated space is next to it using GPartedAllocate free space to root partitiongparted: how to merge unallocated space with a partition