TABLE REPORT
Suppose you need to scrape a financial report organized as a table. This test checks the scraper's ability to:
- Support tables with indefinite number of rows and columns
- Tolerate merged columns and rows
- Parse currency format
- Extract only a certain year
- products - number of product columns (from 1 to 50)
- years - number of year sections in the report
- quarters - number of quarters in the last year
For testing, you may use the following sample links. The scraper should sufficiently scrape all data from the reports using the same project:
Quarter | Product 1 | Product 2 | Product 3 | Total Amount | |||
---|---|---|---|---|---|---|---|
Items | Amount | Items | Amount | Items | Amount | ||
Q1 | 34 | $6,762.60 | 41 | $8,154.90 | $14,917.50 | ||
Q2 | 44 | $8,751.60 | 50 | $9,945.00 | 56 | $11,138.40 | $29,835.00 |
Q3 | 59 | $11,735.10 | 63 | $12,530.70 | 68 | $13,525.20 | $37,791.00 |
Q4 | 70 | $13,923.00 | 73 | $14,519.70 | 75 | $14,917.50 | $43,360.20 |
Total for 2000 | $238,481.10 | ||||||
Q1 | 76 | $15,116.40 | 77 | $15,315.30 | $30,431.70 | ||
Q2 | 78 | $15,514.20 | 77 | $15,315.30 | $30,829.50 | ||
Q3 | 75 | $14,917.50 | 72 | $14,320.80 | $29,238.30 | ||
Q4 | 67 | $13,326.30 | 63 | $12,530.70 | $25,857.00 | ||
Total for 2001 | $291,587.40 | ||||||
Q1 | 55 | $10,939.50 | 50 | $9,945.00 | 43 | $8,552.70 | $29,437.20 |
Q2 | 40 | $7,956.00 | 33 | $6,563.70 | 26 | $5,171.40 | $19,691.10 |
Q3 | 22 | $4,375.80 | 7 | $1,392.30 | $5,768.10 | ||
Q4 | 3 | $596.70 | 5 | $994.50 | 12 | $2,386.80 | $3,978.00 |
Total for 2002 | $124,113.60 | ||||||