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 | Product 4 | Total Amount | ||||
---|---|---|---|---|---|---|---|---|---|
Items | Amount | Items | Amount | Items | Amount | Items | Amount | ||
Q1 | 30 | $5,967.00 | 36 | $7,160.40 | 41 | $8,154.90 | $21,282.30 | ||
Q2 | 42 | $8,353.80 | 47 | $9,348.30 | 52 | $10,342.80 | 56 | $11,138.40 | $39,183.30 |
Q3 | 57 | $11,337.30 | 61 | $12,132.90 | 65 | $12,928.50 | 68 | $13,525.20 | $49,923.90 |
Q4 | 69 | $13,724.10 | 71 | $14,121.90 | 73 | $14,519.70 | 75 | $14,917.50 | $57,283.20 |
Total for 2000 | $396,009.90 | ||||||||
Q1 | 76 | $15,116.40 | 77 | $15,315.30 | 78 | $15,514.20 | $45,945.90 | ||
Q2 | 78 | $15,514.20 | 78 | $15,514.20 | 76 | $15,116.40 | $46,144.80 | ||
Q3 | 75 | $14,917.50 | 74 | $14,718.60 | 69 | $13,724.10 | $43,360.20 | ||
Q4 | 68 | $13,525.20 | 65 | $12,928.50 | 58 | $11,536.20 | $37,989.90 | ||
Total for 2001 | $467,613.90 | ||||||||
Q1 | 57 | $11,337.30 | 53 | $10,541.70 | 48 | $9,547.20 | 43 | $8,552.70 | $39,978.90 |
Q2 | 42 | $8,353.80 | 37 | $7,359.30 | 32 | $6,364.80 | 26 | $5,171.40 | $27,249.30 |
Total for 2002 | $178,015.50 | ||||||||