Can't convert character to numeric

[Sbeldman]

In order to summarise certain values, I wanted to use the sum function.
However, I get an error when trying to do so:

summarise(sales = sum(sales), orderquantity = sum(orderquantity),
unitprice = mean(unitprice), shippingcost = sum(shippingcost))

Error: Problem with summarise() column shippingcost.
i shippingcost = sum(shippingcost).
x invalid 'type' (character) of argument

After a quick look in my dataset, it seems like the column shippingcost is a character:

class(sales$shippingcost)
[1] "character"

However, when trying to change it to a numeric/double only the whole numbers get converted, all the doubles get introduced as NA's:

mutate(shippingcost = as.numeric(shippingcost))
Warning message:Problem with mutate() column shippingcost.
i shippingcost = as.numeric(shippingcost).
i NAs introduced by coercion

Same goes for as.double, any ideas on how to solve this?

[williaml]

Can you provide a reproducible example?

FAQ: What's a reproducible example (`reprex`) and how do I create one?

Why reprex? Getting unstuck is hard. Your first step here is usually to create a reprex, or reproducible example. The goal of a reprex is to package your code, and information about your problem so that others can run it and feel your pain. Then, hopefully, folks can more easily provide a solution. What's in a Reproducible Example? Parts of a reproducible example: background information - Describe what you are trying to do. What have you already done? complete set up - include any library() calls and data to reproduce your issue. data for a reprex: Here's a discussion on setting up data for a reprex make it run - include the minimal code required to reproduce your error on the data…