Task: Data-transform-pbe (source dataset: Transformation-text)

You are given a input table where each row is an input record, and an output table that contains one additional column, called "Output", whose values in each row can be produced by transforming values of the same row in the input table. Your task is to write the corresponding code that can perform such transformations, based on the given input-output examples. Make sure that the transformations you write can generalize to additional input examples not shown in the input table.

Implementation Details:
1. Generate Python code using the Pandas library to perform the transformation.
2. The code should read the input table from "input.csv".
3. Apply the transformation based on the observed pattern.
4. Save the transformed output to "output.csv".
5. Ensure that the output structure matches the expected format, including column names and data types.

Your task is to ensure that the Python script is correctly formatted, efficient, and ready for execution on any dataset following the same transformation pattern.

No explanation and return the Python code in a markdown code block: ```python
<PYTHON-CODE>
```.

Input Table:
| Input                                                                                                 |
|:------------------------------------------------------------------------------------------------------|
| Ryuu Isabekuly                 90 Redwood Pl NE ,Lusaka,MO,(775) 214-4307,(252) 024-3531,03719        |
| Aminata Salazar                 789 Maple Ln SE,Barcelona,CO,(790) 197-2482,(152) 647-4104,38891      |
| Marina Cheburko                 3456 Sixth St NE,Joliet,ID,(111) 578-2402,(436) 471-1157,17293        |
| Kahsay Oblak                 34 Main St NE,Inglewood,ME,(656) 574-9641,(068) 498-3103,03719           |
| Semyon Rajput                 2345 Apple Pl SW,Clinton,NM,(069) 851-0563,(837) 585-5165,17293         |
| Antoinette Jovovic                 5678 Eighth Ct NE ,Honolulu,MT,(741) 418-5760,(549) 112-6722,03719 |
| Shir Meyerson                 34 Second Pkwy SE ,Hiroshima,SD,(137) 303-6977,(582) 275-6191,58712     |
| Hone Mukasine                 456 Fifth Rd SW,Caracas,IN,(464) 908-9638,(890) 659-6501,38891          |
| Grigorijs Svensli                 67 Birch Way NW,Shijiazhuang,CO,(971) 705-6809,(903) 005-8751,38891 |
| Ilija Blazkova                 567 First Pkwy NW,Charlotte,NE,(849) 485-7295,(905) 194-4906,17293     |
| Amal Sahin                 234 Redwood Hwy SE ,London,VT,(626) 679-0552,(010) 725-5679,58712          |
| Jozef Kim                 56 Seventh Rd SE ,Rockford,SC,(116) 658-8235,(605) 914-0190,17293           |
| Ayna Ibrahim                 67 12th Rte NE ,Irving,WA,(931) 606-7330,(654) 401-3149,58712            |
| Haf Shchur                 1234 First Ave NW,Corona,CT,(297) 341-2476,(418) 878-6628,58712            |
| Ivana Mattsson                 23 Seventh Blvd SW ,Macon,MD,(916) 686-5116,(295) 028-5659,03719       |

Output Table:
| Input                                                                                                 | Output             |
|:------------------------------------------------------------------------------------------------------|:-------------------|
| Ryuu Isabekuly                 90 Redwood Pl NE ,Lusaka,MO,(775) 214-4307,(252) 024-3531,03719        | 90 Redwood Pl NE   |
| Aminata Salazar                 789 Maple Ln SE,Barcelona,CO,(790) 197-2482,(152) 647-4104,38891      | 789 Maple Ln SE    |
| Marina Cheburko                 3456 Sixth St NE,Joliet,ID,(111) 578-2402,(436) 471-1157,17293        | 3456 Sixth St NE   |
| Kahsay Oblak                 34 Main St NE,Inglewood,ME,(656) 574-9641,(068) 498-3103,03719           | 34 Main St NE      |
| Semyon Rajput                 2345 Apple Pl SW,Clinton,NM,(069) 851-0563,(837) 585-5165,17293         | 2345 Apple Pl SW   |
| Antoinette Jovovic                 5678 Eighth Ct NE ,Honolulu,MT,(741) 418-5760,(549) 112-6722,03719 | 5678 Eighth Ct NE  |
| Shir Meyerson                 34 Second Pkwy SE ,Hiroshima,SD,(137) 303-6977,(582) 275-6191,58712     | 34 Second Pkwy SE  |
| Hone Mukasine                 456 Fifth Rd SW,Caracas,IN,(464) 908-9638,(890) 659-6501,38891          | 456 Fifth Rd SW    |
| Grigorijs Svensli                 67 Birch Way NW,Shijiazhuang,CO,(971) 705-6809,(903) 005-8751,38891 | 67 Birch Way NW    |
| Ilija Blazkova                 567 First Pkwy NW,Charlotte,NE,(849) 485-7295,(905) 194-4906,17293     | 567 First Pkwy NW  |
| Amal Sahin                 234 Redwood Hwy SE ,London,VT,(626) 679-0552,(010) 725-5679,58712          | 234 Redwood Hwy SE |
| Jozef Kim                 56 Seventh Rd SE ,Rockford,SC,(116) 658-8235,(605) 914-0190,17293           | 56 Seventh Rd SE   |
| Ayna Ibrahim                 67 12th Rte NE ,Irving,WA,(931) 606-7330,(654) 401-3149,58712            | 67 12th Rte NE     |
| Haf Shchur                 1234 First Ave NW,Corona,CT,(297) 341-2476,(418) 878-6628,58712            | 1234 First Ave NW  |
| Ivana Mattsson                 23 Seventh Blvd SW ,Macon,MD,(916) 686-5116,(295) 028-5659,03719       | 23 Seventh Blvd SW |



filename: Address.000014
instruction: Substring
example_input: example_input.csv
example_output: example_output.csv
test_input: test_input.csv
test_output: test_output.csv