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-24 22:54:55 | @sopitas @RappiMexico Donde puedo solicitar ayuda para un pedido en curso que lleva mas de 1 hr y no llega, mi rapi… https://t.co/p550f5qpT0 |               | []                                                             |
| 2020-05-25 02:49:27 | @castillo_2018 @futpicante Petroleros de Salamanca*                                                                                          |               | []                                                             |
| 2020-05-25 03:13:35 | Ur telling me I missed a Namjin live?                                                                                                        |               | []                                                             |
| 2020-05-25 00:55:42 | @ewrikk Me das?                                                                                                                              |               | []                                                             |
| 2020-05-25 02:48:00 | Hay días que me siento bonita 😎 https://t.co/a4Pq6Eo90b                                                                                     |               | []                                                             |
| 2020-05-24 22:39:14 | Que buen pedo toda la comunicación Gobierno-cuidadanos.                                                                                      |               | []                                                             |
|                     |                                                                                                                                              |               |                                                                |
|                     | Neta no entiendo por que tanto odio a la 4T? Tan bien? Ya… https://t.co/Y748p7j4rV                                                           |               |                                                                |
| 2020-05-25 03:50:38 | Im bringing back Nike headbands                                                                                                              |               | []                                                             |
| 2020-05-25 01:02:25 | Lmk why I thought Elon Musks son’s name was pronounced “Axiom” as in from WALL•E                                                             |               | []                                                             |
| 2020-05-24 23:26:55 | @SoyPatylu Noooo!!! 🤦🏻‍♂️🤦🏻‍♂️🤦🏻‍♂️                                                                                                                   |               | []                                                             |
| 2020-05-24 23:39:03 | @yeidckol @lopezobrador_ Seré breve                                                                                                          |               | [{'text': 'MORENAEsUnPeligroParaMexico', 'indices': [36, 64]}] |
|                     | #MORENAEsUnPeligroParaMexico https://t.co/3EIfNyGIAS                                                                                         |               |                                                                |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates   | hashtags                                                   |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------------------------------------------------------|
| 2020-05-23 10:37:23 | MY MENTOR!!!                                                                                                                                 |               | []                                                         |
|                     | We should all be so brave. Calling out those who blatantly dismiss the facts, misinform the public &amp; p… https://t.co/zAmnqVQJUB          |               |                                                            |
| 2020-05-23 15:52:07 | @realDonaldTrump Our new May polls are out: PENNSYLVANIA Trump 50.2% Biden 45.5% MICHIGAN Biden 50.3% Trump 41.5% W… https://t.co/Oosb0jkfrV |               | []                                                         |
| 2020-05-23 14:08:34 | @LomitoDeOro @PacoDeMiguelF Que ridiculo erres                                                                                               |               | []                                                         |
| 2020-05-23 14:54:06 | So I finally got my hands on some cheesecake stuffed strawberries! #SnobbishSweetsAndTreats 🌸 https://t.co/FixxgXAN5E                       |               | [{'text': 'SnobbishSweetsAndTreats', 'indices': [67, 91]}] |
| 2020-05-23 15:18:48 | @PokemonGoAppLA Me gusta más el bug cuando no aparece el pokemon para la captura.                                                            |               | []                                                         |
|                     | Se los dejo por si alguien no sab… https://t.co/VnDYQVQUlZ                                                                                   |               |                                                            |
| 2020-05-23 14:07:28 | During the first Apollo mission the roving vehicle was designed like a farm tractor or bogie to be driven by an ast… https://t.co/mUPSJ7RlV7 |               | []                                                         |
| 2020-05-23 16:45:38 | @yadmid19 Yo igual ya quiero que lo hagas amor, se ve súper excitante y estoy seguro que vas a gozar demasiado 😈🔥                          |               | []                                                         |
| 2020-05-23 16:36:14 | Naaaah me acabo de dar cuenta que voy a la misma veterinaria que los whitexicans de Coyoacán... Algo más que cambia… https://t.co/OIkykQoBKZ |               | []                                                         |
| 2020-05-23 12:19:05 | I feel like I’ve been over sharing on Facebook and because it’s a lot of older people, they either genuinely don’t… https://t.co/BtssITDtRN  |               | []                                                         |
| 2020-05-23 15:53:40 | así es... esta va por otro ratote 😢                                                                                                         |               | []                                                         |


Table #3
Filename: source_2.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates   | hashtags   |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------|
| 2020-05-21 19:46:35 | @portero ¿Hablas cetáceo? https://t.co/aKyVs56nn6                                                                                            |               | []         |
| 2020-05-21 19:54:54 | Jajaja                                                                                                                                       |               | []         |
| 2020-05-21 14:30:17 | De vuelta y nuestra pláticas interminables, nuestras horas de ver cine, hacernos de comer cosas ricas y su sentido… https://t.co/xDU4EeGrpx  |               | []         |
| 2020-05-21 06:04:44 | Recién leí un tweet de una chica diciendo que no estaba para estar dando terapia gratuita a su ex, y que por eso lo… https://t.co/SMGvE9rTHm |               | []         |
| 2020-05-21 18:56:56 | Hace 5 meses vi a Mario 🥺❤️                                                                                                                 |               | []         |
| 2020-05-21 19:45:36 | @DoodleNessa Yes you are                                                                                                                     |               | []         |
| 2020-05-21 18:51:17 | @stefan_lion It is aesthetically appealing                                                                                                   |               | []         |
| 2020-05-21 16:04:07 | @EMILIAMDLAP Imagino que si, el share point es a través de VPN; sin embargo, la instrucción en el órgano jurisdicci… https://t.co/RHi7Rrap1T |               | []         |
| 2020-05-21 19:15:10 | No se como sobrevivir con esto en la pastelería https://t.co/jwrGx1ux61                                                                      |               | []         |
| 2020-05-21 06:23:47 | Ah! Gracias por el dato. https://t.co/MFXLuP0znA                                                                                             |               | []         |


Table #4
Filename: source_3.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates                                           | hashtags                                                                     |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------|:-----------------------------------------------------------------------------|
| 2020-05-24 16:53:29 | @LaliPromotion @lalioficial 139                                                                                                              |                                                       | []                                                                           |
|                     | https://t.co/EFALD3HNhm                                                                                                                      |                                                       |                                                                              |
| 2020-05-24 15:52:48 | @JLozanoA Ahí está el detalle un poquito de coherencia. https://t.co/pylrNZD9pY                                                              |                                                       | []                                                                           |
| 2020-05-24 13:42:41 | @NaelReyes5 Una verga asi                                                                                                                    |                                                       | []                                                                           |
| 2020-05-24 14:17:06 | Mochi tiene cirugía temprano, no hace nada de ruido cuando se va, pero me despertó el olor a barbacoa que me trajo… https://t.co/azAkK1qQkM  |                                                       | []                                                                           |
| 2020-05-24 11:10:23 | Me tienes como loco buscándote.                                                                                                              |                                                       | []                                                                           |
| 2020-05-24 09:41:46 | El amigo solobino... #CDMX #DF en Mexico City, Mexico https://t.co/GUiDNZhI2M                                                                | {'type': 'Point', 'coordinates': [-99.1332, 19.4326]} | [{'text': 'CDMX', 'indices': [21, 26]}, {'text': 'DF', 'indices': [27, 30]}] |
| 2020-05-24 11:46:12 | Y todos los fines de semana !!                                                                                                               |                                                       | []                                                                           |
| 2020-05-24 15:32:28 | @JaniceTXBlessed Janice do not listen to these idiots...They wouldn’t know a True Christian if Paul the Apostle sma… https://t.co/8igzPf6Gc8 |                                                       | []                                                                           |
| 2020-05-24 14:46:39 | Los sucesos más importantes del deporte tienen nombre propio ... 📖                                                                          |                                                       | []                                                                           |
|                     |                                                                                                                                              |                                                       |                                                                              |
|                     | El sextete, la mano de Dios, el gol de preside… https://t.co/gyB5sSqE4x                                                                      |                                                       |                                                                              |
| 2020-05-24 17:13:27 | ❤ en Tepotzotlán https://t.co/FwoVIqI3RN                                                                                                     | {'type': 'Point', 'coordinates': [-99.2244, 19.7139]} | []                                                                           |


Table #5
Filename: source_4.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates   | hashtags                                                                                        |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:------------------------------------------------------------------------------------------------|
| 2020-05-22 01:17:03 | @danielaacallee @nathcampost Y que isistes de comer bebe y a mi me si me gusta el atún  es deli ❤😉                                          |               | []                                                                                              |
| 2020-05-22 02:39:57 | @SteelCity_Burg @NYGfan4ever OUCH... bill thinks that’s what I have                                                                          |               | []                                                                                              |
| 2020-05-22 01:26:13 | They think we not good enough 😂😂                                                                                                           |               | []                                                                                              |
| 2020-05-21 23:17:25 | Estoy a dos de una buena infección en mi hermoso ojo derecho.                                                                                |               | []                                                                                              |
| 2020-05-22 01:33:30 | La más parecida a mi. Coicidimos tanto que nos aburrimos, nos quisimos tanto que fingimos no existía. Luchamos tant… https://t.co/v566bHjArL |               | []                                                                                              |
| 2020-05-22 00:56:30 | @Notorious_BSW Gov DeSantis the real MVP                                                                                                     |               | []                                                                                              |
| 2020-05-22 01:04:42 | Esta soy yo con mi té de 12 flores.                                                                                                          |               | []                                                                                              |
| 2020-05-22 02:56:14 | @jazz_garcia Preferiría esa cruda que la cruda realidad sin alcohol                                                                          |               | []                                                                                              |
| 2020-05-22 01:14:37 | Con vale... madres 😂😂😂                                                                                                                    |               | []                                                                                              |
| 2020-05-21 23:29:33 | .#NoQueremosMásMentiras, México es el país de la OCDE que menos pruebas de #Covid-19 hace, ¿cómo podemos estar segu… https://t.co/QUbvEy2pxk |               | [{'text': 'NoQueremosMásMentiras', 'indices': [1, 23]}, {'text': 'Covid', 'indices': [75, 81]}] |


Table #6
Filename: source_5.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                   | coordinates   | hashtags   |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------|:--------------|:-----------|
| 2020-05-22 12:22:49 | "La costa de la Antártida "se pinta de verde" por el cambio climático ❄️"  https://t.co/R62WaqaBaa                                     |               | []         |
| 2020-05-22 13:45:08 | @trinidadclara Hola...                                                                                                                 |               | []         |
|                     | Excelente Viernes 🌹 https://t.co/1OYwkNvvC9                                                                                           |               |            |
| 2020-05-22 17:04:47 | You’re telling me this isn’t Fred Armisen?                                                                                             |               | []         |
| 2020-05-22 14:31:47 | @dgzurita En efecto, gracias diputada por el apunte. Saludos                                                                           |               | []         |
| 2020-05-22 15:40:26 | @whoisaddison You too                                                                                                                  |               | []         |
| 2020-05-22 12:15:06 | 🍁👽 https://t.co/5N1nQ9Uun9                                                                                                           |               | []         |
| 2020-05-22 14:44:28 | @ESPNmx Cabañas sin duda                                                                                                               |               | []         |
| 2020-05-22 15:20:37 | Blessed by @1GunnaGunna                                                                                                                |               | []         |
| 2020-05-22 16:43:04 | @conchalechicaa jajajaja igual lo haras Eleyna aceptalo, aún recuerdo como si fuera ayer el pobre Volkswagen, como lo esfarataste vale |               | []         |
| 2020-05-22 13:31:10 | @karoflorestic @Splendor_Veri @jrisco jajaja entre bots y trolles se apoyan? Bien eh 👍🏻                                                |               | []         |


Table #7
Filename: source_6.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates                                             | hashtags                                       |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------------------|:-----------------------------------------------|
| 2020-05-21 01:34:43 | #EDEPQ2020AE5 https://t.co/SLUugxEuj3                                                                                                        |                                                         | [{'text': 'EDEPQ2020AE5', 'indices': [0, 13]}] |
| 2020-05-21 00:03:49 | @FherPrMtz @fenixazul44 @julioccontreras @Pericos_Oficial @asbfoto Podrá haber mamitas, foxies y 40° pero el que no… https://t.co/AEG9e1c3dI |                                                         | []                                             |
| 2020-05-20 22:15:28 | @fitoMD Es mi amiga, salúdamela                                                                                                              |                                                         | []                                             |
| 2020-05-20 22:15:12 | @jokerobrador claro qué si millones dé gentes la apoyamos..es una lástima qué pongan en riesgo su vida.                                      |                                                         | []                                             |
| 2020-05-20 20:40:19 | @karlita_linda0 Tienes videitos,🤤🤤                                                                                                         |                                                         | []                                             |
| 2020-05-20 23:28:42 | @pedroferriz3 Si perdiste la dignidad...qué más puedes perder                                                                                |                                                         | []                                             |
| 2020-05-21 00:22:14 | Se hablan más de cinco casos dentro de @ClubSantos y aunque se diga que son asintomáticos, es una razón más de peso… https://t.co/V4JDbVjCRC |                                                         | []                                             |
| 2020-05-20 22:33:33 | Care for yourself 99% the other 1% are the germs that the sanitizer couldn’t get                                                             |                                                         | []                                             |
| 2020-05-20 21:01:45 | Descripción del perfil del Presidente @lopezobrador_ : por una ex simpatizante.                                                              |                                                         | []                                             |
| 2020-05-20 22:59:22 | My feed is becoming an ad for @buff_usa . Still #lovebugfree. @ Courtney Campbell Trail https://t.co/mH5EjBVe7m                              | {'type': 'Point', 'coordinates': [-82.57973, 27.96868]} | [{'text': 'lovebugfree', 'indices': [48, 60]}] |


Table #8
Filename: source_7.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates                                           | hashtags                                                                                                                                  |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:------------------------------------------------------|:------------------------------------------------------------------------------------------------------------------------------------------|
| 2020-05-24 01:42:36 | @z7marie Ojala que ningún familiar o tu necesiten servicios médicos, pq ni con tu tarjeta te alcanzará para. Mejorales.                      |                                                       | []                                                                                                                                        |
| 2020-05-24 04:53:38 | @BarbyVillela Descansa :v https://t.co/6UswGlm6ZY                                                                                            |                                                       | []                                                                                                                                        |
| 2020-05-24 02:45:39 | My mama said “judge a man not by his actions, but by his reactions. Actions are planned, but reactions are instinct.”                        |                                                       | []                                                                                                                                        |
|                     | ...                                                                                                                                          |                                                       |                                                                                                                                           |
|                     | And I felt that.                                                                                                                             |                                                       |                                                                                                                                           |
| 2020-05-24 01:34:37 | Soy el alce.  Je. Q tal mi chika es del 2012 https://t.co/HVG5wEo5d8                                                                         |                                                       | []                                                                                                                                        |
| 2020-05-24 04:09:33 | I love heeeeeer 💚💕 eveeeer!                                                                                                                |                                                       | []                                                                                                                                        |
| 2020-05-24 04:57:59 | @MagallaesMaria Hágalo                                                                                                                       |                                                       | []                                                                                                                                        |
| 2020-05-23 23:57:53 | @Radio_Formula Otra vez la realeza Derbez @vadhirderbez pues que hijo si fue deseado? O mujer? Digo fue un parásito… https://t.co/NbyapLWxH8 |                                                       | []                                                                                                                                        |
| 2020-05-24 03:53:33 | @emiry_junkiie Creo más bien, así como con muchos hombres, si nos gusta una la volvemos a comprar igual...                                   |                                                       | []                                                                                                                                        |
| 2020-05-24 00:15:17 | @Aveefeniix @VigilantesV @CONSUMEAZUCAR @Faby_Nava77 😰😰                                                                                    |                                                       | []                                                                                                                                        |
| 2020-05-24 04:03:37 | Llevate las empanadas congeladas, listas para freír. Pedidos al 2221331868. #momentospiantaos #puebla #cholula… https://t.co/5i68cTsBqU      | {'type': 'Point', 'coordinates': [-98.2064, 19.0483]} | [{'text': 'momentospiantaos', 'indices': [76, 93]}, {'text': 'puebla', 'indices': [94, 101]}, {'text': 'cholula', 'indices': [102, 110]}] |


Table #9
Filename: source_8.csv
Sample Rows in Markdown:
| created_at          | text                                                                                                                                         | coordinates   | hashtags                                    |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------|:--------------------------------------------|
| 2020-05-22 23:01:51 | https://t.co/Aewq1sDdkw                                                                                                                      |               | []                                          |
| 2020-05-22 20:46:02 | Tomandole una foto a #Melmetal como que no se da cuenta @PokemonGoAppLA @pokemongo https://t.co/FEeYms06AE                                   |               | [{'text': 'Melmetal', 'indices': [21, 30]}] |
| 2020-05-22 21:58:31 | Pecado mortal 😰                                                                                                                             |               | []                                          |
| 2020-05-22 19:10:46 | @Eames_R @Uber_MEX Un reencuadre de afán no nos vendría mal.                                                                                 |               | []                                          |
| 2020-05-22 20:40:46 | Si ahora quieres fuego, te dejo con tu incendio                                                                                              |               | []                                          |
| 2020-05-22 23:47:39 | @mellamodisgusto @Martnbadillo2 @Missciencias @ricardolamadri3 @ramos_pakko @SergioSarmiento El grado deseado de in… https://t.co/4GQ4DH7UpQ |               | []                                          |
| 2020-05-22 18:16:54 | Feliz cumpleaños 93 @CruzAzulCD                                                                                                              |               | []                                          |
|                     |                                                                                                                                              |               |                                             |
|                     | 🧂Otra vez terminan el torneo de super líder                                                                                                 |               |                                             |
|                     | 🧂Cancelan el torneo sin campeón                                                                                                             |               |                                             |
|                     | 🧂Este… https://t.co/xXDxCbwZQB                                                                                                              |               |                                             |
| 2020-05-22 20:00:40 | @Lolirotve Que lindo~                                                                                                                        |               | []                                          |
| 2020-05-22 22:57:50 | @ChemoPonce @vissaeusmorenae Así somos, como nuestro presidente. Felicidades                                                                 |               | []                                          |
| 2020-05-22 18:43:40 | @Rogeliuss 😂                                                                                                                                |               | []                                          |


Target Schema:
| created_at          | text                                                                                                                                         | coordinates                                                   | hashtags                                                                                                                                                                     |
|:--------------------|:---------------------------------------------------------------------------------------------------------------------------------------------|:--------------------------------------------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 2020-05-21 19:57:25 | Severe Thunderstorm Warning including Immokalee FL, Clewiston FL, LaBelle FL until 5:00 PM EDT https://t.co/Ni52AAvAOn                       | {'type': 'Point', 'coordinates': [-81.22330289, 26.50451207]} | []                                                                                                                                                                           |
| 2020-05-21 20:48:41 | https://t.co/JvrWgw5XoV                                                                                                                      |                                                               | []                                                                                                                                                                           |
| 2020-05-21 19:51:28 | @abriljrzrs Me da pena 🥺🥺🥺                                                                                                                |                                                               | []                                                                                                                                                                           |
| 2020-05-21 18:37:37 | La canción de Ellie Goulding que interpola Be The One, el álbum PERFECTO de Charli XCX, las disco sessions de Sophi… https://t.co/PlF1bedDZT |                                                               | []                                                                                                                                                                           |
| 2020-05-21 20:22:38 | Verga, como en películas!                                                                                                                    |                                                               | []                                                                                                                                                                           |
| 2020-05-21 19:34:28 | Mi voto es para Jazmín Serrano #ruda gana sin durar a dudas                                                                                  |                                                               | [{'text': 'ruda', 'indices': [31, 36]}, {'text': 'Reactorneo', 'indices': [60, 71]}, {'text': 'ReactorEnCasa', 'indices': [72, 86]}, {'text': 'RICA', 'indices': [99, 104]}] |
|                     | #Reactorneo                                                                                                                                  |                                                               |                                                                                                                                                                              |
|                     | #ReactorEnCasa                                                                                                                               |                                                               |                                                                                                                                                                              |
|                     | @Reactor105                                                                                                                                  |                                                               |                                                                                                                                                                              |
|                     | #RICA                                                                                                                                        |                                                               |                                                                                                                                                                              |
|                     | @claudifonos                                                                                                                                 |                                                               |                                                                                                                                                                              |
| 2020-05-21 16:23:43 | I saw this pic on FB this morning! I’m sending this out to all the ladies who share Mag Birthdays with me! I just l… https://t.co/Q66zDTo7nc |                                                               | []                                                                                                                                                                           |
| 2020-05-21 14:00:47 | @AmyAthatcher @doxie53 @Shannadelic @Mackaveli8 @Crashingmoonxo @lmakowski3 @sonya_gault @customcore7 @ATrumpest… https://t.co/58rguPlKEU    |                                                               | []                                                                                                                                                                           |
| 2020-05-21 14:37:57 | @oso_metalero Prefieren que nos chinguemos el espacio verde que dejamos despues de la enorme devastacion que hicimo… https://t.co/IxXSUlGOnR |                                                               | []                                                                                                                                                                           |
| 2020-05-21 14:19:04 | @LaSiempreLinda Beautiful eyes!                                                                                                              |                                                               | []                                                                                                                                                                           |

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