I am trying to read a csv file. The column names and first row of data are below. I need to convert data that contain % or $ to real numbers, not polynomials. How can I do this?
"id";"rank";"name";"employees";"previous";"revenues";"revenuechange";"profits";"profitschange";"assets";"marketvalue"
"2";"1";"Walmart";"2,300,000";"1";"$485,873";"0.8%";"$13,643.0 ";"-7.2%";"$198,825";"$218,619"
I am sure there is an easy way to do this, but I can't find it. Thanks in advance.