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:
| title                                 | company                      | location            | summary                                                                                                                                                             |   salary | href                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           |   rate | reviews   | org_salary_period   |
|:--------------------------------------|:-----------------------------|:--------------------|:--------------------------------------------------------------------------------------------------------------------------------------------------------------------|---------:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------:|:----------|:--------------------|
| Data Scientist                        | Biz League inc               | Broomfield, CO      | Data scientists use data and analytical ability to find and interpret rich data sources; Manage large amounts of data despite hardware, software, and bandwidth...  |   109980 | https://www.indeed.com/company/Biz-League-inc/jobs/Data-Scientist-653364c1c692d3b4?fccid=0be3817def992013&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                |   52.2 | 6,388     | hour                |
| Data Scientist                        | SSN Group                    | Houston, TX         | Demonstrated experience and accomplishments in the use of data mining, machine learning, and predictive analytics to address real-life problems....                 |   136300 | https://www.indeed.com/company/SSN-GROUP/jobs/Data-Scientist-cb9e9a4c5e2fd392?fccid=eb5bbf09b8a7f035&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                     |   27   | 2.0       | hour                |
| Full Time-Data Scientist-(Durant, OK) | Jackson Lewis                | Durant, OK          | To join a growing team of data scientists who are building the future of workforce law and legal analytics. 2 - 3 years of experience writing code and libraries... |    24440 | https://www.indeed.com/company/Jackson-Lewis/jobs/Data-Scientist-ddafad30dc681ba3?fccid=e54290448239033c&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                 |   41.4 | 16.0      | hour                |
| Data Scientist                        | Veear Projects               | Kirkland, WA        | 3+ years of experience in data analytics, data sciences, mathematics, statistics or data modeling. Should have data visualization skills, experience in tools...    |   136300 | https://www.indeed.com/company/Veear-Projects/jobs/Data-Scientist-0496739fc4fe984b?fccid=1b62f6efacf00111&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                |   51   | 25.0      | hour                |
| Data Scientist @ Apple Inc.           | TekHiring.com                | Sunnyvale, CA       | Machine Intelligence for the purposes of conducting machine learning and deep neural networks using TensorFlow, MLLIB....                                           |    94000 | https://www.indeed.com/company/TekHiring.com/jobs/Data-Scientist-Apple-bac9fe7fd7c6ec91?fccid=b13a6aecd647c160&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                           |   55.8 | 5.0       | hour                |
| Data Engineer/Scientist               | IDM People                   | Stamford, CT        | As a data engineer you will be working on building out a new technology platform that will be used by Firm’s data scientists and analysts....                       |   131600 | https://www.indeed.com/company/IDM-People/jobs/Data-Engineer-Scientist-fcb361578b7d2d16?fccid=ab9c097b77bf2fc0&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                           |   40.2 | 109.0     | hour                |
| Data Scientists – Machine Learning    | Brielle Technologies         | Alpharetta, GA      | Apply machine learning and statistical techniques to large data sets to find actionable insights. You will work on Advanced Analytics using Big Data...             |   122200 | https://www.indeed.com/company/Brielle-Technologies/jobs/Data-Scientist-Machine-Learning-a585a9e116405120?fccid=584a97c871a81538&vjs=3                                                                                                                                                                                                                                                                                                                                                                                         |   51   | 2.0       | hour                |
| Data-Statistical Assistant            | Jobs for America's Graduates | Las Vegas, NV 89146 | Maintain calendar of data deadlines and project time frames necessary to pull and compile data into a variety of reports....                                        |    35720 | https://www.indeed.com/company/Job's-for-Nevada's-Graduates,-Inc./jobs/Data-Statistical-Assistant-e653059b759e1df9?fccid=9877c9790d40d018&vjs=3                                                                                                                                                                                                                                                                                                                                                                                |   43.2 | 1,405     | hour                |
| Data Science Instructor               | Thinkful                     | Miami, FL           | You’ll engage with attendees in-person on a weekly basis, and occasionally reply to emails or direct them to the appropriate Thinkful department.                   |    51700 | https://www.indeed.com/pagead/clk?mo=r&ad=-6NYlbfkN0Ccrkqbmj9TkrtNVDKDL3a3xtsDifr6DsiceG2vkr376I5VCwW_V5oNt50XwFDejChY_tadNrUOurmuRIEsyFgjmjBJ9Y8NAirjCr-px5aCetAANCmZJJcgy0hj4zFRTr8gWhRwDHfdsEffWPq3Noi_OUCEu7WwaPUfgO-hXJryjQOQaBqpV5Q9OVtdCmD-1LotJgyMzm1PmncWLekQqGbuVotH0GIWGabqSJjiThGEc8yoUluvNugqutZywTDAuGSdSav84z-OTdNfvWYDSAs0Q4Qd2Vs-1ww3dZgmKyW-HuhipnkxdckmuANcePWtSWqYiwEAg13EPmKAGq3MTA2ATJmWsIW1ttPLjWffVrZWyqzD2yepzRVsBx9cjXD-nmFofP4AksNou0YITNF5GitgSIciYUoChOyTje0ulqyguchEXVOELGuF&vjs=3&p=6&sk=&fvj=1 |   30   | 2.0       | hour                |
| Data Science Instructor               | Thinkful                     | Miami, FL 33102     | You’ll engage with attendees in-person on a weekly basis, and occasionally reply to emails or direct them to the appropriate Thinkful department.                   |    51700 | https://www.indeed.com/pagead/clk?mo=r&ad=-6NYlbfkN0Ccrkqbmj9TkrtNVDKDL3a3xtsDifr6DsiceG2vkr376I5VCwW_V5oNt50XwFDejChY_tadNrUOurmuRIEsyFgjmjBJ9Y8NAirjCr-px5aCetAANCmZJJcgy0hj4zFRTr8gWhRwDHfdsEffWPq3Noi_OUCEu7WwaPVf3vdPDUDGRhriloDLn-fHnalvx1hPm6InpbfWOf1cdmMuRyLqvIbFnMAfnm5ZepeEX5ZpwCB9ByXhrHba-eMy_EQGqkcVfq_jnA_YBmkBt-Wd4pwnMEhMwwUV5Pty5sephD83Ds80dvwR2D2yPnyzPl-QvvHAK5ZJ3HT1DSVDptEJmnsTCPhmI8ESS2KAjqfuL9N3wx5yzmvuqt0hmlKFm2Axw7s1uuxqlHmvZfXsVb3maV-5O0bX9sIdm5kTWvfBMIUF4xEWQsUiczHF2R_r&vjs=3&p=5&sk=&fvj=1 |   31.8 | 6.0       | hour                |


Table #2
Filename: source_1.csv
Sample Rows in Markdown:
| title                                                                    | company                       | location     | summary                                                                                                                                                        |   salary | href                                                                           |   rate | reviews   | org_salary_period   |
|:-------------------------------------------------------------------------|:------------------------------|:-------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------|---------:|:-------------------------------------------------------------------------------|-------:|:----------|:--------------------|
| DATA ENTRY OPERATOR                                                      | University of Washington      | Seattle, WA  | The mission of University of Washington Medicine is to improve the health of the public by advancing medical knowledge, providing outstanding primary and...   |    36954 | https://www.indeed.com/rc/clk?jk=575e2692cb83632b&fccid=142783ac2edbe56b&vjs=3 |   52.2 | 890.0     | month               |
| BIOLOGICAL ADMINISTRATOR III - SES - 64026333                            | The State of Florida          | None         | Work with the Chief of Laboratory Services and other BOL Laboratory Directors to ensure a comprehensive, quality laboratory system with the BOL for public...  |    67584 | https://www.indeed.com/rc/clk?jk=081db22603b4e343&fccid=0a10ade3465aa10f&vjs=3 |   43.2 | 1,067     | month               |
| MEDICAL LABORATORY SCIENTIST I - 64067592                                | The State of Florida          | None         | Candidates claiming Veterans’ Preference must attach supporting documentation with each submission that includes character of service (for example, DD Form... |    31122 | https://www.indeed.com/rc/clk?jk=b6dcd8b27a9aff9f&fccid=0a10ade3465aa10f&vjs=3 |   43.2 | 1,067     | month               |
| DATA ENTRY OPERATOR                                                      | University of Washington      | Seattle, WA  | Provide centralized support in the Contact Center by independently entering referrals into Epic software, verifying payers and plans prior to patient...       |    36954 | https://www.indeed.com/rc/clk?jk=575e2692cb83632b&fccid=142783ac2edbe56b&vjs=3 |   52.2 | 891.0     | month               |
| Data Science Online Course Instructor (Part-Time, Contract)              | DataCamp                      | New York, NY | Learn from data on how thousands of students engage with your content.                                                                                         |    18000 | https://www.indeed.com/rc/clk?jk=802fc0ae27f7117a&fccid=f0dbb4617995d17b&vjs=3 |   42   | 128.0     | month               |
| Data Science Online Course Instructor (Part-Time, Contract)              | DataCamp                      | New York, NY | Learn from data on how thousands of students engage with your content.                                                                                         |    18000 | https://www.indeed.com/rc/clk?jk=802fc0ae27f7117a&fccid=f0dbb4617995d17b&vjs=3 |   51.6 | 756.0     | month               |
| Research Engineering/ Scientist Associate III - Biostatistician          | University of Texas at Austin | Austin, TX   | Under the direction of the Director of the Hub or other PhD/Faculty (bio)statisticians, the individual will use collaborative skills and knowledge of...       |    46992 | https://www.indeed.com/rc/clk?jk=427cf13ba66449eb&fccid=f7282ad3490137c7&vjs=3 |   52.8 | 808.0     | month               |
| Research Engineering/ Scientist Associate III - Visualization Specialist | University of Texas at Austin | Austin, TX   | Study, learn, and understand the different audiences among Dell Medical School investigators, healthcare partner institutions, community organizations, and... |    60000 | https://www.indeed.com/rc/clk?jk=f53e6106e1b595c2&fccid=f7282ad3490137c7&vjs=3 |   52.8 | 808.0     | month               |
| NEDSS Systems Analyst IV                                                 | Dept of State Health Services | Austin, TX   | Systems Analyst IV The Systems Analyst performs advanced technical work and system administration for the National Electronic Disease Surveillance System...   |    59832 | https://www.indeed.com/rc/clk?jk=09f8a6419bba6ba5&fccid=113517153f849886&vjs=3 |   42   | 870.0     | month               |
| Senior Systems Administrator - Senior Unix Administrator                 | University of Texas at Austin | Austin, TX   | Participate in project development activities with minimal guidance from senior engineering scientists or project managers.                                    |    69774 | https://www.indeed.com/rc/clk?jk=fa1e361c529431e1&fccid=f7282ad3490137c7&vjs=3 |   52.8 | 808.0     | month               |


Table #3
Filename: source_2.csv
Sample Rows in Markdown:
| title                                        | company                                               | location                    | summary                                                                                                                                                          |   salary | href                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       |   rate | reviews   | org_salary_period   |
|:---------------------------------------------|:------------------------------------------------------|:----------------------------|:-----------------------------------------------------------------------------------------------------------------------------------------------------------------|---------:|:-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|-------:|:----------|:--------------------|
| Post-docs                                    | University of Southern California Keck School of M... | Los Angeles, CA             | Experience with data mining, especially for ‘omics’ datasets, or developing pipelines/software for large biological datasets is an asset but not a requirement.  |    52850 | https://www.indeed.com/company/University-of-Southern-California-Keck-School-of-Medicine/jobs/Post-Docs-a0e5572229653fd0?fccid=8ba3d8e724c51840&vjs=3                                                                                                                                                                                                                                                                                                                                                                                      |   43.8 | 9.0       | year                |
| Senior Flavor Scientist                      | Fluid Manufacturing                                   | Pacific Palisades, CA 90272 | • Drive Innovation by contributing idea generation of new product/concepts that leverage new ingredients and or processing in the natural product category.      |    92500 | https://www.indeed.com/rc/clk?jk=4572a270a675c22a&fccid=3f6f376593c4627c&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   44.4 | 7.0       | year                |
| ABS/CLO Research Analyst                     | Pure Search on behalf of an Investment Firm           | Santa Monica, CA            | The incumbent will be responsible for credit surveillance of existing investment positions and providing necessary reports for the investment committee and...   |   115000 | https://www.indeed.com/pagead/clk?mo=r&ad=-6NYlbfkN0DRQvFmim7Djpm-H9mnvPaSsQcCXDXm5PlmwPCgGO2LFqLk0YqYe8gE4jqn9gHMMQgMEnu47_FtJrZu_kjPi6KbbYBwERKooC4Gd7BaBs5Av3EJ0qJo1LP6fQ5GiIg3erXc6Q5uwvR39jaa3TpPKboJYaoD0UfBKELu8Bcf4emeBTUKf3CcNjNtiW-VAiKQ7y3I7bOh6J-3ydQi4kvVOwGGntRnBado3_EdBVf53I2q3MMU0A2NkU62oU3_MSNIMVixZTjQF-qbJ_sc7n-BDISkSsu-lLrs-_fiXmtzZX6jWJvK_iNNym2j8_zZmn5fJNPxVD1vo7sH2ZCBwMxktUCeAiM8O4jyOiwdSVqNdnhaQFA8__Ernrymmmjr8hgSMFhTjOVosiOJKdhKn5Iby-bkz8oZnTyi0pSbJ98RUj3G97RihwQt47iiIuYPRsgaQfQ=&vjs=3&p=3&sk=&fvj=1 |   60   | 2.0       | year                |
| Senior Data Scientist                        | Harnham                                               | Los Angeles, CA             | Based out of their Los Angeles offices, you will be charged with partnering with program managers and engineers to tackle the most complex and challenging...    |   127500 | https://www.indeed.com/rc/clk?jk=c4c7729b393b1e7e&fccid=d72eb0548d91249c&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   55.8 | 6.0       | year                |
| ABS/CLO Research Analyst                     | Pure Search on behalf of an Investment Firm           | Los Angeles, CA             | The incumbent will be responsible for credit surveillance of existing investment positions and providing necessary reports for the investment committee and...   |   115000 | https://www.indeed.com/pagead/clk?mo=r&ad=-6NYlbfkN0DRQvFmim7Djpm-H9mnvPaSsQcCXDXm5PlmwPCgGO2LFqLk0YqYe8gE4jqn9gHMMQgMEnu47_FtJrZu_kjPi6KbbYBwERKooC4Gd7BaBs5Av3EJ0qJo1LP6fQ5GiIg3erXc6Q5uwvR39jaa3TpPKboJYaoD0UfBKEJdxegVsBwB-7aQOdTyyvN6LGAv6ABQ8yNbRyhjeGiAZeDeHaaS_RTx6mmndmG-pdaOmOQrMiKeaM0RBwfNJlijscxASrhBSvkje98XXTWX0_6jH0w2DXd5vF2xn0UbWFdxAPNyM-n1agX3omIdFwJj83YdT2j570_wv2q8RSz6LMYgYQ--Smo9YGAs2ilJudVTz1DU02D1OD0ut9nAM3VFNxr448DwxB9QCDYa143JLSWeLE9G0TJwVQ8_sByeZsBcyxXtz44MmOYmeZnnGj9QWp0EBnHQknM=&vjs=3&p=3&sk=&fvj=1 |   60   | 2.0       | year                |
| SCIENTIST                                    | US Department of the Navy                             | Seal Beach, CA              | Some supplemental documents contain personal information such as SSN and DOB and some documents such as military orders and marriage certificates may contain... |    98828 | https://www.indeed.com/rc/clk?jk=b9b7fe140b9ab826&fccid=91388bf968bdfcad&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   52.8 | 31,038    | year                |
| ABS/CLO Research Analyst                     | Pure Search on behalf of an Investment Firm           | Torrance, CA                | The incumbent will be responsible for credit surveillance of existing investment positions and providing necessary reports for the investment committee and...   |   115000 | https://www.indeed.com/pagead/clk?mo=r&ad=-6NYlbfkN0DRQvFmim7Djpm-H9mnvPaSsQcCXDXm5PlmwPCgGO2LFqLk0YqYe8gE4jqn9gHMMQgMEnu47_FtJrZu_kjPi6KbbYBwERKooC4Gd7BaBs5Av3EJ0qJo1LP6fQ5GiIg3erXc6Q5uwvR39jaa3TpPKboJYaoD0UfBKEKrKRMW0jaUPP2VdFVld14LpiuHm4ARsBofeOHYj3-bPSYvM2Z-tTx7aZK_HfZFtB6Sq-ELFqg8IhakPBQeJ18zMPzfm5dXSgOEZ5BoQ-rB3I9PDpFqoix933Z3W_NS6_TfSYDGzhaGhMnrhhTVjEpV3PZ4p3KYFTLJuw0bnZvrGDZ49e3l-Z1NbJY7hh69ZVqZ8r5TRj_zUPoTuXF9i4Lb3q50_1Ks0zPPEPe4CNmG3eKj6laQGth3uTMfT14h74gFj4R3z7B_GqE19T09j4VmHBP_IkLcXuU=&vjs=3&p=3&sk=&fvj=1 |   60   | 2.0       | year                |
| ABS/CLO Research Analyst                     | Pure Search on behalf of an Investment Firm           | Los Angeles, CA 90064       | The incumbent will be responsible for credit surveillance of existing investment positions and providing necessary reports for the investment committee and...   |   115000 | https://www.indeed.com/pagead/clk?mo=r&ad=-6NYlbfkN0DRQvFmim7Djpm-H9mnvPaSsQcCXDXm5PlmwPCgGO2LFqLk0YqYe8gE4jqn9gHMMQgMEnu47_FtJrZu_kjPi6KbbYBwERKooC4Gd7BaBs5Av3EJ0qJo1LP6fQ5GiIg3erXc6Q5uwvR39jaa3TpPKboJYaoD0UfBKEKmUrCa47YetFQpYLvv4dSpUaVoZ_c__Szs9WBpobA10jAnkoXgTiNjojlEN3qGa12MnQ7B5QdSE8h0RiC5i6D_-RSsERZ3HEkyCa9nV-tFfRb_rwnuLo5zF0MGotOGRcLRp3lt73kSpuLLrE4QD4RhfoC3NyIDFIiBYxoRasaJH4AAsXaWRtGE-qmX841NSaq8wTkm6eASAHS51_nhDdlW5ImUCWXnCSjKrQMGglJIIlQuIvD51CuNEcSGAK28JpBz7iFToB9TqPTv8sj6S_7Ukyql019L7z4=&vjs=3&p=3&sk=&fvj=1 |   60   | 2.0       | year                |
| Market Research Analyst, TV Content Strategy | NRG- A Stagwell Company                               | Los Angeles, CA 90016       | Help with all aspects of project management from kick-off to results (responsibilities include planning/set-up, project execution, survey design/development...  |    50000 | https://www.indeed.com/rc/clk?jk=5f79ef91f1046a9c&fccid=9f875ac9575742bf&vjs=3                                                                                                                                                                                                                                                                                                                                                                                                                                                             |   52.2 | 577.0     | year                |
| ABS/CLO Research Analyst                     | Pure Search on behalf of an Investment Firm           | Santa Monica, CA            | The incumbent will be responsible for credit surveillance of existing investment positions and providing necessary reports for the investment committee and...   |   115000 | https://www.indeed.com/pagead/clk?mo=r&ad=-6NYlbfkN0DRQvFmim7Djpm-H9mnvPaSsQcCXDXm5PlmwPCgGO2LFqLk0YqYe8gE4jqn9gHMMQgMEnu47_FtJrZu_kjPi6KbbYBwERKooC4Gd7BaBs5Av3EJ0qJo1LP6fQ5GiIg3erXc6Q5uwvR39jaa3TpPKboJYaoD0UfBKEKJwuWqrfa3vDHbobMYX-UaM-0O9AiNHamZ-IVmt3cLRtvsDzq3WFCI2DTcik9qpTccar4ADzXbDlYeKklmg2gVD1fLv4Roe3f_-Ffi4t3jcCdqCavOzumb7KkDA6qzq6WPS6uSEkIXCvu0L6hQ9OBk5vA6cS3zlAs2RIsZnQ5vg-McnulXF05XV2cWk1Ohz7zgG_oD4BIOqu1Baug6IxIrNPKleL1F2mti_y7I7vZSR_d1LyGqFjIMnH_fOUqY435ub3bu1kn00qqdXOl1dIEYebkV1KSOhyg=&vjs=3&p=3&sk=&fvj=1 |   60   | 2.0       | year                |


Table #4
Filename: source_3.csv
Sample Rows in Markdown:
| title                                                             | company                 | location     | summary                                                                                                                                                        |   salary | href                                                                                                                    |   rate |   reviews | org_salary_period   |
|:------------------------------------------------------------------|:------------------------|:-------------|:---------------------------------------------------------------------------------------------------------------------------------------------------------------|---------:|:------------------------------------------------------------------------------------------------------------------------|-------:|----------:|:--------------------|
| Lead Data Scientist                                               | Lenmar Consulting, Inc. | New York, NY | Primary focus is to analyze available structured and un-structured information, apply data mining techniques, perform statistical analysis, and provide...     |   207388 | https://www.indeed.com/company/Lenmar-Consulting/jobs/Lead-Data-Scientist-1774446e8a5b29c5?fccid=3aaedf4a3bfe74b4&vjs=3 |   44.4 |        63 | day                 |
| Data Scientist (Pystack, Pyspark, AWS)                            | Workbridge Associates   | Chicago, IL  | Using Artificial Intelligence, Machine Learning, and Deep Learning to build models for clients                                                                 |    24675 | https://www.indeed.com/rc/clk?jk=90eb19a4522a1554&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
|                                                                   |                         |              |  Working directly with clients to fulfill their needs                                                                                                          |          |                                                                                                                         |        |           |                     |
| Data Scientist (Deep Learning)                                    | Workbridge Associates   | Chicago, IL  | They are using Machine Learning, Deep Learning and Artificial Intelligence to run analytics on advertisements and figure out the ROI on those ads.             |    23500 | https://www.indeed.com/rc/clk?jk=e3d8d7fd1e8e1985&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
| Data Scientist (Python, R, SQL)                                   | Workbridge Associates   | Chicago, IL  | You will focus on the design, development and implementation of ranking models, cluster segmentations, and algorithms in support of this business needs.       |    22325 | https://www.indeed.com/rc/clk?jk=bd44de98fcf93d09&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
| Data Scientist (Machine Learning, Deep Learning, Computer Vision) | Workbridge Associates   | Chicago, IL  | These Data Scientists will have the opportunity to work cross-functionally with Data Engineering and Software Engineering teams on a variety of different...   |    25850 | https://www.indeed.com/rc/clk?jk=6d8bf53e38f0a096&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
| Senior Data Scientist (Deep Learning, NLP, Computer Vision)       | Workbridge Associates   | Chicago, IL  | The Senior Data Scientist will be working using Basketball Analytics to support some of their clients which include Professional US teams, D1 College teams... |    28200 | https://www.indeed.com/rc/clk?jk=c0a12b626f68c349&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
| Senior Level Data Scientist (NLP, NLTK, Deep Learning)            | Workbridge Associates   | Chicago, IL  | The company focuses on creating a fraud prevention platform to predict counterfeit transactions in the space.                                                  |    27025 | https://www.indeed.com/rc/clk?jk=52f5584021b644e0&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
| Senior Level Data Scientist                                       | Workbridge Associates   | Chicago, IL  | Applicants must be currently authorized to work in United States on a full-time basis now and in the future.                                                   |    27025 | https://www.indeed.com/rc/clk?jk=3911f6abceb7e3bb&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
| Mid Level Data Engineer (Python, ETL, SQL)                        | Workbridge Associates   | Chicago, IL  | The data is coming from both the operational side and the consumer side- your role would be to normalize the data so Data Scientists can run analytics and...  |    21150 | https://www.indeed.com/rc/clk?jk=58b1d1c65854f44b&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |
| Senior Level Data Engineer (Python, Spark, AWS)                   | Workbridge Associates   | Chicago, IL  | They need this Data Engineer to pipeline data coming in from these companies they’re buying out, normalize it, and help Data Scientists run analytics on it.   |    27025 | https://www.indeed.com/rc/clk?jk=4df684679a2d2f5f&fccid=a6920e0a635e5c4e&vjs=3                                          |   41.4 |        40 | day                 |


Target Schema:
| location                    |   title |   company |   summary |   salary |   href |   rate |   reviews |   org_salary_period |
|:----------------------------|--------:|----------:|----------:|---------:|-------:|-------:|----------:|--------------------:|
| Albany, NY                  |       3 |         3 |         3 |        3 |      3 |      3 |         3 |                   3 |
| Alpharetta, GA              |       2 |         2 |         2 |        2 |      2 |      2 |         2 |                   2 |
| Anaheim, CA                 |       1 |         1 |         1 |        1 |      1 |      1 |         1 |                   1 |
| Armonk, NY 10504            |       1 |         1 |         1 |        1 |      1 |      1 |         1 |                   1 |
| Atlanta, GA 30345           |       1 |         1 |         1 |        1 |      1 |      1 |         1 |                   1 |
| Auburn, WA                  |       3 |         3 |         3 |        3 |      3 |      3 |         3 |                   3 |
| Austin, TX                  |      12 |        12 |        12 |       12 |     12 |     12 |        12 |                  12 |
| Austin, TX 78746            |       1 |         1 |         1 |        1 |      1 |      1 |         1 |                   1 |
| Bainbridge Island, WA 98110 |       1 |         1 |         1 |        1 |      1 |      1 |         1 |                   1 |
| Bala-Cynwyd, PA             |       1 |         1 |         1 |        1 |      1 |      1 |         1 |                   1 |

Return only the final code in markdown codeblock format, without any additional text or explanation. 



target: target.csv
train: source_0.csv
source_1.csv
source_2.csv
source_3.csv
test: test_0.csv
test_1.csv
test_2.csv
test_3.csv