[R] Spreadsheets data

[@vi@e@gross m@iii@g oii gm@ii@com]

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 using r-project.org> On Behalf Of Figueiredo, Carlos
via R-help
Sent: Thursday, December 5, 2024 10:16 AM
To: r-help using 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 using 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 using 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 using 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.