鲁达 经验分享——Excel数据清洗
分享兴趣，传播快乐，增长见闻，留下美好！亲爱的您，这里是LearningYard新学苑。今天小编为大家带来经验分享——Excel数据清洗。
Share interest, spread happiness, increase knowledge, leave good! Dear, this is LearningYard's new school. Today xiaobian for you to bring experience to share -- Excel data cleaning.
在之前的文章中小编为大家介绍了利用八爪鱼采集器采集数据的详细过程，接下来为大家进一步介绍相关数据的清洗过程。
In the previous article, xiaobian introduced the detailed process of collecting data using octopus collector. Next, we will further introduce the cleaning process of relevant data.
01
数据转换
首先我们来到Excel界面，选中商品价格的整列，复制文本型区域数据。
First we go to The Excel interface, select the entire column of commodity prices, copy the text area data.
插入空白列并在所要粘贴单元格中右击鼠标，点击选择性粘贴。
Insert a blank column and right-click in the cell you want to paste and click Selective Paste.
在选择性粘贴对话框中运算下选择加，点击确定按钮。
Select add under operations in the Selective Paste dialog box and click ok.
修改插入列的字段名称，选中原来的列，并删除。
Change the field name of the inserted column, select the original column, and delete it.
以下就是文本型数据转化为数值型数据的结果。
Here is the result of converting textual data to numeric data.
02
数据筛选与修改
接着选中商品价格，点击排序和筛选，选中筛选，点击出现的箭头，删除错误数据。
Then select the commodity price, click sort and filter, select filter, click the arrow that appears, delete the wrong data.
选中筛选出的全部数据，并点击删除。
Select all the selected data and click Delete.
筛选出非空白的数据，点击确定。
Filter out non-blank data and click OK.
在新的单元格内算出价格均值。
Figure out the average price in the new cell.
复制这个均值，复制后记得删除这一行。
Copy the mean, and then delete the row.
同样筛选出空白的单元格，选中空白的单元格，将刚才的均值填充进去。
Also screen out the blank cells, select the blank cells, and fill in the mean value.
最后恢复全选的状态。
Finally, the state of all selection is restored.
继续清洗像素一列的数据，点击排序和筛选，选中筛选。
To continue cleaning the data in the pixel column, click Sort and Filter and select Filter.
将无关字段改为其它。
Change the irrelevant field to something else.
恢复全选状态。
Restore the select all state.
03
重复以上步骤
重复以上操作步骤，修改其它参数字段的数据。
Repeat the preceding steps to modify the data of other parameter fields.
04
清洗后数据
以下就是Excel数据清洗后的展示图。
The following is the Excel data cleaning display diagram.
如果您对今天的文章有独特的想法，欢迎给我们留言，让我们相约明天，祝您今天过得开心快乐！
If you have a unique idea for today's article, feel free to leave a message and let's meet tomorrow. I wish you a happy day today!
-END
参考资料：百度百科、商业数据科学导论课堂视频资料、谷歌翻译
本文由LearningYard学苑原创，部分图片及文字来源于网络，若有侵权请联系删除。