Reading sheets from an Excel file#

An Excel file can consist of multiple worksheets. Specific sheets can be read by passing in a particular argument (sheet_name).

Importing libraries and packages#

1# Mathematical operations and data manipulation
2import pandas as pd

Set paths#

1# Path to datasets directory
2data_path = "./datasets"
3# Path to assets directory (for saving results to)
4assets_path = "./assets"

Loading sheets#

1dataset_12_1 = pd.read_excel(
2    f"{data_path}/Housing_data.xlsx", sheet_name="Data_Tab_1"
3)
4dataset_12_2 = pd.read_excel(
5    f"{data_path}/Housing_data.xlsx", sheet_name="Data_Tab_2"
6)
7dataset_12_3 = pd.read_excel(
8    f"{data_path}/Housing_data.xlsx", sheet_name="Data_Tab_3"
9)

1dataset_12_1
CRIM ZN INDUS CHAS NOX RM AGE DIS RAD TAX PTRATIO B LSTAT PRICE
0 0.00632 18.0 2.31 0 0.538 6.575 65.2 4.0900 1 296 15.3 396.90 4.98 24.0
1 0.02731 0.0 7.07 0 0.469 6.421 78.9 4.9671 2 242 17.8 396.90 9.14 21.6
2 0.02729 0.0 7.07 0 0.469 7.185 61.1 4.9671 2 242 17.8 392.83 4.03 34.7
3 0.03237 0.0 2.18 0 0.458 6.998 45.8 6.0622 3 222 18.7 394.63 2.94 33.4
4 0.06905 0.0 2.18 0 0.458 7.147 54.2 6.0622 3 222 18.7 396.90 5.33 36.2
5 0.02985 0.0 2.18 0 0.458 6.430 58.7 6.0622 3 222 18.7 394.12 5.21 28.7
6 0.08829 12.5 7.87 0 0.524 6.012 66.6 5.5605 5 311 15.2 395.60 12.43 22.9
7 0.14455 12.5 7.87 0 0.524 6.172 96.1 5.9505 5 311 15.2 396.90 19.15 27.1
8 0.21124 12.5 7.87 0 0.524 5.631 100.0 6.0821 5 311 15.2 386.63 29.93 16.5 
1dataset_12_2
CRIM ZN INDUS CHAS NOX RM AGE DIS RAD TAX PTRATIO B LSTAT PRICE
0 0.17004 12.5 7.87 0 0.524 6.004 85.9 6.5921 5 311 15.2 386.71 17.10 18.9
1 0.22489 12.5 7.87 0 0.524 6.377 94.3 6.3467 5 311 15.2 392.52 20.45 15.0
2 0.11747 12.5 7.87 0 0.524 6.009 82.9 6.2267 5 311 15.2 396.90 13.27 18.9
3 0.09378 12.5 7.87 0 0.524 5.889 39.0 5.4509 5 311 15.2 390.50 15.71 21.7 
1dataset_12_3
CRIM ZN INDUS CHAS NOX RM AGE DIS RAD TAX PTRATIO B LSTAT PRICE
0 0.72580 0 8.14 0 0.538 5.727 69.5 3.7965 4 307 21 390.95 11.28 18.2
1 1.25179 0 8.14 0 0.538 5.570 98.1 3.7979 4 307 21 376.57 21.02 13.6
2 0.85204 0 8.14 0 0.538 5.965 89.2 4.0123 4 307 21 392.53 13.83 19.6
3 1.23247 0 8.14 0 0.538 6.142 91.7 3.9769 4 307 21 396.90 18.72 15.2
4 0.98843 0 8.14 0 0.538 5.813 100.0 4.0952 4 307 21 394.54 19.88 14.5
5 0.75026 0 8.14 0 0.538 5.924 94.1 4.3996 4 307 21 394.33 16.30 15.6
6 0.84054 0 8.14 0 0.538 5.599 85.7 4.4546 4 307 21 303.42 16.51 13.9
7 0.67191 0 8.14 0 0.538 5.813 90.3 4.6820 4 307 21 376.88 14.81 16.6
8 0.95577 0 8.14 0 0.538 6.047 88.8 4.4534 4 307 21 306.38 17.28 14.8
9 0.77299 0 8.14 0 0.538 6.495 94.4 4.4547 4 307 21 387.94 12.80 18.4
10 0.62976 0 8.14 0 0.538 5.949 61.8 4.7075 4 307 21 396.90 8.26 20.4
11 0.63796 0 8.14 0 0.538 6.096 84.5 4.4619 4 307 21 380.02 10.26 18.2
12 0.62739 0 8.14 0 0.538 5.834 56.5 4.4986 4 307 21 395.62 8.47 19.9
13 1.05393 0 8.14 0 0.538 5.935 29.3 4.4986 4 307 21 386.85 6.58 23.1
14 0.78420 0 8.14 0 0.538 5.990 81.7 4.2579 4 307 21 386.75 14.67 17.5
15 0.80271 0 8.14 0 0.538 5.456 36.6 3.7965 4 307 21 288.99 11.69 20.2