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:
| company_permalink           | company_name       | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city   | investor_permalink                    | investor_name   | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:----------------------------|:-------------------|:------------------------|:-----------------------|:---------------------|:-----------------|:---------------|:--------------------------------------|:----------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/goto-metrics       | Zettaset           | enterprise              | USA                    | CA                   | SF Bay           | Mountain View  | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | venture              | 2011-07-12  | 2011-07        | 2011-Q3          |          2011 |            3e+06    |
| /company/brighttag          | BrightTag          | enterprise              | USA                    | IL                   | Chicago          | Chicago        | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | venture              | 2011-08-15  | 2011-08        | 2011-Q3          |          2011 |            5e+06    |
| /company/joyent             | Joyent             | enterprise              | USA                    | CA                   | SF Bay           | San Francisco  | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | series-c+            | 2012-01-23  | 2012-01        | 2012-Q1          |          2012 |            8.5e+07  |
| /company/brighttag          | BrightTag          | enterprise              | USA                    | IL                   | Chicago          | Chicago        | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | series-c+            | 2012-04-25  | 2012-04        | 2012-Q2          |          2012 |            1.5e+07  |
| /company/exagen-diagnostics | Exagen Diagnostics | biotech                 | USA                    | NM                   | Albuquerque      | Albuquerque    | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | venture              | 2012-09-10  | 2012-09        | 2012-Q3          |          2012 |            5.3e+06  |
| /company/aspen-avionics     | Aspen Avionics     | transportation          | USA                    | NM                   | Albuquerque      | Albuquerque    | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | venture              | 2012-10-11  | 2012-10        | 2012-Q4          |          2012 |            1.28e+07 |
| /company/janrain            | Janrain            | web                     | USA                    | OR                   | Portland         | Portland       | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | series-c+            | 2013-01-14  | 2013-01        | 2013-Q1          |          2013 |            3.3e+07  |
| /company/goto-metrics       | Zettaset           | enterprise              | USA                    | CA                   | SF Bay           | Mountain View  | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | series-b             | 2013-01-16  | 2013-01        | 2013-Q1          |          2013 |            1e+07    |
| /company/hg-data-company    | HG Data Company    | analytics               | USA                    | CA                   | Santa Barbara    | Santa Barbara  | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | venture              | 2013-03-13  | 2013-03        | 2013-Q1          |          2013 |            2e+06    |
| /company/instructure        | Instructure        | enterprise              | USA                    | UT                   | Salt Lake City   | Salt Lake City | /financial-organization/epic-ventures | EPIC Ventures   |                          | USA                     | UT                    | Salt Lake City    | Salt Lake City  | series-c+            | 2013-06-05  | 2013-06        | 2013-Q2          |          2013 |            3e+07    |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| company_permalink       | company_name   | company_category_code   | company_country_code   | company_state_code   | company_region        | company_city   | investor_permalink   | investor_name   | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year | raised_amount_usd   |
|:------------------------|:---------------|:------------------------|:-----------------------|:---------------------|:----------------------|:---------------|:---------------------|:----------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|:--------------------|
| /company/adstruc        | ADstruc        | advertising             | USA                    | NY                   | New York              | New York City  | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2010-08-05  | 2010-08        | 2010-Q3          |          2010 | 18000.0             |
| /company/statsmix       | StatsMix       | enterprise              | USA                    | CO                   | Denver                | Boulder        | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2010-08-01  | 2010-08        | 2010-Q3          |          2010 | 12000.0             |
| /company/orbotix        | Orbotix        | hardware                | USA                    | CO                   | Denver                | Boulder        | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2010-08-01  | 2010-08        | 2010-Q3          |          2010 | 12000.0             |
| /company/roundpegg      | RoundPegg      | software                | USA                    | CO                   | Denver                | Boulder        | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | venture              | 2010-08-01  | 2010-08        | 2010-Q3          |          2010 | 18000.0             |
| /company/kapost         | Kapost         | software                | USA                    | CO                   | Denver                | Boulder        | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | series-a             | 2010-09-15  | 2010-09        | 2010-Q3          |          2010 | 1100000.0           |
| /company/lumatic        | Lumatic        | transportation          | USA                    |                      | United States - Other |                | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2010-08-01  | 2010-08        | 2010-Q3          |          2010 | 13000.0             |
| /company/highlighter    | Highlighter    | education               | USA                    | WA                   | Seattle               | Seattle        | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2010-11-01  | 2010-11        | 2010-Q4          |          2010 |                     |
| /company/rewardsforce   | RewardsForce   | advertising             | USA                    | WA                   | Seattle               | Seattle        | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2010-11-01  | 2010-11        | 2010-Q4          |          2010 | 18000.0             |
| /company/thinkfuse      | Thinkfuse      | enterprise              | USA                    | WA                   | Seattle               | Seattle        | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2010-11-01  | 2010-11        | 2010-Q4          |          2010 | 12000.0             |
| /company/immersive-labs | IMRSV          | analytics               | USA                    | NY                   | New York              | New York       | /company/techstars   | Techstars       | finance                  | USA                     | CO                    | Denver            | Boulder         | angel                | 2011-01-01  | 2011-01        | 2011-Q1          |          2011 | 18000.0             |


Table #3
Filename: source_10.csv
Sample Rows in Markdown:
| company_permalink       | company_name   | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city        | investor_permalink       | investor_name    | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year | raised_amount_usd   |
|:------------------------|:---------------|:------------------------|:-----------------------|:---------------------|:-----------------|:--------------------|:-------------------------|:-----------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|:--------------------|
| /company/nuorder        | NuORDER        | fashion                 | USA                    | CA                   | Los Angeles      | West Hollywood      | /person/mortimer-singer  | Mortimer Singer  |                          |                         |                       | unknown           |                 | series-a             | 2012-10-01  | 2012-10        | 2012-Q4          |          2012 | 3060000.0           |
| /company/chacha         | ChaCha         | advertising             | USA                    | IN                   | Indianapolis     | Carmel              | /person/morton-meyerson  | Morton Meyerson  |                          |                         |                       | unknown           |                 | series-b             | 2007-10-01  | 2007-10        | 2007-Q4          |          2007 | 12000000.0          |
| /company/binfire        | Binfire        | software                | USA                    | FL                   | Bocat Raton      | Bocat Raton         | /person/moshe-ariel      | Moshe Ariel      |                          |                         |                       | unknown           |                 | angel                | 2008-04-18  | 2008-04        | 2008-Q2          |          2008 | 500000.0            |
| /company/binfire        | Binfire        | software                | USA                    | FL                   | Bocat Raton      | Bocat Raton         | /person/moshe-ariel      | Moshe Ariel      |                          |                         |                       | unknown           |                 | angel                | 2010-01-01  | 2010-01        | 2010-Q1          |          2010 | 750000.0            |
| /company/unified-color  | Unified Color  | software                | USA                    | CA                   | SF Bay           | South San Frnacisco | /person/mr-andrew-oung   | Mr. Andrew Oung  |                          |                         |                       | unknown           |                 | angel                | 2010-01-01  | 2010-01        | 2010-Q1          |          2010 |                     |
| /company/hitviews       | HItviews       | advertising             | USA                    | NY                   | New York         | New York City       | /person/multiple-parties | multiple parties |                          |                         |                       | unknown           |                 | angel                | 2007-11-29  | 2007-11        | 2007-Q4          |          2007 | 485000.0            |
| /company/lockerdome     | LockerDome     | social                  | USA                    | MO                   | Saint Louis      | St. Louis           | /person/multiple-parties | multiple parties |                          |                         |                       | unknown           |                 | angel                | 2012-04-17  | 2012-04        | 2012-Q2          |          2012 | 300000.0            |
| /company/thirdlove      | ThirdLove      | ecommerce               | USA                    | CA                   | SF Bay           | San Francisco       | /person/munjal-shah      | Munjal Shah      |                          |                         |                       | unknown           |                 | series-a             | 2012-12-01  | 2012-12        | 2012-Q4          |          2012 | 5600000.0           |
| /company/hakia          | Hakia          | search                  | USA                    |                      | TBD              |                     | /person/murat-vargi      | Murat Vargi      |                          |                         |                       | unknown           |                 | series-a             | 2006-11-01  | 2006-11        | 2006-Q4          |          2006 | 16000000.0          |
| /company/bookacoach-com | bookacoach     | sports                  | USA                    | IN                   | Indianapolis     | Indianapolis        | /person/myles-grote      | Myles Grote      |                          |                         |                       | unknown           |                 | angel                | 2012-11-01  | 2012-11        | 2012-Q4          |          2012 |                     |


Table #4
Filename: source_2.csv
Sample Rows in Markdown:
| company_permalink                  | company_name              | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city   | investor_permalink                        | investor_name     | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year | raised_amount_usd   |
|:-----------------------------------|:--------------------------|:------------------------|:-----------------------|:---------------------|:-----------------|:---------------|:------------------------------------------|:------------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|:--------------------|
| /company/guardianedge-technologies | GuardianEdge Technologies | software                | USA                    | CA                   | SF Bay           | San Mateo      | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | other                | 2007-07-23  | 2007-07        | 2007-Q3          |          2007 | 3500000.0           |
| /company/netbase                   | NetBase Solutions         | social                  | USA                    | CA                   | SF Bay           | Mountain View  | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | series-c+            | 2010-03-02  | 2010-03        | 2010-Q1          |          2010 | 9000000.0           |
| /company/gigalogix                 | GigaLogix                 | public_relations        | USA                    | CA                   | SF Bay           | Oakland        | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | series-a             | 2007-02-01  | 2007-02        | 2007-Q1          |          2007 | 1400000.0           |
| /company/axcient                   | Axcient                   | enterprise              | USA                    | CA                   | SF Bay           | Mountain View  | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | series-b             | 2010-07-14  | 2010-07        | 2010-Q3          |          2010 | 10000000.0          |
| /company/apsalar                   | Apsalar                   | advertising             | USA                    | CA                   | SF Bay           | SAN FRANCISCO  | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | angel                | 2010-11-01  | 2010-11        | 2010-Q4          |          2010 | 800000.0            |
| /company/milyoni                   | Milyoni                   | games_video             | USA                    | CA                   | SF Bay           | Pleasanton     | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | series-a             | 2011-05-25  | 2011-05        | 2011-Q2          |          2011 | 3000000.0           |
| /company/cotendo                   | Cotendo                   | software                | USA                    | CA                   | SF Bay           | Sunnyvale      | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | series-c+            | 2011-06-15  | 2011-06        | 2011-Q2          |          2011 | 17000000.0          |
| /company/flashsoft                 | FlashSoft                 | software                | USA                    | CA                   | SF Bay           | Sunnyvale      | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | series-a             | 2011-06-28  | 2011-06        | 2011-Q2          |          2011 | 3000000.0           |
| /company/lendingclub               | Lending Club              | finance                 | USA                    | CA                   | SF Bay           | San Francisco  | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | venture              | 2011-09-09  | 2011-09        | 2011-Q3          |          2011 |                     |
| /company/apsalar                   | Apsalar                   | advertising             | USA                    | CA                   | SF Bay           | SAN FRANCISCO  | /financial-organization/thomvest-ventures | Thomvest Ventures |                          | USA                     | CA                    | SF Bay            | Redwood City    | series-a             | 2011-09-13  | 2011-09        | 2011-Q3          |          2011 | 5000000.0           |


Table #5
Filename: source_3.csv
Sample Rows in Markdown:
| company_permalink           | company_name       | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city   | investor_permalink                                    | investor_name                 | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:----------------------------|:-------------------|:------------------------|:-----------------------|:---------------------|:-----------------|:---------------|:------------------------------------------------------|:------------------------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/tricycle           | Tricycle           |                         | USA                    | TN                   | Chattanooga      | Chattanooga    | /financial-organization/northwest-georgia-bank        | Northwest Georgia Bank        |                          | USA                     | GA                    | Ringgold          | Ringgold        | other                | 2003-01-01  | 2003-01        | 2003-Q1          |          2003 |       500000        |
| /company/adapx              | Adapx              | software                | USA                    | WA                   | Seattle          | Seattle        | /financial-organization/northwest-technology-ventures | Northwest Technology Ventures |                          | USA                     | OR                    | Portland          | Beaverton       | venture              | 2012-07-30  | 2012-07        | 2012-Q3          |          2012 |            3e+06    |
| /company/adapx              | Adapx              | software                | USA                    | WA                   | Seattle          | Seattle        | /financial-organization/northwest-technology-ventures | Northwest Technology Ventures |                          | USA                     | OR                    | Portland          | Beaverton       | venture              | 2013-04-11  | 2013-04        | 2013-Q2          |          2013 |            3e+06    |
| /company/actionengine       | Action Engine      | mobile                  | USA                    | WA                   | Seattle          | Bellevue       | /financial-organization/northwest-venture-associates  | Northwest Venture Associates  |                          | USA                     | WA                    | Spokane           | Spokane         | series-c+            | 2007-07-01  | 2007-07        | 2007-Q3          |          2007 |            2e+07    |
| /company/vigilos            | Vigilos            | software                | USA                    | WA                   | Seattle          | Seattle        | /financial-organization/northwest-venture-associates  | Northwest Venture Associates  |                          | USA                     | WA                    | Spokane           | Spokane         | venture              | 2009-04-28  | 2009-04        | 2009-Q2          |          2009 |            1.4e+06  |
| /company/spraycool          | SprayCool          | hardware                | USA                    | WA                   | Liberty Lake     | Liberty Lake   | /financial-organization/northwest-venture-associates  | Northwest Venture Associates  |                          | USA                     | WA                    | Spokane           | Spokane         | venture              | 2007-03-07  | 2007-03        | 2007-Q1          |          2007 |            1e+07    |
| /company/vigilos            | Vigilos            | software                | USA                    | WA                   | Seattle          | Seattle        | /financial-organization/northwest-venture-associates  | Northwest Venture Associates  |                          | USA                     | WA                    | Spokane           | Spokane         | venture              | 2006-03-30  | 2006-03        | 2006-Q1          |          2006 |            6e+06    |
| /company/estorian           | Estorian           | software                | USA                    | WA                   | Seattle          | Bellevue       | /financial-organization/northwest-venture-associates  | Northwest Venture Associates  |                          | USA                     | WA                    | Spokane           | Spokane         | venture              | 2006-04-27  | 2006-04        | 2006-Q2          |          2006 |            4.5e+06  |
| /company/ip-fabrics         | IP Fabrics         |                         | USA                    | OR                   | Portland         | Beaverton      | /financial-organization/northwest-venture-associates  | Northwest Venture Associates  |                          | USA                     | WA                    | Spokane           | Spokane         | series-b             | 2006-03-29  | 2006-03        | 2006-Q1          |          2006 |            1.5e+06  |
| /company/world-wide-packets | World Wide Packets | public_relations        | USA                    | WA                   | Spokane Valley   | Spokane Valley | /financial-organization/northwest-venture-associates  | Northwest Venture Associates  |                          | USA                     | WA                    | Spokane           | Spokane         | series-c+            | 2005-12-05  | 2005-12        | 2005-Q4          |          2005 |            2.55e+07 |


Table #6
Filename: source_4.csv
Sample Rows in Markdown:
| company_permalink                 | company_name             | company_category_code   | company_country_code   | company_state_code   | company_region     | company_city   | investor_permalink                                 | investor_name              | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:----------------------------------|:-------------------------|:------------------------|:-----------------------|:---------------------|:-------------------|:---------------|:---------------------------------------------------|:---------------------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/zag                      | Zag                      | search                  | USA                    | CA                   | Los Angeles        | Santa Monica   | /financial-organization/capricorn-management       | Capricorn Management       |                          | USA                     | CT                    | New York          | Greenwich       | series-c+            | 2009-02-05  | 2009-02        | 2009-Q1          |          2009 |         3.74e+07    |
| /company/frx-polymers             | FRX Polymers             | cleantech               | USA                    | MA                   | Boston             | Chelmsford     | /financial-organization/capricorn-management       | Capricorn Management       |                          | USA                     | CT                    | New York          | Greenwich       | series-a             | 2009-07-27  | 2009-07        | 2009-Q3          |          2009 |         6e+06       |
| /company/targeted-growth          | Targeted Growth          | biotech                 | USA                    | WA                   | Seattle            | Seattle        | /financial-organization/capricorn-management       | Capricorn Management       |                          | USA                     | CT                    | New York          | Greenwich       | venture              | 2007-02-07  | 2007-02        | 2007-Q1          |          2007 |         2.23e+07    |
| /company/mendel-biotechnology     | Mendel Biotechnology     | biotech                 | USA                    | CA                   | SF Bay             | Hayward        | /financial-organization/capricorn-venture-partners | Capricorn Venture Partners |                          | BEL                     |                       | Leuven            | Leuven          | private-equity       | 2007-06-13  | 2007-06        | 2007-Q2          |          2007 |         8.38713e+06 |
| /company/frx-polymers             | FRX Polymers             | cleantech               | USA                    | MA                   | Boston             | Chelmsford     | /financial-organization/capricorn-venture-partners | Capricorn Venture Partners |                          | BEL                     |                       | Leuven            | Leuven          | series-b             | 2011-06-06  | 2011-06        | 2011-Q2          |          2011 |         1.57e+07    |
| /company/yammer                   | Yammer                   | enterprise              | USA                    | CA                   | SF Bay             | San Francisco  | /financial-organization/capricorn-venture-partners | Capricorn Venture Partners |                          | BEL                     |                       | Leuven            | Leuven          | series-c+            | 2012-02-29  | 2012-02        | 2012-Q1          |          2012 |         8.5e+07     |
| /company/wish-upon-a-hero         | HERO Network             | finance                 | USA                    | NJ                   | unknown            | Cherry, Hill   | /financial-organization/capsalus                   | Capsalus                   |                          | USA                     | GA                    | Atlanta           | Atlanta         | series-a             | 2010-10-27  | 2010-10        | 2010-Q4          |          2010 |    400000           |
| /company/henley-putnam-university | Henley-Putnam University | education               | USA                    | CA                   | SF Bay             | San Jose       | /financial-organization/capstone-partners          | Capstone Partners          |                          | USA                     | MA                    | Boston            | Boston          | venture              | 2010-10-08  | 2010-10        | 2010-Q4          |          2010 |         4.8e+06     |
| /company/markettools              | MarketTools              | enterprise              | USA                    | CA                   | California - Other |                | /financial-organization/capstone-ventures          | Capstone Ventures          |                          |                         |                       | unknown           |                 | series-c+            | 2007-01-01  | 2007-01        | 2007-Q1          |          2007 |         6e+07       |
| /company/thinking-phone-networks  | Thinking Phone Networks  | enterprise              | USA                    | MA                   | Boston             | Cambridge      | /financial-organization/capstone-ventures          | Capstone Ventures          |                          |                         |                       | unknown           |                 | venture              | 2010-01-19  | 2010-01        | 2010-Q1          |          2010 |         1.17e+06    |


Table #7
Filename: source_5.csv
Sample Rows in Markdown:
| company_permalink        | company_name    | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city    | investor_permalink                           | investor_name        | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:-------------------------|:----------------|:------------------------|:-----------------------|:---------------------|:-----------------|:----------------|:---------------------------------------------|:---------------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/smith-tinker    | Smith & Tinker  | games_video             | USA                    | WA                   | Seattle          | Bellevue        | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | venture              | 2009-08-25  | 2009-08        | 2009-Q3          |          2009 |         2.9e+07     |
| /company/sway            | Sway            | advertising             | USA                    | WI                   | Middleton        | Middleton       | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | series-a             | 2010-01-19  | 2010-01        | 2010-Q1          |          2010 |         2e+06       |
| /company/shoutlet        | Shoutlet        | enterprise              | USA                    | WI                   | Madison          | Madison         | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | series-a             | 2010-01-19  | 2010-01        | 2010-Q1          |          2010 |         3.2e+06     |
| /company/firefly-mobile  | Firefly Mobile  | mobile                  | USA                    | FL                   | Miami            | Miami Beach     | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | venture              | 2006-10-19  | 2006-10        | 2006-Q4          |          2006 |         3e+06       |
| /company/fastmobile      | Fastmobile      | software                | USA                    | IL                   | Chicago          | Rolling Meadows | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | series-b             | 2005-05-16  | 2005-05        | 2005-Q2          |          2005 |         1.2e+07     |
| /company/firefly-mobile  | Firefly Mobile  | mobile                  | USA                    | FL                   | Miami            | Miami Beach     | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | series-c+            | 2005-11-10  | 2005-11        | 2005-Q4          |          2005 |         3.18e+07    |
| /company/shoutlet        | Shoutlet        | enterprise              | USA                    | WI                   | Madison          | Madison         | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | series-b             | 2010-12-06  | 2010-12        | 2010-Q4          |          2010 |         6e+06       |
| /company/media-chaperone | Media Chaperone | web                     | USA                    | IL                   | Chicago          | Chicago         | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | venture              | 2011-02-24  | 2011-02        | 2011-Q1          |          2011 |         1e+06       |
| /company/fashion-playtes | Fashion Playtes | ecommerce               | USA                    | MA                   | Boston           | Salem           | /financial-organization/leo-capital-holdings | Leo Capital Holdings |                          | USA                     | IL                    | Chicago           | Northbrook      | series-b             | 2012-09-11  | 2012-09        | 2012-Q3          |          2012 |         5e+06       |
| /company/fundation       | Fundation       | finance                 | USA                    | NY                   | New York         | New York        | /financial-organization/leogroup             | LeoGroup             |                          |                         |                       | unknown           |                 | series-a             | 2013-03-28  | 2013-03        | 2013-Q1          |          2013 |         2.72897e+06 |


Table #8
Filename: source_6.csv
Sample Rows in Markdown:
| company_permalink            | company_name        | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city   | investor_permalink      | investor_name   | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:-----------------------------|:--------------------|:------------------------|:-----------------------|:---------------------|:-----------------|:---------------|:------------------------|:----------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/bread-labs          | Bread               | advertising             | USA                    | CA                   | SF Bay           | San Francisco  | /person/brendan-wallace | Brendan Wallace |                          |                         |                       | unknown           |                 | angel                | 2011-02-01  | 2011-02        | 2011-Q1          |          2011 |             1e+06   |
| /company/nuiku               | Nuiku               | software                | USA                    | WA                   | Seattle          | Redmond        | /person/brent-frei      | Brent Frei      |                          |                         |                       | unknown           |                 | series-a             | 2013-09-17  | 2013-09        | 2013-Q3          |          2013 |             1.6e+06 |
| /company/savvy-cellar-wines  | Savvy Cellar Wines  | other                   | USA                    | CA                   | SF Bay           | Redwood City   | /person/brent-harrison  | Brent Harrison  |                          |                         |                       | unknown           |                 | angel                | 2005-01-01  | 2005-01        | 2005-Q1          |          2005 |        300000       |
| /company/enigma-technologies | Enigma Technologies | analytics               | USA                    | NY                   | New York         | New York       | /person/brent-hurley    | Brent Hurley    |                          |                         |                       | unknown           |                 | angel                | 2013-02-27  | 2013-02        | 2013-Q1          |          2013 |             1.1e+06 |
| /company/yext                | Yext                | software                | USA                    | NY                   | New York         | New York       | /person/brent-metz      | Brent Metz      |                          |                         |                       | unknown           |                 | angel                | 2006-11-01  | 2006-11        | 2006-Q4          |          2006 |        250000       |
| /company/onegoodlove-com     | OneGoodLove.com     | web                     | USA                    | CA                   | Los Angeles      | West Hollywood | /person/bret-mcallister | Bret McAllister |                          |                         |                       | unknown           |                 | angel                | 2013-08-30  | 2013-08        | 2013-Q3          |          2013 |        900000       |
| /company/cue                 | Cue                 | web                     | USA                    | CA                   | SF Bay           | San Francisco  | /person/bret-taylor     | Bret Taylor     |                          |                         |                       | unknown           |                 | angel                | 2010-08-31  | 2010-08        | 2010-Q3          |          2010 |        700000       |
| /company/docstoc             | Docstoc             | web                     | USA                    | CA                   | Los Angeles      | Santa Monica   | /person/brett-brewer    | Brett Brewer    |                          |                         |                       | unknown           |                 | series-a             | 2007-11-01  | 2007-11        | 2007-Q4          |          2007 |        750000       |
| /company/compare-metrics     | Compare Metrics     | analytics               | USA                    | TX                   | Austin           | Austin         | /person/brett-hurt-2    | Brett Hurt      |                          |                         |                       | unknown           |                 | series-a             | 2013-05-21  | 2013-05        | 2013-Q2          |          2013 |             4.2e+06 |
| /company/madkast             | madKast             | web                     | USA                    | CO                   | Denver           | Boulder        | /person/brett-jackson-3 | Brett Jackson   |                          |                         |                       | unknown           |                 | series-a             | 2007-10-01  | 2007-10        | 2007-Q4          |          2007 |        300000       |


Table #9
Filename: source_7.csv
Sample Rows in Markdown:
| company_permalink                  | company_name              | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city        | investor_permalink                        | investor_name     | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:-----------------------------------|:--------------------------|:------------------------|:-----------------------|:---------------------|:-----------------|:--------------------|:------------------------------------------|:------------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/visible-world             | Visible World             | advertising             | USA                    | NY                   | New York         | New York            | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2008-04-14  | 2008-04        | 2008-Q2          |          2008 |            2.5e+07  |
| /company/obopay                    | obopay                    | mobile                  | USA                    | CA                   | SF Bay           | Redwood City        | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2008-04-21  | 2008-04        | 2008-Q2          |          2008 |            2e+07    |
| /company/jumptap                   | Jumptap                   | mobile                  | USA                    | MA                   | Boston           | Boston              | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2008-08-26  | 2008-08        | 2008-Q3          |          2008 |            2.6e+07  |
| /company/avid-radiopharmaceuticals | Avid Radiopharmaceuticals | biotech                 | USA                    | PA                   | Philadelphia     | Philadelphia        | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2009-05-21  | 2009-05        | 2009-Q2          |          2009 |            3.45e+07 |
| /company/avid-radiopharmaceuticals | Avid Radiopharmaceuticals | biotech                 | USA                    | PA                   | Philadelphia     | Philadelphia        | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2007-05-09  | 2007-05        | 2007-Q2          |          2007 |            2.6e+07  |
| /company/pacific-biosciences       | Pacific Biosciences       | biotech                 | USA                    | CA                   | SF Bay           | Menlo Park          | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2009-10-01  | 2009-10        | 2009-Q4          |          2009 |            6.8e+07  |
| /company/fluidigm                  | Fluidigm                  | biotech                 | USA                    | CA                   | SF Bay           | South San Francisco | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2007-01-10  | 2007-01        | 2007-Q1          |          2007 |            1.7e+07  |
| /company/metabolex                 | Metabolex                 | biotech                 | USA                    | CA                   | SF Bay           | Hayward             | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2007-04-19  | 2007-04        | 2007-Q2          |          2007 |            3.2e+07  |
| /company/impinj                    | Impinj                    | semiconductor           | USA                    | WA                   | Seattle          | Seattle             | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | series-c+            | 2007-03-07  | 2007-03        | 2007-Q1          |          2007 |            1.9e+07  |
| /company/targeted-growth           | Targeted Growth           | biotech                 | USA                    | WA                   | Seattle          | Seattle             | /financial-organization/alliancebernstein | AllianceBernstein |                          | USA                     | NY                    | New York          | New York        | venture              | 2007-02-07  | 2007-02        | 2007-Q1          |          2007 |            2.23e+07 |


Table #10
Filename: source_8.csv
Sample Rows in Markdown:
| company_permalink             | company_name      | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city   | investor_permalink                              | investor_name           | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:------------------------------|:------------------|:------------------------|:-----------------------|:---------------------|:-----------------|:---------------|:------------------------------------------------|:------------------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/coulomb-technologies | ChargePoint, Inc. | cleantech               | USA                    | CA                   | SF Bay           | Campbell       | /financial-organization/hartford-ventures       | Hartford Ventures       |                          | USA                     | CT                    | Hartford          | Hartford        | series-c+            | 2010-09-08  | 2010-09        | 2010-Q3          |          2010 |            1.5e+07  |
| /company/oncothyreon          | Oncothyreon       | biotech                 | USA                    | WA                   | Seattle          | Seattle        | /financial-organization/hartz-capital           | Hartz Capital           |                          |                         |                       | unknown           |                 | venture              | 2010-09-24  | 2010-09        | 2010-Q3          |          2010 |            1.49e+07 |
| /company/grouply              | Grouply           | network_hosting         | USA                    | CA                   | SF Bay           | Redwood City   | /financial-organization/harvard-angel-group     | Harvard Angel Group     |                          | USA                     |                       | TBD               |                 | angel                | 2007-06-01  | 2007-06        | 2007-Q2          |          2007 |       935000        |
| /company/grouply              | Grouply           | network_hosting         | USA                    | CA                   | SF Bay           | Redwood City   | /financial-organization/harvard-angel-group     | Harvard Angel Group     |                          | USA                     |                       | TBD               |                 | angel                | 2008-01-01  | 2008-01        | 2008-Q1          |          2008 |       365000        |
| /company/grouply              | Grouply           | network_hosting         | USA                    | CA                   | SF Bay           | Redwood City   | /financial-organization/harvard-angel-group     | Harvard Angel Group     |                          | USA                     |                       | TBD               |                 | series-a             | 2008-01-14  | 2008-01        | 2008-Q1          |          2008 |            1.3e+06  |
| /company/blue-buzz-network    | Blue Buzz Network | news                    | USA                    | CA                   | SF Bay           | San Francisco  | /financial-organization/harvard-angel-group     | Harvard Angel Group     |                          | USA                     |                       | TBD               |                 | venture              | 2010-07-13  | 2010-07        | 2010-Q3          |          2010 |            1.31e+06 |
| /company/glue-networks        | Glue Networks     | enterprise              | USA                    | CA                   | Sacramento       | Sacramento     | /financial-organization/harvard-angel-group     | Harvard Angel Group     |                          | USA                     |                       | TBD               |                 | series-a             | 2011-03-03  | 2011-03        | 2011-Q1          |          2011 |            4.5e+06  |
| /company/ninjametrics         | Ninja Metrics     | analytics               | USA                    | CA                   | Los Angeles      | Redondo Beach  | /financial-organization/harvard-angel-group     | Harvard Angel Group     |                          | USA                     |                       | TBD               |                 | series-a             | 2012-07-17  | 2012-07        | 2012-Q3          |          2012 |            2.6e+06  |
| /company/panaya               | Panaya            | software                | USA                    | CA                   | SF Bay           | Menlo Park     | /financial-organization/hasso-plattner-ventures | Hasso Plattner Ventures |                          | DEU                     |                       | Potsdam           | Potsdam         | venture              | 2010-09-21  | 2010-09        | 2010-Q3          |          2010 |            6e+06    |
| /company/knowledgetree        | KnowledgeTree     | software                | USA                    | NC                   | Raleigh-Durham   | Raleigh        | /financial-organization/hasso-plattner-ventures | Hasso Plattner Ventures |                          | DEU                     |                       | Potsdam           | Potsdam         | series-b             | 2012-07-09  | 2012-07        | 2012-Q3          |          2012 |            4.75e+06 |


Table #11
Filename: source_9.csv
Sample Rows in Markdown:
| company_permalink                  | company_name              | company_category_code   | company_country_code   | company_state_code   | company_region   | company_city   | investor_permalink                   | investor_name   | investor_category_code   | investor_country_code   | investor_state_code   | investor_region   | investor_city   | funding_round_type   | funded_at   | funded_month   | funded_quarter   |   funded_year |   raised_amount_usd |
|:-----------------------------------|:--------------------------|:------------------------|:-----------------------|:---------------------|:-----------------|:---------------|:-------------------------------------|:----------------|:-------------------------|:------------------------|:----------------------|:------------------|:----------------|:---------------------|:------------|:---------------|:-----------------|--------------:|--------------------:|
| /company/ping-identity-corporation | Ping Identity Corporation | security                | USA                    | CO                   | Denver           | Denver         | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | series-c+            | 2006-10-11  | 2006-10        | 2006-Q4          |          2006 |            1.3e+07  |
| /company/mulesource                | MuleSoft                  | enterprise              | USA                    | CA                   | SF Bay           | San Francisco  | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | series-c+            | 2010-03-30  | 2010-03        | 2010-Q1          |          2010 |            1.2e+07  |
| /company/amberpoint                | AmberPoint                | web                     | USA                    | CA                   | SF Bay           | Oakland        | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | series-c+            | 2006-03-28  | 2006-03        | 2006-Q1          |          2006 |            1.93e+07 |
| /company/questra                   | Questra                   | software                | USA                    | CA                   | SF Bay           | Redwood City   | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | series-c+            | 2006-08-15  | 2006-08        | 2006-Q3          |          2006 |            1.25e+07 |
| /company/reva-systems              | Reva Systems              | hardware                | USA                    | MA                   | Boston           | Westford       | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | series-b             | 2006-10-02  | 2006-10        | 2006-Q4          |          2006 |            2.35e+07 |
| /company/spring-mobile-solutions   | Spring Mobile Solutions   | mobile                  | USA                    | WA                   | Seattle          | Seattle        | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | series-c+            | 2010-05-17  | 2010-05        | 2010-Q2          |          2010 |            1.2e+07  |
| /company/zend-technologies         | Zend Technologies         | software                | USA                    | CA                   | SF Bay           | Cupertino      | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | venture              | 2010-05-17  | 2010-05        | 2010-Q2          |          2010 |            9e+06    |
| /company/devicevm                  | Splashtop, Inc            | software                | USA                    | CA                   | SF Bay           | San Jose       | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | venture              | 2010-06-02  | 2010-06        | 2010-Q2          |          2010 |            1e+07    |
| /company/qumu                      | Qumu                      | software                | USA                    | CA                   | SF Bay           | San Bruno      | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | other                | 2010-09-21  | 2010-09        | 2010-Q3          |          2010 |            8.75e+06 |
| /company/virtual-iron-software     | Virtual Iron Software     | software                | USA                    | MA                   | Boston           | Lowell         | /financial-organization/sap-ventures | SAP Ventures    |                          | USA                     | CA                    | SF Bay            | Palo Alto       | series-c+            | 2005-09-26  | 2005-09        | 2005-Q3          |          2005 |            1.15e+07 |


Target Schema:
| company_permalink          |   funded_year |   raised_amount_usd |
|:---------------------------|--------------:|--------------------:|
| /company/0xdata            |          2013 |             1700000 |
| /company/1                 |         16088 |             8000400 |
| /company/1-800-dentist     |          4020 |                   0 |
| /company/1000memories      |         18098 |            20175000 |
| /company/100plus           |          8044 |             2750000 |
| /company/1010data          |          2010 |            35000000 |
| /company/11i-solutions     |          2011 |             1800000 |
| /company/121nexus          |         10062 |              774000 |
| /company/12society         |         10060 |                   0 |
| /company/1366-technologies |         24117 |           136100000 |

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_10.csv
source_2.csv
source_3.csv
source_4.csv
source_5.csv
source_6.csv
source_7.csv
source_8.csv
source_9.csv
test: test_0.csv
test_1.csv
test_10.csv
test_2.csv
test_3.csv
test_4.csv
test_5.csv
test_6.csv
test_7.csv
test_8.csv
test_9.csv