Task: Transform-by-output-target-schema (source dataset: github-pipelines)

Your task is to create a data transformation pipeline in Python using pandas libraries.

Given Source Tables below, and a Target Schema provided by users that demonstrates how the desired output table should look like schematically, please write Python pandas code that can transform the Source Tables into an output table, that matches the schema/structure given by the Target Schema.  Please note that the data values in the Target Schema are intended to represent the format and layout of the output table, but may not exactly match the actual data generated from the Source Tables when the python code is run on the Source Tables.

Use operations such as merge, groupby, pivot, apply, or any appropriate python or pandas steps. Your code should save the resulting DataFrame to a CSV file named 'output.csv'. Ensure that the code is executable and can be run directly as is, in a Python environment with pandas installed.

Source Tables:


Table #1
Filename: source_0.csv
Sample Rows in Markdown:
|   S/N | Building/Project Name   | Street Name              |   Postal District | Type                  |   No. of Bedroom(for Non-Landed Only) |   Monthly Gross Rent($) | Floor Area (sq ft)   | Lease Commencement Date   |
|------:|:------------------------|:-------------------------|------------------:|:----------------------|--------------------------------------:|------------------------:|:---------------------|:--------------------------|
|   104 | PARC VISTA              | CORPORATION ROAD         |                22 | Non-landed Properties |                                     2 |                    2800 | 1200 to 1300         | Oct-2018                  |
| 24898 | SYMPHONY HEIGHTS        | HUME AVENUE              |                21 | Non-landed Properties |                                     2 |                    2100 | 900 to 1000          | Feb-2016                  |
|  8465 | MEADOWLODGE             | CHUN TIN ROAD            |                21 | Non-landed Properties |                                     3 |                    3000 | 1300 to 1400         | Dec-2017                  |
| 10790 | THE LAKESHORE           | JURONG WEST STREET 41    |                22 | Non-landed Properties |                                     3 |                    3250 | 1100 to 1200         | Sep-2017                  |
| 24293 | THE JADE                | BUKIT BATOK CENTRAL LINK |                23 | Non-landed Properties |                                     2 |                    3200 | 1000 to 1100         | Mar-2016                  |
| 22617 | HONG HENG MANSIONS      | SEMBAWANG ROAD           |                26 | Non-landed Properties |                                     3 |                    2200 | 1200 to 1300         | May-2016                  |
| 23544 | THE LAKESHORE           | JURONG WEST STREET 41    |                22 | Non-landed Properties |                                     3 |                    3700 | 1100 to 1200         | Apr-2016                  |
| 21696 | REGENT GROVE            | CHOA CHU KANG NORTH 7    |                23 | Non-landed Properties |                                     3 |                    2400 | 1100 to 1200         | Jul-2016                  |
|  7876 | LAKEVILLE               | JURONG LAKE LINK         |                22 | Non-landed Properties |                                     2 |                    2100 | 700 to 800           | Jan-2018                  |
|  4104 | PARC OASIS              | JURONG EAST AVENUE 1     |                22 | Non-landed Properties |                                     3 |                    3200 | 1200 to 1300         | Jun-2018                  |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
|   S/N | Building/Project Name       | Street Name      |   Postal District | Type                  | No. of Bedroom(for Non-Landed Only)   |   Monthly Gross Rent($) | Floor Area (sq ft)   | Lease Commencement Date   |
|------:|:----------------------------|:-----------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
|     1 | THE ESTUARY                 | YISHUN AVENUE 1  |                27 | Non-landed Properties | 1                                     |                    1800 | 600 to 700           | Oct-2018                  |
|     2 | THE MILTONIA RESIDENCES     | MILTONIA CLOSE   |                27 | Non-landed Properties | 3                                     |                    2250 | 1100 to 1200         | Oct-2018                  |
|     3 | SKIES MILTONIA              | MILTONIA CLOSE   |                27 | Non-landed Properties | 3                                     |                    2100 | 900 to 1000          | Oct-2018                  |
|     4 | THE GREENWICH               | SELETAR ROAD     |                28 | Non-landed Properties | na*                                   |                    1600 | 600 to 700           | Oct-2018                  |
|     5 | THE WISTERIA                | YISHUN RING ROAD |                27 | Non-landed Properties | 1                                     |                    1600 | 400 to 500           | Oct-2018                  |
|     6 | H2O RESIDENCES              | FERNVALE LINK    |                28 | Non-landed Properties | 4                                     |                    2900 | 1300 to 1400         | Oct-2018                  |
|     7 | SKIES MILTONIA              | MILTONIA CLOSE   |                27 | Non-landed Properties | 3                                     |                    2500 | 1000 to 1100         | Oct-2018                  |
|     8 | SELETAR SPRINGS CONDOMINIUM | GERALD DRIVE     |                28 | Non-landed Properties | 3                                     |                    2750 | 1500 to 1600         | Oct-2018                  |
|     9 | SELETAR PARK RESIDENCE      | SELETAR ROAD     |                28 | Non-landed Properties | 2                                     |                    2200 | 800 to 900           | Oct-2018                  |
|    10 | EIGHT COURTYARDS            | CANBERRA DRIVE   |                27 | Non-landed Properties | na*                                   |                    1600 | 400 to 500           | Oct-2018                  |


Table #3
Filename: source_2.csv
Sample Rows in Markdown:
|   S/N | Building/Project Name   | Street Name            |   Postal District | Type                  | No. of Bedroom(for Non-Landed Only)   |   Monthly Gross Rent($) | Floor Area (sq ft)   | Lease Commencement Date   |
|------:|:------------------------|:-----------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
|  3269 | SKYSUITES@ANSON         | ENGGOR STREET          |                 2 | Non-landed Properties | na*                                   |                    2900 | 300 to 400           | Aug-2018                  |
| 24383 | EMERALD GARDEN          | CLUB STREET            |                 1 | Non-landed Properties | 1                                     |                    3400 | 800 to 900           | Dec-2016                  |
|  8556 | WEST BAY CONDOMINIUM    | WEST COAST CRESCENT    |                 5 | Non-landed Properties | 3                                     |                    2900 | 1200 to 1300         | Apr-2018                  |
| 19156 | PEOPLE'S PARK COMPLEX   | PARK ROAD              |                 1 | Non-landed Properties | 3                                     |                    4500 | 1100 to 1200         | May-2017                  |
|  2135 | THE SAIL @ MARINA BAY   | MARINA BOULEVARD       |                 1 | Non-landed Properties | 2                                     |                    4650 | 800 to 900           | Sep-2018                  |
| 28054 | THE ANCHORAGE           | ALEXANDRA ROAD         |                 3 | Non-landed Properties | 3                                     |                    4100 | 1400 to 1500         | Jul-2016                  |
| 12715 | THE SAIL @ MARINA BAY   | MARINA BOULEVARD       |                 1 | Non-landed Properties | 1                                     |                    3000 | 600 to 700           | Nov-2017                  |
| 22799 | ECHELON                 | ALEXANDRA VIEW         |                 3 | Non-landed Properties | 3                                     |                    3400 | 800 to 900           | Jan-2017                  |
| 31138 | EMERALD GARDEN          | CLUB STREET            |                 1 | Non-landed Properties | 1                                     |                    3800 | 800 to 900           | Apr-2016                  |
| 26223 | SPOTTISWOODE RESIDENCES | SPOTTISWOODE PARK ROAD |                 2 | Non-landed Properties | 2                                     |                    5100 | 900 to 1000          | Sep-2016                  |


Table #4
Filename: source_3.csv
Sample Rows in Markdown:
|   S/N | Building/Project Name          | Street Name          |   Postal District | Type                  | No. of Bedroom(for Non-Landed Only)   |   Monthly Gross Rent($) | Floor Area (sq ft)   | Lease Commencement Date   |
|------:|:-------------------------------|:---------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
| 56173 | CASA AERATA                    | LORONG 26 GEYLANG    |                14 | Non-landed Properties | 1                                     |                    1900 | 400 to 500           | Jan-2016                  |
| 45823 | 10 SHELFORD                    | SHELFORD ROAD        |                11 | Non-landed Properties | 1                                     |                    2200 | 400 to 500           | Aug-2016                  |
| 34184 | BARTLEY RIDGE                  | MOUNT VERNON ROAD    |                13 | Non-landed Properties | 1                                     |                    1900 | 400 to 500           | Mar-2017                  |
| 55205 | CASUARINA COVE                 | TANJONG RHU ROAD     |                15 | Non-landed Properties | 1                                     |                    2500 | 900 to 1000          | Feb-2016                  |
| 42463 | NON-LANDED HOUSING DEVELOPMENT | JOO CHIAT ROAD       |                15 | Non-landed Properties | na*                                   |                    2700 | 1100 to 1200         | Oct-2016                  |
| 32978 | PAVILION 11                    | AKYAB ROAD           |                11 | Non-landed Properties | 2                                     |                    3250 | 900 to 1000          | Apr-2017                  |
| 54005 | CITY EDGE                      | MOULMEIN RISE        |                11 | Non-landed Properties | 2                                     |                    3500 | 800 to 900           | Mar-2016                  |
| 33236 | CITY PLAZA                     | GEYLANG ROAD         |                14 | Non-landed Properties | 2                                     |                    2400 | 900 to 1000          | Apr-2017                  |
| 54777 | SUNNY GROVE                    | LORONG 37 GEYLANG    |                14 | Non-landed Properties | na*                                   |                    2950 | 1100 to 1200         | Feb-2016                  |
| 57161 | THE SEAWIND                    | LORONG M TELOK KURAU |                15 | Non-landed Properties | 3                                     |                    4300 | 1100 to 1200         | Jan-2016                  |


Table #5
Filename: source_4.csv
Sample Rows in Markdown:
|   S/N | Building/Project Name      | Street Name          |   Postal District | Type                  |   No. of Bedroom(for Non-Landed Only) |   Monthly Gross Rent($) | Floor Area (sq ft)   | Lease Commencement Date   |
|------:|:---------------------------|:---------------------|------------------:|:----------------------|--------------------------------------:|------------------------:|:---------------------|:--------------------------|
| 40485 | CHERRYHILL                 | LORONG LEW LIAN      |                19 | Non-landed Properties |                                     3 |                    3500 | 1700 to 1800         | Mar-2016                  |
|  1657 | WATERTOWN                  | PUNGGOL CENTRAL      |                19 | Non-landed Properties |                                     2 |                    2800 | 800 to 900           | Sep-2018                  |
| 34079 | EDELWEISS PARK CONDOMINIUM | FLORA ROAD           |                17 | Non-landed Properties |                                     2 |                    2000 | 900 to 1000          | Aug-2016                  |
| 34322 | WATERFRONT GOLD            | BEDOK RESERVOIR ROAD |                16 | Non-landed Properties |                                     2 |                    2500 | 800 to 900           | Aug-2016                  |
| 15178 | RIVER ISLES                | EDGEDALE PLAINS      |                19 | Non-landed Properties |                                     3 |                    2200 | 900 to 1000          | Dec-2017                  |
| 41872 | KOVAN REGENCY              | KOVAN RISE           |                19 | Non-landed Properties |                                     2 |                    2300 | 500 to 600           | Jan-2016                  |
| 24032 | RIPPLE BAY                 | PASIR RIS LINK       |                18 | Non-landed Properties |                                     2 |                    1900 | 700 to 800           | May-2017                  |
| 36225 | CENTRO RESIDENCES          | ANG MO KIO AVENUE 8  |                20 | Non-landed Properties |                                     4 |                    7600 | 2300 to 2400         | Jul-2016                  |
| 31205 | CHUAN PARK                 | LORONG CHUAN         |                19 | Non-landed Properties |                                     2 |                    2800 | 1400 to 1500         | Nov-2016                  |
| 31038 | MIDTOWN RESIDENCES         | UPPER SERANGOON ROAD |                19 | Non-landed Properties |                                     1 |                    2000 | 400 to 500           | Nov-2016                  |


Table #6
Filename: source_5.csv
Sample Rows in Markdown:
|   S/N | Building/Project Name     | Street Name        |   Postal District | Type                  | No. of Bedroom(for Non-Landed Only)   |   Monthly Gross Rent($) | Floor Area (sq ft)   | Lease Commencement Date   |
|------:|:--------------------------|:-------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
| 19298 | THE TRILLIUM              | KIM SENG ROAD      |                 9 | Non-landed Properties | 3                                     |                    9700 | 1700 to 1800         | Nov-2017                  |
| 22885 | THE IMPERIAL              | JALAN RUMBIA       |                 9 | Non-landed Properties | 3                                     |                    7000 | 1700 to 1800         | Aug-2017                  |
| 24014 | ASPEN HEIGHTS             | RIVER VALLEY ROAD  |                 9 | Non-landed Properties | 3                                     |                    4250 | 1300 to 1400         | Aug-2017                  |
| 36538 | THE REGALIA               | RIVER VALLEY CLOSE |                 9 | Non-landed Properties | 3                                     |                    3600 | 1200 to 1300         | Dec-2016                  |
| 13238 | HOLLAND GEMS              | TAMAN NAKHODA      |                10 | Non-landed Properties | 4                                     |                    5472 | 2000 to 2100         | Mar-2018                  |
| 47668 | UP@ROBERTSON QUAY         | ROBERTSON QUAY     |                 9 | Non-landed Properties | na*                                   |                    3800 | 400 to 500           | Apr-2016                  |
| 31209 | NASSIM REGENCY            | NASSIM ROAD        |                10 | Non-landed Properties | 3                                     |                    8778 | 2000 to 2100         | Apr-2017                  |
| 49268 | CORONATION SHOPPING PLAZA | BUKIT TIMAH ROAD   |                10 | Non-landed Properties | na*                                   |                    2600 | 1000 to 1100         | Mar-2016                  |
|  6060 | DUCHESS CREST             | DUCHESS AVENUE     |                10 | Non-landed Properties | 4                                     |                    7400 | 2000 to 2100         | Jul-2018                  |
| 33968 | VIDA                      | PECK HAY ROAD      |                 9 | Non-landed Properties | 2                                     |                    3600 | 800 to 900           | Feb-2017                  |


Target Schema:
|   S/N | Building/Project Name    | Street Name        |   Postal District | Type                  | No. of Bedroom(for Non-Landed Only)   |   Monthly Gross Rent($) | Floor Area (sq ft)   | Lease Commencement Date   |
|------:|:-------------------------|:-------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
|     1 | TIONG BAHRU ESTATE       | TIONG POH ROAD     |                 3 | Non-landed Properties | na*                                   |                    3000 | 600 to 700           | Oct-2018                  |
|     2 | HIGHLINE RESIDENCES      | KIM TIAN ROAD      |                 3 | Non-landed Properties | 3                                     |                    5000 | 900 to 1000          | Oct-2018                  |
|     3 | ONE-NORTH RESIDENCES     | ONE-NORTH GATEWAY  |                 5 | Non-landed Properties | 4                                     |                    6000 | 1500 to 1600         | Oct-2018                  |
|     4 | LUMIERE                  | MISTRI ROAD        |                 2 | Non-landed Properties | 1                                     |                    3050 | 600 to 700           | Oct-2018                  |
|     5 | HARBOURLIGHTS            | TELOK BLANGAH ROAD |                 4 | Non-landed Properties | 2                                     |                    2300 | 800 to 900           | Oct-2018                  |
|     6 | GLORIA MANSION           | PASIR PANJANG ROAD |                 5 | Non-landed Properties | 2                                     |                    2200 | 1100 to 1200         | Oct-2018                  |
|     7 | DOVER PARKVIEW           | DOVER RISE         |                 5 | Non-landed Properties | 2                                     |                    3000 | 900 to 1000          | Oct-2018                  |
|     8 | HARBOURLIGHTS            | TELOK BLANGAH ROAD |                 4 | Non-landed Properties | 2                                     |                    2450 | 700 to 800           | Oct-2018                  |
|     9 | THE ROCHESTER RESIDENCES | ROCHESTER DRIVE    |                 5 | Non-landed Properties | 3                                     |                    5800 | 1600 to 1700         | Oct-2018                  |
|    10 | CAPE ROYALE              | COVE WAY           |                 4 | Non-landed Properties | 3                                     |                    6800 | 1600 to 1700         | Oct-2018                  |

Return only the final code in markdown codeblock format, without any additional text or explanation. 



target: target.csv
train: source_0.csv
source_1.csv
source_2.csv
source_3.csv
source_4.csv
source_5.csv
test: test_0.csv
test_1.csv
test_2.csv
test_3.csv
test_4.csv
test_5.csv