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:
| movie_display_name                             |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office |   movie_annual_summary_tickets_sold |   movie_video_summary_domestic_dvd_units | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         |   movie_running_time | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:-----------------------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|------------------------------------:|-----------------------------------------:|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|---------------------:|:------------------------------------|:----------------------------------------|---------------:|
| Transformers: Revenge of the Fallen            |                    2009 | Action                     |                                   210000000 |                                          434407829 |                            53614916 |                              1.10834e+07 | Shia LaBeouf                     | 2009-06-24                              | Science Fiction                    | Animation/Live Action                  | Based on TV                       |                  149 | Michael Bay                         | DreamWorks                              |              1 |
| Harry Potter and the Half-Blood Prince         |                    2009 | Adventure                  |                                   250000000 |                                          633124489 |                            40261226 |                              1.14557e+07 | Gemma Jones                      | 2009-07-15                              | Fantasy                            | Animation/Live Action                  | Based on Fiction Book/Short Story |                  153 | David Yates                         | Heyday Films                            |              1 |
| Up                                             |                    2009 | Adventure                  |                                   175000000 |                                          438538457 |                            39067222 |                              1.29959e+07 | Christopher Plummer              | 2009-05-29                              | Fantasy                            | Digital Animation                      | Original Screenplay               |                   89 | Pete Docter                         | Walt Disney Pictures                    |              0 |
| The Hangover                                   |                    2009 | Comedy                     |                                    35000000 |                                          188441583 |                            36976334 |                              1.27776e+07 | Mike Tyson                       | 2009-06-05                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  100 | Todd Phillips                       | Warner Bros                             |              0 |
| Star Trek                                      |                    2009 | Adventure                  |                                   140000000 |                                          127950427 |                            34364003 |                              8.77734e+06 | Zachary Quinto                   | 2009-05-08                              | Science Fiction                    | Live Action                            | Based on TV                       |                  125 | J.J. Abrams                         | Bad Robot                               |              1 |
| Monsters vs. Aliens                            |                    2009 | Adventure                  |                                   175000000 |                                          183335854 |                            26446870 |                              5.91115e+06 | Reese Witherspoon                | 2009-03-27                              | Kids Fiction                       | Digital Animation                      | Based on Comic/Graphic Novel      |                   95 | Rob Letterman                       | DreamWorks Animation                    |              0 |
| Ice Age: Dawn of the Dinosaurs                 |                    2009 | Adventure                  |                                    90000000 |                                          663128152 |                            26209827 |                              6.43895e+06 | Kristen Wiig                     | 2009-07-01                              | Kids Fiction                       | Digital Animation                      | Original Screenplay               |                   93 | Carlos Saldanha                     | Blue Sky Studios                        |              1 |
| X-Men Origins: Wolverine                       |                    2009 | Action                     |                                   150000000 |                                          194942603 |                            23984421 |                              5.49402e+06 | Hugh Jackman                     | 2009-05-01                              | Super Hero                         | Live Action                            | Spin-Off                          |                  107 | Gavin Hood                          | 20th Century Fox                        |              0 |
| Night at the Museum: Battle of the Smithsonian |                    2009 | Comedy                     |                                   150000000 |                                          224987342 |                            23632496 |                              4.39609e+06 | Ben Stiller                      | 2009-05-22                              | Fantasy                            | Live Action                            | Based on Fiction Book/Short Story |                  105 | Shawn Levy                          | Twentieth Century Fox                   |              1 |
| The Proposal                                   |                    2009 | Romantic Comedy            |                                    40000000 |                                          150751686 |                            21861071 |                              6.93893e+06 | Sandra Bullock                   | 2009-06-19                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  107 | Anne Fletcher                       | Touchstone Pictures                     |              0 |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| movie_display_name            |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office |   movie_annual_summary_tickets_sold | movie_video_summary_domestic_dvd_units   | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         | movie_running_time   | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|------------------------------------:|:-----------------------------------------|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|:---------------------|:------------------------------------|:----------------------------------------|---------------:|
| Nanny McPhee and the Big Bang |                    2010 | Adventure                  |                                    35000000 |                                           68602223 |                         3.67696e+06 | 705091.0                                 | Emma Thompson                    | 2010-08-20                              | Kids Fiction                       | Live Action                            | Based on Fiction Book/Short Story | 109.0                | Debra Osborne                       | StudioCanal                             |              1 |
| Sex and the City 2            |                    2010 | Comedy                     |                                    95000000 |                                          199333086 |                         1.20846e+07 | 2463557.0                                | Sarah Jessica Parker             | 2010-05-27                              | Contemporary Fiction               | Live Action                            | Based on TV                       |                      | Michael Patrick King                |                                         |              1 |
| The Rum Diary                 |                    2010 | Drama                      |                                           0 |                                            8434917 |                         1.65319e+06 | 322440.0                                 | Johnny Depp                      | 2011-10-28                              | Historical Fiction                 | Live Action                            | Based on Fiction Book/Short Story | 122.0                | Bruce Robinson                      | Infinitum Nihil                         |              0 |
| The Last Station              |                    2010 | Drama                      |                                    18000000 |                                            9078279 |                    838766           |                                          | Anne-Marie Duff                  | 2010-01-15                              | Dramatization                      | Live Action                            | Based on Fiction Book/Short Story |                      |                                     |                                         |              0 |
| Inception                     |                    2010 | Thriller/Suspense          |                                   160000000 |                                          540008221 |                         3.7081e+07  | 6633339.0                                | Michael Caine                    | 2010-07-16                              | Science Fiction                    | Animation/Live Action                  | Original Screenplay               | 147.0                | Christopher Nolan                   |                                         |              0 |
| Death at a Funeral            |                    2010 | Comedy                     |                                    21000000 |                                            6237886 |                         5.4169e+06  | 861227.0                                 | Peter Dinklage                   | 2010-04-16                              | Contemporary Fiction               | Live Action                            | Remake                            | 92.0                 | Neil LaBute                         | Sidney Kimmel Entertianment             |              0 |
| Straw Dogs                    |                    2010 | Thriller/Suspense          |                                    25000000 |                                             929380 |                         1.30195e+06 | 797194.0                                 | James Marsden                    | 2011-09-16                              | Contemporary Fiction               | Live Action                            | Remake                            | 110.0                | Rod Lurie                           | Screen Gems                             |              0 |
| Cop Out                       |                    2010 | Comedy                     |                                    37000000 |                                           11034429 |                         5.68764e+06 | 854142.0                                 | Kevin Pollak                     | 2010-02-26                              | Contemporary Fiction               | Live Action                            | Original Screenplay               | 107.0                | Kevin Smith                         | Warner Bros.                            |              0 |
| Daybreakers                   |                    2010 | Horror                     |                                    20000000 |                                           21343926 |                         3.81516e+06 | 802640.0                                 | Isabel Lucas                     | 2010-01-08                              | Science Fiction                    | Live Action                            | Original Screenplay               |                      | Michael Spierig                     |                                         |              0 |
| The Sorcerer's Apprentice     |                    2010 | Adventure                  |                                   160000000 |                                          154835329 |                         8.00393e+06 | 1552613.0                                | Alfred Molina                    | 2010-07-14                              | Fantasy                            | Animation/Live Action                  | Based on Short Film               | 108.0                | Jon Turteltaub                      | Walt Disney Pictures                    |              0 |


Table #3
Filename: source_2.csv
Sample Rows in Markdown:
| movie_display_name                 |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office | movie_annual_summary_tickets_sold   | movie_video_summary_domestic_dvd_units   | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         | movie_running_time   | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:-----------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|:------------------------------------|:-----------------------------------------|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|:---------------------|:------------------------------------|:----------------------------------------|---------------:|
| Ender's Game                       |                    2012 | Adventure                  |                                   110000000 |                                           28000000 | 7583868.0                           | 847264.0                                 | Asa Butterfield                  | 2013-11-01                              | Science Fiction                    | Live Action                            | Based on Fiction Book/Short Story | 114.0                | Gavin Hood                          | Summit Entertainment                    |              0 |
| Foodfight!                         |                    2012 | Comedy                     |                                    45000000 |                                              73706 |                                     |                                          | Wayne Brady                      |                                         | Kids Fiction                       | Digital Animation                      | Original Screenplay               |                      |                                     | Threshold Entertainment                 |              0 |
| Madagascar 3: Europe's Most Wanted |                    2012 | Adventure                  |                                   145000000 |                                          530529789 | 27184859.0                          | 3511489.0                                | Eric Darnell                     | 2012-06-08                              | Kids Fiction                       | Digital Animation                      | Original Screenplay               | 85.0                 | Eric Darnell                        | DreamWorks Animation                    |              1 |
| Pompeii                            |                    2012 | Drama                      |                                    80000000 |                                           85300000 | 2835866.0                           | 239403.0                                 | Kit Harington                    | 2014-02-21                              | Historical Fiction                 | Live Action                            | Original Screenplay               | 102.0                | Paul W.S. Anderson                  | Constantin Film International           |              0 |
| The Avengers                       |                    2012 | Adventure                  |                                   225000000 |                                          896200000 | 78301450.0                          | 6025168.0                                | Scarlett Johansson               | 2012-05-04                              | Super Hero                         | Animation/Live Action                  | Based on Comic/Graphic Novel      | 143.0                | Joss Whedon                         | Marvel Studios                          |              0 |
| Brave                              |                    2012 | Adventure                  |                                   185000000 |                                          317324350 | 29808677.0                          | 7265553.0                                | Emma Thompson                    | 2012-06-22                              | Kids Fiction                       | Digital Animation                      | Original Screenplay               | 93.0                 | Mark Andrews                        | Disney-Pixar                            |              0 |
| Man of Steel                       |                    2012 | Action                     |                                   225000000 |                                          376954000 | 35798956.0                          | 2575890.0                                | Henry Cavill                     | 2013-06-14                              | Super Hero                         | Live Action                            | Based on Comic/Graphic Novel      | 142.0                | Emma Thomas                         | Warner Bros.                            |              1 |
| The Amazing Spider-Man             |                    2012 | Adventure                  |                                   220000000 |                                          495859604 | 32918425.0                          | 2413452.0                                | Andrew Garfield                  | 2012-07-03                              | Super Hero                         | Live Action                            | Based on Comic/Graphic Novel      | 136.0                | Steve Kloves                        | Columbia Pictures                       |              1 |
| The Hobbit: An Unexpected Journey  |                    2012 | Adventure                  |                                   250000000 |                                          714000000 | 33145087.0                          | 4379272.0                                | Hugo Weaving                     | 2012-12-14                              | Fantasy                            | Animation/Live Action                  | Based on Fiction Book/Short Story | 169.0                | Peter Jackson                       | New Line Cinema                         |              1 |
| The Croods                         |                    2012 | Adventure                  |                                   135000000 |                                          385900000 | 23021946.0                          | 2666130.0                                | Ryan Reynolds                    | 2013-03-22                              | Kids Fiction                       | Digital Animation                      | Original Screenplay               | 98.0                 | Chris Sanders                       | Dreamworks Animation                    |              0 |


Table #4
Filename: source_3.csv
Sample Rows in Markdown:
| movie_display_name                  |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office |   movie_annual_summary_tickets_sold |   movie_video_summary_domestic_dvd_units | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         |   movie_running_time | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:------------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|------------------------------------:|-----------------------------------------:|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|---------------------:|:------------------------------------|:----------------------------------------|---------------:|
| RoboCop                             |                    2013 | Action                     |                                   120000000 |                                          184374792 |                         7.17344e+06 |                         442503           | Joel Kinnaman                    | 2014-02-12                              | Science Fiction                    | Live Action                            | Remake                            |                  116 | Jose Padilha                        | Strike Entertainment                    |              0 |
| We're the Millers                   |                    2013 | Comedy                     |                                    37000000 |                                          117422157 |                         1.84987e+07 |                              2.16349e+06 | Will Poulter                     | 2013-08-07                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  100 | Rawson Thurber                      | New Line Cinema                         |              0 |
| The Hobbit: The Desolation of Smaug |                    2013 | Adventure                  |                                   250000000 |                                          702000000 |                         2.81746e+07 |                              2.86657e+06 | Martin Freeman                   | 2013-12-13                              | Fantasy                            | Animation/Live Action                  | Based on Fiction Book/Short Story |                  201 | Peter Jackson                       | Wingnut Films                           |              1 |
| The Lone Ranger                     |                    2013 | Western                    |                                   275000000 |                                          170700000 |                         9.77083e+06 |                              1.45177e+06 | Johnny Depp                      | 2013-07-02                              | Historical Fiction                 | Live Action                            | Based on TV                       |                  149 | Gore Verbinski                      | Walt Disney Pictures                    |              0 |
| 47 Ronin                            |                    2013 | Action                     |                                   175000000 |                                          113296587 |                         4.02062e+06 |                         437437           | Hiroyuki Sanada                  | 2013-12-25                              | Fantasy                            | Live Action                            | Original Screenplay               |                  127 | Carl Rinsch                         | Relativity Media                        |              0 |
| Dallas Buyers Club                  |                    2013 | Drama                      |                                     5000000 |                                           28939760 |                         2.00502e+06 |                         378524           | Matthew McConaughey              | 2013-11-01                              | Dramatization                      | Live Action                            | Based on Real Life Events         |                  117 | Jean-Marc Vallee                    | Focus Features                          |              0 |
| Legends of Oz: Dorothy’s Return     |                    2013 | Adventure                  |                                    70000000 |                                           11645586 |                         1.03578e+06 |                         119235           | Lea Michele                      | 2014-05-09                              | Kids Fiction                       | Digital Animation                      | Based on Fiction Book/Short Story |                   88 | Will Finn                           | Summertime Entertainment                |              0 |
| Maleficent                          |                    2013 | Adventure                  |                                   180000000 |                                          517000000 |                         2.9548e+07  |                              2.15268e+06 | Angelina Jolie                   | 2014-05-30                              | Fantasy                            | Live Action                            | Spin-Off                          |                   97 | Robert Stromberg                    | Roth Films                              |              0 |
| How to Train Your Dragon 2          |                    2013 | Adventure                  |                                   145000000 |                                          439100000 |                         2.1665e+07  |                              2.30754e+06 | Jay Baruchel                     | 2014-06-13                              | Fantasy                            | Digital Animation                      | Original Screenplay               |                  102 | Dean DeBlois                        | DreamWorks Animation                    |              1 |
| Kick-Ass 2                          |                    2013 | Action                     |                                    28000000 |                                           34333924 |                         3.54194e+06 |                         513894           | Aaron Johnson                    | 2013-08-16                              | Contemporary Fiction               | Live Action                            | Based on Comic/Graphic Novel      |                  103 | Jeff Wadlow                         | Universal Pictures                      |              0 |


Table #5
Filename: source_4.csv
Sample Rows in Markdown:
| movie_display_name                     |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office | movie_annual_summary_tickets_sold   | movie_video_summary_domestic_dvd_units   | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         |   movie_running_time | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:---------------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|:------------------------------------|:-----------------------------------------|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|---------------------:|:------------------------------------|:----------------------------------------|---------------:|
| Point Break                            |                    2015 | Action                     |                                   100000000 |                                           14100000 |                                     |                                          | Edgar Ramirez                    | 2015-12-25                              | Contemporary Fiction               | Live Action                            | Remake                            |                    0 | Ericson Core                        |                                         |              0 |
| Max                                    |                    2015 | Adventure                  |                                    20000000 |                                             896846 | 5096326.0                           | 176225.0                                 | Thomas Haden Church              | 2015-06-26                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  111 | Boaz Yakin                          | Sunswept Entertainment                  |              0 |
| The Gunman                             |                    2015 | Thriller/Suspense          |                                    40000000 |                                            2979543 | 1274163.0                           | 82641.0                                  | Sean Penn                        | 2015-03-20                              | Contemporary Fiction               | Live Action                            | Based on Fiction Book/Short Story |                  115 | Pierre Morel                        | Silver Pictures                         |              0 |
| Scout's Guide to the Zombie Apocalypse |                    2015 | Comedy                     |                                    15000000 |                                           10300000 | 442418.0                            |                                          | Tye Sheridan                     | 2015-10-30                              | Fantasy                            | Live Action                            | Original Screenplay               |                   93 | Christopher Landon                  | Paramount Pictures                      |              0 |
| The Visit                              |                    2015 | Thriller/Suspense          |                                     5000000 |                                           31973325 | 7779213.0                           |                                          | Kathryn Hahn                     | 2015-09-11                              | Fantasy                            | Live Action                            | Original Screenplay               |                   94 | M. Night Shyamalan                  | Blinding Edge Pictures                  |              0 |
| American Sniper                        |                    2015 | Drama                      |                                    58000000 |                                          197200000 | 272862.0                            | 2063019.0                                | Bradley Cooper                   | 2015-01-16                              | Dramatization                      | Live Action                            | Based on Factual Book/Article     |                  132 | Clint Eastwood                      | Mad Chance                              |              0 |
| The Vatican Tapes                      |                    2015 | Horror                     |                                    13000000 |                                           10342828 | 213233.0                            | 2543.0                                   | Michael Peña                     | 2015-07-24                              | Fantasy                            | Live Action                            | Original Screenplay               |                   91 | Mark Neveldine                      | Lakeshore Entertainment                 |              0 |
| Bridge of Spies                        |                    2015 | Thriller/Suspense          |                                    40000000 |                                           41900000 | 8211718.0                           |                                          | Tom Hanks                        | 2015-10-16                              | Historical Fiction                 | Live Action                            | Original Screenplay               |                  141 | Steven Spielberg                    | DreamWorks Pictures                     |              0 |
| Straight Outta Compton                 |                    2015 | Drama                      |                                    28000000 |                                           39388086 | 19242375.0                          |                                          | O'Shea Jackson, Jr.              | 2015-08-14                              | Dramatization                      | Live Action                            | Based on Real Life Events         |                  146 | F. Gary Gray                        | Broken Chair Flickz                     |              0 |
| Ex Machina                             |                    2015 | Thriller/Suspense          |                                    13000000 |                                           12691165 | 3039542.0                           | 235320.0                                 | Oscar Isaac                      | 2015-04-24                              | Science Fiction                    | Live Action                            | Original Screenplay               |                  110 | Alex Garland                        | DNA Films                               |              0 |


Table #6
Filename: source_5.csv
Sample Rows in Markdown:
| movie_display_name                            |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office |   movie_annual_summary_tickets_sold |   movie_video_summary_domestic_dvd_units | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         |   movie_running_time | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:----------------------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|------------------------------------:|-----------------------------------------:|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|---------------------:|:------------------------------------|:----------------------------------------|---------------:|
| Lincoln                                       |                    2011 | Drama                      |                                    65000000 |                                           91138308 |                         1.81016e+07 |                              2.04798e+06 | Daniel Day-Lewis                 | 2012-11-09                              | Dramatization                      | Live Action                            | Based on Fiction Book/Short Story |                  149 | Steven Spielberg                    | DreamWorks Pictures                     |              0 |
| The Smurfs                                    |                    2011 | Adventure                  |                                   110000000 |                                          421135165 |                         1.79841e+07 |                              2.36039e+06 | Alan Cumming                     | 2011-07-29                              | Kids Fiction                       | Animation/Live Action                  | Based on Comic/Graphic Novel      |                  103 | Raja Gosnell                        | Sony Pictures Animation                 |              0 |
| Harry Potter and the Deathly Hallows: Part II |                    2011 | Adventure                  |                                   125000000 |                                          960500000 |                         4.80468e+07 |                              7.6188e+06  | Josh Herdman                     | 2011-07-15                              | Fantasy                            | Animation/Live Action                  | Based on Fiction Book/Short Story |                  131 | David Yates                         | Warner Bros                             |              1 |
| Transformers: Dark of the Moon                |                    2011 | Action                     |                                   195000000 |                                          771400000 |                         4.44376e+07 |                              3.63084e+06 | Shia LaBeouf                     | 2011-06-29                              | Science Fiction                    | Animation/Live Action                  | Based on TV                       |                  154 | Michael Bay                         | Paramount Pictures                      |              1 |
| Thor                                          |                    2011 | Action                     |                                   150000000 |                                          268295994 |                         2.28286e+07 |                              2.40779e+06 | Kelly Hawthorne                  | 2011-05-06                              | Super Hero                         | Live Action                            | Based on Comic/Graphic Novel      |                  113 | Kenneth Branagh                     | Marvel Studios                          |              0 |
| Sucker Punch                                  |                    2011 | Action                     |                                    75000000 |                                           53365887 |                         4.58922e+06 |                         708039           | Abbie Cornish                    | 2011-03-25                              | Fantasy                            | Live Action                            | Original Screenplay               |                  110 | Zack Snyder                         | Warner Bros                             |              0 |
| Green Lantern                                 |                    2011 | Action                     |                                   200000000 |                                          114600000 |                         1.47038e+07 |                              1.76419e+06 | Tim Robbins                      | 2011-06-17                              | Super Hero                         | Animation/Live Action                  | Based on Comic/Graphic Novel      |                  113 | Martin Campbell                     | De Line Pictures                        |              0 |
| The Hangover Part II                          |                    2011 | Comedy                     |                                    80000000 |                                          332000000 |                         3.20888e+07 |                              3.76972e+06 | Zach Galifianakis                | 2011-05-26                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  102 | Todd Phillips                       | Warner Bros                             |              1 |
| Battleship                                    |                    2011 | Action                     |                                   209000000 |                                          239984828 |                         8.19515e+06 |                              1.14146e+06 | Liam Neeson                      | 2012-05-18                              | Contemporary Fiction               | Live Action                            | Based on Game                     |                  130 | Brian Goldner                       | Universal Pictures                      |              0 |
| Puss in Boots                                 |                    2011 | Adventure                  |                                   130000000 |                                          405726973 |                         1.8346e+07  |                              3.04023e+06 | Antonio Banderas                 | 2011-10-28                              | Kids Fiction                       | Digital Animation                      | Spin-Off                          |                   90 | Joe M. Aguilar                      | Paramount Pictures                      |              0 |


Table #7
Filename: source_6.csv
Sample Rows in Markdown:
| movie_display_name                                 |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office |   movie_annual_summary_tickets_sold |   movie_video_summary_domestic_dvd_units | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         |   movie_running_time | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:---------------------------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|------------------------------------:|-----------------------------------------:|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|---------------------:|:------------------------------------|:----------------------------------------|---------------:|
| The Dark Knight                                    |                    2008 | Action                     |                                   185000000 |                                          469546000 |                              312504 |                                 19512907 | Cillian Murphy                   | 2008-07-18                              | Super Hero                         | Live Action                            | Based on Comic/Graphic Novel      |                  152 | Christopher Nolan                   | Legendary Pictures                      |              1 |
| Iron Man                                           |                    2008 | Action                     |                                   186000000 |                                          263839000 |                            44347089 |                                 10953144 | Robert Downey, Jr.               | 2008-05-02                              | Super Hero                         | Live Action                            | Based on Comic/Graphic Novel      |                  126 | Jon Favreau                         | Paramount Pictures                      |              0 |
| Indiana Jones and the Kingdom of the Crystal Skull |                    2008 | Adventure                  |                                   185000000 |                                          469534294 |                            44164501 |                                  6138134 | Karen Allen                      | 2008-05-22                              | Historical Fiction                 | Live Action                            | Original Screenplay               |                  123 | Steven Spielberg                    | Lucasfilm                               |              1 |
| Hancock                                            |                    2008 | Action                     |                                   150000000 |                                          396287998 |                            31747392 |                                  5907862 | Jae Head                         | 2008-07-01                              | Super Hero                         | Live Action                            | Original Screenplay               |                   92 | Peter Berg                          | Blue Light                              |              0 |
| WALL-E                                             |                    2008 | Adventure                  |                                   180000000 |                                          308782830 |                            31170876 |                                 12315243 | Fred Willard                     | 2008-06-27                              | Science Fiction                    | Digital Animation                      | Original Screenplay               |                  100 | Andrew Stanton                      | Walt Disney Animation Studios           |              0 |
| Kung Fu Panda                                      |                    2008 | Adventure                  |                                   130000000 |                                          416475940 |                            30004818 |                                  9994732 | Dan Fogler                       | 2008-06-06                              | Kids Fiction                       | Digital Animation                      | Original Screenplay               |                   91 | Leslee Feldman                      | DreamWorks Animation                    |              0 |
| Twilight                                           |                    2008 | Drama                      |                                    37000000 |                                          209510305 |                            24641065 |                                 13870262 | Kristen Stewart                  | 2008-11-21                              | Fantasy                            | Live Action                            | Based on Fiction Book/Short Story |                  121 | Tricia Wood                         | Temple Hill Entertainment               |              0 |
| Madagascar: Escape 2 Africa                        |                    2008 | Comedy                     |                                   150000000 |                                          419505894 |                              421076 |                                  8263300 | Sacha Baron Cohen                | 2008-11-07                              | Kids Fiction                       | Digital Animation                      | Original Screenplay               |                   89 | Eric Darnell                        | DreamWorks Animation                    |              1 |
| Quantum of Solace                                  |                    2008 | Action                     |                                   230000000 |                                          422323651 |                              339735 |                                  3254599 | Daniel Craig                     | 2008-11-14                              | Contemporary Fiction               | Live Action                            | Based on Fiction Book/Short Story |                  106 | David Arnold                        |                                         |              1 |
| Horton Hears a Who                                 |                    2008 | Adventure                  |                                    85000000 |                                          144948447 |                            21522206 |                                  6171282 | Mickie McGowan                   | 2008-03-14                              | Fantasy                            | Digital Animation                      | Based on Fiction Book/Short Story |                   88 | Jimmy Hayward                       | 20th Century Fox Animation              |              0 |


Table #8
Filename: source_7.csv
Sample Rows in Markdown:
| movie_display_name   |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office | movie_annual_summary_tickets_sold   | movie_video_summary_domestic_dvd_units   | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         |   movie_running_time | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:---------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|:------------------------------------|:-----------------------------------------|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|---------------------:|:------------------------------------|:----------------------------------------|---------------:|
| Accidental Love      |                    2014 | Comedy                     |                                    26000000 |                                             135436 |                                     |                                          | Jessica Biel                     | 2015-03-18                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                   81 | David O. Russell                    | K Jam Media                             |              0 |
| Big Eyes             |                    2014 | Drama                      |                                    10000000 |                                            1393287 | 1214690.0                           | 124825.0                                 | Christoph Waltz                  | 2014-12-25                              | Dramatization                      | Live Action                            | Based on Real Life Events         |                  106 | Tim Burton                          | Tim Burton                              |              0 |
| Poltergeist          |                    2014 | Horror                     |                                    35000000 |                                           48400000 | 5666084.0                           | 122204.0                                 | Sam Rockwell                     | 2015-05-22                              | Fantasy                            | Live Action                            | Remake                            |                   93 | Gil Kenan                           | Ghost House Pictures                    |              0 |
| Blended              |                    2014 | Romantic Comedy            |                                    45000000 |                                           81700000 | 5665941.0                           | 759013.0                                 | Drew Barrymore                   | 2014-05-23                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  117 | Frank Coraci                        | Gulfstream Pictures                     |              0 |
| Boulevard            |                    2014 | Drama                      |                                           0 |                                              86346 | 15071.0                             | 44532.0                                  | Robin Williams                   | 2015-07-10                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                   88 | Dito Montiel                        | Camellia Entertainment                  |              0 |
| Chef                 |                    2014 | Comedy                     |                                           0 |                                           15405305 | 3846267.0                           | 359536.0                                 | Jon Favreau                      | 2014-05-09                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  115 | Jon Favreau                         | Fairview Entertainment                  |              0 |
| Dracula Untold       |                    2014 | Action                     |                                    70000000 |                                          160830062 | 6853351.0                           | 553448.0                                 | Luke Evans                       | 2014-10-10                              | Fantasy                            | Live Action                            | Based on Fiction Book/Short Story |                   92 | Gary Shore                          | Legendary Pictures                      |              0 |
| St. Vincent          |                    2014 | Comedy                     |                                    13000000 |                                           10699522 | 5321694.0                           | 355380.0                                 | Bill Murray                      | 2014-10-24                              | Contemporary Fiction               | Live Action                            | Original Screenplay               |                  102 | Theodore Melfi                      | Chernin Entertainment                   |              0 |
| A Walk in the Woods  |                    2014 | Adventure                  |                                           0 |                                            5093057 | 3521671.0                           |                                          | Robert Redford                   | 2015-09-02                              | Dramatization                      | Live Action                            | Based on Factual Book/Article     |                  104 | Ken Kwapis                          | Route One                               |              0 |
| Selma                |                    2014 | Drama                      |                                    20000000 |                                           14700000 | 253176.0                            | 277090.0                                 | David Oyelowo                    | 2014-12-25                              | Dramatization                      | Live Action                            | Based on Real Life Events         |                  123 | Ava Duvernay                        | Plan B Entertainment                    |              0 |


Target Schema:
| movie_display_name                    |   movie_production_year | movie_genre_display_name   |   movie_financial_summary_production_budget |   movie_financial_summary_international_box_office |   movie_annual_summary_tickets_sold | movie_video_summary_domestic_dvd_units   | movie_acting_role_display_name   | movie_theatrical_release_release_date   | movie_creative_type_display_name   | movie_production_method_display_name   | movie_source_display_name         |   movie_running_time | movie_technical_role_display_name   | movie_production_company_display_name   |   movie_sequel |
|:--------------------------------------|------------------------:|:---------------------------|--------------------------------------------:|---------------------------------------------------:|------------------------------------:|:-----------------------------------------|:---------------------------------|:----------------------------------------|:-----------------------------------|:---------------------------------------|:----------------------------------|---------------------:|:------------------------------------|:----------------------------------------|---------------:|
| Jurassic World                        |                    2015 | Action                     |                                   215000000 |                                         1016966151 |                         7.79209e+07 | 1109651.0                                | Chris Pratt                      | 2015-06-12                              | Science Fiction                    | Live Action                            | Based on Fiction Book/Short Story |                  124 | Colin Trevorow                      | Universal Pictures                      |              1 |
| Ant-Man                               |                    2015 | Action                     |                                   130000000 |                                          338400000 |                         2.15225e+07 |                                          | Paul Rudd                        | 2015-07-17                              | Super Hero                         | Live Action                            | Based on Comic/Graphic Novel      |                  117 | Peyton Reed                         | Marvel Studios                          |              0 |
| The Age of Adaline                    |                    2015 | Drama                      |                                    30000000 |                                           17703764 |                         5.09316e+06 | 264813.0                                 | Blake Lively                     | 2015-04-24                              | Fantasy                            | Live Action                            | Original Screenplay               |                  112 | Lee Toland Krieger                  | Sidney Kimmel Entertianment             |              0 |
| Nie yin niang                         |                    2015 | Drama                      |                                    15000000 |                                            6200000 |                     71129           |                                          | Zhou Yun                         | 2015-08-27                              | Historical Fiction                 | Live Action                            | Remake                            |                  107 | Hou Hsiao-hsien                     | SpotFilms                               |              0 |
| Mad Max: Fury Road                    |                    2015 | Action                     |                                   150000000 |                                          219500000 |                         1.83556e+07 | 830010.0                                 | Tom Hardy                        | 2015-05-15                              | Science Fiction                    | Live Action                            | Original Screenplay               |                  120 | George Miller                       | Kennedy Miller Mitchell Productions     |              1 |
| Entourage                             |                    2015 | Comedy                     |                                    30000000 |                                           13861922 |                         3.8666e+06  | 60108.0                                  | Kevin Connolly                   | 2015-06-03                              | Contemporary Fiction               | Live Action                            | Based on TV                       |                  104 | Doug Ellin                          | Closest to the Hole                     |              0 |
| The Hunger Games: Mockingjay - Part 2 |                    2015 | Thriller/Suspense          |                                   160000000 |                                          296800000 |                         2.75419e+07 |                                          | Jennifer Lawrence                | 2015-11-20                              | Science Fiction                    | Live Action                            | Based on Fiction Book/Short Story |                  136 | Francis Lawrence                    | Lionsgate                               |              1 |
| The Avengers: Age of Ultron           |                    2015 | Action                     |                                   250000000 |                                          945700000 |                         5.48394e+07 | 1102604.0                                | Claudia Kim                      | 2015-05-01                              | Super Hero                         | Live Action                            | Based on Comic/Graphic Novel      |                  141 | Joss Whedon                         | Marvel Studios                          |              1 |
| The Peanuts Movie                     |                    2015 | Comedy                     |                                    99000000 |                                           13200000 |                         1.45642e+07 |                                          | Noah Schnapp                     | 2015-11-06                              | Kids Fiction                       |                                        | Based on Comic/Graphic Novel      |                   89 | Steve Martino                       | Blue Sky Studios                        |              0 |
| Hotel Transylvania 2                  |                    2015 | Comedy                     |                                    80000000 |                                          274100000 |                         1.99994e+07 |                                          | Adam Sandler                     | 2015-09-25                              | Kids Fiction                       | Digital Animation                      | Original Screenplay               |                   89 | Genndy Tartakovsky                  | Sony Pictures Animation                 |              1 |

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
source_6.csv
source_7.csv
test: test_0.csv
test_1.csv
test_2.csv
test_3.csv
test_4.csv
test_5.csv
test_6.csv
test_7.csv