Importing Excel format data into R/R Studio and using glmnet package?












1












$begingroup$


I have no problem importing Excel formatted data into R/R Studio and use all other R packages that I use. But, when I want to use the glmnet package to develop a regularization model, I invariably run into the following error (after specifying my regularization model and attempting to run it): 



Error in storage.mode(y) <- "double":

  (list) object cannot be coerced to type 'double'


Here is what I have already tried to resolve this:




  1. De-format the numbers in Excel (no scientific notation, no %, etc.)


  2. Did copy-paste-special values several times


  3. At time of importing the spreadsheet, converted every column from "include" to "numeric" type


  4. After importing the data, converting it to a matrix.



But, none of the above have eliminated the error.






r data regularization excel error-handling







share|improve this question









New contributor




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







$endgroup$








  • 1




    $begingroup$
    Are you using an excel file or a CSV file?
    $endgroup$
    – MachineLearner
    yesterday






  • 1




    $begingroup$
    How exactly do you import the data? Where exactly does the error arise? It hints that your dependent variable is a list and not a number, and this is likely due to some sort of data import problems, either on R side or excel side
    $endgroup$
    – Ott Toomet
    yesterday










  • $begingroup$
    i am using an Excel file, and using the standard R Studio import Excel file facility. I am not sure why Y would be a list as I changed the data set to a matrix. But, other colleagues have reviewed my codes and I think I may have done an error in naming my data reference when converting the Y data to a matrix. I will work on that and keep you posted. Your suggestions to review my data import and data references are helpful.
    $endgroup$
    – Sympa
    7 hours ago
















1












$begingroup$


I have no problem importing Excel formatted data into R/R Studio and use all other R packages that I use. But, when I want to use the glmnet package to develop a regularization model, I invariably run into the following error (after specifying my regularization model and attempting to run it): 



Error in storage.mode(y) <- "double":

  (list) object cannot be coerced to type 'double'


Here is what I have already tried to resolve this:




  1. De-format the numbers in Excel (no scientific notation, no %, etc.)


  2. Did copy-paste-special values several times


  3. At time of importing the spreadsheet, converted every column from "include" to "numeric" type


  4. After importing the data, converting it to a matrix.



But, none of the above have eliminated the error.






r data regularization excel error-handling







share|improve this question









New contributor




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







$endgroup$








  • 1




    $begingroup$
    Are you using an excel file or a CSV file?
    $endgroup$
    – MachineLearner
    yesterday






  • 1




    $begingroup$
    How exactly do you import the data? Where exactly does the error arise? It hints that your dependent variable is a list and not a number, and this is likely due to some sort of data import problems, either on R side or excel side
    $endgroup$
    – Ott Toomet
    yesterday










  • $begingroup$
    i am using an Excel file, and using the standard R Studio import Excel file facility. I am not sure why Y would be a list as I changed the data set to a matrix. But, other colleagues have reviewed my codes and I think I may have done an error in naming my data reference when converting the Y data to a matrix. I will work on that and keep you posted. Your suggestions to review my data import and data references are helpful.
    $endgroup$
    – Sympa
    7 hours ago














1












1








1





$begingroup$


I have no problem importing Excel formatted data into R/R Studio and use all other R packages that I use. But, when I want to use the glmnet package to develop a regularization model, I invariably run into the following error (after specifying my regularization model and attempting to run it): 



Error in storage.mode(y) <- "double":

  (list) object cannot be coerced to type 'double'


Here is what I have already tried to resolve this:




  1. De-format the numbers in Excel (no scientific notation, no %, etc.)


  2. Did copy-paste-special values several times


  3. At time of importing the spreadsheet, converted every column from "include" to "numeric" type


  4. After importing the data, converting it to a matrix.



But, none of the above have eliminated the error.






r data regularization excel error-handling







share|improve this question









New contributor




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







$endgroup$




I have no problem importing Excel formatted data into R/R Studio and use all other R packages that I use. But, when I want to use the glmnet package to develop a regularization model, I invariably run into the following error (after specifying my regularization model and attempting to run it): 



Error in storage.mode(y) <- "double":

  (list) object cannot be coerced to type 'double'


Here is what I have already tried to resolve this:




  1. De-format the numbers in Excel (no scientific notation, no %, etc.)


  2. Did copy-paste-special values several times


  3. At time of importing the spreadsheet, converted every column from "include" to "numeric" type


  4. After importing the data, converting it to a matrix.



But, none of the above have eliminated the error.






r data regularization excel error-handling




r data regularization excel error-handling






share|improve this question









New contributor




Sympa 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




Sympa 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 yesterday









Esmailian

1,421113




1,421113






New contributor




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









asked yesterday









SympaSympa

1062




1062




New contributor




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





New contributor





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






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








  • 1




    $begingroup$
    Are you using an excel file or a CSV file?
    $endgroup$
    – MachineLearner
    yesterday






  • 1




    $begingroup$
    How exactly do you import the data? Where exactly does the error arise? It hints that your dependent variable is a list and not a number, and this is likely due to some sort of data import problems, either on R side or excel side
    $endgroup$
    – Ott Toomet
    yesterday










  • $begingroup$
    i am using an Excel file, and using the standard R Studio import Excel file facility. I am not sure why Y would be a list as I changed the data set to a matrix. But, other colleagues have reviewed my codes and I think I may have done an error in naming my data reference when converting the Y data to a matrix. I will work on that and keep you posted. Your suggestions to review my data import and data references are helpful.
    $endgroup$
    – Sympa
    7 hours ago














  • 1




    $begingroup$
    Are you using an excel file or a CSV file?
    $endgroup$
    – MachineLearner
    yesterday






  • 1




    $begingroup$
    How exactly do you import the data? Where exactly does the error arise? It hints that your dependent variable is a list and not a number, and this is likely due to some sort of data import problems, either on R side or excel side
    $endgroup$
    – Ott Toomet
    yesterday










  • $begingroup$
    i am using an Excel file, and using the standard R Studio import Excel file facility. I am not sure why Y would be a list as I changed the data set to a matrix. But, other colleagues have reviewed my codes and I think I may have done an error in naming my data reference when converting the Y data to a matrix. I will work on that and keep you posted. Your suggestions to review my data import and data references are helpful.
    $endgroup$
    – Sympa
    7 hours ago








1




1




$begingroup$
Are you using an excel file or a CSV file?
$endgroup$
– MachineLearner
yesterday




$begingroup$
Are you using an excel file or a CSV file?
$endgroup$
– MachineLearner
yesterday




1




1




$begingroup$
How exactly do you import the data? Where exactly does the error arise? It hints that your dependent variable is a list and not a number, and this is likely due to some sort of data import problems, either on R side or excel side
$endgroup$
– Ott Toomet
yesterday




$begingroup$
How exactly do you import the data? Where exactly does the error arise? It hints that your dependent variable is a list and not a number, and this is likely due to some sort of data import problems, either on R side or excel side
$endgroup$
– Ott Toomet
yesterday












$begingroup$
i am using an Excel file, and using the standard R Studio import Excel file facility. I am not sure why Y would be a list as I changed the data set to a matrix. But, other colleagues have reviewed my codes and I think I may have done an error in naming my data reference when converting the Y data to a matrix. I will work on that and keep you posted. Your suggestions to review my data import and data references are helpful.
$endgroup$
– Sympa
7 hours ago




$begingroup$
i am using an Excel file, and using the standard R Studio import Excel file facility. I am not sure why Y would be a list as I changed the data set to a matrix. But, other colleagues have reviewed my codes and I think I may have done an error in naming my data reference when converting the Y data to a matrix. I will work on that and keep you posted. Your suggestions to review my data import and data references are helpful.
$endgroup$
– Sympa
7 hours ago










1 Answer
1






active

oldest

votes


















0












$begingroup$

After soliciting assistance from many colleagues, I found the answer to my problem. And, I thought it be worth sharing. glmnet package requires that you format your data as matrix.



What I had already done is import and transform the data as matrix as follows:
data.matrix(data)



But, that is not enough. You still have to convert the X and Y arrays as matrix as follows:



x = as.matrix(data,...
y = as.matrix(data,...



Once I did the above change the glmnet package seems to work just fine.



I am unclear why the glmnet package is so much more sensitive to how much you matricize your data. But, that is the way it is.






share|improve this answer








New contributor




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






$endgroup$













    Your Answer





    StackExchange.ifUsing("editor", function () {
    return StackExchange.using("mathjaxEditing", function () {
    StackExchange.MarkdownEditor.creationCallbacks.add(function (editor, postfix) {
    StackExchange.mathjaxEditing.prepareWmdForMathJax(editor, postfix, [["$", "$"], ["\\(","\\)"]]);
    });
    });
    }, "mathjax-editing");

    StackExchange.ready(function() {
    var channelOptions = {
    tags: "".split(" "),
    id: "557"
    };
    initTagRenderer("".split(" "), "".split(" "), channelOptions);

    StackExchange.using("externalEditor", function() {
    // Have to fire editor after snippets, if snippets enabled
    if (StackExchange.settings.snippets.snippetsEnabled) {
    StackExchange.using("snippets", function() {
    createEditor();
    });
    }
    else {
    createEditor();
    }
    });

    function createEditor() {
    StackExchange.prepareEditor({
    heartbeatType: 'answer',
    autoActivateHeartbeat: false,
    convertImagesToLinks: false,
    noModals: true,
    showLowRepImageUploadWarning: true,
    reputationToPostImages: null,
    bindNavPrevention: true,
    postfix: "",
    imageUploader: {
    brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
    contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
    allowUrls: true
    },
    onDemand: true,
    discardSelector: ".discard-answer"
    ,immediatelyShowMarkdownHelp:true
    });


    }
    });






    Sympa 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%2f47445%2fimporting-excel-format-data-into-r-r-studio-and-using-glmnet-package%23new-answer', 'question_page');
    }
    );

    Post as a guest















    Required, but never shown

























    1 Answer
    1






    active

    oldest

    votes








    1 Answer
    1






    active

    oldest

    votes









    active

    oldest

    votes






    active

    oldest

    votes









    0












    $begingroup$

    After soliciting assistance from many colleagues, I found the answer to my problem. And, I thought it be worth sharing. glmnet package requires that you format your data as matrix.



    What I had already done is import and transform the data as matrix as follows:
    data.matrix(data)



    But, that is not enough. You still have to convert the X and Y arrays as matrix as follows:



    x = as.matrix(data,...
    y = as.matrix(data,...



    Once I did the above change the glmnet package seems to work just fine.



    I am unclear why the glmnet package is so much more sensitive to how much you matricize your data. But, that is the way it is.






    share|improve this answer








    New contributor




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






    $endgroup$


















      0












      $begingroup$

      After soliciting assistance from many colleagues, I found the answer to my problem. And, I thought it be worth sharing. glmnet package requires that you format your data as matrix.



      What I had already done is import and transform the data as matrix as follows:
      data.matrix(data)



      But, that is not enough. You still have to convert the X and Y arrays as matrix as follows:



      x = as.matrix(data,...
      y = as.matrix(data,...



      Once I did the above change the glmnet package seems to work just fine.



      I am unclear why the glmnet package is so much more sensitive to how much you matricize your data. But, that is the way it is.






      share|improve this answer








      New contributor




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






      $endgroup$
















        0












        0








        0





        $begingroup$

        After soliciting assistance from many colleagues, I found the answer to my problem. And, I thought it be worth sharing. glmnet package requires that you format your data as matrix.



        What I had already done is import and transform the data as matrix as follows:
        data.matrix(data)



        But, that is not enough. You still have to convert the X and Y arrays as matrix as follows:



        x = as.matrix(data,...
        y = as.matrix(data,...



        Once I did the above change the glmnet package seems to work just fine.



        I am unclear why the glmnet package is so much more sensitive to how much you matricize your data. But, that is the way it is.






        share|improve this answer








        New contributor




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






        $endgroup$



        After soliciting assistance from many colleagues, I found the answer to my problem. And, I thought it be worth sharing. glmnet package requires that you format your data as matrix.



        What I had already done is import and transform the data as matrix as follows:
        data.matrix(data)



        But, that is not enough. You still have to convert the X and Y arrays as matrix as follows:



        x = as.matrix(data,...
        y = as.matrix(data,...



        Once I did the above change the glmnet package seems to work just fine.



        I am unclear why the glmnet package is so much more sensitive to how much you matricize your data. But, that is the way it is.







        share|improve this answer








        New contributor




        Sympa 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






        New contributor




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









        answered 5 hours ago









        SympaSympa

        1062




        1062




        New contributor




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





        New contributor





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






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






















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










            draft saved

            draft discarded


















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













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












            Sympa 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%2f47445%2fimporting-excel-format-data-into-r-r-studio-and-using-glmnet-package%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown





















































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown

































            Required, but never shown














            Required, but never shown












            Required, but never shown







            Required, but never shown







            -

            Popular posts from this blog

            How to label and detect the document text images

            Image
            1 $begingroup$ This is what I mean as document text image: I want to label the texts in image as separate blocks and my model should detect these labels as classes. NOTE: This is how the end result should be like: The labels like Block 1, Block 2, Block 3,.. should be Logo, Title, Date,.. Others, etc. Work done: First approach : I tried to implement this method via Object Detection, it didn't work. It didn't even detect any text. Second approach : Then I tried it using PixelLink. As this model is build for scene text detection, it detected each and every text in the image. But this method can detect multiple lines of text if the threshold values are increased. But I have no idea how do I add labels to the text blocks. PIXEL_CLS_WEIGHT_all_ones = 'PIXEL_CLS_WEIGHT_all_ones' PIXEL_C...
            Read more

            Vallis Paradisi

            Image
            Coordinata: .mw-parser-output .geo-default,.mw-parser-output .geo-dms,.mw-parser-output .geo-dec{display:inline}.mw-parser-output .geo-nondefault,.mw-parser-output .geo-multi-punct{display:none}.mw-parser-output .longitude,.mw-parser-output .latitude{white-space:nowrap} 33°03′S 71°37′W  /  33.05°S 71.617°W  / -33.05; -71.617 Vallis Paradisi Res apud Vicidata repertae: Civitas : Chilia Numerus incolarum : 296 655 Zona horaria : UTC-4 Situs interretialis Nomen officiale : Valparaíso Gubernium Consilium : municipal council of Valparaíso Geographia Superficies : 401 600 000 Metrum quadratum Coniunctiones urbium Urbes gemellae : Ovetum , Badalona , Santa Fe , Ora longa , Sciamhaevum , Quantunia , Callao , Bat Yam , Melaka , Novorossiysk , Busan , Corduba , Odessa , Rosario , Malacca , Barcino , Soteropolis , Franciscopolis (California) , Guanajuato, Silao Tabula aut despectus Despectus in portum sinumque et urbem Vallis Paradisi Vallis Para...
            Read more

            Tabula Rosettana

            Image
            Tabula multilinguis Rosettana in Museo Britannico ostenditur. Tabula Rosettana, [1] etiam titulo OGIS 90 agnita, est stela decreto de rebus sacris in Aegypto anno 196 a.C.n. lato inscripta. Tabula iuxta Rosettam Aegypti, urbem in delta Nili et ad oram maris Mediterranei iacentem, anno 1799 a milite Francico reperta est. Inventio stelae, linguis duabus scripturisque tribus inscriptae, eruditis Instituti Aegypti statim nuntiata est; ibi enim iussu imperatoris Napoleonis eruditi omnium scientiarum (sub aegide Commissionis Scientiarum et Artium) properaverant cum expeditione Francica. Qua a Britannis mox debellata, tabula Rosettana Londinium missa hodie apud Museum Britannicum iacet. Textus Graecus cito lectus interpretationi textuum Aegyptiorum (in formis hieroglyphica et demotica expressorum) gradatim adiuvit. Denique textum plene interpretatus est Ioannes Franciscus Champollion. Ab opere eruditorum cumulativo coepit hodiernus scripturae hieroglyphicae linguaeque Aegyptiae a...
            Read more