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:
|   calaccess_committee_id | committee_name                                                                                                                                                                                         |   calaccess_filing_id | date_received   | contributor_lastname              | contributor_firstname   | contributor_city   | contributor_state   |   contributor_zip | contributor_employer                | contributor_occupation      | contributor_is_self_employed   |   amount |
|-------------------------:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|----------------------:|:----------------|:----------------------------------|:------------------------|:-------------------|:--------------------|------------------:|:------------------------------------|:----------------------------|:-------------------------------|---------:|
|                  1329332 | SAVE THE BAG BAN, YES ON 67, SPONSORED BY ENVIRONMENT CALIFORNIA                                                                                                                                       |               1979246 | 2015-06-02      | LUCAS                             | MELANIE                 | MONTARA            | CA                  |         940379811 | MACYS                               | IT                          | False                          |      100 |
|                  1382067 | COALITION FOR CIVIL LIBERTIES - NO ON 63, A PROJECT OF CALIFORNIA RIFLE & PISTOL ASSOCIATION                                                                                                           |               2082835 | 2016-08-21      | BLOMGREN                          | GLEN                    | FRESNO             | CA                  |             93722 |                                     | RETIRED                     | False                          |       50 |
|                  1346266 | CALIFORNIANS TO MEND, NOT END, THE DEATH PENALTY. NO ON PROP 62, YES ON PROP 66. SUPPORTED BY PROSECUTORS, LAW ENFORCEMENT, AND FAMILIES OF VICTIMS.                                                   |               2064651 | 2016-04-11      | ESPOSITO                          | JOSEPH                  | LOS ANGELES        | CA                  |             90020 | LOS ANGELES COUNTY DISTRICT ATTORNEYS OFFICE                                     | ASSISTANT DISTRICT ATTORNEY | False                          |     1000 |
|                  1382067 | COALITION FOR CIVIL LIBERTIES - NO ON 63, A PROJECT OF CALIFORNIA RIFLE & PISTOL ASSOCIATION                                                                                                           |               2129919 | 2016-11-02      | DICKINSON                         | RICHARD                 | PERRIS             | CA                  |             92571 |                                     | RETIRED                     | False                          |      100 |
|                  1380675 | NEWSOM BALLOT MEASURE COMMITTEE; SAFETY FOR ALL, YES ON PROP. 63,                                                                                                                                      |               2083720 | 2016-08-08      | KREADER                           | BEN                     | LOS ANGELES        | CA                  |             90027 | FOX GROUP                           | IT VICE PRESIDENT           | False                          |      100 |
|                  1329332 | SAVE THE BAG BAN, YES ON 67, SPONSORED BY ENVIRONMENT CALIFORNIA                                                                                                                                       |               1979246 | 2015-05-29      | JOLIVALT                          | CORINNE                 | ENCINITAS          | CA                  |             92024 | UNIVERSITY OF CALIFORNIA, SAN DIEGO | PROFESSOR                   | False                          |      150 |
|                  1374469 | YES ON PROPOSITION 51 - CALIFORNIANS FOR QUALITY SCHOOLS, SPONSORED AND FUNDED BY COALITION FOR ADEQUATE SCHOOL HOUSING ISSUES COMMITTEE AND CALIFORNIA BUILDING INDUSTRY ASSOCIATION ISSUES COMMITTEE |               2083357 | 2016-07-29      | JANCO INDUSTRIES, INC.            |                         | FREMONT            | CA                  |             94536 |                                     |                             | False                          |     5000 |
|                  1380746 | STOP PROP 63, A GRASSROOTS, COMMON-SENSE EFFORT FOR RATIONAL POLICY SPONSORED BY FIREARMS POLICY COALITION                                                                                             |               2082753 | 2016-07-01      | JANZEN                            | JONATHAN                | SQUAW VALLEY       | CA                  |             93675 |                                     | RETIRED                     | False                          |       50 |
|                  1380746 | STOP PROP 63, A GRASSROOTS, COMMON-SENSE EFFORT FOR RATIONAL POLICY SPONSORED BY FIREARMS POLICY COALITION                                                                                             |               2097199 | 2016-10-03      | INMAN                             | STEVE                   | SAN BERNARDINO     | CA                  |             92404 | SELF-EMPLOYED - STEVE INMAN         | RESTORER                    | False                          |       25 |
|                  1374469 | YES ON PROPOSITION 51 - CALIFORNIANS FOR QUALITY SCHOOLS, SPONSORED AND FUNDED BY COALITION FOR ADEQUATE SCHOOL HOUSING ISSUES COMMITTEE AND CALIFORNIA BUILDING INDUSTRY ASSOCIATION ISSUES COMMITTEE |               2012265 | 2015-12-07      | MONTAIR CONSTRUCTION COMPANY INC. |                         | SAN RAMON          | CA                  |             94583 |                                     |                             | False                          |      100 |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| ocd_prop_id                                      |   calaccess_prop_id |   ccdc_prop_id | prop_name                                                                                                                      |   ccdc_committee_id |   calaccess_committee_id | committee_name                                                                                                                                                                                         | committee_position   |
|:-------------------------------------------------|--------------------:|---------------:|:-------------------------------------------------------------------------------------------------------------------------------|--------------------:|-------------------------:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|:---------------------|
| ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6 |             1376258 |             70 | PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-12 SCHOOL AND COMMUNITY COLLEGE FACILITIES. INITIATIVE STATUTORY AMENDMENT.      |                 382 |                  1374469 | YES ON PROPOSITION 51 - CALIFORNIANS FOR QUALITY SCHOOLS, SPONSORED AND FUNDED BY COALITION FOR ADEQUATE SCHOOL HOUSING ISSUES COMMITTEE AND CALIFORNIA BUILDING INDUSTRY ASSOCIATION ISSUES COMMITTEE | SUPPORT              |
| ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6 |             1376258 |             70 | PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-12 SCHOOL AND COMMUNITY COLLEGE FACILITIES. INITIATIVE STATUTORY AMENDMENT.      |                 383 |                  1220380 | COMMUNITY COLLEGE FACILITY COALITION ISSUES COMMITTEE, YES ON 51                                                                                                                                       | SUPPORT              |
| ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6 |             1376258 |             70 | PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-12 SCHOOL AND COMMUNITY COLLEGE FACILITIES. INITIATIVE STATUTORY AMENDMENT.      |                 384 |                  1282321 | TORLAKSON'S INVEST IN CALIFORNIA A BALLOT MEASURE COMMITTEE TO SUPPORT PROPOSITION 51, SUPERINTENDENT TOM                                                                                              | SUPPORT              |
| ocd-contest/b51dc64d-3562-4913-a190-69f5088c22a6 |             1376258 |             70 | PROPOSITION 051 - SCHOOL BONDS. FUNDING FOR K-12 SCHOOL AND COMMUNITY COLLEGE FACILITIES. INITIATIVE STATUTORY AMENDMENT.      |                 385 |                  1382843 | CALIFORNIA TAXPAYERS AND EDUCATORS OPPOSED TO SPRAWL AND DEVELOPER ABUSE                                                                                                                               | OPPOSE               |
| ocd-contest/85990193-9d6f-4600-b8e7-bf1317841d82 |             1362198 |             71 | PROPOSITION 052 - STATE FEES ON HOSPITALS. FEDERAL MEDI-CAL MATCHING FUNDS. INITIATIVE STATUTORY AND CONSTITUTIONAL AMENDMENT. |                 386 |                  1362973 | YES ON PROPOSITION 52 - A COALITION OF CALIFORNIA ASSOCIATION OF HOSPITALS AND HEALTH SYSTEMS AND NON-PROFIT HEALTH CARE ORGANIZATIONS                                                                 | SUPPORT              |
| ocd-contest/85990193-9d6f-4600-b8e7-bf1317841d82 |             1362198 |             71 | PROPOSITION 052 - STATE FEES ON HOSPITALS. FEDERAL MEDI-CAL MATCHING FUNDS. INITIATIVE STATUTORY AND CONSTITUTIONAL AMENDMENT. |                 387 |                  1381488 | CALIFORNIANS FOR HOSPITAL ACCOUNTABILITY AND QUALITY CARE - NO ON 52, SPONSORED BY SERVICE EMPLOYEES INTERNATIONAL UNION - UNITED HEALTHCARE WORKERS WEST                                              | OPPOSE               |
| ocd-contest/85990193-9d6f-4600-b8e7-bf1317841d82 |             1362198 |             71 | PROPOSITION 052 - STATE FEES ON HOSPITALS. FEDERAL MEDI-CAL MATCHING FUNDS. INITIATIVE STATUTORY AND CONSTITUTIONAL AMENDMENT. |                 388 |                  1373047 | SERVICE EMPLOYEES INTERNATIONAL UNION, UNITED HEALTHCARE WORKERS WEST (NONPROFIT 501 (C)(5))                                                                                                           | OPPOSE               |
| ocd-contest/9fb6a199-7520-433c-a290-83e016a9d389 |             1376142 |             72 | PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOTER APPROVAL. INITIATIVE CONSTITUTIONAL AMENDMENT.                                |                 389 |                  1376040 | YES ON 53 - STOP BLANK CHECKS                                                                                                                                                                          | SUPPORT              |
| ocd-contest/9fb6a199-7520-433c-a290-83e016a9d389 |             1376142 |             72 | PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOTER APPROVAL. INITIATIVE CONSTITUTIONAL AMENDMENT.                                |                 390 |                  1378875 | NO ON PROP 53 - CALIFORNIANS TO PROTECT LOCAL CONTROL, A COALITION OF PUBLIC SAFETY, LOCAL GOVERNMENT, BUSINESS AND LABOR ORGANIZATIONS, GOVERNOR BROWN AND TAXPAYERS                                  | OPPOSE               |
| ocd-contest/9fb6a199-7520-433c-a290-83e016a9d389 |             1376142 |             72 | PROPOSITION 053 - REVENUE BONDS. STATEWIDE VOTER APPROVAL. INITIATIVE CONSTITUTIONAL AMENDMENT.                                |                 391 |                   761010 | CA BUSINESS PAC, SP0NSORED BY CA CHAMBER OF COMMERCE (AKA CALBUSPAC)                                                                                                                                   | OPPOSE               |


Target Schema:
| ocd_prop_id                                      |   calaccess_prop_id |   ccdc_prop_id | prop_name                                                                                                    |   ccdc_committee_id |   calaccess_committee_id | committee_name_x                                                 | committee_position   | committee_name_y                                                 |   calaccess_filing_id | date_received   | contributor_lastname   | contributor_firstname   | contributor_city   | contributor_state   |   contributor_zip | contributor_employer    | contributor_occupation   | contributor_is_self_employed   |   amount |
|:-------------------------------------------------|--------------------:|---------------:|:-------------------------------------------------------------------------------------------------------------|--------------------:|-------------------------:|:-----------------------------------------------------------------|:---------------------|:-----------------------------------------------------------------|----------------------:|:----------------|:-----------------------|:------------------------|:-------------------|:--------------------|------------------:|:------------------------|:-------------------------|:-------------------------------|---------:|
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-07-01      | KORMUNDOY              | EDWARD                  | LOS ANGELES        | CA                  |             90026 | RETIRED                 | RETIRED                  | False                          |      100 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-07-03      | CARSON                 | RICHARD                 | NEVADA CITY        | CA                  |             95959 | RETIRED                 | RETIRED                  | False                          |      100 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-09-20      | MORRISON               | JAMES                   | HUNTINGTON BEACH   | CA                  |             92647 | RETIRED                 | RETIRED                  | False                          |       59 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-09-21      | CRESSMAN               | DEREK                   | SACRAMENTO         | CA                  |             95816 | CALIFORNIA COMMON CAUSE | CAMPAIGN MANAGER         | False                          |      159 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-10-04      | MORRISON               | JAMES                   | HUNTINGTON BEACH   | CA                  |             92647 | RETIRED                 | RETIRED                  | False                          |       59 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-10-04      | ANDREW-AKITA           | EDITH                   | SAN DIEGO          | CA                  |             92107 | RETIRED                 | RETIRED                  | False                          |      100 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-10-05      | BJORK                  | MATT                    | OAKLAND            | CA                  |             94611 | NIKON PRECISION         | ENGINEER                 | False                          |       59 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-10-05      | MAFFLY                 | ROY                     | PALO ALTO          | CA                  |             94301 | RETIRED                 | RETIRED                  | False                          |       59 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-10-05      | STENMAN                | BRUCE                   | PRUNEDALE          | CA                  |             93907 | LIGHTSMITH              | MANAGER                  | False                          |      200 |
| ocd-contest/e0c5f9f0-63a9-4c15-9a5c-017e20ac15bc |             1381642 |             73 | PROPOSITION 054 - LEGISLATURE. LEGISLATION AND PROCEEDINGS. INITIATIVE CONSTITUTIONAL AMENDMENT AND STATUTE. |                 396 |                  1389997 | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) | SUPPORT              | CALIFORNIA COMMON CAUSE -- YES ON 54 AND 59 (NONPROFIT 501(C)(4) |               2098058 | 2016-10-05      | LITTLE                 | DARLENE                 | SEAL BEACH         | CA                  |             90740 | NOCCCD                  | LECTURER                 | False                          |      159 |

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
test: test_0.csv
test_1.csv