| Description | |
|---|---|
| Skip rows when reading excel files |
| Ingredients | |
| Package | Data |
|---|---|
readxl |
sample_housing_data.xlsx |
Sample Instructions
package::function("file_path/file_name.xlsx", skip = number)Actual Instructions
readxl::read_excel("C:/data/sample.xlsx", skip = 2)Output
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 10535174 | 15 | NA...4 | NA...5 | KINGS WHARF | PL | DARTMOUTH | 2020 | 282700...10 | 282700...11 | NA...12 | NA...13 | NA...14 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 822639 | 40 | NA | NA | CAMPBELL | AVE | DARTMOUTH | 2020 | 26600 | 16800 | NA | NA | NA |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 9037063 | 275 | NA | NA | WINDMILL | RD | DARTMOUTH | 2020 | 72500 | 72500 | NA | NA | NA |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 10535301 | 15 | NA | NA | KINGS WHARF | PL | DARTMOUTH | 2018 | 283200 | 283200 | NA | NA | NA |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 9282262 | 352 | NA | NA | BROOKS | DR | EAST PRESTON | 2020 | 16000 | 16000 | 44.72913 | -63.42245 | (44.72913, -63.42245) |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 9911871 | 56 | NA | NA | LINDENWOOD | TERR | DARTMOUTH | 2020 | 485700 | 467200 | 44.6611 | -63.52719 | (44.6611, -63.52719) |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 10642906 | 67 | NA | NA | KINGS WHARF | PL | DARTMOUTH | 2018 | 602400 | 602400 | NA | NA | NA |