| Description | |
|---|---|
| Read a specific sheet of an excel file |
| Ingredients | |
| Package | Data |
|---|---|
readxl |
sample_housing_data.xlsx |
Sample Instructions
package::function("file_path/file_name.xlsx", sheet = "sheet_name")Actual Instructions
readxl::read_excel("C:/data/sample_housing_data.xlsx", sheet = "sample_dwelling_characteristics")Output
| municipal_unit | assessment_account_number | civic_number | civic_additional | civic_direction | civic_street_name | civic_street_suffix | civic_city_name | living_units | year_built | square_foot_living_area | style | bedrooms | bathrooms | under_construction | construction_grade | finished_basement | garage | y_map_coordinate | x_map_coordinate | map_coordinates |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 10703689 | NA | NA | NA | ALPS | RD | PORTERS LAKE | 1 | 2016 | 1226 | 1 Storey | 2 | 2 | N | Average | N | N | NA | NA | NA |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 8566615 | 10 | NA | NA | SNEEZY | AVE | LAKE ECHO | 1 | 1973 | 768 | Manufactured Home | 2 | 1 | N | Manufactured Home | N | N | NA | NA | NA |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 9781315 | 108 | NA | NA | ATIKIAN | DR | EASTERN PASSAGE | 1 | 2008 | 1400 | 2 Storey | 3 | 3 | N | Average | N | N | 44.61654 | -63.4618 | (44.61654, -63.4618) |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 8567875 | 19 | NA | NA | THE OTHER | ST | PORTERS LAKE | 1 | 1991 | 896 | Manufactured Home | 2 | 1 | N | Manufactured Home | N | N | NA | NA | NA |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 10535001 | 15 | NA | NA | KINGS WHARF | PL | DARTMOUTH | 1 | 2012 | NA | NA | 2 | 2 | N | NA | N | N | NA | NA | NA |
| HALIFAX REGIONAL MUNICIPALITY (HRM) | 10738822 | 25 | NA | NA | ALDERNEY | DR | DARTMOUTH | 1 | 2016 | NA | NA | 2 | 2 | N | NA | N | N | NA | NA | NA |