Trjtdtk

Travelling in US for more than 90 days

I keep switching characters, how do I stop?

What properties make a magic weapon befit a Rogue more than a DEX-based Fighter?

Purpose of creating non root user

How can I handle alert using if else condition in selenium?

"Oh no!" in Latin

Adding up numbers in Portuguese is strange

Extracting patterns from a text

How to predict the next number in a series while having additional series of data that might affect it?

win_unzip does not extract file

How can I split a complicated line into different fill-able groups?

Pre-Employment Background Check With Consent For Future Checks

Echo with obfuscation

Bash: Why does this Brace Expression work this way?

Why didn't Voldemort know what Grindelwald looked like?

How to test the sharpness of a knife?

Friend wants my recommendation but I don't want to give it to him

Why is participating in the European Parliamentary elections used as a threat?

Would a primitive species be able to learn English from reading books alone?

What (if any) is the reason to buy in small local stores?

Has the laser at Magurele, Romania reached a tenth of the Sun's power?

How to add numbers in array using forEach

Sort with assumptions

How do you justify more code being written by following clean code practices?

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

Do data scientists use Excel?What are recommended waystools for processing large data from Excel Files?Connecting Infusionsoft data to Google data studioIs Excel sufficient for data science?Excel file merge with different headers but same dataImporting Common Constants to R and PythonFind value and return row in excel spreadsheet with over 1 mil rowsCategorical data into numeric in excelEvolutionary solver using Open Solver in ExcelExtract tabular data to excel

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

edited Mar 17 at 7:54

Esmailian

1,546114

asked Mar 17 at 3:02

SympaSympa

1063

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
  Mar 17 at 9:48
  

  
  
  
  


• 
  
  
  

  
  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
  2 days 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
  yesterday
  

  
  
  
  

add a comment | 

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

edited Mar 17 at 7:54

Esmailian

1,546114

asked Mar 17 at 3:02

SympaSympa

1063

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
  Mar 17 at 9:48
  

  
  
  
  


• 
  
  
  

  
  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
  2 days 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
  yesterday
  

  
  
  
  

add a comment | 

$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

edited Mar 17 at 7:54

Esmailian

1,546114

asked Mar 17 at 3:02

SympaSympa

1063

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$

Error in storage.mode(y) <- "double":
 (list) object cannot be coerced to type 'double'

share|improve this question

edited Mar 17 at 7:54

Esmailian

1,546114

asked Mar 17 at 3:02

SympaSympa

1063

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

edited Mar 17 at 7:54

Esmailian

1,546114

asked Mar 17 at 3:02

SympaSympa

1063

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.

edited Mar 17 at 7:54

Esmailian

1,546114

edited Mar 17 at 7:54

Esmailian

1,546114

asked Mar 17 at 3:02

SympaSympa

1063

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 Mar 17 at 3:02

SympaSympa

1063

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:

a) First do the x matrix: x = as.matrix(data,...);
b) Second do the y matrix: 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

edited yesterday

answered yesterday

SympaSympa

1063

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$

add a comment | 

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

Sign up or log in

StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

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

Name

Email

Required, but never shown

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:

a) First do the x matrix: x = as.matrix(data,...);
b) Second do the y matrix: 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

edited yesterday

answered yesterday

SympaSympa

1063

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$

add a comment | 

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:

a) First do the x matrix: x = as.matrix(data,...);
b) Second do the y matrix: 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

edited yesterday

answered yesterday

SympaSympa

1063

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$

add a comment | 

$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:

a) First do the x matrix: x = as.matrix(data,...);
b) Second do the y matrix: 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

edited yesterday

answered yesterday

SympaSympa

1063

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$

share|improve this answer

edited yesterday

answered yesterday

SympaSympa

1063

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 yesterday

SympaSympa

1063

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 yesterday

SympaSympa

1063