ETL--CensusData-Trees

Background

Census dataset of Street Trees in New York

Process

Extract: Extract csv file from Census Data source.

Transform:

  • Trim the data-frame in necessary columns
  • Remove incomplete rows
  • Remove Na values

Load: Load using SQLalchemy library