Displaying 2 results from an estimated 2 matches for "sale5".
Did you mean:
sales
2010 Feb 24
2
How to read percentage and currency data?
...as characters rather than values. Is there a function or library
which can deal with such values?
As an example, I use this sample from one of chinna's questions:
Store Year Revenue
abc 2010 $557889
def 2010 $697356
Similarly, for percentage values:
Product Sale1 Sale2 Sale3 Sale4 Sale5 Sale6 Sale7
A 101.00% 93.00% 85.00% 65.00% 74.00% 102.00% 119.00%
B 585.00% 484.00% 599.00% 653.00% 726.00% 882.00% 1035.00%
C 18.00% 19.00% 25.00% 15.00% 31.00% 33.00% 33.00%
D 23.00% 22.00% 31.00% 30.00% 36.00% 42.00% 49.00%
E 35.00% 41.00% 49.00% 40.00% 48.00% 48.00% 53.00%
F 19.00% 20.00% 33.00...
2011 May 15
1
Need help with text processing / string split
I used screen scraping to extract some information and put it into a table
called tbl. Now I want to modify the table a bit so the data can be more
useful. Here's the code I used:
library(XML)
rm(list=ls())
url <-
"http://webapp.montcopa.org/sherreal/salelist.asp?saledate=05/25/2011"
tbl <-data.frame(readHTMLTable(url))[2:405, c(3,5,6,8,9)]
names(tbl) <-