关于天池竞赛的三两事。二手车成交价格预测；.zip

# 天池的一些竞赛与想法👩‍💻 --- <div align="center"> [](https://github.com/ExcaliburEX/Tianchi-Story/issues) [](https://github.com/ycraaron/LuotuoCoin/pulls)    [](http://hits.dwyl.com/ExcaliburEX/Tianchi-Story) [](/LICENSE)       [](https://twitter.com/Excaliburjp)  [](https://chrome.google.com/webstore/detail/lastpass-free-password-ma/hdokiejnpimakedhajhdlcegeplioahd) </div> --- # 全文大导航 - [二手车成交价格预测](https://github.com/ExcaliburEX/Tianchi-Story#二手车成交价格预测) - [1️⃣ 赛题理解✍️](https://github.com/ExcaliburEX/Tianchi-Story#1%EF%B8%8F%E2%83%A3-%E8%B5%9B%E9%A2%98%E7%90%86%E8%A7%A3%EF%B8%8F)[天池_二手车价格预测_Task_1-2.ipynb](https://github.com/ExcaliburEX/Tianchi-Story/blob/master/天池_二手车价格预测_Task_1-2.ipynb) - [1️⃣.1️⃣ 赛题重述](https://github.com/ExcaliburEX/Tianchi-Story#1%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-%E8%B5%9B%E9%A2%98%E9%87%8D%E8%BF%B0) - [1️⃣.2️⃣ 数据集概述](https://github.com/ExcaliburEX/Tianchi-Story#1%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E9%9B%86%E6%A6%82%E8%BF%B0) - [1️⃣.3️⃣ 预测结果评价指标⚒️](https://github.com/ExcaliburEX/Tianchi-Story#1%EF%B8%8F%E2%83%A33%EF%B8%8F%E2%83%A3-%E9%A2%84%E6%B5%8B%E7%BB%93%E6%9E%9C%E8%AF%84%E4%BB%B7%E6%8C%87%E6%A0%87%EF%B8%8F) - [2️⃣ 数据分析EDA](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E5%88%86%E6%9E%90eda) - [2️⃣.1️⃣ 数据总览](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E6%80%BB%E8%A7%88) - [2️⃣.1️⃣.1️⃣ 数据载入](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-%E5%90%84%E7%A7%8D%E8%AE%A1%E7%AE%97%E5%8C%85%E7%9A%84%E5%AF%BC%E5%85%A5) - [2️⃣.1️⃣.2️⃣ 数据的基本形态](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E7%9A%84%E5%9F%BA%E6%9C%AC%E5%BD%A2%E6%80%81) - [2️⃣.2️⃣ 数据的缺失情况📌](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E7%9A%84%E7%BC%BA%E5%A4%B1%E6%83%85%E5%86%B5) - [2️⃣.3️⃣ 数据的异常情况☢️](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A33%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E7%9A%84%E5%BC%82%E5%B8%B8%E6%83%85%E5%86%B5%EF%B8%8F) - [2️⃣.4️⃣ 待预测的真实值的分布情况📈](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A34%EF%B8%8F%E2%83%A3-%E5%BE%85%E9%A2%84%E6%B5%8B%E7%9A%84%E7%9C%9F%E5%AE%9E%E5%80%BC%E7%9A%84%E5%88%86%E5%B8%83%E6%83%85%E5%86%B5) - [2️⃣.5️⃣ 数据特征相关性的分析🎎](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A35%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E7%89%B9%E5%BE%81%E7%9B%B8%E5%85%B3%E6%80%A7%E7%9A%84%E5%88%86%E6%9E%90) - [2️⃣.5️⃣.1️⃣ `numric`特征的相关性分析](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A35%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-numric%E7%89%B9%E5%BE%81%E7%9A%84%E7%9B%B8%E5%85%B3%E6%80%A7%E5%88%86%E6%9E%90) - [2️⃣.5️⃣.2️⃣ `pandas_profiling`生成数据报告📕](https://github.com/ExcaliburEX/Tianchi-Story#2%EF%B8%8F%E2%83%A35%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-pandas_profiling%E7%94%9F%E6%88%90%E6%95%B0%E6%8D%AE%E6%8A%A5%E5%91%8A) - [2️⃣.6️⃣ 结语✏️](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A3-%E7%BB%93%E8%AF%AD%EF%B8%8F) - [3️⃣&emsp; 特征工程🃏](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A3-%E7%89%B9%E5%BE%81%E5%B7%A5%E7%A8%8B)[天池_二手车价格预测_Task_3_特征工程.ipynb](https://github.com/ExcaliburEX/Tianchi-Story/blob/master/天池_二手车价格预测_Task_3_特征工程.ipynb) - [3️⃣.1️⃣&emsp; 前言](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-%E5%89%8D%E8%A8%80) - [3️⃣.1️⃣.1️⃣&emsp; 赛题重述](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-%E8%B5%9B%E9%A2%98%E9%87%8D%E8%BF%B0) - [3️⃣.1️⃣.2️⃣&emsp; 数据集概述](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-%E6%95%B0%E6%8D%AE%E9%9B%86%E6%A6%82%E8%BF%B0) - [3️⃣.2️⃣&emsp; 异常缺失值删除](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-%E5%BC%82%E5%B8%B8%E7%BC%BA%E5%A4%B1%E5%80%BC%E5%88%A0%E9%99%A4) - [3️⃣.2️⃣.1️⃣&emsp; 导入库与数据](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-%E5%AF%BC%E5%85%A5%E5%BA%93%E4%B8%8E%E6%95%B0%E6%8D%AE) - [3️⃣.2️⃣.2️⃣&emsp; 异常值删除](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-%E5%BC%82%E5%B8%B8%E5%80%BC%E5%88%A0%E9%99%A4) - [3️⃣.3️⃣&emsp; 树模型的特征构造](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A33%EF%B8%8F%E2%83%A3-%E6%A0%91%E6%A8%A1%E5%9E%8B%E7%9A%84%E7%89%B9%E5%BE%81%E6%9E%84%E9%80%A0) - [3️⃣.3️⃣.1️⃣&emsp; 时间特征构造](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A33%EF%B8%8F%E2%83%A31%EF%B8%8F%E2%83%A3-%E6%97%B6%E9%97%B4%E7%89%B9%E5%BE%81%E6%9E%84%E9%80%A0) - [3️⃣.3️⃣.2️⃣&emsp; 城市信息特征提取](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A33%EF%B8%8F%E2%83%A32%EF%B8%8F%E2%83%A3-%E5%9F%8E%E5%B8%82%E4%BF%A1%E6%81%AF%E7%89%B9%E5%BE%81%E6%8F%90%E5%8F%96) - [3️⃣.3️⃣.3️⃣&emsp; 品牌特征提取](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A33%EF%B8%8F%E2%83%A33%EF%B8%8F%E2%83%A3-%E5%93%81%E7%89%8C%E7%89%B9%E5%BE%81%E6%8F%90%E5%8F%96) - [3️⃣.4️⃣&emsp; 树模型的数据分桶](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A34%EF%B8%8F%E2%83%A3-%E6%A0%91%E6%A8%A1%E5%9E%8B%E7%9A%84%E6%95%B0%E6%8D%AE%E5%88%86%E6%A1%B6) - [3️⃣.5️⃣&emsp; LR与NN模型的特征构造](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A35%EF%B8%8F%E2%83%A3-lr%E4%B8%8Enn%E6%A8%A1%E5%9E%8B%E7%9A%84%E7%89%B9%E5%BE%81%E6%9E%84%E9%80%A0) - [3️⃣.5️⃣.1️⃣&emsp; log与归一化](https://github.com/ExcaliburEX/Tianchi-Story#3%EF%B8%8F%E2%83%A35%EF%B8%8F%E2%83%A31%EF%B8