<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[禾木页]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/qq_42281663</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; qq_42281663]]></copyright><item><title><![CDATA[[Excel] 用sumproduct函数实现数据透视表功能]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/124738757</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/124738757</guid><author>qq_42281663</author><pubDate>Thu, 12 May 2022 21:50:49 +0800</pubDate><description><![CDATA[Excel中用sumproduct（）函数实现销售额统计，实现数据透视表功能


]]></description><category></category></item><item><title><![CDATA[[Python] 变量重分类（连续变量重分类、离散变量重分类）]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/122020581</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/122020581</guid><author>qq_42281663</author><pubDate>Sat, 02 Apr 2022 13:15:38 +0800</pubDate><description><![CDATA[Python变量重分类/Python变量重编码（连续变量重分类、离散变量重分类）]]></description><category></category></item><item><title><![CDATA[SQL基础]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121027557</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121027557</guid><author>qq_42281663</author><pubDate>Sun, 20 Mar 2022 00:37:36 +0800</pubDate><description><![CDATA[MySQL基础]]></description><category></category></item><item><title><![CDATA[[评价体系] 2、层次分析法AHP原理、例题]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/123399145</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/123399145</guid><author>qq_42281663</author><pubDate>Fri, 11 Mar 2022 18:34:02 +0800</pubDate><description><![CDATA[层次分析法AHP基本原理+综合评价体系案例]]></description><category></category></item><item><title><![CDATA[[评价体系] 1、数据规范化/无量纲化方法]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/123395534</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/123395534</guid><author>qq_42281663</author><pubDate>Thu, 10 Mar 2022 13:09:45 +0800</pubDate><description><![CDATA[数据规范化、数据无量纲化方法（效益型、成本型、区间型、固定值、偏离区间、偏离固定值）]]></description><category></category></item><item><title><![CDATA[R语言导入xlsx包错误: JAVA_HOME cannot be determined from the Registry]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/122012921</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/122012921</guid><author>qq_42281663</author><pubDate>Sat, 18 Dec 2021 15:37:07 +0800</pubDate><description><![CDATA[成功解决方案：

R语言加载xlsx报错错误: JAVA_HOME cannot be determined from the Registry解决方法 - 程序员大本营q



其他记录：

1、R语言安装路径在C:\Program Files\R

2、而R语言安装的库都在C:\Users\XXX\Documents\R\win-library\4.1下，可删掉其中的库重新inatall（不知道可不可以通过直接把包放进去实现install（待试））。
...]]></description><category></category></item><item><title><![CDATA[[MySQL | Python] MySQL子查询及其对于的Python操作]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121773646</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121773646</guid><author>qq_42281663</author><pubDate>Tue, 07 Dec 2021 21:43:37 +0800</pubDate><description><![CDATA[MySQL标量子查询、关联子查询、普通子查询及其对于的Python操作]]></description><category></category></item><item><title><![CDATA[python3.7安装libtiff包报错及解决]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121763241</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121763241</guid><author>qq_42281663</author><pubDate>Tue, 07 Dec 2021 11:17:02 +0800</pubDate><description><![CDATA[python3.7安装libtiff包报错及解决]]></description><category></category></item><item><title><![CDATA[更新pip包时报错（ “Python‘ setup.py egg_info“ failed with error code 1）记录]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121754683</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121754683</guid><author>qq_42281663</author><pubDate>Mon, 06 Dec 2021 20:26:02 +0800</pubDate><description><![CDATA[更新pip包时报错（ "Python' setup.py egg_info" failed with error code 1）记录]]></description><category></category></item><item><title><![CDATA[[MySQL] 用Python读取MySQL中的数据]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121640840</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121640840</guid><author>qq_42281663</author><pubDate>Sun, 05 Dec 2021 09:09:31 +0800</pubDate><description><![CDATA[用python导入MySQL数据]]></description><category></category></item><item><title><![CDATA[[MySQL | Python] MySQL频数表、Python频数表]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121652890</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121652890</guid><author>qq_42281663</author><pubDate>Wed, 01 Dec 2021 14:37:12 +0800</pubDate><description><![CDATA[MySQL频数频率表]]></description><category></category></item><item><title><![CDATA[[Python] 散点图（二维散点图、三维散点图、散点图矩阵）]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121381757</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121381757</guid><author>qq_42281663</author><pubDate>Wed, 17 Nov 2021 18:59:01 +0800</pubDate><description><![CDATA[python 二维散点图、气泡图、三维散点图、二维三点矩阵 【案例+python代码】]]></description><category></category></item><item><title><![CDATA[2021华为杯数学建模B题“空气质量预报二次建模” 预处理思路+Python代码]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/120880145</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/120880145</guid><author>qq_42281663</author><pubDate>Fri, 29 Oct 2021 11:15:21 +0800</pubDate><description><![CDATA[简介

前阵子和小伙伴做了2021年华为杯研赛的B题，发现数据预处理一块挺有意思的，涵盖了常规的缺失值（随机缺失、指标缺失/列缺失、条目缺失/行缺失）、异常值（偏离正态分布、非负数据为负），以及不常规的协同处理等，一直想着有机会整理一下。

1. 赛题及数据

    赛题及数据大家可自行前往“中国研究生创新实践系列大赛管理平台”下载，或者直接在网上搜索也可以。

1.1 赛题

    简而言之，2021年B题题目为“空气质量预报二次建模”，核心任务是让你用已有的基于WRF-CMAQ模型...]]></description><category></category></item><item><title><![CDATA[[Python] 反距离权重插值案例及代码]]></title><link>https://blog.youkuaiyun.com/qq_42281663/article/details/121013066</link><guid>https://blog.youkuaiyun.com/qq_42281663/article/details/121013066</guid><author>qq_42281663</author><pubDate>Thu, 28 Oct 2021 22:10:16 +0800</pubDate><description><![CDATA[简介

2021年华为杯研赛B题“空气质量预报二次建模”第四题的数据预处理过程用到了一个反距离权重插值（见章节3.2），在这里整理一下。

目录

1. 赛题及数据

1.1 竞赛试题

1.2 数据集预览

2. 监测点A、A1、A2、A3实测时数据协同处理

2.1 缺失值处理1：反向距离权重

2.1.1 反向距离权重函数定义方法一

2.1.2反向距离权重函数定义方法二

2.1.3 协同处理插值

2.2 缺失值处理2：随机森林插补

2.3 异常值处理1：3西格玛原则

2.3 异常值处理2：.]]></description><category></category></item></channel></rss>