# coding: utf-8
# In[1]:
import pandas as pd
import numpy as np
import os
from sklearn.preprocessing import StandardScaler
# In[2]:
#指定工作路径
os.chdir('/Users/a1/Downloads/百度云盘/机器学习算法配套案例实战/K近邻')
# In[3]:
#导入csv文件
dc_listings = pd.read_csv('listings.csv')
#指定features
features = ['accommodates', 'bedrooms', 'bathrooms', 'beds', 'price', 'minimum_nights', 'maximum_nights', 'number_of_reviews']
#定义features为DataFrame的列
dc_listings = dc_listings[features]
#清洗数据集,去除价格的$符合
dc_listings['price'] = dc_listings.price.str.replace("\$|,", '').astype(float)
#清洗数据集,去除带有空单元格的行
dc_listings = dc_listings.dropna()
#对所有特征做标准化
dc_listings[features] = StandardScaler().fit_transform(dc_listings[features])
normalized_listings = dc_listings
#打印DataFrame的行列属性
print(dc_listings.shape)
# In[4]:
#打印DataFrame的表头head()
dc_listings.head()
# In[5]:
#切分数据集
norm_train_df = normalized_listings.copy().iloc[0:2792]
norm_test_df = normalized_listings.copy().iloc[2792:]
# In[6]:
#调包算距离
from scipy.spatial import distance
first_listing = normalized_listings.iloc[0][['accommodates', 'bathrooms']]
fifth_listing = normalized_listings.iloc[20][['accommodates', 'bathrooms']]
first_fifth_distance = distance.euclidean(first_listing, fifth_listing)
first_fifth_distance
# In[9]:
#增加一列预测价格 注意apply函数的使用, test_df中的每一条数据都对应一条预测的价格
#test_df['predicted_price'] = test_df.accommodates.apply(predict_price, feature_column = 'accommodates')
# In[10]:
#多变量KNN模型
def predict_price_multivariate(new_listing_value, feature_columns):
temp_df = norm_train_df
temp_df['distance'] = distance.cdist(temp_df[feature_columns], [new_listing_value[feature_columns]])
temp_df = temp_df.sort_values('distance')
knn_5 = temp_df.price.iloc[:5]
predicted_price = knn_5.mean()
return predicted_price
cols = ['accommodates', 'bathrooms']
norm_test_df['predicted_price'] = norm_test_df[cols].apply(predict_price_multivariate,feature_columns=cols,axis=1)
norm_test_df['squared_error'] = (norm_test_df['predicted_price'] - norm_test_df['price'])**(2)
mse = norm_test_df['squared_error'].mean()
rmse = mse ** (1/2)
print(rmse)
KNN 邻近 - 回归算法
最新推荐文章于 2023-08-11 17:00:43 发布