How to convert comma-seperated number to number?

General Usage
,
1

Data are read from excel xls file in which some numbers are stored as text and comma-seperated.
excel screenshot:
Screenshot_20220222_210423

Dataframe sreenshot (read using ExcelFiles.jl):
Screenshot_20220222_210019

I have tried function tryparse or parse, but it does not work as expected. Failed example in short here:

tryparse(Float64, "1,000")

The question is: how to convert these comma-seperated texted numbers to normal numbers in Julia?

2 
julia> parse(Float64, replace("1,000", "," => "."))
1.0
3

Thanks. It would work.
However, given the background of dealing with DataFrame read from Excel, I am not sure if there is any conventional trick to do this conversion?

4

Well, you could create a feature request for https://github.com/queryverse/ExcelReaders.jl to do this conversion using a keyword argument…

5

There is a reason you are not saving the file as CSV, and reading it to a DataFrame with CSV.jl and DataFrames.jl?

Also, are you sure the comma is not being used to separate thousands? The solution given consider it is separating the fractional part, but considering the magnitude of the values (and the fact it is always three digits after the comma) involved it seems like it using the comma to separate thousands not the fractional part.

6

In case the comma is used to separate thousands you need to write

parse(Float64, replace("1,000", "," => "")) instead...
7

We have a batch of legacy xls files with several sheets.

8

Thanks. Replace and parse works!