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:
| created_at          | text                                                                                                                                       | coordinates                                                   | hashtags                                           |
|:--------------------|:-------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------------------------|:---------------------------------------------------|
| 2020-05-22 18:47:24 | 🧬👨🏻‍⚕️ (@ Torre De Patología, Genética, Genómica Y Centro De Perfeccionamiento De Habilidades Médico-Técnicas in Ci… https://t.co/zCc2Jxtc1I | {'type': 'Point', 'coordinates': [-99.15376881, 19.41317555]} | []                                                 |
| 2020-05-22 19:18:46 | @yeidckol @GobiernoMX @lopezobrador_ https://t.co/hpqoAwHwuA                                                                               |                                                               | []                                                 |
| 2020-05-22 20:25:41 | #ElVioladorEresTú debería catalogarse como instigar al odio y levantar falsedades ¿no?                                                     |                                                               | [{'text': 'ElVioladorEresTú', 'indices': [0, 17]}] |
|                     | Obviamente estoy de acuerdo… https://t.co/eNh9gB6wJc                                                                                       |                                                               |                                                    |
| 2020-05-22 21:07:13 | Que paso güerita, te molesta el sol? https://t.co/RhrwxZtJ2k                                                                               |                                                               | []                                                 |
| 2020-05-22 18:35:52 | Si andas por acá y también tus recargas de teléfono o servicio.. https://t.co/yglgCz3iQh                                                   |                                                               | []                                                 |
| 2020-05-22 20:47:59 | @RosaMariaCueto8 ! Listo ya te sigo!                                                                                                       |                                                               | []                                                 |
| 2020-05-22 23:48:08 | @loveemom_ I’m tryin to get my car waxed too.. who’s Open?                                                                                 |                                                               | []                                                 |
| 2020-05-22 21:52:57 | @bolitadeaIgodon Ojalá y si , y me confronten para hacer valer la igualdad que piden .                                                     |                                                               | []                                                 |
| 2020-05-22 20:47:53 | Qué desconsiderados esos chinos, tanta gente enferma de #COVIDー19 y el consulado en Puebla sigue cerrado 😏 https://t.co/YydOX2jwZB       |                                                               | [{'text': 'COVIDー19', 'indices': [56, 65]}]       |
| 2020-05-22 20:02:56 | Applying self tan is one of the ultimate forms of self care and you cannot change my mind.                                                 |                                                               | []                                                 |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                        | coordinates   | hashtags   |
|:--------------------|:--------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------|
| 2020-05-24 02:46:17 | A las cuantas decepciones se hace piedra el corazón?                                                                                        |               | []         |
| 2020-05-24 00:55:57 | Week in Preview for 5/25-5/29:  Let's finish ROYAL STRONG! Don't miss Mrs. Murphy's Weekly Principal's Message:… https://t.co/jlkosv9uXY    |               | []         |
| 2020-05-24 03:15:04 | ✅                                                                                                                                          |               | []         |
| 2020-05-24 05:08:41 | @rocionahle @SENER_mx Rápido aprenden de su líder. Pura ineptitud, incompetencia, poco profesionalismo.                                     |               | []         |
| 2020-05-24 02:46:28 | @Lizgottik @lahzoe1 Dale oportunidattt , ese lo debió d leer hace 🤔🤔🤔🧐🤷‍♀️🤕.......años ? 🤯😢🤦🏻‍♀️🇲🇽😂😂😂😂😂😂🤣🤣🤣🤣🤣⚡️⚡️              |               | []         |
| 2020-05-24 02:44:16 | No tengo necesidad de aparentar nada, lo que ven es lo que soy 🤷🏻‍♀️                                                                           |               | []         |
| 2020-05-24 01:59:00 | Everyone has been reaching out and I appreciate each and everyone of y’all... sorry I haven’t responded... looking… https://t.co/6vEQLl1O4w |               | []         |
| 2020-05-24 03:43:04 | @rocioglzm Viste mi penúltimo tweet???                                                                                                      |               | []         |
| 2020-05-24 02:39:43 | @El_Loboso https://t.co/0b6iNiwhcq                                                                                                          |               | []         |
| 2020-05-24 04:18:04 | Me caga barrer, amo trapear                                                                                                                 |               | []         |


Table #3
Filename: source_2.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                   | coordinates   | hashtags                                     |
|:--------------------|:-----------------------------------------------------------------------------------------------------------------------|:--------------|:---------------------------------------------|
| 2020-05-22 15:33:57 | @lapotrahn Haciéndolo.....                                                                                             |               | []                                           |
|                     |                                                                                                                        |               |                                              |
|                     | La rutina de ejercicios de hoy 😢                                                                                      |               |                                              |
| 2020-05-22 16:34:17 | @cecitomich Gracias @cecitomich 😅 un saludo, guardo silencio. Pero eso sí, un gustado estar, encontrarte a tu lado... |               | []                                           |
| 2020-05-22 16:42:47 | This here is personal af                                                                                               |               | []                                           |
| 2020-05-22 15:46:42 | Quiero la mejor cámara de #HuaweiP40 Pro con descuento para regalarlo como graduación de la pepa a mi hijo             |               | [{'text': 'HuaweiP40', 'indices': [26, 36]}] |
| 2020-05-22 13:17:40 | @JohnJHarwood The Boors                                                                                                |               | []                                           |
| 2020-05-22 14:22:43 | 🤦🏻‍♀️🤢 https://t.co/kAYNKBPIhs                                                                                           |               | []                                           |
| 2020-05-22 15:10:13 | @Soniavirginiat Ojalá!!                                                                                                |               | []                                           |
| 2020-05-22 17:18:46 | @somecaboose floral/fruity is good in a gin, imo                                                                       |               | []                                           |
| 2020-05-22 15:36:07 | ¿Por qué a la gente le cuesta tanto decir no/no se/no me acuerdo?                                                      |               | []                                           |
| 2020-05-22 12:38:35 | Después de cierto tiempo, un hombre y una mujer no están para darse espacio, sino para darse con todo.😎😎😎           |               | []                                           |


Table #4
Filename: source_3.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates                                                   | hashtags                                                                                                                                                                                                               |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2020-05-24 13:36:12 | ..                                                                                                                                           | {'type': 'Point', 'coordinates': [-99.15408278, 19.43615941]} | [{'text': 'MEXICO', 'indices': [20, 27]}, {'text': 'CDMX', 'indices': [68, 73]}]                                                                                                                                       |
|                     |                                                                                                                                              |                                                               |                                                                                                                                                                                                                        |
|                     | Any Second Now*                                                                                                                              |                                                               |                                                                                                                                                                                                                        |
|                     | #MEXICO                                                                                                                                      |                                                               |                                                                                                                                                                                                                        |
|                     | @ptorres                                                                                                                                     |                                                               |                                                                                                                                                                                                                        |
|                     | @mrjccampos                                                                                                                                  |                                                               |                                                                                                                                                                                                                        |
|                     | @maximiliano_vg                                                                                                                              |                                                               |                                                                                                                                                                                                                        |
|                     | #CDMX @ Monumento a la Revolución https://t.co/yQiqX9YGbQ                                                                                    |                                                               |                                                                                                                                                                                                                        |
| 2020-05-24 14:49:37 | Leave it 2 me to get a haircut after 6 WEEKS of  #COVID19 &amp; go fr WOLFMAN 2 TEDDY TIP                                                    |                                                               | [{'text': 'COVID19', 'indices': [49, 57]}]                                                                                                                                                                             |
|                     |                                                                                                                                              |                                                               |                                                                                                                                                                                                                        |
|                     | TIP-ur hair is essential-Ea… https://t.co/pbqxg1hEZr                                                                                         |                                                               |                                                                                                                                                                                                                        |
| 2020-05-24 14:04:43 | @salva_profesor Como jugador siempre mirándole la espalda al rey de Roma en esos clásicos. https://t.co/YbfKDMfzhT                           |                                                               | []                                                                                                                                                                                                                     |
| 2020-05-24 18:14:12 | Dominguito de mucho trabajo 🍓🙌🏻                                                                                                             |                                                               | []                                                                                                                                                                                                                     |
| 2020-05-24 07:45:44 | Desde el Palco48 PteSegundo nivel, tenemos cientos de partidos apoyando cada 15 días, vimos el título, libertadores… https://t.co/m9SZFahBXA |                                                               | []                                                                                                                                                                                                                     |
| 2020-05-24 17:02:35 | @KatelinSport Thank you!! I didn't see the bracelet but found some nice rings and other goodies. Glad Adele is supporting them!              |                                                               | []                                                                                                                                                                                                                     |
| 2020-05-24 15:11:57 | Ah, también tenía cáncer. Así de miserable está sujeto. Y luego, se queja de que no la dejaron velarla a sus anchas… https://t.co/t72ecrRkfu |                                                               | []                                                                                                                                                                                                                     |
| 2020-05-24 10:35:33 | @Zuly_Mor 💋💓🌹                                                                                                                             |                                                               | []                                                                                                                                                                                                                     |
| 2020-05-24 15:55:35 | When her Face Is Caked Up With Make Up But Her Arms Are Hairy As Hell                                                                        |                                                               | [{'text': 'laugh', 'indices': [71, 77]}, {'text': 'comedy', 'indices': [78, 85]}, {'text': 'facts', 'indices': [86, 92]}, {'text': 'TruthHurts', 'indices': [93, 104]}, {'text': 'quarantine', 'indices': [105, 116]}] |
|                     |                                                                                                                                              |                                                               |                                                                                                                                                                                                                        |
|                     | #laugh #comedy #facts #TruthHurts #quarantine                                                                                                |                                                               |                                                                                                                                                                                                                        |
| 2020-05-24 16:06:35 | @ClouthierManuel @LuisaAlcalde El mantecoso sin pelo nos quiere ver la cara de chinos como ven?                                              |                                                               | []                                                                                                                                                                                                                     |
|                     | 🤣🤣🤣🤣👍🏼                                                                                                                                   |                                                               |                                                                                                                                                                                                                        |


Table #5
Filename: source_4.csv
Sample Rows in Markdown:
| created_at          | text                                                                                          | coordinates   | hashtags   |
|:--------------------|:----------------------------------------------------------------------------------------------|:--------------|:-----------|
| 2020-05-25 02:59:24 | De pronto quiero algo así...                                                                  |               | []         |
| 2020-05-25 00:52:29 | @Don_DavidZ @joserra_espn "No seas amargado, David"                                           |               | []         |
|                     |                                                                                               |               |            |
|                     | - Yo, 2020.                                                                                   |               |            |
| 2020-05-24 21:59:40 | @alek_sanz Esa no he tenido la oportunidad de verla jaja                                      |               | []         |
| 2020-05-25 03:13:07 | @ArlosJk @IvancitoGT502 Ya tu sabe papi 😁                                                    |               | []         |
| 2020-05-25 01:51:42 | @liverpoolmexico tengo un pedido y no se actualiza la información de envío (?)                |               | []         |
| 2020-05-25 00:58:07 | Extraño a la universidad                                                                      |               | []         |
| 2020-05-25 03:06:18 | @lalis_245 Y como dice forrest gump es todo lo que tengo que decir de tu foto: me gusta mucho |               | []         |
| 2020-05-25 01:51:02 | @Irandi69 Felicidades excelente preparación                                                   |               | []         |
| 2020-05-25 03:05:43 | @IndirectaVip ☺️                                                                              |               | []         |
| 2020-05-25 02:00:18 | Hyundai pintura fascia trasera https://t.co/xuYYDGHZlm                                        |               | []         |


Table #6
Filename: source_5.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                               | coordinates   | hashtags                                       |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------------------------------------------|
| 2020-05-22 01:41:40 | @laoctavadigital , buenas noches y con el debido respeto, me da pena la calidad de audio y video de tan interesante… https://t.co/JYLn4wl4Mf       |               | []                                             |
| 2020-05-22 01:33:30 | @DonGabymx @ChairosArrepen3 @ElMilkyWay99 @JLozanoA @PartidoMorenaMx Claro que trató de ser lo más crítico y objeti… https://t.co/cI6G7veD7W       |               | []                                             |
| 2020-05-22 00:39:52 | https://t.co/dyzYLod1LX                                                                                                                            |               | []                                             |
| 2020-05-22 01:28:19 | @CamilaPriego Ya quiero verte amorcito 🥺❤️                                                                                                        |               | []                                             |
| 2020-05-22 02:09:06 | If u a Raider hater pls dont ever listen to any NWA/Ice Cube music or movies... FUCK YALL                                                          |               | []                                             |
| 2020-05-22 01:50:00 | En algún lugar https://t.co/vvRIa1LDo7                                                                                                             |               | []                                             |
| 2020-05-22 03:17:45 | @mariajosegglez https://t.co/zSSGmwkCWr                                                                                                            |               | []                                             |
| 2020-05-22 00:50:24 | https://t.co/qHILFKeoXa                                                                                                                            |               | []                                             |
| 2020-05-22 00:11:44 | @tbattest &amp; the @EdwardHWhiteHi1 family can’t wait to see our #ClassOf2020🎓 tomorrow @ 1:30 in the bus 🚌 loading zo… https://t.co/iQZrhD8iPL |               | [{'text': 'ClassOf2020', 'indices': [66, 78]}] |
| 2020-05-21 22:32:39 | Para los que reclaman de los cobros de luz en Yucatán, chequen el hilo:                                                                            |               | []                                             |


Table #7
Filename: source_6.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates   | hashtags   |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------|
| 2020-05-20 20:45:39 | 😂😂 already know bro 🤦🏾‍♂️                                                                                                                     |               | []         |
| 2020-05-20 21:38:35 | Excelente análisis y respuesta                                                                                                               |               | []         |
| 2020-05-20 18:31:46 | Por qué no hacen algo para parar las quemas de pastizales y basura ilegal @HectorAstudillo @Adela_Roman… https://t.co/9FTmtQRNGx             |               | []         |
| 2020-05-20 18:34:26 | este año ya son varios los que se han ejecutado por estos “enemigos de los estudios universitarios”, como los descr… https://t.co/dnZm0OB1OA |               | []         |
| 2020-05-20 20:32:03 | @josealemano Bello 😎                                                                                                                        |               | []         |
| 2020-05-20 22:41:19 | "Instruye y prepara a tus hijos en el camino que deben andar ... pero asegúrate de andar tu mismo en ese camino".… https://t.co/YUeXpnGDv8   |               | []         |
| 2020-05-21 00:17:02 | @SevenGirlSoph @kanygarcia Es que es tan perfecto lo que hace que se merece eso y más.                                                       |               | []         |
|                     |                                                                                                                                              |               |            |
|                     | ¡Gracias @kanygarcia! ❤️                                                                                                                     |               |            |
| 2020-05-20 22:53:51 | Ninguna verga les embona me consta                                                                                                           |               | []         |
| 2020-05-20 23:23:29 | @anarascon ¿Y qué tal .... "vizzzzted"?                                                                                                      |               | []         |
| 2020-05-20 21:43:31 | I’ve never seen the first quote 🤣                                                                                                           |               | []         |


Table #8
Filename: source_7.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates   | hashtags   |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------|
| 2020-05-23 15:43:59 | Me puse protector solar y olió a playita y me emocioné :(                                                                                    |               | []         |
| 2020-05-23 15:42:54 | @idelatou @berlich Hasta que las bolas ardan                                                                                                 |               | []         |
| 2020-05-23 18:42:39 | tbh yo me di cuenta que mi compañera estaba embarazada cuando tenía como 6 meses Y SE SENTABA AL LADO DE MI.                                 |               | []         |
| 2020-05-23 14:36:13 | Hırsızlık dolandırıcılık paçalardan akıyor!                                                                                                  |               | []         |
| 2020-05-23 16:54:08 | @GermanSalazarM @sonia_ssi @NTRGuadalajara Hay mucho que aprender sobre los principios y valores que mueven a quien… https://t.co/qQ4mTnjAiJ |               | []         |
| 2020-05-23 16:44:03 | Bandit isn’t even two months old and is already walking to the sliding glass door so he can be let out to go potty! Proud mommy!             |               | []         |
| 2020-05-23 13:21:46 | @Robbybas @airport_girl Especially being late and you watch the sun rise over Nebraska instead of being in your hotel room in Detroit!       |               | []         |
| 2020-05-23 15:56:07 | @AriadnaSBM Gracias Ari, te quiero mucho                                                                                                     |               | []         |
|                     | Gracias por mantener la amistad, un abrazo 🥰🥰🥰🥰🥰🥰🥰                                                                                    |               |            |
| 2020-05-23 17:45:11 | Traigo puesta una playera que está llena de m*cos. Verdaderamente está cuarentena acabo con el respeto que tenía por mi imagen personal.     |               | []         |
| 2020-05-23 14:45:09 | @ToughMudder Dudes a beast, makes it look all too easy.                                                                                      |               | []         |


Table #9
Filename: source_8.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                             | coordinates   | hashtags   |
|:--------------------|:-----------------------------------------------------------------------------------------------------------------|:--------------|:-----------|
| 2020-05-21 14:06:35 | @melissa69toluca Buenisimos                                                                                      |               | []         |
| 2020-05-21 19:13:53 | @laReinaNARA_ 😦🙏                                                                                               |               | []         |
| 2020-05-21 16:11:43 | 🤩                                                                                                               |               | []         |
| 2020-05-21 18:35:15 | Oye, extrañas a @PalmerasFC_ ?                                                                                   |               | []         |
|                     |                                                                                                                  |               |            |
|                     | Yo: https://t.co/2gD0m4L5NC                                                                                      |               |            |
| 2020-05-21 15:13:24 | @Stop_Trump20 @MuffyBevin Maggie I saw this video and believe the driver was a bit over board with his response. |               | []         |
|                     | I… https://t.co/EUtHncX6sF                                                                                       |               |            |
| 2020-05-21 14:43:32 | Nota mental: Si no voy a estar en mi casita de foránea, dejarle a alguien para que pague mi agua                 |               | []         |
| 2020-05-21 16:06:56 | You asked to see the boss so they sent me dawg                                                                   |               | []         |
| 2020-05-21 14:49:12 | Eso es estar bien informado. 😷                                                                                  |               | []         |
| 2020-05-21 05:34:44 | @ContactoCitibmx @Citibanamex  por favor me URGE SU AYUDA Y ORINTACION!!!!                                       |               | []         |
| 2020-05-21 20:29:07 | Dayumm I retweeted everything 🤤                                                                                 |               | []         |


Target Schema:
| created_at          | text                                                                                                                                         | coordinates                                                | hashtags                                                                                                                                                                                                                                                                                                                                                                                                           |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:-----------------------------------------------------------|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2020-05-21 19:12:58 | #landscape #urban #urbanfotography #streetfotography #street #downtown #nightfotography #paisaje #urbano… https://t.co/0qGTKZTu4v            | {'type': 'Point', 'coordinates': [-99.122012, 19.363443]}  | [{'text': 'landscape', 'indices': [0, 10]}, {'text': 'urban', 'indices': [11, 17]}, {'text': 'urbanfotography', 'indices': [18, 34]}, {'text': 'streetfotography', 'indices': [35, 52]}, {'text': 'street', 'indices': [53, 60]}, {'text': 'downtown', 'indices': [61, 70]}, {'text': 'nightfotography', 'indices': [71, 87]}, {'text': 'paisaje', 'indices': [88, 96]}, {'text': 'urbano', 'indices': [97, 104]}] |
| 2020-05-21 16:38:48 | @MrForeverFly YESSSS.. brightens and even skin tone QUICKLY                                                                                  |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 18:14:40 | La seguridad de mi papá de enlazar su teléfono en la pantalla y ver videos de FB con mi mamá! 👌🏻👌🏻👌🏻 https://t.co/lcqE7zJb04                 |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 19:21:07 | @mailomarcos Mira vato, a mi no me vienes y me alteras así haha                                                                              |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 14:36:08 | @holaesjulia Aleluya y Gloria a Dios Padre Amado                                                                                             |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 18:21:43 | Jesus Lives, and We will Live Also: A Sermon for 6 Easter  https://t.co/1cabajDLta                                                           | {'type': 'Point', 'coordinates': [-86.2260528, 30.380972]} | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 18:29:41 | @mario_delgado @GobiernoMX Tan fácil, bajense sueldos y privilegios como hospitales particulares, desaparezcan tant… https://t.co/noKKGHspQC |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 16:32:16 | @albanilfifi @VictoriaMX 😂😂😂😂😂😂                                                                                                        |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 20:32:15 | https://t.co/gs0xm04sny                                                                                                                      |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
| 2020-05-21 19:52:46 | Así o más chafaaaaaa @infinitum                                                                                                              |                                                            | []                                                                                                                                                                                                                                                                                                                                                                                                                 |
|                     | Pésimo servicio.                                                                                                                             |                                                            |                                                                                                                                                                                                                                                                                                                                                                                                                    |

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
source_8.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
test_8.csv