{ "cells": [ { "attachments": {}, "cell_type": "markdown", "metadata": { "id": "Mtf5REmBrcZS" }, "source": [ "#**Activity 4 - Part 2 and Part 3**\n", "Part #2: Linear Regression\n", "\n", "Part #3: Model Dumping \n", "\n", "***Group 4***\n", "\n", "*Fagarita, Dave*\n", "\n", "*Servandil, Jimuel*\n", "\n", "*Magno, Jannica Mae*\n", "\n", "*Catanus, Jeziah Lois*" ] }, { "cell_type": "code", "execution_count": 66, "metadata": { "id": "v802SOLmrGxk" }, "outputs": [], "source": [ "import pandas as pd\n", "import numpy as np\n", "import re" ] }, { "cell_type": "code", "execution_count": 67, "metadata": { "colab": { "base_uri": "https://localhost:8080/", "height": 904 }, "id": "92o5soHO1opT", "outputId": "651119c6-496e-4612-f6ff-2df415a98cc2" }, "outputs": [ { "data": { "text/html": [ "
\n", " | Job | \n", "Location | \n", "Salary | \n", "Experience | \n", "Job_Pos | \n", "
---|---|---|---|---|---|
0 | \n", "Junior Graphics Designer | \n", "Remote | \n", "Php20,000.00 -Php30,000.00 | \n", "At least 1 year | \n", "Junior | \n", "
1 | \n", "Junior Product Designer | \n", "Philippines | \n", "PHP30K | \n", "1-2 years | \n", "Junior | \n", "
2 | \n", "Junior Services Developer - Javascript (100% R... | \n", "Remote | \n", "PHP 32,000 - PHP 57,000 | \n", "20 years | \n", "Junior | \n", "
3 | \n", "Junior Software Engineers | \n", "Remote in Makati | \n", "NaN | \n", "Minimum 1-2 years | \n", "Junior | \n", "
4 | \n", "Junior Enterprise Growth Consultant (Work From... | \n", "Remote | \n", "Php50,000.00 -Php70,000.00 | \n", "Minimum 1-2 years | \n", "Junior | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
295 | \n", "Chief Technology Officer | Flexible Shift - Pe... | \n", "Remote in Makati | \n", "Php150,000.00 -Php200,000.00 | \n", "5 years | \n", "CTO | \n", "
296 | \n", "Senior Web Developer | \n", "Remote in Manila | \n", "Php80,000.00 -Php100,000.00 | \n", "NaN | \n", "CTO | \n", "
297 | \n", "HEAD OF THE SOFTWARE DEVELOPMENT TEAM | \n", "Taguig | \n", "Php150,000.00 -Php200,000.00 | \n", "7 years | \n", "CTO | \n", "
298 | \n", "Chief Technology Officer | \n", "Taguig | \n", "NaN | \n", "NaN | \n", "CTO | \n", "
299 | \n", "Chief Technology Officer (CTO) | \n", "Makati | \n", "P160K | \n", "5 years | \n", "CTO | \n", "
300 rows × 5 columns
\n", "\n", " | Job | \n", "Location | \n", "Salary | \n", "Experience | \n", "Job_Pos | \n", "Lower Salary | \n", "Upper Salary | \n", "New Salary | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Junior Graphics Designer | \n", "Remote | \n", "20000.00-30000.00 | \n", "At least 1 year | \n", "Junior | \n", "20000.0 | \n", "30000.0 | \n", "25000.0 | \n", "
1 | \n", "Junior Product Designer | \n", "Philippines | \n", "30000 | \n", "1-2 years | \n", "Junior | \n", "30000.0 | \n", "0.0 | \n", "30000.0 | \n", "
2 | \n", "Junior Services Developer - Javascript (100% R... | \n", "Remote | \n", "32000-57000 | \n", "20 years | \n", "Junior | \n", "32000.0 | \n", "57000.0 | \n", "44500.0 | \n", "
3 | \n", "Junior Software Engineers | \n", "Remote in Makati | \n", "NaN | \n", "Minimum 1-2 years | \n", "Junior | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
4 | \n", "Junior Enterprise Growth Consultant (Work From... | \n", "Remote | \n", "50000.00-70000.00 | \n", "Minimum 1-2 years | \n", "Junior | \n", "50000.0 | \n", "70000.0 | \n", "60000.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
295 | \n", "Chief Technology Officer | Flexible Shift - Pe... | \n", "Remote in Makati | \n", "150000.00-200000.00 | \n", "5 years | \n", "CTO | \n", "150000.0 | \n", "200000.0 | \n", "175000.0 | \n", "
296 | \n", "Senior Web Developer | \n", "Remote in Manila | \n", "80000.00-100000.00 | \n", "NaN | \n", "CTO | \n", "80000.0 | \n", "100000.0 | \n", "90000.0 | \n", "
297 | \n", "HEAD OF THE SOFTWARE DEVELOPMENT TEAM | \n", "Taguig | \n", "150000.00-200000.00 | \n", "7 years | \n", "CTO | \n", "150000.0 | \n", "200000.0 | \n", "175000.0 | \n", "
298 | \n", "Chief Technology Officer | \n", "Taguig | \n", "NaN | \n", "NaN | \n", "CTO | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
299 | \n", "Chief Technology Officer (CTO) | \n", "Makati | \n", "160000 | \n", "5 years | \n", "CTO | \n", "160000.0 | \n", "0.0 | \n", "160000.0 | \n", "
300 rows × 8 columns
\n", "\n", " | Job | \n", "Location | \n", "Salary | \n", "Experience | \n", "Job_Pos | \n", "Lower Salary | \n", "Upper Salary | \n", "New Salary | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Junior Graphics Designer | \n", "Remote | \n", "20000.00-30000.00 | \n", "1.0 | \n", "1 | \n", "20000.0 | \n", "30000.0 | \n", "25000.0 | \n", "
1 | \n", "Junior Product Designer | \n", "Philippines | \n", "30000 | \n", "1.5 | \n", "1 | \n", "30000.0 | \n", "0.0 | \n", "30000.0 | \n", "
2 | \n", "Junior Services Developer - Javascript (100% R... | \n", "Remote | \n", "32000-57000 | \n", "20.0 | \n", "1 | \n", "32000.0 | \n", "57000.0 | \n", "44500.0 | \n", "
3 | \n", "Junior Software Engineers | \n", "Remote in Makati | \n", "NaN | \n", "1.5 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
4 | \n", "Junior Enterprise Growth Consultant (Work From... | \n", "Remote | \n", "50000.00-70000.00 | \n", "1.5 | \n", "1 | \n", "50000.0 | \n", "70000.0 | \n", "60000.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
295 | \n", "Chief Technology Officer | Flexible Shift - Pe... | \n", "Remote in Makati | \n", "150000.00-200000.00 | \n", "5.0 | \n", "4 | \n", "150000.0 | \n", "200000.0 | \n", "175000.0 | \n", "
296 | \n", "Senior Web Developer | \n", "Remote in Manila | \n", "80000.00-100000.00 | \n", "NaN | \n", "4 | \n", "80000.0 | \n", "100000.0 | \n", "90000.0 | \n", "
297 | \n", "HEAD OF THE SOFTWARE DEVELOPMENT TEAM | \n", "Taguig | \n", "150000.00-200000.00 | \n", "7.0 | \n", "4 | \n", "150000.0 | \n", "200000.0 | \n", "175000.0 | \n", "
298 | \n", "Chief Technology Officer | \n", "Taguig | \n", "NaN | \n", "NaN | \n", "4 | \n", "0.0 | \n", "0.0 | \n", "0.0 | \n", "
299 | \n", "Chief Technology Officer (CTO) | \n", "Makati | \n", "160000 | \n", "5.0 | \n", "4 | \n", "160000.0 | \n", "0.0 | \n", "160000.0 | \n", "
300 rows × 8 columns
\n", "\n", " | Job | \n", "Location | \n", "Salary | \n", "Experience | \n", "Job_Pos | \n", "Lower Salary | \n", "Upper Salary | \n", "New Salary | \n", "
---|---|---|---|---|---|---|---|---|
0 | \n", "Junior Graphics Designer | \n", "Remote | \n", "20000.00-30000.00 | \n", "1.0 | \n", "1 | \n", "20000.0 | \n", "30000.0 | \n", "25000.0 | \n", "
1 | \n", "Junior Product Designer | \n", "Philippines | \n", "30000 | \n", "1.5 | \n", "1 | \n", "30000.0 | \n", "0.0 | \n", "30000.0 | \n", "
3 | \n", "Junior Software Engineers | \n", "Remote in Makati | \n", "NaN | \n", "1.5 | \n", "1 | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "
4 | \n", "Junior Enterprise Growth Consultant (Work From... | \n", "Remote | \n", "50000.00-70000.00 | \n", "1.5 | \n", "1 | \n", "50000.0 | \n", "70000.0 | \n", "60000.0 | \n", "
5 | \n", "Junior Operations Associate | \n", "Remote in Manila | \n", "28000-53000 | \n", "1.5 | \n", "1 | \n", "28000.0 | \n", "53000.0 | \n", "40500.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
295 | \n", "Chief Technology Officer | Flexible Shift - Pe... | \n", "Remote in Makati | \n", "150000.00-200000.00 | \n", "5.0 | \n", "4 | \n", "150000.0 | \n", "200000.0 | \n", "175000.0 | \n", "
296 | \n", "Senior Web Developer | \n", "Remote in Manila | \n", "80000.00-100000.00 | \n", "NaN | \n", "4 | \n", "80000.0 | \n", "100000.0 | \n", "90000.0 | \n", "
297 | \n", "HEAD OF THE SOFTWARE DEVELOPMENT TEAM | \n", "Taguig | \n", "150000.00-200000.00 | \n", "7.0 | \n", "4 | \n", "150000.0 | \n", "200000.0 | \n", "175000.0 | \n", "
298 | \n", "Chief Technology Officer | \n", "Taguig | \n", "NaN | \n", "NaN | \n", "4 | \n", "0.0 | \n", "0.0 | \n", "NaN | \n", "
299 | \n", "Chief Technology Officer (CTO) | \n", "Makati | \n", "160000 | \n", "5.0 | \n", "4 | \n", "160000.0 | \n", "0.0 | \n", "160000.0 | \n", "
284 rows × 8 columns
\n", "\n", " | Experience | \n", "Job_Pos | \n", "New Salary | \n", "
---|---|---|---|
0 | \n", "1.0 | \n", "1 | \n", "25000.0 | \n", "
1 | \n", "1.5 | \n", "1 | \n", "30000.0 | \n", "
3 | \n", "1.5 | \n", "1 | \n", "NaN | \n", "
4 | \n", "1.5 | \n", "1 | \n", "60000.0 | \n", "
5 | \n", "1.5 | \n", "1 | \n", "40500.0 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
295 | \n", "5.0 | \n", "4 | \n", "175000.0 | \n", "
296 | \n", "NaN | \n", "4 | \n", "90000.0 | \n", "
297 | \n", "7.0 | \n", "4 | \n", "175000.0 | \n", "
298 | \n", "NaN | \n", "4 | \n", "NaN | \n", "
299 | \n", "5.0 | \n", "4 | \n", "160000.0 | \n", "
284 rows × 3 columns
\n", "\n", " | Experience | \n", "Job_Pos | \n", "New Salary | \n", "
---|---|---|---|
0 | \n", "1.0 | \n", "1 | \n", "25000.000000 | \n", "
1 | \n", "1.5 | \n", "1 | \n", "30000.000000 | \n", "
3 | \n", "1.5 | \n", "1 | \n", "49804.276271 | \n", "
4 | \n", "1.5 | \n", "1 | \n", "60000.000000 | \n", "
5 | \n", "1.5 | \n", "1 | \n", "40500.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
295 | \n", "5.0 | \n", "4 | \n", "175000.000000 | \n", "
296 | \n", "6.2 | \n", "4 | \n", "90000.000000 | \n", "
297 | \n", "7.0 | \n", "4 | \n", "175000.000000 | \n", "
298 | \n", "6.2 | \n", "4 | \n", "133952.238342 | \n", "
299 | \n", "5.0 | \n", "4 | \n", "160000.000000 | \n", "
284 rows × 3 columns
\n", "\n", " | Experience | \n", "Job_Pos | \n", "New Salary | \n", "
---|---|---|---|
0 | \n", "1.0 | \n", "1 | \n", "25000.000000 | \n", "
1 | \n", "1.5 | \n", "1 | \n", "30000.000000 | \n", "
2 | \n", "1.5 | \n", "1 | \n", "49804.276271 | \n", "
3 | \n", "1.5 | \n", "1 | \n", "60000.000000 | \n", "
4 | \n", "1.5 | \n", "1 | \n", "40500.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
279 | \n", "5.0 | \n", "4 | \n", "175000.000000 | \n", "
280 | \n", "6.2 | \n", "4 | \n", "90000.000000 | \n", "
281 | \n", "7.0 | \n", "4 | \n", "175000.000000 | \n", "
282 | \n", "6.2 | \n", "4 | \n", "133952.238342 | \n", "
283 | \n", "5.0 | \n", "4 | \n", "160000.000000 | \n", "
275 rows × 3 columns
\n", "LinearRegression()In a Jupyter environment, please rerun this cell to show the HTML representation or trust the notebook.
LinearRegression()
\n", " | Experience | \n", "Job_Pos | \n", "New Salary | \n", "
---|---|---|---|
0 | \n", "1.0 | \n", "1 | \n", "25000.000000 | \n", "
1 | \n", "1.5 | \n", "1 | \n", "30000.000000 | \n", "
2 | \n", "1.5 | \n", "1 | \n", "49804.276271 | \n", "
3 | \n", "1.5 | \n", "1 | \n", "60000.000000 | \n", "
4 | \n", "1.5 | \n", "1 | \n", "40500.000000 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "
279 | \n", "5.0 | \n", "4 | \n", "175000.000000 | \n", "
280 | \n", "6.2 | \n", "4 | \n", "90000.000000 | \n", "
281 | \n", "7.0 | \n", "4 | \n", "175000.000000 | \n", "
282 | \n", "6.2 | \n", "4 | \n", "133952.238342 | \n", "
283 | \n", "5.0 | \n", "4 | \n", "160000.000000 | \n", "
275 rows × 3 columns
\n", "