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 HCA.DPO at hcahealthcare.co.uk and please return this e-mail. If you have a query relating to an upcoming appointment or your clinical treatment, please email Contact at hcahealthcare.co.uk. 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. ________________________________
On Thu, 5 Dec 2024 at 23:16, Figueiredo, Carlos via R-help <r-help at r-project.org> 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
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 <r-help at r-project.org> 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 HCA.DPO at hcahealthcare.co.uk and please return this e-mail. If you have a query relating to an upcoming appointment or your clinical treatment, please email Contact at hcahealthcare.co.uk. > > 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. > > ________________________________ > ______________________________________________ > R-help at r-project.org 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.
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 <r-help-bounces at r-project.org> On Behalf Of Figueiredo, Carlos via R-help Sent: Thursday, December 5, 2024 10:16 AM To: r-help at r-project.org 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 HCA.DPO at hcahealthcare.co.uk and please return this e-mail. If you have a query relating to an upcoming appointment or your clinical treatment, please email Contact at hcahealthcare.co.uk. 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. ________________________________ ______________________________________________ R-help at r-project.org 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.