Training a classifier when some of the features are unknown 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 ResultsClassifier ChainsHow to improve an existing (trained) classifier?What is effect when I set up some self defined predisctor variables?Why Matlab neural network classification returns decimal values on prediction dataset?Fitting and transforming text data in training, testing, and validation setsHow to quantify the performance of the classifier (multi-class SVM) using the test data?How do I control for some patients providing multiple samples in my training data?Training and Test setTraining a convolutional neural network for image denoising in MatlabDealing with correlated features when calculating permutation importance

Multi tool use
Multi tool use

Need a suitable toxic chemical for a murder plot in my novel

Is above average number of years spent on PhD considered a red flag in future academia or industry positions?

When is phishing education going too far?

How to politely respond to generic emails requesting a PhD/job in my lab? Without wasting too much time

The following signatures were invalid: EXPKEYSIG 1397BC53640DB551

Unable to start mainnet node docker container

Typsetting diagram chases (with TikZ?)

Complexity of many constant time steps with occasional logarithmic steps

Why is "Captain Marvel" translated as male in Portugal?

Can I throw a longsword at someone?

What was the last x86 CPU that did not have the x87 floating-point unit built in?

Mortgage adviser recommends a longer term than necessary combined with overpayments

Stars Make Stars

Windows 10: How to Lock (not sleep) laptop on lid close?

What to do with post with dry rot?

Why use gamma over alpha radiation?

Is drag coefficient lowest at zero angle of attack?

Passing functions in C++

Jazz greats knew nothing of modes. Why are they used to improvise on standards?

Stop battery usage [Ubuntu 18]

Why don't the Weasley twins use magic outside of school if the Trace can only find the location of spells cast?

What's the point in a preamp?

How is simplicity better than precision and clarity in prose?

What did Darwin mean by 'squib' here?



Training a classifier when some of the features are unknown



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 ResultsClassifier ChainsHow to improve an existing (trained) classifier?What is effect when I set up some self defined predisctor variables?Why Matlab neural network classification returns decimal values on prediction dataset?Fitting and transforming text data in training, testing, and validation setsHow to quantify the performance of the classifier (multi-class SVM) using the test data?How do I control for some patients providing multiple samples in my training data?Training and Test setTraining a convolutional neural network for image denoising in MatlabDealing with correlated features when calculating permutation importance










2












$begingroup$


I am training a classifier in Matlab with a dataset that I created.
Unfortunately some of the features in the dataset were not recorded.



I currently have the unknown features set as -99999.



So, for example my dataset looks something like this:



class1: 10 1 12 -99999 6 8
class1: 11 2 13 7 6 10
...
class2: 5 -99999 4 3 2 -99999
class2: -99999 16 4 3 1 8
...
class3: 18 2 11 22 7 5
class3: 19 1 9 25 7 5
...


and so on, where the -99999 are the places where the features werent able to be measured. In this case, each class has 6 features.



I don't want to bias my classifier with the unknown features so I thought it would be a good idea to set the unknowns to -99999 so it would be way out of the range of normal features.



I tested the classifier with the -99999's and it was 78% accurate.
Then I changed the -99999 to 0's and tested the classifier again, this time it was 91% accurate.



So my question is, what is a general rule for training a classifier when some of the features were not recorded? Was I right to assume setting the unknowns to a very high negative value? But why was it more accurate when I set the unknowns to 0s?



Thanks for reading!










share|improve this question









New contributor




Darklink9110 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 training a classifier in Matlab with a dataset that I created.
    Unfortunately some of the features in the dataset were not recorded.



    I currently have the unknown features set as -99999.



    So, for example my dataset looks something like this:



    class1: 10 1 12 -99999 6 8
    class1: 11 2 13 7 6 10
    ...
    class2: 5 -99999 4 3 2 -99999
    class2: -99999 16 4 3 1 8
    ...
    class3: 18 2 11 22 7 5
    class3: 19 1 9 25 7 5
    ...


    and so on, where the -99999 are the places where the features werent able to be measured. In this case, each class has 6 features.



    I don't want to bias my classifier with the unknown features so I thought it would be a good idea to set the unknowns to -99999 so it would be way out of the range of normal features.



    I tested the classifier with the -99999's and it was 78% accurate.
    Then I changed the -99999 to 0's and tested the classifier again, this time it was 91% accurate.



    So my question is, what is a general rule for training a classifier when some of the features were not recorded? Was I right to assume setting the unknowns to a very high negative value? But why was it more accurate when I set the unknowns to 0s?



    Thanks for reading!










    share|improve this question









    New contributor




    Darklink9110 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 training a classifier in Matlab with a dataset that I created.
      Unfortunately some of the features in the dataset were not recorded.



      I currently have the unknown features set as -99999.



      So, for example my dataset looks something like this:



      class1: 10 1 12 -99999 6 8
      class1: 11 2 13 7 6 10
      ...
      class2: 5 -99999 4 3 2 -99999
      class2: -99999 16 4 3 1 8
      ...
      class3: 18 2 11 22 7 5
      class3: 19 1 9 25 7 5
      ...


      and so on, where the -99999 are the places where the features werent able to be measured. In this case, each class has 6 features.



      I don't want to bias my classifier with the unknown features so I thought it would be a good idea to set the unknowns to -99999 so it would be way out of the range of normal features.



      I tested the classifier with the -99999's and it was 78% accurate.
      Then I changed the -99999 to 0's and tested the classifier again, this time it was 91% accurate.



      So my question is, what is a general rule for training a classifier when some of the features were not recorded? Was I right to assume setting the unknowns to a very high negative value? But why was it more accurate when I set the unknowns to 0s?



      Thanks for reading!










      share|improve this question









      New contributor




      Darklink9110 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 training a classifier in Matlab with a dataset that I created.
      Unfortunately some of the features in the dataset were not recorded.



      I currently have the unknown features set as -99999.



      So, for example my dataset looks something like this:



      class1: 10 1 12 -99999 6 8
      class1: 11 2 13 7 6 10
      ...
      class2: 5 -99999 4 3 2 -99999
      class2: -99999 16 4 3 1 8
      ...
      class3: 18 2 11 22 7 5
      class3: 19 1 9 25 7 5
      ...


      and so on, where the -99999 are the places where the features werent able to be measured. In this case, each class has 6 features.



      I don't want to bias my classifier with the unknown features so I thought it would be a good idea to set the unknowns to -99999 so it would be way out of the range of normal features.



      I tested the classifier with the -99999's and it was 78% accurate.
      Then I changed the -99999 to 0's and tested the classifier again, this time it was 91% accurate.



      So my question is, what is a general rule for training a classifier when some of the features were not recorded? Was I right to assume setting the unknowns to a very high negative value? But why was it more accurate when I set the unknowns to 0s?



      Thanks for reading!







      machine-learning classification dataset matlab






      share|improve this question









      New contributor




      Darklink9110 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




      Darklink9110 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








      edited 3 hours ago







      Darklink9110













      New contributor




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









      asked 3 hours ago









      Darklink9110Darklink9110

      113




      113




      New contributor




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





      New contributor





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






      Darklink9110 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


















          1












          $begingroup$

          Welcome to Data Science SE!



          Well, we say that most of our jobs is to wrangle with data, and that is because data is usually trying to deceive us... jokes aside:



          You have a missing data problem



          that means your have to clean your data and fill those missing values. To perform this cleaning process your must take the most classic statistician inside of you and ask:



          • Why is this data missing?

          • How much data is missing?

          There are many reasons for a specific information to be unavailable. This will demand you to make assumptions and decide how to deal with this.



          Jeff Sauro posted at MeasuringU: 7 Ways to Handle Missing Data, some which I list here:



          • Delete corrupted samples:

          If you have a large dataset and there is not much data missing, you can simply remove those corrupted data points and go on with life



          • Recover the values:

          Some problems will allow you to go back and get missing information.



          We usually ain't that lucky, then you can



          • Educated Guessing:

          Sometimes, you can infer what would be the feature value by simply looking their pears. That is a bit arbitrary but it might work.



          • Average:

          This is the most common approach, simply use the average of that value whenever it is missing. This might artificially reduce your variance but so does using 0 or -9999... for every missing value.



          • Regression Substitution:

          You can use a multiple regression to infer the missing value from the available values for each candidate.



          Some references on missing data are:



          • Allison, Paul D. 2001. Missing Data. Sage University Papers
            Series on Quantitative Applications in the Social Sciences.
            Thousand Oaks: Sage.

          • Enders, Craig. 2010. Applied Missing Data Analysis.
            Guilford Press: New York.

          • Little, Roderick J., Donald Rubin. 2002. Statistical Analysis
            with Missing Data. John Wiley & Sons, Inc: Hoboken.

          • Schafer, Joseph L., John W. Graham. 2002. “Missing Data:
            Our View of the State of the Art.” Psychological Methods.


          About your experiment:



          Adding -99... is creating outliers and that bit of information is heavy (numerically speaking, it is huge) and will affect parameter tuning. For example, suppose you have this data:



          | Feature1 | Feature2 | 
          |----------|----------|
          | 0 | 8 |
          | -1 | 7 |
          | 1 | - |
          | - | 8 |


          And you try filling the missing values with -99, now try to fit a linear regression trough the data. Can you see that you don't be able to fit it properly?



          The brown line



          The line won't fit, and this will yield bad performance.



          Adding 0 values on the other hand will give a slightly better line:



          The yellow line



          It is still not good, but slightly better since the scale of the parameters will be more realistic.



          Now, using average, is this case will give you even better curve, but using regression will give you a perfect fitting line:



          The perfect line



          Note: I need to remake those images, but these should do until I have the time for it.






          share|improve this answer











          $endgroup$













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



            );






            Darklink9110 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%2f49298%2ftraining-a-classifier-when-some-of-the-features-are-unknown%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









            1












            $begingroup$

            Welcome to Data Science SE!



            Well, we say that most of our jobs is to wrangle with data, and that is because data is usually trying to deceive us... jokes aside:



            You have a missing data problem



            that means your have to clean your data and fill those missing values. To perform this cleaning process your must take the most classic statistician inside of you and ask:



            • Why is this data missing?

            • How much data is missing?

            There are many reasons for a specific information to be unavailable. This will demand you to make assumptions and decide how to deal with this.



            Jeff Sauro posted at MeasuringU: 7 Ways to Handle Missing Data, some which I list here:



            • Delete corrupted samples:

            If you have a large dataset and there is not much data missing, you can simply remove those corrupted data points and go on with life



            • Recover the values:

            Some problems will allow you to go back and get missing information.



            We usually ain't that lucky, then you can



            • Educated Guessing:

            Sometimes, you can infer what would be the feature value by simply looking their pears. That is a bit arbitrary but it might work.



            • Average:

            This is the most common approach, simply use the average of that value whenever it is missing. This might artificially reduce your variance but so does using 0 or -9999... for every missing value.



            • Regression Substitution:

            You can use a multiple regression to infer the missing value from the available values for each candidate.



            Some references on missing data are:



            • Allison, Paul D. 2001. Missing Data. Sage University Papers
              Series on Quantitative Applications in the Social Sciences.
              Thousand Oaks: Sage.

            • Enders, Craig. 2010. Applied Missing Data Analysis.
              Guilford Press: New York.

            • Little, Roderick J., Donald Rubin. 2002. Statistical Analysis
              with Missing Data. John Wiley & Sons, Inc: Hoboken.

            • Schafer, Joseph L., John W. Graham. 2002. “Missing Data:
              Our View of the State of the Art.” Psychological Methods.


            About your experiment:



            Adding -99... is creating outliers and that bit of information is heavy (numerically speaking, it is huge) and will affect parameter tuning. For example, suppose you have this data:



            | Feature1 | Feature2 | 
            |----------|----------|
            | 0 | 8 |
            | -1 | 7 |
            | 1 | - |
            | - | 8 |


            And you try filling the missing values with -99, now try to fit a linear regression trough the data. Can you see that you don't be able to fit it properly?



            The brown line



            The line won't fit, and this will yield bad performance.



            Adding 0 values on the other hand will give a slightly better line:



            The yellow line



            It is still not good, but slightly better since the scale of the parameters will be more realistic.



            Now, using average, is this case will give you even better curve, but using regression will give you a perfect fitting line:



            The perfect line



            Note: I need to remake those images, but these should do until I have the time for it.






            share|improve this answer











            $endgroup$

















              1












              $begingroup$

              Welcome to Data Science SE!



              Well, we say that most of our jobs is to wrangle with data, and that is because data is usually trying to deceive us... jokes aside:



              You have a missing data problem



              that means your have to clean your data and fill those missing values. To perform this cleaning process your must take the most classic statistician inside of you and ask:



              • Why is this data missing?

              • How much data is missing?

              There are many reasons for a specific information to be unavailable. This will demand you to make assumptions and decide how to deal with this.



              Jeff Sauro posted at MeasuringU: 7 Ways to Handle Missing Data, some which I list here:



              • Delete corrupted samples:

              If you have a large dataset and there is not much data missing, you can simply remove those corrupted data points and go on with life



              • Recover the values:

              Some problems will allow you to go back and get missing information.



              We usually ain't that lucky, then you can



              • Educated Guessing:

              Sometimes, you can infer what would be the feature value by simply looking their pears. That is a bit arbitrary but it might work.



              • Average:

              This is the most common approach, simply use the average of that value whenever it is missing. This might artificially reduce your variance but so does using 0 or -9999... for every missing value.



              • Regression Substitution:

              You can use a multiple regression to infer the missing value from the available values for each candidate.



              Some references on missing data are:



              • Allison, Paul D. 2001. Missing Data. Sage University Papers
                Series on Quantitative Applications in the Social Sciences.
                Thousand Oaks: Sage.

              • Enders, Craig. 2010. Applied Missing Data Analysis.
                Guilford Press: New York.

              • Little, Roderick J., Donald Rubin. 2002. Statistical Analysis
                with Missing Data. John Wiley & Sons, Inc: Hoboken.

              • Schafer, Joseph L., John W. Graham. 2002. “Missing Data:
                Our View of the State of the Art.” Psychological Methods.


              About your experiment:



              Adding -99... is creating outliers and that bit of information is heavy (numerically speaking, it is huge) and will affect parameter tuning. For example, suppose you have this data:



              | Feature1 | Feature2 | 
              |----------|----------|
              | 0 | 8 |
              | -1 | 7 |
              | 1 | - |
              | - | 8 |


              And you try filling the missing values with -99, now try to fit a linear regression trough the data. Can you see that you don't be able to fit it properly?



              The brown line



              The line won't fit, and this will yield bad performance.



              Adding 0 values on the other hand will give a slightly better line:



              The yellow line



              It is still not good, but slightly better since the scale of the parameters will be more realistic.



              Now, using average, is this case will give you even better curve, but using regression will give you a perfect fitting line:



              The perfect line



              Note: I need to remake those images, but these should do until I have the time for it.






              share|improve this answer











              $endgroup$















                1












                1








                1





                $begingroup$

                Welcome to Data Science SE!



                Well, we say that most of our jobs is to wrangle with data, and that is because data is usually trying to deceive us... jokes aside:



                You have a missing data problem



                that means your have to clean your data and fill those missing values. To perform this cleaning process your must take the most classic statistician inside of you and ask:



                • Why is this data missing?

                • How much data is missing?

                There are many reasons for a specific information to be unavailable. This will demand you to make assumptions and decide how to deal with this.



                Jeff Sauro posted at MeasuringU: 7 Ways to Handle Missing Data, some which I list here:



                • Delete corrupted samples:

                If you have a large dataset and there is not much data missing, you can simply remove those corrupted data points and go on with life



                • Recover the values:

                Some problems will allow you to go back and get missing information.



                We usually ain't that lucky, then you can



                • Educated Guessing:

                Sometimes, you can infer what would be the feature value by simply looking their pears. That is a bit arbitrary but it might work.



                • Average:

                This is the most common approach, simply use the average of that value whenever it is missing. This might artificially reduce your variance but so does using 0 or -9999... for every missing value.



                • Regression Substitution:

                You can use a multiple regression to infer the missing value from the available values for each candidate.



                Some references on missing data are:



                • Allison, Paul D. 2001. Missing Data. Sage University Papers
                  Series on Quantitative Applications in the Social Sciences.
                  Thousand Oaks: Sage.

                • Enders, Craig. 2010. Applied Missing Data Analysis.
                  Guilford Press: New York.

                • Little, Roderick J., Donald Rubin. 2002. Statistical Analysis
                  with Missing Data. John Wiley & Sons, Inc: Hoboken.

                • Schafer, Joseph L., John W. Graham. 2002. “Missing Data:
                  Our View of the State of the Art.” Psychological Methods.


                About your experiment:



                Adding -99... is creating outliers and that bit of information is heavy (numerically speaking, it is huge) and will affect parameter tuning. For example, suppose you have this data:



                | Feature1 | Feature2 | 
                |----------|----------|
                | 0 | 8 |
                | -1 | 7 |
                | 1 | - |
                | - | 8 |


                And you try filling the missing values with -99, now try to fit a linear regression trough the data. Can you see that you don't be able to fit it properly?



                The brown line



                The line won't fit, and this will yield bad performance.



                Adding 0 values on the other hand will give a slightly better line:



                The yellow line



                It is still not good, but slightly better since the scale of the parameters will be more realistic.



                Now, using average, is this case will give you even better curve, but using regression will give you a perfect fitting line:



                The perfect line



                Note: I need to remake those images, but these should do until I have the time for it.






                share|improve this answer











                $endgroup$



                Welcome to Data Science SE!



                Well, we say that most of our jobs is to wrangle with data, and that is because data is usually trying to deceive us... jokes aside:



                You have a missing data problem



                that means your have to clean your data and fill those missing values. To perform this cleaning process your must take the most classic statistician inside of you and ask:



                • Why is this data missing?

                • How much data is missing?

                There are many reasons for a specific information to be unavailable. This will demand you to make assumptions and decide how to deal with this.



                Jeff Sauro posted at MeasuringU: 7 Ways to Handle Missing Data, some which I list here:



                • Delete corrupted samples:

                If you have a large dataset and there is not much data missing, you can simply remove those corrupted data points and go on with life



                • Recover the values:

                Some problems will allow you to go back and get missing information.



                We usually ain't that lucky, then you can



                • Educated Guessing:

                Sometimes, you can infer what would be the feature value by simply looking their pears. That is a bit arbitrary but it might work.



                • Average:

                This is the most common approach, simply use the average of that value whenever it is missing. This might artificially reduce your variance but so does using 0 or -9999... for every missing value.



                • Regression Substitution:

                You can use a multiple regression to infer the missing value from the available values for each candidate.



                Some references on missing data are:



                • Allison, Paul D. 2001. Missing Data. Sage University Papers
                  Series on Quantitative Applications in the Social Sciences.
                  Thousand Oaks: Sage.

                • Enders, Craig. 2010. Applied Missing Data Analysis.
                  Guilford Press: New York.

                • Little, Roderick J., Donald Rubin. 2002. Statistical Analysis
                  with Missing Data. John Wiley & Sons, Inc: Hoboken.

                • Schafer, Joseph L., John W. Graham. 2002. “Missing Data:
                  Our View of the State of the Art.” Psychological Methods.


                About your experiment:



                Adding -99... is creating outliers and that bit of information is heavy (numerically speaking, it is huge) and will affect parameter tuning. For example, suppose you have this data:



                | Feature1 | Feature2 | 
                |----------|----------|
                | 0 | 8 |
                | -1 | 7 |
                | 1 | - |
                | - | 8 |


                And you try filling the missing values with -99, now try to fit a linear regression trough the data. Can you see that you don't be able to fit it properly?



                The brown line



                The line won't fit, and this will yield bad performance.



                Adding 0 values on the other hand will give a slightly better line:



                The yellow line



                It is still not good, but slightly better since the scale of the parameters will be more realistic.



                Now, using average, is this case will give you even better curve, but using regression will give you a perfect fitting line:



                The perfect line



                Note: I need to remake those images, but these should do until I have the time for it.







                share|improve this answer














                share|improve this answer



                share|improve this answer








                edited 1 hour ago

























                answered 2 hours ago









                Pedro Henrique MonfortePedro Henrique Monforte

                466114




                466114




















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









                    draft saved

                    draft discarded


















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












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











                    Darklink9110 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%2f49298%2ftraining-a-classifier-when-some-of-the-features-are-unknown%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







                    0TCap3NYq okU,bzHm2WW5Ymt1Z9Sjhs0E,n,yQ B4 OE9EN1vjgfOz,gwtamuj7S90TrBItRUOJRDwPmQd1tBnOpSBN,Ey,R0155a
                    H WrZg5uKgu9 NAnm 6wc0KvpLlugrekf,H,gX5,688 E2oRcAaB7SAWKWwBy7g4V

                    Popular posts from this blog

                    What is the result of assigning to std::vector::begin()? The Next CEO of Stack OverflowWhat are the differences between a pointer variable and a reference variable in C++?What does the explicit keyword mean?Concatenating two std::vectorsHow to find out if an item is present in a std::vector?Why is “using namespace std” considered bad practice?What is the “-->” operator in C++?What is the easiest way to initialize a std::vector with hardcoded elements?What is The Rule of Three?What are the basic rules and idioms for operator overloading?Why are std::begin and std::end “not memory safe”?

                    Creating centerline of river in QGIS? 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)Finding centrelines from polygons in QGIS?Splitting line into two lines with GRASS GIS?Centroid of the equator and a pointpostgis: problems creating flow direction polyline; not all needed connections are drawnhow to make decent sense from scattered river depth measurementsQGIS Interpolation on Curved Grid (River DEMs)How to create automatic parking baysShortest path creation between two linesclipping layer using query builder in QGISFinding which side of closest polyline point lies on in QGIS?Create centerline from multi-digitized roadway lines Qgis 2.18Getting bathymetric contours confined only within river banks using QGIS?

                    SQL Server 2016 - excessive memory grant warning on poor performing query The Next CEO of Stack OverflowFix for slow SQL_INLINE_TABLE_VALUED_FUNCTIONLarge memory grant requestsPoor performing Query -Tsql execution plan - estimated number of rows =1 Paste the PlanMSSQL - Query had to wait for memory grantRow estimates always too lowBad performance using “NOT IN”Warning about memory “Excessive Grant” in the query plan - how to find out what is causing it?Optimizing table valued function SQL ServerWhen does SQL Server warn about an Excessive Memory Grant?Warning in Execution Plan