# 经个人的经验摸索，数据分析不应是对数据进行分析。

RunMews 2023-06-10 15:27:20

## 第二步：使用SQL进行数据预处理

1.介绍一下字段的含义：

use yfsgoalter table dbo.dodgers alter column attend int;alter table dbo.dodgers alter column temp int;alter table dbo.dodgers drop column day,cap,shirt;update dbo.dodgers set month=case month when 'APR' then '四月'when 'MAY' then '五月'whEN 'JUN'  THEN '六月'WHEN 'JUL' THEN '七月'WHEN 'AUG' THEN '八月'WHEN 'SEP' THEN '九月'WHEN 'OCT' THEN '十月'endupdate dbo.dodgers set day_of_week= case day_of_weekwhen 'Monday' then '星期一'when 'Tuesday' then '星期二'when 'Wednesday' then '星期三'when 'Thursday' then '星期四'when 'Friday' then '星期五'when 'Saturday' then '星期六'when 'Sunday' then '星期日'end

html{color:#000;overflow-y:scroll;overflow:-moz-scrollbars}
body,button,input,select,textarea{font-size:12px;font-family:Arial,sans-serif}
h1,h2,h3,h4,h5,h6{font-size:100%}
em{font-style:normal}
small{font-size:12px}
ol,ul{list-style:none}
a{text-decoration:none}
a:hover{text-decoration:underline}
legend{color:#000}
fieldset,img{border:0}
button,input,select,textarea{font-size:100%}
table{border-collapse:collapse;border-spacing:0}
img{-ms-interpolation-mode:bicubic}
textarea{resize:vertical}
.left{float:left}
.right{float:right}
.overflow{overflow:hidden}
.hide{display:none}
.block{display:block}
.inline{display:inline}
.error{color:red;font-size:12px}
button,label{cursor:pointer}
.clearfix:after{content:'\20';display:block;height:0;clear:both}
.clearfix{zoom:1}
.clear{clear:both;height:0;line-height:0;font-size:0;visibility:hidden;overflow:hidden}
.wordwrap{word-break:break-all;word-wrap:break-word}
.s-yahei{font-family:arial,'Microsoft Yahei','微软雅黑'}
pre.wordwrap{white-space:pre-wrap}
body{text-align:center;background:#fff;width:100%}
body,form{position:relative;z-index:0}
td{text-align:left}
img{border:0}
#s_wrap{position:relative;z-index:0;min-width:1000px}
#wrapper{height:100%}
.s-ps-sug .sug_ala{border-bottom:1px solid #e6e6e6}

...全文
101 回复 打赏 收藏 转发到动态 举报

48

• 近7日
• 近30日
• 至今