coding

some questions was not tought in the course

great learning

b and h are in sheet 1 pivot table in sheet 2

Sub DataSummary() Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("Sheet1") ' Replace "Sheet1" with your actual sheet name ' Data Summary for All Female Clients Dim femaleData As Range Dim femaleIncome As Range Dim femaleLoanAmount As Range ' Filter data for female clients based on CODE_GENDER column Set femaleData =…

import pandas as pdimport mysql.connector cnx = mysql.connector.connect( host='your_host', user='your_user', password='your_password', database='alumni') def fetch_rows(table_name): query = f"SELECT * FROM {table_name} LIMIT 1000" df = pd.read_sql(query, cnx) return df table_names = [ 'College_A_HS', 'College_A_SE', 'College_A_SJ',…

great learning

great learning

great learning

all the questions can be done in Python and R. but got no information. therefore I have to write it in the box; Display the data of white wine and red wine: Display the rows and columns of the "winequality-white" and "winequality-red" datasets. Get the size of both white wine and red wine: Count the number of rows and…

three files

I took Uber cab request from Kaggle. Dataset provided below

These regression models are used to learn the underlying patterns in the given dataset and make predictions on whether a patient is likely to have heart disease based on their clinical parameters. 

PCA, K-Means Clustering and Hierarchical Clustering are in three different scripts

no image required to solve the above questions

in grading policy section it is mentioned that it should be done in excel. therefore i submitted both excel and word files but the calculations for ques 1 is done on excel. all answered questions are in excel and word file

code in the jupyter notebook and rest in the word

all questions are in ms word

ques 2 is in ms word

ques 1 is in ms word

ques 1 is in docx file ques 2 is in jupyternotebook

perform on auto_clean.csv

file in jupyter notebook

answers in jupyter notebook