Task: Data-transform-pbe (source dataset: TDE)

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                  |
|:-----------------------|
| hxf                    |
| vbproj                 |
| c                      |
| mod                    |
| cod                    |
| safariextz             |
| searchConnector-ms     |
| csh                    |
| x                      |
| hhk                    |
| m2v                    |
| crd                    |
| s                      |
| jpg                    |
| gsm                    |
| hxr                    |
| fsscript               |
| aca                    |
| crt                    |
| pko                    |
| mht                    |
| hxt                    |
| AAC                    |
| inl                    |
| mpv2                   |
| hxw                    |
| pnt                    |
| tsv                    |
| cxx                    |
| spc                    |
| mso                    |
| xdr                    |
| vsmdi                  |
| coverage               |
| xrm-ms                 |
| u32                    |
| aiff                   |
| lsx                    |
| msi                    |
| csv                    |
| xss                    |
| asf                    |
| xlk                    |
| m3u8                   |
| 3gp2                   |
| h                      |
| vsto                   |
| lst                    |
| hhp                    |
| ocx                    |
| vtx                    |
| xhtml                  |
| vbdproj                |
| xla                    |
| xbap                   |
| smz                    |
| vdx                    |
| mdp                    |
| man                    |
| p10                    |
| wdb                    |
| slk                    |
| pct                    |
| css                    |
| mak                    |
| xpm                    |
| idl                    |
| eml                    |
| contact                |
| xsc                    |
| pntg                   |
| cs                     |
| ac3                    |
| dsw                    |
| mpeg                   |
| tif                    |
| dlm                    |
| xap                    |
| dcr                    |
| csproj                 |
| mde                    |
| flv                    |
| lsf                    |
| crl                    |
| skin                   |
| wmx                    |
| pfm                    |
| pnm                    |
| ods                    |
| inf                    |
| cpp                    |
| master                 |
| vssettings             |
| mp2                    |
| cmx                    |
| vcf                    |
| cdf                    |
| rpm                    |
| wcm                    |
| docx                   |
| datasource             |
| pot                    |
| wave                   |
| application            |
| xtp                    |
| sdp                    |
| 3g2                    |
| accda                  |
| ruleset                |
| adobebridge            |
| sea                    |
| rtx                    |
| ipsw                   |
| dbproj                 |
| ite                    |
| hqx                    |
| latex                  |
| xslt                   |
| htt                    |
| odh                    |
| isp                    |
| accft                  |
| movie                  |
| wlpginstall            |
| thmx                   |
| jck                    |
| m4b                    |
| accdr                  |
| xsl                    |
| bmp                    |
| qt                     |
| asx                    |
| der                    |
| srf                    |
| mno                    |
| wm                     |
| zip                    |
| wbmp                   |
| scd                    |
| sldm                   |
| ppm                    |
| resx                   |
| psess                  |
| wav                    |
| src                    |
| cnf                    |
| onepkg                 |
| hxc                    |
| itpc                   |
| xaf                    |
| hta                    |
| exe                    |
| snp                    |
| WLMP                   |
| mmf                    |
| roff                   |
| qxd                    |
| setreg                 |
| pmr                    |
| wrz                    |
| sldx                   |
| nc                     |
| hdf                    |
| png                    |
| smd                    |
| vddproj                |
| acx                    |
| SSISDeploymentManifest |
| cab                    |
| tts                    |
| p12                    |
| ustar                  |
| qht                    |
| vcxproj                |
| wml                    |
| lpk                    |
| ADTS                   |
| setpay                 |
| pcz                    |
| wmlc                   |
| asm                    |
| rct                    |
| mpa                    |
| jnlp                   |
| ppt                    |
| pps                    |
| hxa                    |
| fdf                    |
| pcast                  |
| sgimb                  |
| iii                    |
| air                    |
| dvi                    |
| xlm                    |
| ief                    |
| nsc                    |
| pnz                    |
| caf                    |
| odl                    |
| ADT                    |
| accdw                  |
| xof                    |
| class                  |
| xll                    |
| onetoc                 |
| xml                    |
| oda                    |
| vsct                   |
| vsi                    |
| dgml                   |
| ipg                    |
| slupkg-ms              |
| deploy                 |
| adp                    |
| onetoc2                |
| pkgundef               |
| mvb                    |
| aa                     |
| dxr                    |
| asr                    |
| mov                    |
| pptx                   |
| tr                     |
| accdt                  |
| au                     |
| rar                    |
| testrunconfig          |
| 3gpp                   |
| rmi                    |
| tiff                   |
| cc                     |
| jpb                    |
| ppsx                   |
| xltm                   |
| dtd                    |
| wri                    |
| pls                    |
| aifc                   |
| xbm                    |
| m4v                    |
| wvx                    |
| afm                    |
| aaf                    |
| ipproj                 |
| axs                    |
| dsp                    |
| manifest               |
| ascx                   |
| hxe                    |
| mfp                    |
| xls                    |
| emz                    |
| testsettings           |
| dwf                    |
| wks                    |
| jsxbin                 |
| inc                    |
| tlh                    |
| pdf                    |
| jfif                   |
| trx                    |
| clp                    |
| xlt                    |
| hxx                    |
| odt                    |
| user                   |
| jcz                    |
| html                   |
| sor                    |
| tgz                    |
| tcl                    |
| osdx                   |
| docm                   |
| vspscc                 |
| cpio                   |
| rgs                    |
| xlsx                   |
| eot                    |
| pptm                   |
| ra                     |

Output Table:
| Input                  | Output                                                                    |
|:-----------------------|:--------------------------------------------------------------------------|
| hxf                    | application/xml                                                           |
| vbproj                 | text/plain                                                                |
| c                      | text/plain                                                                |
| mod                    | video/mpeg                                                                |
| cod                    | image/cis-cod                                                             |
| safariextz             | application/x-safari-safariextz                                           |
| searchConnector-ms     | application/windows-search-connector+xml                                  |
| csh                    | application/x-csh                                                         |
| x                      | application/directx                                                       |
| hhk                    | application/octet-stream                                                  |
| m2v                    | video/mpeg                                                                |
| crd                    | application/x-mscardfile                                                  |
| s                      | text/plain                                                                |
| jpg                    | image/jpeg                                                                |
| gsm                    | audio/x-gsm                                                               |
| hxr                    | application/octet-stream                                                  |
| fsscript               | application/fsharp-script                                                 |
| aca                    | application/octet-stream                                                  |
| crt                    | application/x-x509-ca-cert                                                |
| pko                    | application/vnd.ms-pki.pko                                                |
| mht                    | message/rfc822                                                            |
| hxt                    | text/html                                                                 |
| AAC                    | audio/aac                                                                 |
| inl                    | text/plain                                                                |
| mpv2                   | video/mpeg                                                                |
| hxw                    | application/octet-stream                                                  |
| pnt                    | image/x-macpaint                                                          |
| tsv                    | text/tab-separated-values                                                 |
| cxx                    | text/plain                                                                |
| spc                    | application/x-pkcs7-certificates                                          |
| mso                    | application/octet-stream                                                  |
| xdr                    | text/plain                                                                |
| vsmdi                  | application/xml                                                           |
| coverage               | application/xml                                                           |
| xrm-ms                 | text/xml                                                                  |
| u32                    | application/octet-stream                                                  |
| aiff                   | audio/aiff                                                                |
| lsx                    | video/x-la-asf                                                            |
| msi                    | application/octet-stream                                                  |
| csv                    | text/csv                                                                  |
| xss                    | application/xml                                                           |
| asf                    | video/x-ms-asf                                                            |
| xlk                    | application/vnd.ms-excel                                                  |
| m3u8                   | audio/x-mpegurl                                                           |
| 3gp2                   | video/3gpp2                                                               |
| h                      | text/plain                                                                |
| vsto                   | application/x-ms-vsto                                                     |
| lst                    | text/plain                                                                |
| hhp                    | application/octet-stream                                                  |
| ocx                    | application/octet-stream                                                  |
| vtx                    | application/vnd.visio                                                     |
| xhtml                  | application/xhtml+xml                                                     |
| vbdproj                | text/plain                                                                |
| xla                    | application/vnd.ms-excel                                                  |
| xbap                   | application/x-ms-xbap                                                     |
| smz                    | audio/x-smd                                                               |
| vdx                    | application/vnd.ms-visio.viewer                                           |
| mdp                    | application/octet-stream                                                  |
| man                    | application/x-troff-man                                                   |
| p10                    | application/pkcs10                                                        |
| wdb                    | application/vnd.ms-works                                                  |
| slk                    | application/vnd.ms-excel                                                  |
| pct                    | image/pict                                                                |
| css                    | text/css                                                                  |
| mak                    | text/plain                                                                |
| xpm                    | image/x-xpixmap                                                           |
| idl                    | text/plain                                                                |
| eml                    | message/rfc822                                                            |
| contact                | text/x-ms-contact                                                         |
| xsc                    | application/xml                                                           |
| pntg                   | image/x-macpaint                                                          |
| cs                     | text/plain                                                                |
| ac3                    | audio/ac3                                                                 |
| dsw                    | text/plain                                                                |
| mpeg                   | video/mpeg                                                                |
| tif                    | image/tiff                                                                |
| dlm                    | text/dlm                                                                  |
| xap                    | application/x-silverlight-app                                             |
| dcr                    | application/x-director                                                    |
| csproj                 | text/plain                                                                |
| mde                    | application/msaccess                                                      |
| flv                    | video/x-flv                                                               |
| lsf                    | video/x-la-asf                                                            |
| crl                    | application/pkix-crl                                                      |
| skin                   | application/xml                                                           |
| wmx                    | video/x-ms-wmx                                                            |
| pfm                    | application/octet-stream                                                  |
| pnm                    | image/x-portable-anymap                                                   |
| ods                    | application/oleobject                                                     |
| inf                    | application/octet-stream                                                  |
| cpp                    | text/plain                                                                |
| master                 | application/xml                                                           |
| vssettings             | text/xml                                                                  |
| mp2                    | video/mpeg                                                                |
| cmx                    | image/x-cmx                                                               |
| vcf                    | text/x-vcard                                                              |
| cdf                    | application/x-cdf                                                         |
| rpm                    | audio/x-pn-realaudio-plugin                                               |
| wcm                    | application/vnd.ms-works                                                  |
| docx                   | application/vnd.openxmlformats-officedocument.wordprocessingml.document   |
| datasource             | application/xml                                                           |
| pot                    | application/vnd.ms-powerpoint                                             |
| wave                   | audio/wav                                                                 |
| application            | application/x-ms-application                                              |
| xtp                    | application/octet-stream                                                  |
| sdp                    | application/sdp                                                           |
| 3g2                    | video/3gpp2                                                               |
| accda                  | application/msaccess.addin                                                |
| ruleset                | application/xml                                                           |
| adobebridge            | application/x-bridge-url                                                  |
| sea                    | application/octet-stream                                                  |
| rtx                    | text/richtext                                                             |
| ipsw                   | application/x-itunes-ipsw                                                 |
| dbproj                 | text/plain                                                                |
| ite                    | application/x-itunes-ite                                                  |
| hqx                    | application/mac-binhex40                                                  |
| latex                  | application/x-latex                                                       |
| xslt                   | text/xml                                                                  |
| htt                    | text/webviewhtml                                                          |
| odh                    | text/plain                                                                |
| isp                    | application/x-internet-signup                                             |
| accft                  | application/msaccess.ftemplate                                            |
| movie                  | video/x-sgi-movie                                                         |
| wlpginstall            | application/x-wlpg-detect                                                 |
| thmx                   | application/vnd.ms-officetheme                                            |
| jck                    | application/liquidmotion                                                  |
| m4b                    | audio/m4b                                                                 |
| accdr                  | application/msaccess.runtime                                              |
| xsl                    | text/xml                                                                  |
| bmp                    | image/bmp                                                                 |
| qt                     | video/quicktime                                                           |
| asx                    | video/x-ms-asf                                                            |
| der                    | application/x-x509-ca-cert                                                |
| srf                    | text/plain                                                                |
| mno                    | text/xml                                                                  |
| wm                     | video/x-ms-wm                                                             |
| zip                    | application/x-zip-compressed                                              |
| wbmp                   | image/vnd.wap.wbmp                                                        |
| scd                    | application/x-msschedule                                                  |
| sldm                   | application/vnd.ms-powerpoint.slide.macroEnabled.12                       |
| ppm                    | image/x-portable-pixmap                                                   |
| resx                   | application/xml                                                           |
| psess                  | application/xml                                                           |
| wav                    | audio/wav                                                                 |
| src                    | application/x-wais-source                                                 |
| cnf                    | text/plain                                                                |
| onepkg                 | application/onenote                                                       |
| hxc                    | application/xml                                                           |
| itpc                   | application/x-itunes-itpc                                                 |
| xaf                    | x-world/x-vrml                                                            |
| hta                    | application/hta                                                           |
| exe                    | application/octet-stream                                                  |
| snp                    | application/octet-stream                                                  |
| WLMP                   | application/wlmoviemaker                                                  |
| mmf                    | application/x-smaf                                                        |
| roff                   | application/x-troff                                                       |
| qxd                    | application/octet-stream                                                  |
| setreg                 | application/set-registration-initiation                                   |
| pmr                    | application/x-perfmon                                                     |
| wrz                    | x-world/x-vrml                                                            |
| sldx                   | application/vnd.openxmlformats-officedocument.presentationml.slide        |
| nc                     | application/x-netcdf                                                      |
| hdf                    | application/x-hdf                                                         |
| png                    | image/png                                                                 |
| smd                    | audio/x-smd                                                               |
| vddproj                | text/plain                                                                |
| acx                    | application/internet-property-stream                                      |
| SSISDeploymentManifest | text/xml                                                                  |
| cab                    | application/octet-stream                                                  |
| tts                    | video/vnd.dlna.mpeg-tts                                                   |
| p12                    | application/x-pkcs12                                                      |
| ustar                  | application/x-ustar                                                       |
| qht                    | text/x-html-insertion                                                     |
| vcxproj                | Application/xml                                                           |
| wml                    | text/vnd.wap.wml                                                          |
| lpk                    | application/octet-stream                                                  |
| ADTS                   | audio/aac                                                                 |
| setpay                 | application/set-payment-initiation                                        |
| pcz                    | application/octet-stream                                                  |
| wmlc                   | application/vnd.wap.wmlc                                                  |
| asm                    | text/plain                                                                |
| rct                    | text/plain                                                                |
| mpa                    | video/mpeg                                                                |
| jnlp                   | application/x-java-jnlp-file                                              |
| ppt                    | application/vnd.ms-powerpoint                                             |
| pps                    | application/vnd.ms-powerpoint                                             |
| hxa                    | application/xml                                                           |
| fdf                    | application/vnd.fdf                                                       |
| pcast                  | application/x-podcast                                                     |
| sgimb                  | application/x-sgimb                                                       |
| iii                    | application/x-iphone                                                      |
| air                    | application/vnd.adobe.air-application-installer-package+zip               |
| dvi                    | application/x-dvi                                                         |
| xlm                    | application/vnd.ms-excel                                                  |
| ief                    | image/ief                                                                 |
| nsc                    | video/x-ms-asf                                                            |
| pnz                    | image/png                                                                 |
| caf                    | audio/x-caf                                                               |
| odl                    | text/plain                                                                |
| ADT                    | audio/vnd.dlna.adts                                                       |
| accdw                  | application/msaccess.webapplication                                       |
| xof                    | x-world/x-vrml                                                            |
| class                  | application/x-java-applet                                                 |
| xll                    | application/vnd.ms-excel                                                  |
| onetoc                 | application/onenote                                                       |
| xml                    | text/xml                                                                  |
| oda                    | application/oda                                                           |
| vsct                   | text/xml                                                                  |
| vsi                    | application/ms-vsi                                                        |
| dgml                   | application/xml                                                           |
| ipg                    | application/x-itunes-ipg                                                  |
| slupkg-ms              | application/x-ms-license                                                  |
| deploy                 | application/octet-stream                                                  |
| adp                    | application/msaccess                                                      |
| onetoc2                | application/onenote                                                       |
| pkgundef               | text/plain                                                                |
| mvb                    | application/x-msmediaview                                                 |
| aa                     | audio/audible                                                             |
| dxr                    | application/x-director                                                    |
| asr                    | video/x-ms-asf                                                            |
| mov                    | video/quicktime                                                           |
| pptx                   | application/vnd.openxmlformats-officedocument.presentationml.presentation |
| tr                     | application/x-troff                                                       |
| accdt                  | application/msaccess                                                      |
| au                     | audio/basic                                                               |
| rar                    | application/octet-stream                                                  |
| testrunconfig          | application/xml                                                           |
| 3gpp                   | video/3gpp                                                                |
| rmi                    | audio/mid                                                                 |
| tiff                   | image/tiff                                                                |
| cc                     | text/plain                                                                |
| jpb                    | application/octet-stream                                                  |
| ppsx                   | application/vnd.openxmlformats-officedocument.presentationml.slideshow    |
| xltm                   | application/vnd.ms-excel.template.macroEnabled.12                         |
| dtd                    | text/xml                                                                  |
| wri                    | application/x-mswrite                                                     |
| pls                    | audio/scpls                                                               |
| aifc                   | audio/aiff                                                                |
| xbm                    | image/x-xbitmap                                                           |
| m4v                    | video/x-m4v                                                               |
| wvx                    | video/x-ms-wvx                                                            |
| afm                    | application/octet-stream                                                  |
| aaf                    | application/octet-stream                                                  |
| ipproj                 | text/plain                                                                |
| axs                    | application/olescript                                                     |
| dsp                    | application/octet-stream                                                  |
| manifest               | application/x-ms-manifest                                                 |
| ascx                   | application/xml                                                           |
| hxe                    | application/xml                                                           |
| mfp                    | application/x-shockwave-flash                                             |
| xls                    | application/vnd.ms-excel                                                  |
| emz                    | application/octet-stream                                                  |
| testsettings           | application/xml                                                           |
| dwf                    | drawing/x-dwf                                                             |
| wks                    | application/vnd.ms-works                                                  |
| jsxbin                 | text/plain                                                                |
| inc                    | text/plain                                                                |
| tlh                    | text/plain                                                                |
| pdf                    | application/pdf                                                           |
| jfif                   | image/pjpeg                                                               |
| trx                    | application/xml                                                           |
| clp                    | application/x-msclip                                                      |
| xlt                    | application/vnd.ms-excel                                                  |
| hxx                    | text/plain                                                                |
| odt                    | application/vnd.oasis.opendocument.text                                   |
| user                   | text/plain                                                                |
| jcz                    | application/liquidmotion                                                  |
| html                   | text/html                                                                 |
| sor                    | text/plain                                                                |
| tgz                    | application/x-compressed                                                  |
| tcl                    | application/x-tcl                                                         |
| osdx                   | application/opensearchdescription+xml                                     |
| docm                   | application/vnd.ms-word.document.macroEnabled.12                          |
| vspscc                 | text/plain                                                                |
| cpio                   | application/x-cpio                                                        |
| rgs                    | text/plain                                                                |
| xlsx                   | application/vnd.openxmlformats-officedocument.spreadsheetml.sheet         |
| eot                    | application/octet-stream                                                  |
| pptm                   | application/vnd.ms-powerpoint.presentation.macroEnabled.12                |
| ra                     | audio/x-pn-realaudio                                                      |



filename: Transform-Data-by-Example/Benchmark/benchmark-stackoverflow/9.txt
instruction: //Get MIME type from filename extension
example_input: example_input.csv
example_output: example_output.csv
test_input: test_input.csv
test_output: test_output.csv