Re: [R] Spreadsheets data
What exactly is stopping you, Carlos? Do you know where the reagent dataset is? I don't. Is it being loaded from a known format like a .CSV file, or part of an EXCEL spreadsheet and so on? Does it come with a function in a package that you load and then invoke to load it or make it visible? Or, should you already have copied it somewhere on your disk? Depending on many scenarios, loading methods are available. Moving on, if you read it in, often enough some columns are assigned a different data type than you want. Some methods of reading in may allow you to supply a list of hints as to what you want each column to be. In any case, once you have read in the data, perhaps in the form of a data.frame or tibble or other variants, you can generally execute commands to replace a column with a transformation of your choice such as as.integer() or convert it to a factor or even make new columns with other visions of the original and so on. Without some info on what you have tried and what failed, this is a very basic request and chances are you won't get much help. -Original Message- From: R-help On Behalf Of Figueiredo, Carlos via R-help Sent: Thursday, December 5, 2024 10:16 AM To: [email protected] Subject: [R] Spreadsheets data Hi there I want to create a script in Rstudio and load in the reagent dataset ensuring that the different data types in there (dates, text, etc) come through correctly. Best wishes Carlos Notice of Confidentiality: The contents of this e-mail and any attachments are confidential and copyright to HCA International and may also be privileged. They are intended only for the use of the addressee(s) shown above. Any unauthorised reading, use, distribution or copying of them is prohibited. If this e-mail has been sent to you in error, you may not take action based on it, nor may you rely on it for any purpose. Please let us know of the error by emailing [email protected] and please return this e-mail. If you have a query relating to an upcoming appointment or your clinical treatment, please email [email protected]. Whilst all reasonable care has been taken to avoid the transmission of viruses, it is the responsibility of the recipient to ensure that onward transmission, opening or use of this message and any attachments will not adversely affect its systems or data. No responsibility is accepted by HCA International in this regard and the recipient should carry out such virus and other checks as it considers appropriate. HCA International is registered in the UK, Company Number 3020522, at 2 Cavendish Square, London, W1G 0PU. __ [email protected] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide https://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code. __ [email protected] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide https://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Spreadsheets data
And R Studio has an import data function that will provide a import command.. BUT Spreadsheet is a broad scope On Thu, 5 Dec 2024, 23:38 Martin Møller Skarbiniks Pedersen, < [email protected]> wrote: > On Thu, 5 Dec 2024 at 23:16, Figueiredo, Carlos via R-help > wrote: > > > > Hi there > > > > > > I want to create a script in Rstudio and load in the reagent dataset > ensuring that the different data types in there (dates, text, etc) come > through correctly. > > What have you tried? How good do you know R? > R contains many functions to read input. > > Regards > Martin > > __ > [email protected] mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide > https://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] __ [email protected] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide https://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Spreadsheets data
Please read **and follow** the posting guide linked below to learn how to ask for help on this list. Cheers, Bert On Thu, Dec 5, 2024 at 2:16 PM Figueiredo, Carlos via R-help wrote: > > Hi there > > > I want to create a script in Rstudio and load in the reagent dataset ensuring > that the different data types in there (dates, text, etc) come through > correctly. > > Best wishes > > Carlos > > > > Notice of Confidentiality: The contents of this e-mail and any attachments > are confidential and copyright to HCA International and may also be > privileged. They are intended only for the use of the addressee(s) shown > above. Any unauthorised reading, use, distribution or copying of them is > prohibited. If this e-mail has been sent to you in error, you may not take > action based on it, nor may you rely on it for any purpose. Please let us > know of the error by emailing [email protected] and please return > this e-mail. If you have a query relating to an upcoming appointment or your > clinical treatment, please email [email protected]. > > Whilst all reasonable care has been taken to avoid the transmission of > viruses, it is the responsibility of the recipient to ensure that onward > transmission, opening or use of this message and any attachments will not > adversely affect its systems or data. No responsibility is accepted by HCA > International in this regard and the recipient should carry out such virus > and other checks as it considers appropriate. HCA International is registered > in the UK, Company Number 3020522, at 2 Cavendish Square, London, W1G 0PU. > > > __ > [email protected] mailing list -- To UNSUBSCRIBE and more, see > https://stat.ethz.ch/mailman/listinfo/r-help > PLEASE do read the posting guide https://www.R-project.org/posting-guide.html > and provide commented, minimal, self-contained, reproducible code. __ [email protected] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide https://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
Re: [R] Spreadsheets data
On Thu, 5 Dec 2024 at 23:16, Figueiredo, Carlos via R-help wrote: > > Hi there > > > I want to create a script in Rstudio and load in the reagent dataset ensuring > that the different data types in there (dates, text, etc) come through > correctly. What have you tried? How good do you know R? R contains many functions to read input. Regards Martin __ [email protected] mailing list -- To UNSUBSCRIBE and more, see https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide https://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
