Errors after importing excel file to r

General
1

I have tried to import excel files to r recently. It was a small file with numerical data.
However, when trying to analyse the data, all the numerical columns have become string or doubles

A <-Clinic_aptients_drug_cost <- read_excel("Office Work/Clinic_aptients_drug_cost.xlsx",

  • sheet = "Sheet5", col_types = c("numeric",

  •     "numeric"))
2

Please post the output of

Clinic_aptients_drug_cost <- read_excel("Office Work/Clinic_aptients_drug_cost.xlsx",
                                        sheet = "Sheet5", col_types = c("numeric", "numeric"))

dput(head(Clinic_aptients_drug_cost, 20))
3

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.