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   |
|------:|:------------------------|:----------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
| 29540 | THE CALLISTA            | MAR THOMA ROAD        |                12 | Non-landed Properties | 3.0                                   |                    2600 | 1100 to 1200         | Jun-2017                  |
| 45701 | EUHABITAT               | JALAN EUNOS           |                14 | Non-landed Properties | 3.0                                   |                    3000 | 1100 to 1200         | Aug-2016                  |
| 36284 | KEMAMAN POINT           | JALAN KEMAMAN         |                12 | Non-landed Properties | 3.0                                   |                    2650 | 800 to 900           | Feb-2017                  |
| 44082 | EASTERN LAGOON          | UPPER EAST COAST ROAD |                15 | Non-landed Properties | 1.0                                   |                    1950 | 700 to 800           | Sep-2016                  |
| 49996 | GUILLEMARD EDGE         | LORONG 30 GEYLANG     |                14 | Non-landed Properties | 1.0                                   |                    2100 | 400 to 500           | May-2016                  |
| 49301 | GRANDVIEW SUITES        | LORONG 22 GEYLANG     |                14 | Non-landed Properties | 1.0                                   |                    1500 | 300 to 400           | Jun-2016                  |
| 34114 | EASTERN LAGOON          | UPPER EAST COAST ROAD |                15 | Non-landed Properties | 2.0                                   |                    2600 | 800 to 900           | Mar-2017                  |
| 52032 | PARK INFINIA AT WEE NAM | LINCOLN ROAD          |                11 | Non-landed Properties | 3.0                                   |                    6000 | 1500 to 1600         | Apr-2016                  |
| 53957 | EUHABITAT               | JALAN EUNOS           |                14 | Non-landed Properties | na*                                   |                    3000 | 1000 to 1100         | Mar-2016                  |
| 55870 | TREASURES @ G20         | LORONG 20 GEYLANG     |                14 | Non-landed Properties | 1.0                                   |                    1750 | 400 to 500           | Jan-2016                  |


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   |
|------:|:------------------------|:------------------------|------------------:|:----------------------|--------------------------------------:|------------------------:|:---------------------|:--------------------------|
|  7306 | URBAN VISTA             | TANAH MERAH KECHIL LINK |                16 | Non-landed Properties |                                     1 |                    1800 | 400 to 500           | May-2018                  |
|  7812 | COCO PALMS              | PASIR RIS GROVE         |                18 | Non-landed Properties |                                     1 |                    1700 | 400 to 500           | May-2018                  |
| 43665 | MELVILLE PARK           | SIMEI STREET 1          |                18 | Non-landed Properties |                                     2 |                    2800 | 1000 to 1100         | Dec-2015                  |
| 11698 | TRESALVEO               | MARYMOUNT TERRACE       |                20 | Non-landed Properties |                                     3 |                    4200 | 1500 to 1600         | Feb-2018                  |
| 28659 | RIPPLE BAY              | PASIR RIS LINK          |                18 | Non-landed Properties |                                     2 |                    2100 | 700 to 800           | Jan-2017                  |
| 22758 | THOMSON GRAND           | SIN MING WALK           |                20 | Non-landed Properties |                                     2 |                    2600 | 900 to 1000          | Jun-2017                  |
| 39132 | THE BAYSHORE            | BAYSHORE ROAD           |                16 | Non-landed Properties |                                     3 |                    2600 | 1200 to 1300         | Apr-2016                  |
| 18598 | THE LUXURIE             | COMPASSVALE ROAD        |                19 | Non-landed Properties |                                     3 |                    2700 | 1000 to 1100         | Sep-2017                  |
|  4601 | ECO                     | BEDOK SOUTH AVENUE 3    |                16 | Non-landed Properties |                                     1 |                    1900 | 600 to 700           | Jul-2018                  |
|  7629 | WATERTOWN               | PUNGGOL CENTRAL         |                19 | Non-landed Properties |                                     1 |                    1850 | 500 to 600           | May-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   |
|------:|:------------------------|:---------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
| 19506 | BALMORAL HEIGHTS        | BALMORAL CRESCENT    |                10 | Non-landed Properties | 3.0                                   |                    4000 | 1100 to 1200         | Nov-2017                  |
| 40289 | OUE TWIN PEAKS          | LEONIE HILL ROAD     |                 9 | Non-landed Properties | 1.0                                   |                    3300 | 500 to 600           | Sep-2016                  |
| 48212 | THE FERNHILL            | FERNHILL ROAD        |                10 | Non-landed Properties | 3.0                                   |                    5200 | 1500 to 1600         | Apr-2016                  |
|  2376 | TANGLIN PARK            | RIDLEY PARK          |                10 | Non-landed Properties | 3.0                                   |                    4000 | 1500 to 1600         | Sep-2018                  |
| 20497 | SOUTHBANK               | NORTH BRIDGE ROAD    |                 7 | Non-landed Properties | 1.0                                   |                    3500 | 500 to 600           | Oct-2017                  |
| 15677 | CUSCADEN ROYALE         | CUSCADEN WALK        |                10 | Non-landed Properties | 3.0                                   |                    6000 | 1300 to 1400         | Jan-2018                  |
| 13896 | CONCOURSE SKYLINE       | BEACH ROAD           |                 7 | Non-landed Properties | 2.0                                   |                    6000 | 1300 to 1400         | Feb-2018                  |
| 20672 | ASTRID MEADOWS          | CORONATION ROAD WEST |                10 | Non-landed Properties | na*                                   |                    5800 | 2000 to 2100         | Oct-2017                  |
| 33582 | BOTANIC GARDENS VIEW    | TAMAN SERASI         |                10 | Non-landed Properties | 3.0                                   |                    4600 | 1400 to 1500         | Feb-2017                  |
| 50988 | NIVEN LOFT              | NIVEN ROAD           |                 9 | Non-landed Properties | 3.0                                   |                    5750 | 2200 to 2300         | Jan-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   |
|------:|:------------------------|:-----------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
| 24033 | THE INTERLACE           | DEPOT ROAD             |                 4 | Non-landed Properties | 2.0                                   |                    3700 | 1000 to 1100         | Dec-2016                  |
|  8678 | SKYLINE RESIDENCES      | TELOK BLANGAH ROAD     |                 4 | Non-landed Properties | 3.0                                   |                    5600 | 1400 to 1500         | Apr-2018                  |
| 20921 | PARK WEST               | JALAN LEMPENG          |                 5 | Non-landed Properties | na*                                   |                    2500 | 800 to 900           | Mar-2017                  |
|  6203 | THE CLIFT               | MCCALLUM STREET        |                 1 | Non-landed Properties | 1.0                                   |                    4763 | 800 to 900           | Jun-2018                  |
| 31428 | CARIBBEAN AT KEPPEL BAY | KEPPEL BAY DRIVE       |                 4 | Non-landed Properties | 3.0                                   |                    6200 | 1200 to 1300         | Apr-2016                  |
| 31966 | BLUE HORIZON            | WEST COAST CRESCENT    |                 5 | Non-landed Properties | 2.0                                   |                    3300 | 900 to 1000          | Apr-2016                  |
| 15797 | SPOTTISWOODE RESIDENCES | SPOTTISWOODE PARK ROAD |                 2 | Non-landed Properties | 1.0                                   |                    2850 | 500 to 600           | Aug-2017                  |
| 11980 | ONE-NORTH RESIDENCES    | ONE-NORTH GATEWAY      |                 5 | Non-landed Properties | 2.0                                   |                    4000 | 900 to 1000          | Dec-2017                  |
|  5410 | BOTANNIA                | WEST COAST PARK        |                 5 | Non-landed Properties | 4.0                                   |                    4200 | 1500 to 1600         | Jun-2018                  |
| 18341 | MERAPRIME               | JALAN BUKIT HO SWEE    |                 3 | Non-landed Properties | 3.0                                   |                    5050 | 1000 to 1100         | Jun-2017                  |


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   |
|------:|:------------------------|:----------------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
|  4289 | HIGH OAK CONDOMINIUM    | TOH TUCK ROAD         |                21 | Non-landed Properties | 2.0                                   |                    2000 | 900 to 1000          | Jun-2018                  |
| 25259 | ASTOR GREEN             | PINE GROVE            |                21 | Non-landed Properties | 2.0                                   |                    3000 | 1000 to 1100         | Jan-2016                  |
| 21910 | GLENDALE PARK           | HILLVIEW AVENUE       |                23 | Non-landed Properties | 3.0                                   |                    3100 | 1600 to 1700         | Jun-2016                  |
|  7075 | TREE HOUSE              | CHESTNUT AVENUE       |                23 | Non-landed Properties | 3.0                                   |                    3100 | 1100 to 1200         | Feb-2018                  |
|  1096 | PARC ROSEWOOD           | ROSEWOOD DRIVE        |                25 | Non-landed Properties | 1.0                                   |                    1600 | 400 to 500           | Sep-2018                  |
| 14095 | REGENT GROVE            | CHOA CHU KANG NORTH 7 |                23 | Non-landed Properties | 3.0                                   |                    2500 | 1100 to 1200         | May-2017                  |
| 13744 | PARK VIEW MANSION       | YUAN CHING ROAD       |                22 | Non-landed Properties | na*                                   |                    1950 | 1100 to 1200         | Jun-2017                  |
| 15621 | IVORY HEIGHTS           | JURONG EAST STREET 13 |                22 | Non-landed Properties | na*                                   |                    2700 | 1600 to 1700         | Mar-2017                  |
|  1077 | HILLSTA                 | PHOENIX ROAD          |                23 | Non-landed Properties | na*                                   |                    1700 | 500 to 600           | Sep-2018                  |
|  6462 | PARC OASIS              | JURONG EAST AVENUE 1  |                22 | Non-landed Properties | 3.0                                   |                    2600 | 1300 to 1400         | Mar-2018                  |


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   |
|------:|:----------------------------|:-----------------|------------------:|:----------------------|:--------------------------------------|------------------------:|:---------------------|:--------------------------|
|     1 | THE ESTUARY                 | YISHUN AVENUE 1  |                27 | Non-landed Properties | 1.0                                   |                    1800 | 600 to 700           | Oct-2018                  |
|     2 | THE MILTONIA RESIDENCES     | MILTONIA CLOSE   |                27 | Non-landed Properties | 3.0                                   |                    2250 | 1100 to 1200         | Oct-2018                  |
|     3 | SKIES MILTONIA              | MILTONIA CLOSE   |                27 | Non-landed Properties | 3.0                                   |                    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.0                                   |                    1600 | 400 to 500           | Oct-2018                  |
|     6 | H2O RESIDENCES              | FERNVALE LINK    |                28 | Non-landed Properties | 4.0                                   |                    2900 | 1300 to 1400         | Oct-2018                  |
|     7 | SKIES MILTONIA              | MILTONIA CLOSE   |                27 | Non-landed Properties | 3.0                                   |                    2500 | 1000 to 1100         | Oct-2018                  |
|     8 | SELETAR SPRINGS CONDOMINIUM | GERALD DRIVE     |                28 | Non-landed Properties | 3.0                                   |                    2750 | 1500 to 1600         | Oct-2018                  |
|     9 | SELETAR PARK RESIDENCE      | SELETAR ROAD     |                28 | Non-landed Properties | 2.0                                   |                    2200 | 800 to 900           | Oct-2018                  |
|    10 | EIGHT COURTYARDS            | CANBERRA DRIVE   |                27 | Non-landed Properties | na*                                   |                    1600 | 400 to 500           | Oct-2018                  |


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.0                                   |                    5000 | 900 to 1000          | Oct-2018                  |
|     3 | ONE-NORTH RESIDENCES     | ONE-NORTH GATEWAY  |                 5 | Non-landed Properties | 4.0                                   |                    6000 | 1500 to 1600         | Oct-2018                  |
|     4 | LUMIERE                  | MISTRI ROAD        |                 2 | Non-landed Properties | 1.0                                   |                    3050 | 600 to 700           | Oct-2018                  |
|     5 | HARBOURLIGHTS            | TELOK BLANGAH ROAD |                 4 | Non-landed Properties | 2.0                                   |                    2300 | 800 to 900           | Oct-2018                  |
|     6 | GLORIA MANSION           | PASIR PANJANG ROAD |                 5 | Non-landed Properties | 2.0                                   |                    2200 | 1100 to 1200         | Oct-2018                  |
|     7 | DOVER PARKVIEW           | DOVER RISE         |                 5 | Non-landed Properties | 2.0                                   |                    3000 | 900 to 1000          | Oct-2018                  |
|     8 | HARBOURLIGHTS            | TELOK BLANGAH ROAD |                 4 | Non-landed Properties | 2.0                                   |                    2450 | 700 to 800           | Oct-2018                  |
|     9 | THE ROCHESTER RESIDENCES | ROCHESTER DRIVE    |                 5 | Non-landed Properties | 3.0                                   |                    5800 | 1600 to 1700         | Oct-2018                  |
|    10 | CAPE ROYALE              | COVE WAY           |                 4 | Non-landed Properties | 3.0                                   |                    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